Use the Tax Payable Report to view all sales taxes payable as collected by the system's Purchasing and A/P modules. Typically, you will print this report when you prepare the tax return.
You can produce this report for a range of tax codes, distribution dates, and vendors.
This report is most applicable for tax system 1, defined as an area-based tax system, with the Active for Purchasing check box selected on the Tax Systems form.
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.
NOTE: The system
extracts the tax records from voucher history. If you purge voucher
history before printing the report, any tax records prior to the report's
date range are lost and do not appear on the report.
Voucher 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 Purchasing before posting them in A/P,
and 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.
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 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.
In Purchasing, the system creates the tax records at the same time it generates the A/P voucher. The system does not alter these records, 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 system creates the tax records based on the values in the special tax fields in the G/L distributions. When you post the manual voucher, the system creates the tax records.