Skip to main content

Legal

Tax & Accounting

Trade & Supply

Risk & Fraud

News & Media

Books

Developers

Work with returns

Australia GST Analytical Tool (GAT)

The Australia GST Analytical Tool (GAT) helps reconcile data from a Business Activity Statement (BAS) return with other financial data. Here's a concise guide on how to use the GAT effectively.

Worksheets included in GAT

  • BAS and Accounting Summary (ATO Summary):
    • Collates data from the Revenue, Expenses, and BAS details sheets, calculating the effective GST rate. This worksheet is also reported to the Australian Tax Office.
  • BAS Details:
    • Consolidates BAS figures from GST returns. You can also enter figures directly in the BAS Details (B) sheet in the GAT report.
  • Method Statement:
    • Integrates data from Revenue and Expenses sheets.
  • Revenue & Expenses:
    • Enables entry of financial data from various sources for comparison with BAS figures. You can also populate this worksheet with the
      Advanced Import Feature
       discussed later.

GAT reports

For clients that produce BAS returns to report Australia GST in OIC, a dataset for the Australia GST Analytical Tool (GAT) can be created using the same entity structure as the BAS return and covering the period for which the GAT is required. The GAT template should be used for every entity in the GAT dataset.
For example, if we have four quarterly Australia GST returns which cover the year 2024 and we want to create a GAT report which consolidates the BAS figures from these four quarterly returns, then we set up an Australia GAT dataset using the same entities and covering the year 2024.
Data updates available icon
When an update has been made in one of the quarterly Australia GST returns and it is not yet reflected in the annual GAT report then the
Data updates available
 icon appears at the top of the screen. After you refresh the GAT report so all updates from the quarterly Australia GST returns are pulled into the GAT report, then this icon will disappear.

Advanced import feature

This feature supports importing non-transactional data directly from Excel into an OIC return.
Steps to use advanced import:
  1. Go to
    Admin
     then
    Settings
     and activate
    Enable Advanced Import
    . This requires super-user permissions so you may need to contact Support.
  2. Use the
    Import Type
     dropdown and select
    Advanced Import
    .
  3. Select the template and entity, then choose the dataset and sheet type. Currently the Australian GAT supports Revenue and Expenses.
  4. Import files in .csv or .xlsx formats, ensuring they contain the necessary sheet and block contexts.
    1. Data requirements for the import file
      The sections of the workbook that we can import to contain properties called Sheet Contexts and Block Contexts. Imported files need to contain fields with the sheet context and block context that we want to import to. The sheet context is specific to the sheet. The block contexts are the different sections (or blocks) that we can import to on the sheet.
      For Australia GAT Revenue and Expenses the sheet contexts and block contexts are as follows:
      • Revenue
        :
        • Sheet context: Revenue”
        • Block contexts: Total revenue, Grouping variance, Profit and loss statement adjustments, Balance sheet and capital adjustments, Other adjustments
      • Expenses
        :
        • Sheet context: Expenses
        • Block contexts: Total expenses, Grouping variance, Profit and loss statement adjustments, Balance sheet and capital adjustments, Other adjustments
      For example, a spreadsheet could contain the following headers (in any order):
      • Description
      • Financial Statements
      • STGroups
      • Adjustments
      • OtherAdjustments
      • Sheet
      • Block
      The columns contain the sheet context and block context and will be mapped in the Data Mappings screen later.
  5. Map the data fields from the source file to the GAT fields using the mapping wizard. The first row of the mapping wizard shows a dropdown list of fields supporting advanced import for the selected template.
    1. For Australia GAT Revenue and Expenses this dropdown contains the five columns that we can import to: Description, Financialstatements, TransactionsrelatedtootherGSTgroups, Statutoryreporting adjustments(TBtoGAAP), Other adjustments.
    2. The dropdown also includes SheetContext and BlockContext so you can map the relevant fields to these.
    3. The second row represents column headers from the source file.
    4. Subsequent rows display the actual data from the source file for preview.
  6. Submit the import to upload data into the workbook. After the import finishes, a Details screen will show the figures and categories in your import.

This article applies to:

  • Product: ONESOURCE Indirect Tax Compliance