I would like to see a report by tax district that combines both what hits the GL in the sales tax paid account and the A/P vendor invoice. We compare what we collect in tax to what we have paid in tax and only want to pay the difference. No sense in double paying taxes. In 2-4-51 subsidiary ledger report, I can prove it is pulling the correct tax by record but I need the invoice total for which the tax was calculated in order to properly report to the state.
by: Carrie C. | over a year ago | Accounts Payable
Comments
We also had this problem. We created a part # in Inventory for each tax district. Then when entering the tax in the 4-2 Payable Invoice Screen, enter the part # for the tax district in which the tax was paid.
Created a report in the 4-1-2 screen to print AP invoices with period = current period and part # between range of tax districts.
Not a perfect solution, but it does work.