About Tax

You must create a separate tax code for each different type of tax you want to record. The tax codes you need to set up will depend on your country's legislation and how you and your customers are registered for tax purposes. Tax codes are defined at organization (org) level.

Example tax codes might be:

Tax Code

Description

PA-State Pennsylvania State Sales Tax
MA-State Massachusetts State Sales Tax
Philadelphia-PA-City Philadelphia City Sales Tax
Boston-MA-City Boston City Sales Tax

The Tax Codes tab displays a home page that lets you quickly create and locate your tax codes. You can also sort and filter your tax codes using standard and custom list viewsClosedGive you instant access to specific sets of data. In addition to using existing views, you can create custom list views for the items most relevant to you.. In addition, this tab lets you view and edit detailed information on each tax code.

The Tax Code object is an org-level objectClosedCustom object that exists across all companies in an organization (org).. In FinancialForce Accounting, all companies in an organizationClosedA deployment of the Salesforce/FinancialForce applications with a defined set of licensed users. Your organization (org) includes all of your data and applications, and is separate from all other orgs. (org) share the same tax codes.

Note: Note
If your FinancialForce Accounting org is integrated with Avalara's AvaTax product for the calculation of tax you only need to create one tax code, as explained in Setting up External Tax Calculation. The tax value calculated by AvaTax will replace any tax values calculated internally by FinancialForce Accounting, or entered manually by users.

Tax Rates

The Tax Rates related list lets you set new tax rates for each tax code.

Example tax rates might be:

Start Date

Rate

05/20/2011 5.000%
10/01/2010 4.500%
01/31/2010 4.750%
Note: Note
Tax rates are preloaded when a new FinancialForce document new or edit page is opened. If you amend the applicable tax rate while a document is "In Progress", you must reload the page to apply the new rate before posting.

Tax Modes

The default tax code that is displayed on a sales or payable document depends on many factors, including the following configuration settings.

VAT/GST or Combined Mode: Sales Invoice or Sales Credit Note

  1. If the account's tax status is "Home" or "EC Non-registered", the Output VAT/GST Code on the product is used as the default tax code for each line.
  2. If one of the following is true, the Output VAT/GST Code on the account is used as the default tax code for each line:

    2.1 The account's tax status is "EC Registered" or "Export".

    2.2 The account's tax status is "Home" AND a VAT/GST Group exists (both the owner company and the account share the same VAT Registration Number and Tax Country Code AND the VAT/GST Group checkbox on the company is selected). See note.

  3. If you do not enter a Output VAT/GST Code code on the account or product, the tax code stored on the company record is used instead.
  4. If a tax code is unspecified at both company and product/account level, then there will be no default on the invoice or credit note line. In this situation, the person entering the document will have to provide a tax code at the time, or leave the field blank.
  5. The tax rate is derived from tax code for the line, and the invoice date, then applied to the line net value to calculate the line tax value.

The result of each combination in 1 and 2 is summarized in the following table:

Sales Invoices/Sales Credit Notes
  Account Tax Status
Home EC Non-Reg EC Reg Export
VAT/GST Status No Group Rate applied as per defined tax code on the product Rate applied as per defined tax code on the product Rate applied as per defined tax code on the account Rate applied as per defined tax code on the account
Group Exists Rate applied as per defined tax code on the account Rate applied as per defined tax code on the product Rate applied as per defined tax code on the account Rate applied as per defined tax code on the account

VAT/GST Mode: Payable Invoice or Payable Credit Note (including Place of Supply and Reverse Charge)

For default input tax codes:

  1. If a VAT/GST Group exists (both the owner company and the account share the same VAT Registration Number and Tax Country Code AND the VAT/GST Group checkbox on the company is selected), the Input VAT/GST Code on the account is used as the default tax code for each line. See note.
  2. If all of the following are true, the Input VAT/GST Code on the account is used as the default tax code for each line:
    2.1 No VAT/GST Group exists.
    2.2 The VAT/GST Reverse Charge checkbox is set to false.
    2.3 The VAT/GST Place of Supply on the product is set to "With Account".
    2.4 The vendor account's tax status is "EC Non-Registered", "EC Registered" or "Export".

In all other cases, the Input VAT/GST Code is retrieved from the product.

