Currently, when an AP invoice is split over 2 lines with different tax classes on each line, the Purchases Item Tax Tracking report is showing the batch entry total in the Purchase column for both tax classes instead of the line entry total. The result is overstating the purchase amount on the Tax Tracking report.
This is relevant for countries that have a Goods & Services Tax (GST) where reporting the taxable and non taxable purchase amounts is a compulsory requirement by law.
We expect the “Purchase” column to be the sum of “Tax Base” + “Tax Amount”. But in reality that may not be the case all the time, for example when tax base is determined by the user-defined cost that bears no relationship with the purchase amount, then the “tax base” + “tax amount” will definitely NOT be equal to the purchase amount, and the purchase amount is merely a reference field.
We would like the tax tracking report to make the “purchase” column = “Tax base” + “Tax amount”. Perhaps there could be a switch included on the report to be able to calculate the purchase column this way or the current way.
by: Melissa W. | over a year ago | Reports / BI
Comments
Agreed, have had to change this every upgrade for 18 years and have advised Sage multiple times. Sage Australia support says its by design