...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
THERE IS CURRENTLY AN ISSUE GENERATING THE BAS REPORT FOR LARGE DATASETS.
...
THE ARTICLE BELOW WILL NOT WORK AND WILL RESULT IN A CORRUPT BAS SHEET IF YOU ARE A PRODUCTION WITH A LARGE DATASET.
...
REFER TO THE ARTICLE HERE FOR HOW TO RUN A BAS REPORT IF THE BELOW REPORT RESULTS IN A CORRUPTED SHEET: BAS Worksheet Workaround.
The BAS Report is used for GST (Australia) and VAT (UK) reporting purposes. The BAS Report will go over your entire ledger and look at your tax flags to calculate your tax. In order to run this report you must only have one Tax account, and you can only use the period range to filter the results. This report does not work with the reconcile method.
If you do not meet this criteria it is recommended that you run a traditional VAT Report: VAT Report / Reconciliation
1. Go to General Ledger > Ledger Inquiry > Reports
2. Ensure that the following is set on the Report Details tab
...
Run the report over a certain period range
Run the report over a certain date range. Note: Please read Using MTD and the Date Range Filter about using dates, we do not recommend it.
...
DO NOT tick exclude reconciled transactions.
This report will not work with reconciled transactions as your GL will not equal 0.
DO NOT tick calculate net tax amount.
The report calculates this automatically. Ticking this will break the output.
DO NOT tick Bible or it will export every single transaction in your database.
4. Click the Save icon on the Report Details tab after making your changes. Then click the OK button to run the Report. Note: If you do not click the Floppy Disk Save Icon your settings for running the report will not be used.
5. An Excel worksheet will open up and will be populated with four sheets.
...
6. On the GST/VAT Balance sheet, please make any applicable changes to the sections highlighted in yellow. This may be either the Account Codes or Tax Flag sections. Changes which have been highlighted in the below boxes.
Once you have made changes to the account code and tax flags, the figures will be automatically calculated from the ledger export sheet by using the supplied formulas in the cells.
...
7. If your ledger balance is not zero Ledger Balance [Must = 0] there is a problem with your search range and you have not run your report over your entire ledger.
8. If you have a Balance in the Bal VAT/GST cell Cell H31 (in this screenshot is it -2,362.62) this means there is a difference between the amount of VAT/GST posted directly into your VAT/GST Accounts compared to the percentage calculation of VAT/GST based on all your NET flagged items.
...