Use the Sales Tax Report to view all sales taxes receivable as collected by Customer Order Entry 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:
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 Customer Order Entry 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.
In Customer Order Entry, the system creates the tax records when it prints and posts each invoice. The system does not alter these records, regardless of whether or not changes have been made to the transactions in A/R or G/L.
If you enter invoices, credit memos, or debit memos directly in A/R (not from Customer Order Entry), the system creates the tax records, based on the values in the special tax fields in the G/L distributions. When you post the manual transactions, the system creates the tax records.
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 Customer Order Entry. 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.