Avalara - Commit Tax Transactions

Avalara - Commit Tax Transactions

Release Date: 4/28/23
Version: 8.6 and Above

Posting Invoices to Accounts Receivable does not communicate with Avalara to commit the transaction. This is to avoid a crash in invoice posting if the application is unable to communicate with Avalara. Instead, the invoice posting application posts the tax transactions to the new Avalara Tax Queue file (AVTAXQUE). The Commit Tax Transactions application commits the transaction to Avalara in a separate step and can be scheduled through deferred processing after invoice posting has completed.


If the AvaTax service is unavailable when invoices are printed, tax amounts are estimated when written to the tax queue. When the commit is performed, taxes are recalculated and committed. There may be a difference in the amount estimated and the final calculation. In this case, distributions need to be offset to make up for the difference in tax liabilities. The original tax account defined in the tax code file will be adjusted and the offset will be posted to the Tax Adjustment Account defined in Global Setup-> Add-Ons-> Avalara Integration.

Here is an example of the commit journal where there was a difference between estimated amount and final committed amount including distributions.


Original estimated tax amounts are for an address in the state of Missouri:
State:                 3.23      
County:               2.69
City                       .00

When the invoice is posted the following distributions are created:
    21020626-000000 Missouri Sales Tax Payable           3.23CR
    21020626-000000 Missouri Sales Tax Payable           2.69CR

The actual tax amounts calculated by Avalara are:
State:                 3.24      
County:               1.74      
District:               1.34

Posting creates these adjustment distributions:

Distributions:   21020626-000000 Missouri Sales Tax Payable             .01CR
                            21020626-000000 Missouri Sales Tax Payable             .95
                            21020626-000000 Missouri Sales Tax Payable           1.34CR
                            00001010-000000 Tax Adjustment Account                 .40

Here is a sample posting journal with the headings changed and the G/L Journal Source printed. This is also an example where the distributions are different between the county and the district but no adjustment is necessary.



Programs Added: AVTAXJNL
CLS



    • Related Articles

    • Avalara - Tax Commit Edit List

      Release Date: 4/28/23 Version: 8.6 and Above The Tax Commit Edit List shows a the list of transactions to be committed to Avalara using the AvaTax Service. Programs Added: AVTAXEDT CLS
    • Avalara - Tax Queue

      'Release Date: 4/28/23 Updated: 1/26/24 Version: 8.6 and Above The tax queue application is designed to capture all of the tax transactions processed through Customer Order Processing to prepare them to be committed through the AvaTax Service. This ...
    • Avalara - Review Tax Queue

      Release Date: 4/28/23 Updated: 8/22/23 Version: 8.6 and Above This application shows a list of the transactions in the queue to be processed. A reconciliation status will show which transactions failed calculation and were estimated using a combined ...
    • Avalara - Tax Reconciliation Report

      Release Date: 4/28/23 Version: 8.6 and Above The Tax Reconciliation Report shows all of the committed tax transactions that occurred during a specific time period. The report has the option to only show transactions where there is a discrepancy ...
    • Avalara - Review Tax History

      Release Date: 4/28/23 Version: 8.6 and Above This application shows the batches of transactions that have been successfully committed using the AvaTax service. Drill downs are available to the individual invoices posted in each batch. Launching the ...