This is the first time I have run the GST Calculation Worksheet for BAS after running my accounts through an Excel spreadsheet and I have a discrepancy with the Capital and Non-Capital purchases (G10 and G11). My total purchases are correct, however the individual line items are incorrect.
The totals should be as follows:
G10 Capital Purchases: $12,613
G11 Non Capital Purhcases: $175,216
I have run a Tax Audit Report as follows:
If I add up the total Assets on the Tax Audit Report I end up with the same total of $175,216 if I add the GST back in.
I have run these same transactions through my Excel Spreadsheet as well to ensure Manager output was correct but noticed this discrepancy.
Have I incorrectly entered something? I have doubled checked everything that I can think of with nothing popping out as obviously wrong. When I drill down on the GST Payable Line for GST transactions, nothing appears as I cannot see if that is the issue.
If anyone can see anything wrong I would greatly appreciate the assistance.
Thanks in advance.