Open topic with navigation

Setting up Tax Calculation for Sales and Use Tax

FinancialForce Accounting can integrate with Avalara's AvaTax product for the calculation of Sales and Use Tax (SUT).

The following setup must be completed in order for FinancialForce Accounting to integrate successfully with the external system. Once this setup has been completed users will be able to validate addresses on company and account records (see Validating Addresses for Sales and Use Tax Calculation), calculate tax values for sales invoices and sales credit notes, and post those documents so that they are "Complete" in FinancialForce Accounting and their tax values are "Committed" in AvaTax.

Create a Tax Code for Use by AvaTax

Create a tax code that will be used to represent the summarized tax on an invoice line and give it a tax rate starting from the beginning of time. We recommend that you set this tax rate to zero because AvaTax will calculate the actual tax rate and tax value for each line. This tax code must be supplied when completing the Sales Tax Calculation Settings (below).

Complete the Sales Tax Calculation Settings

To complete the Sales Tax Calculation Settings, ensure that you are logged in as System Administrator then:

1. Enable the Sales Tax Calculation Settings custom tab in the System Administrator's profile. This custom tab is hidden on all profiles by default.
2. Click the Sales Tax Calculation Settings tab.
3. Select the Enable External Sales Tax Calculation checkbox.
4. [Optional] To restrict address validation to specific countries, enter a comma separated list of country codes in the Address Validation Country Code Filter. A company or account address will then only be validated if its country code matches one of the codes identified by this filter. If this field is left blank, addresses will be validated regardless of country code.
5. Enter your account number, license key and URL as provided by Avalara. You must register the URL as a trusted remote site (Security Controls | Remote Site Settings).
6. Click Test Connection to verify that the connection to AvaTax is successful. If the test fails, double-check the account number, license key and connection URL.
7. In Summary Tax Code, enter the tax code that was created for use by AvaTax (above). This must be a valid tax code.
8. The Record Full Sales Tax Details checkbox determines whether AvaTax returns line level tax details, or jurisdiction level tax details. For example, if a sales invoice line has three tax jurisdictions, when this checkbox is selected AvaTax will return three rows of tax details (one for each tax jurisdiction) whereas when this checkbox is deselected AvaTax will return one row of tax information for the whole line. See Recording Full Tax Details for more information.
9. Click Save.

Link your FinancialForce Accounting company to its corresponding AvaTax company

Each SUT company in FinancialForce Accounting must be linked to its corresponding company in AvaTax so that transactions committed in AvaTax can be reported correctly. To do this:

1. In FinancialForce Accounting, display the company detail page.
2. In the Sales Tax Company Code field, enter the code used for this company in AvaTax. This field is mandatory when the organization is enabled for sales tax calculation and the company's record type is SUT. The code can be up to 50 characters.
3. Click Save.

See Company Fields for information about other fields on the company detail page.

Link your FinancialForce Accounting products to items or tax codes in AvaTax

If you want to use product-specific tax calculation, you can do either of the following:

• Map each of your FinancialForce Accounting products to the appropriate tax code in AvaTax. To do this, display the product detail page and enter the AvaTax tax code in the External Sales Tax Code field. The AvaTax tax code must, in turn, be linked to an AvaTax tax rule.
• Map each of your FinancialForce Accounting products to its corresponding AvaTax item. To do this, the product code in FinancialForce Accounting must match the item code in AvaTax. The tax code associated with the AvaTax item is then used to calculate tax values for the product. This product to item mapping always takes precedence and will override any external sales tax code set on the product.

If you do neither of the above, AvaTax will calculate sales tax based solely on the addresses.

The Calculate Tax button on sales invoices and sales credit notes

If your users will be entering sales documents using Extended EditionThe view of the application that you see when you install one of the extension packages (such as the Cash Entry Extension package). For invoices, credit notes, and journals Extended Edition is integrated into the main package, but must be configured., you must complete the setup explained in Setting up Extended Edition for Sales Invoices and Sales Credit Notes. The Calculate Tax button is included on the 'extended' page layout for sales invoices and sales credit notes.

If your users will be entering sales documents using Classic EditionThe view of the application that you see when you first install the base managed package., ensure that they are aware that they must click the Edit button on their sales document before the Calculate Tax button becomes available.

Configure the Background Posting Scheduler

Make sure that the Background Posting Scheduler is set up to run at a suitable frequency. See Setting up the Background Posting Scheduler for details.

Exemption Certificates

If the AvaTax Exemption Certificate Management System (ECMS) is to be used, it must be enabled and all available certificates must be registered. If the ECMS is disabled, certificate numbers from FinancialForce Accounting will be taken on trust.

Note:

Note

For one-time exemptions, users must populate the Customer Reference field on the sales document in FinancialForce Accounting. The value is passed to the Purchase Order No field in AvaTax when the document is posted.

Pass Account Name or Account Number to Avalara

The custom setting 'Avalara Tax calls use account number' (Accounting Settings) determines whether the account name or account number is passed to the Cust/Vendor Code in Avalara. By default this custom setting is OFF meaning that account names are passed to Avalara.

If you want to pass account numbers instead, turn this custom setting ON and ensure that all account numbers are populated. Avalara will report an error if it is triggered when the account number is blank.

© Copyright 2009-2016 FinancialForce.com, inc. All rights reserved.
Various trademarks held by their respective owners.

Open topic with navigation