Avalara AvaTax™

This article provides instruction and information on the following:

• How to get started with Avalara AvaTax™
• How to set up Avalara AvaTax™ with Paladin
• How to manually update Avalara AvaTax™ address information
• How to manually send offline transactions to Avalara AvaTax™
• How to manually update Avalara AvaTax™ tax information
• How to manually compare invoice tax information between Avalara AvaTax™ and Paladin
• How to assign an Avalara AvaTax™ tax exempt category to a customer
• How to assign an Avalara AvaTax™ tax code to a department
• How to assign an Avalara AvaTax™ tax code to an inventory item

How to get started with Avalara AvaTax™

Avalara AvaTax™ is a cloud-based solution that automates transaction tax calculations and the tax filing process. Avalara AvaTax™ computes real-time tax amounts using up-to-date tax rules from more than 12,000 United States taxing jurisdictions and from more than 200 countries.

To learn more about Avalara AvaTax™, click here. In the Learn more about Avalara section, when you enter your information and click Get info now, a Paladin Support representative will contact you.

Back to Top

How to set up Avalara AvaTax™ with Paladin

Important: These steps must be performed by Paladin Support and require an Avalara AvaTax™ account. To sign up for the Avalara AvaTax™ service, see How to get started with Avalara AvaTax™.

1. In Paladin, from the main menu, select File > Setup.
2. Select the Taxes tab.
3. In the Invoices pane, check Use Avalara for Sales Tax Calculation.
   
4. Enter the Avalara AvaTax™ credentials:
   1. 1. In the Account Number box, enter the client’s Avalara AvaTax™ account number.
      2. In the Account Key box, enter the client’s Avalara AvaTax™ software license key.
      3. In the Company Code box, enter the company code from the AvaTax Admin Console.
      4. In the Batch Company ID box, enter the batch company ID from the AvaTax Admin Console.
      5. In the Batch UID box enter the client’s username from the AvaTax Admin Console.
      6. In the Batch PWD box, enter the client’s password from the AvaTax Admin Console.
5. Click the Test Connection button and verify the Avalara AvaTax™ connection. One of the following messages will appear:
   • Successfully connected to Avalara: Continue with the next step.
   • Failed to connect to Avalara: You must troubleshoot and resolve the connection issue before continuing.
6. The following options are turned off by default because they are not required for most clients. If an option is required, select the checkbox.

• • • Default to Customer Address:  If the store primarily delivers purchased products to the customer, select this option so that Avalara AvaTax™ calculates tax using the customer’s address. When this option is not selected, tax is calculated using the store’s location.
    • Calculate Tax Only (do not commit): If the store submits invoices from a different system (not Paladin) that integrates with Avalara AvaTax™, select this option so that Paladin uses the Avalara AvaTax™ service to calculate the tax but does not submit the invoice.
    • Log Avalara Calls: If you are troubleshooting and issue and need a detailed transaction log, select this option.
    • Disable Address Validation: If the store uses another system to validate addresses, select this option.

7. Optional: Test the services before going live.
8. In the Test Settings pane, enter the values provided by Avalara:

• • • Test Account Number
    • Test Account Key
    • Test Company Code
    • Test Batch Company ID
    • Test Batch UID
    • Test Batch PWD

9. To turn on the test mode, check Use Avalara in Test Mode only.

Important: After testing is complete, and you are ready to go live with the Avalara AvaTax™ service, clear the Use Avalara in Test Mode only checkbox, and then save your changes.

10. Click Save, and then click Close.

Back to Top

How to manually update Avalara AvaTax™ address information

Important: These steps must be performed by Paladin Support and require an Avalara AvaTax™ account. To sign up for the Avalara AvaTax™ service, see How to get started with Avalara AvaTax™.

Notes:

• Paladin periodically updates Avalara AvaTax™ with a current list of customer delivery addresses, but you can also manually perform these customer address updates at any time.
• During the update process, Avalara AvaTax™ automatically verifies each address and may update the Delivery Address in Paladin. For example, Avalara AvaTax™ may correct a misspelled street, town, or add ‘W’ (for west) to a street name. The customer’s primary address that displays at the top of the Customers tab is never updated by Avalara AvaTax™.
   

1. In Paladin, from the main menu, select File > Setup.
2. Select the Taxes tab.
3. In the Invoices pane, click Verify Addresses. An Excel icon will appear on the bottom taskbar of your computer. Click the Excel icon to open the worksheet.
4. Click Save, and then click Close.

