Thank you for visiting our Partner Zone. This area is an exclusive space for MYOB Partners. Find out how to Partner with MYOB.
If we use the Gross Amount in Workpapers and let the workpaper calculate the GST it shows correctly for each line but the total is frequently out by a few cents. This then means the total doesn't match the account balance and the workpaper gets red flag.
Each line rounds to 2 decimal places but the workpaper GST and net totals are calculated from the total in the gross amount. Can workpapers please be changed so the totals are the sum of the column above instead?
A screenshot of an expense workpaper which is out by 1 cent is attached.
From the screen shot, it looks like you are using te Generic Expense template for ACC.
I have checked the calculations on this template, and it does actually sum the column, so the issue must be slightly different - maybe that it is summing the non-rounded values for each amount rather than the rounded values. We will need to investigate that further, but I agree that, at face value, it doesn't appear correct.
One workaround may be to add another row entitled "immaterial rounding adjustment" and put in the amount necessary to make the workpaper balance. We are using this technique with other workpapers where rounding differences are inherent in the calculation. It has the benefit of making the amount of any minor discrepancy obvious to the reviewer who can then decide whether the adjustment is in fact immaterial.