Can't find what you're looking for? Still have questions? Contact customer support (smile)

BAS Worksheet Workaround

Owned by Kai Andras
Last updated: 01 Dec 2022
4 min read

  • If there is an issue running the BAS report from Eclipse please use this work around.

  • This work around involves running a ledger inquiry report and then pasting it into the BAS worksheet that you can download further down in step 5.

 

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:  

 

  1. Go to General Ledger > Ledger Inquiry > Reports

  2. Ensure that the following is set on the Report Details tab

  • BAS is unticked

  • Excel/CSV is ticked

  • Currency is set to Native

  • Your account range is set to go over all accounts, from blank to ZZZZ.

 

3. Follow the settings below:

  • Type in a Period Range

  • 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.

 

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. Once the export is completed, download the BAS Report Worksheet based on your region below and open it.

 

STANDARD AUSTRALIA TEMPLATE:


ENDEMOL SHINE AUSTRALIA TEMPLATE:

 

STANDARD UNITED KINGDOM TEMPLATE:

 

6. An Excel worksheet will open up and will be populated with six sheets. 

  • A Checklist sheet for you to read

  • The Ledger sheet for you to paste your Ledger CSV Export into

  • A GBAS Balance sheet

  • A BAS Statement sheet

 

7. Open your Ledger CSV Export completed in Step 4 and paste it into the Ledger tab of the BAS Worksheet.

  • Select the entire Ledger CSV Export and click Copy.

     

  • Open the BAS Worksheet excel file and navigate to the Ledger tab.

     

  • Select the entire Ledger and press Paste.

 

8. On the BAS 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 will be automatically calculated from the ledger export sheet.

 

9. 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 Ledger export over your entire ledger. You will need to check your filters and start at Step 1 again.

 

10. If you have a Balance in the Bal VAT/GST 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. 

This difference means that some transactions have been incorrectly flagged with the wrong tax code. You will need to go over your ledger to find and correct these flags.