Tax Receivable Report
Use this form to view all the sales tax receivables as collected by Sales/Parts Orders and Accounts Receivable. Usually, you print this report when preparing a tax return.
This report is most applicable to an area-based tax system defined for Tax System 1.
This report lists detailed information from the tax records. You select the range of tax codes and customers to include, and the inclusive date range of the tax records. The system groups and subtotals the records by tax code, credit transactions are listed as negative values, and a grand total of the report for all groups is included at the end of the report.
The invoice history does not contain postings you performed manually from the G/L journal to the tax G/L accounts. Also, if you generated tax account distributions from Sales / Parts Orders before posting them in A/R, and then adjusted the distributions manually, the adjustments are not retained. 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 that were created from Sales/Parts Orders.
Then, ensure the A/R Distribution journal has been posted to the ledger. You may have additional discrepancies if you manually adjusted the tax account balances with journal entries, or manually adjusted the A/R Invoice G/L Tax Account Distribution records. Only these discrepancies are acceptable.