About the Tax Payable Report
Report Output
This report lists detailed information from the tax records. You select the inclusive date range of records to print. The system groups and subtotals the records by tax code and sorts the records by distribution date within the group. A negative value identifies reduction adjustments made to vouchers. A total prints at the end of the report for all tax codes of the voucher amount and tax amount.
Voucher history does not contain postings you performed manually from the G/L journal to the G/L tax accounts. If you generated tax account distributions from Purchasing before posting them in A/P, then manually adjusted the distributions, these adjustments are not stored in voucher history. 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, ensure that 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 when the A/P voucher is generated. These records are not altered, regardless of changes to the transactions 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 voucher, the tax records are created.