File an Australian Business Activity Statement Using the BAS Macro

Note: This macro is designed for the use of companies doing business in Australia.

Overview

At the end of each tax period, you must submit a Business Activity Statement to report your tax obligations to the Australian Tax Office (ATO).

Businesses can submit a paper form, or they can use the ATO's Electronic Commerce Interface (ECI) to submit their monthly or quarterly Business Activity Statement (BAS) electronically over the Internet.

The BAS macro can help you to complete the paper BAS form and to submit it electronically.

To print a report that can help you to fill in the Business Activity Statement:

  1. Start the BAS.avb macro.
    1. On the Sage 300 Desktop, click Macro > Run.
    2. In the Run Macro form that appears, select VBA Macro from the Files Of Type list.
    3. Select BAS.avb.
    4. Click Open.

  2. Fill in the Australian Business Activity Statement form by entering amounts or by selecting General Ledger accounts, tax authorities, and tax classes.

    • If you specify General Ledger accounts, the net changes for the specified fiscal periods appear automatically.
    • If you specify tax authorities and tax classes, the macro displays tax information from Tax Services.

    You can also specify amounts to add to or subtract from the net change amount.

  3. To save a copy of the form, click Save or Save As, and then specify the folder and filename.
  4. When the form is complete, click the Print button to print a report of the amounts to enter on the Business Activity Statement.

To submit your Business Activity Statement electronically using the BAS macro:

Note: Follow the instructions from the ATO for installing and using the Electronic Commerce Interface.

  1. Start the ECI Client software.
  2. In the In Tray, choose Get New Documents.
  3. When the new document appears in the In Tray, export the document to a folder.
  4. Start the BAS.avb macro.
    1. On the Sage 300 Desktop, click Macro > Run.
    2. In the Run Macro form that appears, select VBA Macro from the Files Of Type list.
    3. Select BAS.avb.
    4. Click Open.

      5. The Australian Business Activity Statement form appears.

  5. Click the Open button, and then select the file that you exported from the ECI Client. Some information is filled automatically in by the export file.
  6. Fill in the Australian Business Activity Statement form by entering amounts or by selecting General Ledger accounts, tax authorities, and tax classes.
    • If you specify General Ledger accounts, the net changes for the specified fiscal periods appear automatically.
    • If you specify tax authorities and tax classes, the macro displays tax information from Tax Services.

    You can also specify amounts to add to or subtract from the net change amount.

  7. To save the file you are working on, you can save the information to the original file or as a new file.
  8. When you have completed the form, click the Submit button.
  9. In the ECI client:
    1. Import the file.
    2. Move the document to the Out Tray, and send it to the ATO.