Back to Top

How to manually send offline transactions to Avalara AvaTax™

Important: These steps must be performed by Paladin Support and require an Avalara AvaTax account. To sign up for the Avalara AvaTax™ service, see How to get started with Avalara AvaTax™.

During an internet outage, Paladin will use saved offline Avalara AvaTax™ information to process transactions. When the store is back online, Paladin will send the transactions that were processed during the outage to Avalara AvaTax™, typically within an hour.

1. In Paladin, from the main menu, select File > Setup.
2. Select the Taxes tab.
3. In the Invoices pane, click Process Queue.
4. Click Save, and then click Close.

Back to Top

How to manually update Avalara AvaTax™ tax information

Important: These steps must be performed by Paladin Support, and require an Avalara AvaTax™ account. To sign up for the Avalara AvaTax service, see How to get started with Avalara AvaTax™.

Paladin periodically saves offline Avalara AvaTax™ information so a store can process transactions during an internet outage, but you can also manually update offline tax information at any time.

1. In Paladin, from the main menu, select File > Setup.
2. Select the Taxes tab.
3. In the Invoices pane, click Update Offline Data.
   Note: The offline tax information update process can take time and will run in the background. A status bar at the bottom of the Paladin window will show progress. Do not close Paladin until the update process completes and a window with this message appears: Offline Tax Data Updated.
4. Click Save, and then click Close.

Back to Top

How to manually compare invoice tax information between Avalara AvaTax™ and Paladin

Important: These steps must be performed by Paladin Support and require an Avalara AvaTax™ account. To sign up for the Avalara AvaTax™ service, see How to get started with Avalara AvaTax™.

This process will find the transaction tax and tax location differences between Avalara AvaTax™ and Paladin.

1. In Paladin, from the main menu, select File > Setup.
2. Select the Taxes tab.
3. In the Invoices pane, select the Starting Date value for the tax validation.
4. Click Validate Taxes. Any discrepancies will be listed in the box below the Starting Date value.

Back to Top

How to assign an Avalara AvaTax™ tax exempt category to a customer

1. In Paladin, on the top ribbon, select the Customers module.
2. Enter or select a customer from the Customer list.
3. On the bottom ribbon of the module, click F8 Taxes.
4. In the Tax Window, in the State column, select None, and then click F12 Finish.
5. Click the Electronic tab.
6. In the Alternate Customer IDs pane, in the Tax Exempt Code list, select the customer’s tax exempt code.

Tax exempt codes

A – Federal government (United States)

B – State government (United States)

C – Tribe / Status Indian / Indian Band (both)

D – Foreign diplomat (both)

E – Charitable or benevolent org (both)

F – Religious or educational org (both)

G – Resale (both)

H – Commercial agricultural production (both)

I – Industrial production / manufacturer (both)

J – Direct pay permit (United States)

K -Direct mail (United States)

L – Other (both)

M – Not Used

N -Local government (United States)

O – Not Used

P – Commercial aquaculture (Canada)

Q – Commercial Fishery (Canada)

R – Non-resident (Canada)

7. Click F12 Save.

Note: If a customer’s State Tax value is not None, and you set a tax-exempt code, you cannot save the changes. A message stating this will appear.

Back to Top

How to assign an Avalara AvaTax™ tax code to a department

1. In Paladin, from the main menu, select File > Setup.
2. Select the Dept tab.
3. Select the department from the list.
4. In Item Information pane, in the Tax Code box, enter the Avalara AvaTax™ tax code. To see a list of Avalara AvaTax™ tax codes, click http://taxcode.avatax.avalara.com
   
5. Click Save, and then click Close.

Note: An inventory item can override its department’s tax code by setting it in the Inventory module. To learn more, see How to assign an Avalara tax code to an inventory item.

Back to Top

How to assign an Avalara AvaTax™ tax code to an inventory item

Note: You can assign an Avalara AvaTax™ tax code to a department, and then use this procedure to override the department tax code for individual inventory items. To learn more, see How to assign an Avalara tax code to a department.

1. In Paladin, on the top ribbon, select the Inventory module.
2. Search for the inventory item, and then display it. To search for any item, click Advanced Lookup or press F1.
3. Click the General tab.
4. In Item Information pane, in the Tax Code box, enter the Avalara AvaTax™ tax Code.

To see a list of Avalara AvaTax™ tax codes, refer to: http://taxcode.avatax.avalara.com

5. Click Save, and then click Close.

Back to Top