Using A/R Tax Reports

Use the A/R tax reports when working with tax receivables.

Note: The invoice 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.

Sales Tax Report

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.

Tax Receivable Report

You can produce the Tax Receivable Report for a range of tax codes, invoice dates, and customers.

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.