For default output tax codes:

  1. If no VAT/GST Group exists and the VAT/GST Reverse Charge checkbox is set to true, the Output VAT/GST Code on the product is used as the default output tax code for each line.
  2. If all of the following are true, the Output VAT/GST Code on the product is used as the default tax code for each line:
    2.1 No VAT/GST Group exists.
    2.2 The VAT/GST Reverse Charge checkbox is set to false.
    2.3 The VAT/GST Place of Supply on the product is set to "With Customer".
    2.4 The vendor account's tax status is "EC Non-Registered", "EC Registered" or "Export".

In all other cases, the Output VAT/GST Code is not retrieved.

The combinations available are summarized in the following table:

Payable Invoices/Payable Credit Notes
  Product Account Tax Status
VAT/GST Reverse Charge VAT/GST Place of Supply Rules Home EC Non-Reg, EC Reg and Export
VAT/GST Status No Group Yes With Account or With Customer Default input and output tax rates applied as per defined tax codes on the product. Default input and output tax rates applied as per defined tax codes on the product.
No With Account Default input tax rate applied as per defined tax code on the product.
Default output tax code not retrieved.
Default input tax rate applied as per defined tax code on the account.
Default output tax code not retrieved.
No With Customer Default input tax rate applied as per defined tax code on the product.
Default output tax code not retrieved.
Default input and output tax rates applied as per defined tax codes on the product.
Group Exists Yes or No With Account or With Customer Default input tax rate applied as per defined tax code on the account.
Default output tax code not retrieved.
Default input tax rate applied as per defined tax code on the account.
Default output tax code not retrieved.
Note: Note
For intercompany transactions, for a VAT/GST group to exist the Tax Registration Number and Tax Country Code must match in the sending company, in the receiving company and on the account. The account's tax status must be "Home" and the VAT/GST Group checkbox must be selected in both companies.

VAT/GST or Combined Mode: Payable Invoice or Payable Credit Note

Note: Note
This section does not apply to VAT/GST companies using place of supply rules and reverse charge.
  1. If the vendor account's tax status is "Home", the Input VAT/GST Code on the product is used as the default tax code for each line.
  2. If the account's tax status is "Home" AND a VAT/GST Group exists (both the owner company and the account share the same VAT Registration Number and Tax Country Code AND the VAT/GST Group checkbox on the company is selected), the Input VAT/GST Code on the account is used as the default tax code for each line. See note.

In all other cases, the tax code is retrieved from the account.

Payable Invoices/Payable Credit Notes
  Account Tax Status
Home EC Non-Reg EC Reg Export
VAT/GST Status No Group Rate applied as per defined tax code on the product Rate applied as per defined tax code on the account Rate applied as per defined tax code on the account Rate applied as per defined tax code on the account
Group Exists Rate applied as per defined tax code on the account Rate applied as per defined tax code on the account Rate applied as per defined tax code on the account Rate applied as per defined tax code on the account
Note: Note
For intercompany transactions, for a VAT/GST group to exist the Tax Registration Number and Tax Country Code must match in the sending company, in the receiving company and on the account. The account's tax status must be "Home" and the VAT/GST Group checkbox must be selected in both companies.

SUT Mode

For a sales invoice or sales credit note:

  1. If the account and product's sales tax status is "Taxable", the tax codes set on the account are used to derive the tax rates for each product line on the invoice. This uses the rate in force on the invoice date.
  2. If the account or product's sales tax status is "Exempt", the tax codes set on the account are used, but the rate for each one is set to 0.000%.
  3. If the account's sales tax status is "Exempt for Qualifying Products", the tax codes defined on the account are used for qualifying products (those with a sales tax status of "Exempt for Qualifying Accounts"), but a tax rate of 0.000% is applied.
  4. If the account's sales tax status is "Taxable" and the product's tax status is "Exempt for Qualifying Accounts", OR if the product's sales tax status is "Taxable" and the account's tax status is "Exempt for Qualifying Products" THEN the tax codes defined on the account are used to derive the tax rates for each product line on the invoice. This uses the rate in force on the invoice date.

The result of each combination is summarized in the following table:

  Account Sales Tax Status
Taxable Exempt Exempt for Qualifying Products
Product Sales Tax Status Taxable Rate applied as per defined tax codes on the account Rate applied as 0.000% using tax codes on the account Rate applied as per tax codes on the account
Exempt Rate applied as 0.000% using tax codes on the account Rate applied as 0.000% using tax codes on the account Rate applied as 0.000% using tax codes on the account
Exempt for Qualifying Accounts Rate applied as per defined tax codes on the account Rate applied as 0.000% using tax codes on the account Rate applied as 0.000% using tax codes on the account
Note: Note
If your tax mode is SUT you cannot record tax information on payable documents.