Use reconciliation reports to compare AvaTax Update invoices with the invoices in your accounting software.
AvaTax Update refreshes report data every 30 minutes, so you may need to wait to see your most recent transactions in your reports. Go to the Transactions page for up-to-the-minute activity.
Get more information about using reports and how reports are linked to each other.
To run a reconcile report:
- Go to Reports > Reconciliation Reports.
- Click Create Report next to the type of report you want to run and fill out the required fields. In most cases the purpose of the fields are self-explanatory, but in some cases you may want to use the descriptions below for more information.
Follow the reports workflow
Determine which report you need
|Top Line Reconcile||
Provides a snapshot of each transaction from your companies in AvaTax Update, giving you a basic summary of the country and/or region(s) selected. Run for sales tax or consumer use tax.
|Document Summary Reconcile||Digs in deeper than the top line report, showing totals for the documents in transactions you've entered into AvaTax Update. Run for sales tax or consumer use tax.|
|Document Summary Listing Reconcile||
Shows sales tax totals, broken up by taxingor address, for transactions you've entered in AvaTax Update.
Note that options available in the Report Level list vary depending on the country you've selected.
|Document Line Detail Reconcile||
Shows more detail than the document summary report, providing you with totals for each document line within the documents in transactions you've entered into AvaTax Update. Run for sales tax or consumer use tax.
Note that options available in the Jurisdiction Type and Tax Type lists vary depending on the country you've selected.
|Document Line Tax Detail Reconcile||Shows individualtax details for each document line of the selected document. Run for sales tax or consumer use tax.|
|Exemption Exposure Reconcile||Shows the total exempt exposure for one or more companies in AvaTax Update. These are exempt transactions that don't have exemption certificate entries applied. Drill down in the report to view this exposure summarized by customer or at the document level.|
|Exemption Exposure Aging Reconcile||Shows groups of exemption exposure documents by company. Exposures display in four groups: current, older than 30 days, older than 60 days, and older than 90 days.|
Fill out the report details
These fields may require additional explanation. Not all fields appear in every report form.
Select the date type to use when applying a date range:
|Company or Companies||To select more than one company from the Company or Companies list, hold Ctrl and click each company name.|
|Document Code From / Document Code To||The document code is typically the number of the document as assigned by your accounting software. In the Document Code From field, type the individualthat you want to restrict the form to. To use a range of document codes, type another document code in the Document Code To field. On forms where these aren't required fields, leave them blank to run a report for all document codes.|
|Customer ID||The unique code referencing your customer, which is typically the same as the unique customer identifier used in your accounting software.|