Versions Compared

Old Version 6

changes.mady.by.user Greg Walsh

Saved on

compared with

New Version 7

changes.mady.by.user Micah Gallant

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Avatax Reconciliation Process

NOTE: BatchIdentifier in Taxlog matches ‘Document Code’ in Avalara reports

  1. Export the Transaction Detail report from Avatax interface for the month you are trying to reconcile

  2. Use a Tax Log report (custom report) and filter it by 'CreatedDate' for the same period (May 1 to May 31). The created date matches the 'Committed Date' as it is labeled on the Avatax side

  3. Uncheck columns per image below so that the report groups and sums up based on your filters - these sums will be used to compare to the Transaction Details report from Avatax

  4. Remove transactions from the Transaction Detail report that are marked as false under the 'Is Committed' column (these are voided transactions or transactions that should not be considered)

...