This article relates to situations where the GL has all expected transactions (GST Collected or GST Paid), but the BAS does not. Note that this article is also relevant for New Zealand GST.
The BAS report is created at the invoice level in Attaché as per GST legislation structure. That is, you need to enter invoices (tax invoices) and credit adjustment notes in order to have transactions appear on your BAS. Once you have entered the tax invoices and credit adjustment notes, you need to allocate these to a BAS period as a separate step.
If you are date based for Customers and Suppliers, then it is important to allocate transactions to both the GL and to your BAS with a date range so that both balance. If this is not done, and you use the Accrual BAS method, the Attaché produced BAS report may not equal the GL balance for the BAS period.
If you use the Cash BAS Method reconciling your BAS and GL is more complex and is not covered by this article.
To find missing BAS transactions that appear in your GL but not on your BAS Allocations report, do the following:
Check that you can find a transaction in the Customer or Supplier Masterfile, for example if a customer transaction is missing then look in Customers, Masterfiles, Enquire, then select the Customer Code and then select Trans (F5).
You may need to use Options (F8) to select Display Transactions with Zero Balance in order to see all transactions.
If you can find the transaction, then you can know that the transaction will be somewhere in your BAS system. It may not be allocated, or it may be allocated to the incorrect BAS Statement.
If there is no transaction, then you will not find the transaction in your BAS. This means the record has either been deleted or there was a partial update during a network or power failure, or the entry you are searching for in the GL did not come from the Customer or Supplier module, etc.
If you found the transaction in step 1, then use any of the following reports to find the missing transaction:
(NZ) Substitute Customer BAS or Supplier BAS in the below paths for GST Return (NZ).
Customers, Period End, Customer BAS, BAS Allocation Report.
Suppliers, Period End, Supplier BAS, BAS Allocation Report.
Customers, Period End, Customer BAS, BAS Audit Report.
Suppliers, Period End, Supplier BAS, BAS Audit Report.
Try the following when using the BAS Allocation Report:
Remove the Current Period Only selection and run the report for All Transactions. Then use Find (F2) to search for the Document Number, Amount, etc.
Add Date Range, Customer Code Range, etc ranges on the Ranges tab to reduce the number of results.
Once you find the document you are looking for, run the report with either Updated Transactions only or Transactions to be updated to find out the status of the transaction.
If the transaction is to be updated, then use the relevant module BAS Update menu item to post the transaction to the BAS.
If the transaction was updated, use the BAS Audit Report with a wide period range to determine the PRD (period) number the transaction was allocated to.
If you find a transaction was allocated to the incorrect period, there is no way to correct the allocation. The best course of action is to manually adjust your BAS / GST Return when lodging it.