Using A/R Tax Reports

Use this information with these reports:

  • Sales Tax Report
  • Tax Receivable Report
  • GST Invoiced Report (Canada)
  • PST Invoiced Report (Canada)
Note: 

The iinvoice history information does not include postings you performed manually from the G/L journal to the tax G/L accounts. Also, if you generated tax account distributions from Customer Order Entry before posting them in A/R, and then adjusted the distributions manually, the history information does not include the adjustments. Therefore, the report does not reflect these secondary changes to account balances.

Tax Records

In Customer Order Entry, the tax records are created when each invoice is printed and posted. The system does not alter these records, regardless of changes to the transaction 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 tax records are created based on the values in the special tax fields in the G/L distributions. When you post the manual transactions, the tax records are created.

Verifying the Report

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/credit memos from Customer Order Entry.

Then, make sure the A/R Distribution journal has been posted to the ledger. You may have additional discrepancies if you adjusted the GST account balances manually with journal entries, or adjusted the A/R Invoice G/L GST Account Distribution records manually. Only these discrepancies are acceptable.