Sales Tax Report

Use this report to view all sales taxes receivable as collected by sales/parts orders and Accounts Receivable. Typically, you print this report when preparing the tax return.

This report is most applicable to item-based tax systems defined for Tax System 1.

This report lists detailed information from the tax records for a range of invoices, invoice dates and customers.

The report has two parts:

The first part shows each tax record in invoice number order. A grand total is printed at the end of the report for the tax basis, tax amount and invoice totals.
The second part shows tax amounts, summarized by tax code. Only the tax records that meet the selection criteria are included in the totals.

Note: The system extracts the tax records from invoice history. If you purge this information before printing the report, any tax records prior to the report's date range are lost and do not appear on the report.

Invoice history does not contain postings you performed manually from the G/L journal to the G/L tax accounts. Also, if you generated tax account distributions from Sales / Parts Orders before posting them in Accounts Receivable, and then adjusted the distributions manually, invoice history does not contain the adjustments. Therefore, the report does not reflect these secondary changes to the account balance.

Compare the contents of the report to the tax account balances for the period reported from the G/L. If you find discrepancies, first verify that A/R does not contain unposted invoices or credit memos created from sales/parts orders. Then, make sure that the A/R Distribution journal has been posted to the ledger. You may have additional discrepancies if you adjusted the tax account balances manually with journal entries, or adjusted the A/R Invoice G/L Tax Account Distribution records manually. Only these discrepancies are acceptable.