Tax Code and Rate Fields

Here is a description of the fields that make up a tax code and their associated tax rates. Some of these fields might not be visible or editable at all times, or in all package combinations.

Key: R – Read-only; * – Mandatory field
The number indicates the number of characters that are allowed in this text field, where appropriate.

Field     Description
BAS Gross Box    

The boxes that you select are used to report the gross value of the transaction line items of type “Tax” associated with the tax code. Possible values:

  • G1
  • G10
  • G11
  • W1
Note:

G1 can only be defined either as a gross box or a net box.

BAS Net Box    

The boxes that you select are used to report the net value of the transaction line items of type “Tax” associated with the tax code. Possible values:

  • G1
  • G2
  • G3
Note:

G1 can only be defined either as a gross box or a net box.

BAS Tax Box    

The boxes that you select are used to report the tax value of the transaction line items of type “Tax” associated with the tax code. Possible values:

  • 1A
  • 1B
  • W2
  • W3
  • W4
Description * 80 Description of the tax code, such as Boston City Tax.
General Ledger Account *   The general ledger account to which transactions for this account will be posted. This cannot be the retained earnings account. This field supports corporate and local GLAs.
Tax Code * 24 Each type of tax must be assigned a unique code by which it can be identified.
Tax Group     Tax group used to enable grouping on reports. You can update the entries in this custom picklist.
VAT Net Box    

The box that you select is used to report the net value of the transaction line items of type “Tax” associated with the tax code.

VAT Tax Box    

The box that you select is used to report the tax value of the transaction line items of type “Tax” associated with the tax code.

The following fields might have been added to the page layout. They are only relevant if your company's record type is Combined. See What is Combined Tax? for more information.

Field Description
Parent When selected, this checkbox indicates that the tax code is a rollup of two child tax codes. You cannot add, edit or delete tax rates on a parent tax code; instead its tax rates are calculated from the rates on its children. When deselected, the tax code is a regular tax code and cannot have child tax codes linked to it (but can itself be a child tax code linked to another parent). This checkbox cannot be modified once the tax code has been saved.
GST The first child tax code linked to this parent. Typically this is a federal tax code.
PST/QST The second child tax code linked to this parent. Typically this is a provincial tax code.
Tax Model Determines how the combined tax is calculated when creating sales documents and payable documents. The different tax models are explained in What is Combined Tax?.

Dimension Analysis

The following fields might have been added to the page layout. They can be used to allocate analysis dimensions to your tax codes. Analysis dimensions can be used to map tax code lines to local GLAs when using Chart of Accounts.

Field   Description
Dimensions 1-4   Any analysis dimensions that you want to apply to your tax code.

Tax Rate

Here is a description of the fields that make up a tax rate history record.

Field   Description
Rate * Rate of tax chargeable on goods and services with this tax code. Must be a positive value to three decimal places (such as 8.000%), or zero (0.000%).
Start Date * First day on which the new tax rate comes into force. The selected date must be unique for this tax code.
Tax Code R Tax code to which this rate belongs.

Foundations Tax Code Fields

The Foundations Tax Code and Tax Rates objects are core components of Foundations. Other Certinia applications use this object and add fields, buttons, and functionality to it. For more information, see Tax Codes.

Here is a description of the fields that Accounting adds to the Foundations Tax Code object.

Field Name

Description

Accounting Tax Code Lookup to the Accounting tax code to which this tax code record relates.