The attached generic inquiry can be used for GST exceptions for rates 0%, 10% and 100%. No consideration has been made for deductible or WET GST.
This report is joining two table Batch and GLTran to get general journal transaction line information including ref number , dates , Debit/Credit amount , Tax ID , Tax category and logic which only shows GL transactions marked as tax transactions.
Possible ways to find out incorrect transactions
System will only show general journals which has Create Tax Transaction ticked
It will show all the general journal line as Error when there if no Ref number assigned to it which would be mean it is in General ledger but not in BAS report
User can also check for any GL journal which doesn't have Tax Category defined twice to constitute Asset/Liability versus Income/Expense to determine the Taxable and tax amount, any journal which doesn't have that will not go to BAS report
In order to reconcile GST Paid and GST Received account check the Tax Summary by GL Account by Date report , it gives clear and detailed information