Using A/P Tax Reports

Use this information with these reports:

  • Tax Payable Report
  • Tax Vouchered (Parametric) Report
  • Goods and Services Taxes (GST) Tax Credit Report
  • Provincial Sales Taxes (PST) Tax Credit Report

Report Output

The tax reports list detailed information from the tax records for a range of tax periods. The records are grouped and subtotaled by tax code, and the records are sorted by distribution date within the group. A negative value identifies a reduction adjustment made to a voucher.

Caution:  The tax records are extracted from voucher history. If you purge this information before printing this report, any tax records prior to the report's date range are lost and do not appear on the report. The 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 Purchasing before posting them in A/P, and then adjusted the distributions manually, the history information does not include the adjustments. Therefore, the report does not reflect these secondary changes to the account balance.

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 the A/P module does not contain unposted vouchers posted from Purchasing.

Then, make sure the A/P 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/P Voucher G/L tax account distribution records manually. Only these discrepancies are acceptable.

A/P Voucher Information

In Purchasing, the tax records are created at the same time as the A/P voucher is generated. The system does not alter these records, regardless of changes to the transaction in A/P or G/L.

If you enter vouchers or adjustments directly in A/P (not from Purchasing), the tax records are created, based on the values in the special tax fields in the G/L distributions. When you post the manual vouchers, the tax records are created.

On the GST and PST reports, The GST or PST Taxable column shows only the value of goods that apply to the tax code being reported. The value in the Voucher Total column includes all lines, charges, freight, and taxes on the document.

Because of the method by which the voucher history is maintained on the GST and PST reports, when you make adjustments to pre-vouchered amounts, the records are stored under the same voucher number, and the original voucher total is updated. In this situation, independent tax records are maintained under the separate Taxable, but the Voucher Total shows the same amount. Therefore, because the column would double count, the Voucher Total column does not contain a subtotal.

The GST or PST Taxable column is less accurate for vouchers than for invoices, because the vendor calculates the tax with the tax basis as estimated from the tax codes stored with the PO.