Declarations > Tax management > Australia > GST report > GST reporting periods 

Use this function to create the Australian VAT declaration information for existing GST groups. You must have at least one group defined in the GST groups function (GESGSTGRP) to create and manage reporting periods.
For each GST group, you can:
  • Create and manage reporting periods.
  • Track and update the validation status per period.
  • Manually enter additional BAS values.
  • Run the GST report for an individual company to review amounts.
  • Run the GST report for the group to prepare the data required to submit to the Australian Tax Office (ATO).
  • Close a GST reporting period.
Note: This function only applies to Australian legislation and companies within a GST group that have an ABN.
You can only start the GST data update when there are no pending changes on an open GST period. The Update GST data button is greyed out until all pending changes are saved.
Once a period is closed, the data is finalized and no more updates are possible.

Creating and managing GST reporting periods

You can only create a reporting period for an active GST group. When you enter the group code, the group member companies display in the Member companies grid.

You must also enter the start and end date of the period or accept the proposed period range. When saving the new period, a unique period code is automatically created that identifies the reporting period.

Start and end dates for a reporting period must:

  • Match the reporting period frequency of the GST group (monthly or quarterly)
  • Be aligned with the calendar by months or quarters, depending on the GST group setting
  • Not overlap with existing periods from the same group

After saving a new reporting period, you can no longer modify the start and end dates. If necessary, you can delete the incorrect period and create a new one.

Include unreported transactions

You can include journal entry transactions from a previous period into the current period by selecting the Include unreported transactions check box and then entering or selecting an As of date.

For example:

The current period is February 2018 for a GST group with a monthly reporting frequency. During February, you receive two late supplier invoices, one from December 2017 and one from January 2018.

  • If you select the check box and set a date As of 1 January 2018, only the January invoice is included.
  • If you select the check box and set a date As of 1 December 2017, both late invoices are included.
  • If the check box is not selected, the As of date field is not available and neither invoice is included in this period.

You can use the AUSGSTASOF - Default As of date parameter (LOC chapter, AUS group) to define a date that automatically sets an As of datewhen you select the Include unreported transactions check box. You can still enter a new date in this field and override the default value.

Changes to GST group membership and inactive GST groups

When creating a new reporting period, the list of member companies belonging to the entered GST group at this point in time is saved as part of the reporting period. This makes it possible to re-create the GST report even if the related GST group has been modified in the meantime.

If a GST group is marked as inactive this doesn’t influence previously created GST reporting periods for this group.

Missing or incorrect VAT box settings

The GST calculation relies on proper VAT box settings (GESVTB).

To create a complete and correct BAS statement, there cannot be any missing or incorrect VAT box settings. If there are such errors the data update is not carried out and a log file is generated when you click Update GST data.

The log file contains the following:

  • Accounting lines with VAT codes that are not specified in the VAT box setup
  • Accounting lines with VAT codes that are outside the validity date range.
  • Accounting lines with accounts that have tax management or tax allocation settings that are not consistent with the related setting for the VAT code on the line made in the VAT box setup.

    Prerequisites

    SEEREFERTTO Refer to documentation Implementation

    Screen management

    Header

    Fields

    The following fields are present on this tab :

    Reporting period

    Enter the code for an existing GST group. Companies that are part of this group display in the Member companies grid.

    Once you save this period, the group code cannot be changed.

    Groups are created and managed in GST groupings.

    • Period code (field CODGSTPER)

    This field displays the reporting code for this period based on the sequence counter. You cannot modify this field.

    • Reporting status (field GSTGRPSTA)

    Select a status to keep track of your workflow. This is recommended and not required.

    In review = This indicates that you have not yet finalized data for this group and period.

    Validated = This indicates that you have confirmed the data, but the period is not yet closed. You can still make modifications and reset to In review if desired.

    Closed = When you select this option, you can no longer make modifications to the data and Update GST data is no longer active. This closes the period and you can no longer change the status.

    • Start date (field DATSTR)

    Enter a start date for the period. The date range is suggested for the next period for the group if periods exist for this group. If not, the date range is set to the period before the current date.

    For monthly reporting: The start date must be the first day of a month.

    For quarterly reporting: The start date must be the first day of a quarter.

    Note: Monthly or quarterly reporting is determined by the GST group profile in GST groupings.

    • End date (field DATEND)

    Enter an end date for the period. A period can span multiple months or quarters.

    For monthly reporting: The start date must be the last day of a month.

    For quarterly reporting: The start date must be the last day of a quarter.

    • Include unreported transactions (field FLGPRE)

    Select this check box to include transactions with a date prior to the start of the current reporting period and that were not reported in a previous period. For example, this could be invoices that were received late.

    • As of date (field PREDAT)

    Enter or select a date prior to the current start date to include unreported transactions beginning on that date.

    If a date is defined in the AUSGSTASOF – As of date parameter (LOC chapter, AUS group), that date displays by default, but you can still enter a new date in this field.

    This field is greyed out if the Include unreported transactions check box is not selected.

    • Date lodged (field DATLDG)

    Enter the date that data in the GST report was submitted to the ATO. This is for your reference only.

    Group BAS values

    • Net GST (field GSTNET)

    This field displays the amount owed to the ATO or the amount that can be claimed. This total is based on the difference between the group totals for 1A (GST on sales) and 1B (GST on purchases).

    • 1A (field GST1A)

    This field displays the group total for this VAT box. It cannot be modified.

    • 1B (field GST1B)

     

    Block number 3

    • G1 (field GSTG1)

     

    • G2 (field GSTG2)

     

    • G3 (field GSTG3)

     

    • G4 (field GSTG4)

     

    • G10 (field GSTG10)

     

    • G11 (field GSTG11)

     

    • G14 (field GSTG14)

     

    Block number 4

    • 4 PAYG tax withheld (field GSTADD2)

    This field displays the group total for this BAS category based on data manually entered in the Member companies grid and updates accordingly.

    • 5A PAYG income tax inst. (field GSTADD1)

     

    • 6A Fringe benefit (field GSTADD4)

     

    • 7C Fuel tax credit overclaim (field GSTADD3)

     

    • 7D Fuel tax credit (field GSTADD5)

     

    Close

     

    Tab Member companies

    Presentation

    This tab lists the companies in the group for the GST group code. You can manually enter BAS values that are included in the Group BAS values block on this screen. This is helpful when completing the BAS section of the GST reporting period.

    Close

     

    Fields

    The following fields are present on this tab :

    Grid

    This fields displays the company code for the group member and cannot be modified.

    • Reporting status (field GSTMEMSTA)

    Use this field to track your workflow for this company.

    In review: Signals that you are still reviewing data for this company. When you select Update GST data, data for this company would update as well.

    Validated: Signals that you are satisfied with the data for this company. When you select Update GST data, data for this company does not change.

    • Head entity (field GSTHEA)

    This field displays whether or not this company is the Head entity as defined in the group profile in GST groupings.

    You can change the Head entity in GST groupings.

    • PAYG W1 (field GSTADDW01)

    You can manually enter additional values related to the BAS. For details, refer to the official BAS form from the ATO.

    • PAYG W2 (field GSTADDW02)

     

    • PAYG W3 (field GSTADDW03)

     

    • PAYG W4 (field GSTADDW04)

     

    • FBT F1 (field GSTADDF01)

     

    • FBT F2 (field GSTADDF02)

     

    • FBT F3 (field GSTADDF03)

     

    • FBT F4 reason (field GSTADDF04)

     

    • PAYG T1 (field GSTADDT01)

     

    • PAYG T2 % (field GSTADDT02)

     

    • PAYG T3 % (field GSTADDT03)

     

    • PAYG T4 reason (field GSTADDT04)

     

    • PAYG T7 (field GSTADDT07)

     

    • PAYG T8 (field GSTADDT08)

     

    • PAYG T9 (field GSTADDT09)

     

    • Fuel tax 7C (field GSTADD7C)

     

    • Fuel tax 7D (field GSTADD7D)

     

    Close

     

    Action icon

    GST report

    Click this option to run a GST report for the company on the line. This is for informational purposes only and does not include BAS values. Use the Print Action to run the GST report (GSTCLCWRKSHT) for the GST group.

    This provides the information needed to submit to the ATO.

     

    Close

     

    Tab GST preview

    Presentation

    Click Update GST data to populate this grid. As a result, the grid displays data per member company and BAS label.

    Click Detail from the Action icon menu in a cell to view the underlying records and further drill-down to the originating records.

     

    Fields

    The following fields are present on this tab :

    Block number 1

    Grid

    This fields displays the company code for the group member and cannot be modified.

    • Net GST (field GSTNET)

    This field displays the amount owed to the ATO or the amount that can be claimed. This total is based on the difference between the group totals for 1A (GST on sales) and 1B (GST on purchases).

    • 1A (field GST1A)

    This field displays the individual company amount for this VAT box. From the Action icon menu, select Details to view the underlying records and from there, you can continue to drill-down to the original records.

    • 1B (field GST1B)

     

    • G1 (field GSTG1)

     

    • G2 (field GSTG2)

     

    • G3 (field GSTG3)

     

    • G4 (field GSTG4)

     

    • G10 (field GSTG10)

     

    • G11 (field GSTG11)

     

    • G13 (field GSTG13)

     

    • G14 (field GSTG14)

     

     

    Reports

    By default, the following reports are associated with this function :

     GSTCLCWRKSHT : GST calculation worksheet

    This can be changed using a different setup.

    You can run the GSTCLCWRKSHT- GST report from the Print icon in the Actionpanel to generate the information needed to submit to the ATO. You can run this report at any time, even for a closed period, without changing the reporting status.

    You can also run the report for a single company using the Action icon menu on the Member companies tab to review that company’s data.

    You can limit the report to a specific site or range of sites using the Financial site range report parameter. When you enter a site or range of sites, only transactions for that site or sites are included in the report. By default, this parameter value is empty, and all financial sites are included.

    Note: The AUSGST -GST report has been deprecated and can no longer be used for BAS/GST reporting.

    GST report content

    The report is divided into five sections.

    1) A list of journal entries included for the reporting period

    • Depending on the tax type, there are typically two lines for each journal entry: one line for the tax base and one line for the tax entry.
    • The journal entries are grouped by GST member company and by BAS label.

    2) For each company, there is a summary section for all available BAS labels.

    3) A summary section per BAS labels for the entire GST group

    • This summary is based on full AUD values per company.
    • For each BAS label and company, the decimals of the totals are truncated first and only the resulting full AUD values are summed up for the group totals.

    4) A calculation worksheet for the period.

    5) BAS preparatory report

    • This section contains the BAS values, i.e., GST and additionally entered BAS values.
    • This section only displays when the GST report is run for the entire GST group, not for a single member company.

    Specific actions

    Select this action to add and then update reporting data for member companies whose status is In review. If an individual company status is Validated in the Member companies grid, their data is not affected. Once the reporting period status is Closed, this action is no longer available.

    This process collects tax values from general ledger journal entries according to their tax codes and calculates the records for GST reporting. It is based on the VAT box settings (GESVTB).

    After updating the GST data, you can review the results on the GST preview tab and drill-down to underlying data if necessary. After making any corrections or updates, you can click Update GST data again.

    Important considerations

    BAS data must be entered manually in the Member companies grid.

    When satisfied with the company data on the GST Preview tab, set that company’s status to Validated to avoid changing the information. You can revert the member company status any time as long as the reporting period is not closed yet.

    You can exclude a company from this process by setting the AUSVAT – Australian VAT parameter (LOC chapter, AUS group) to No at the company level.

    You receive a notification if any accounting journals have a temporary status. Depending on the AUSTMPBLK – Blocking on temporary journals parameter (LOC chapter, AUS group), setting, this message displays as either a warning or a blocking notification.

    Actions menu

    Functions / Mass period creation

    Use this function to create reporting periods for multiple groups at once.

    When you click this Action, you see a list of proposed groups and periods based on the current date. You can clear the check box to exclude a specific GST group and period from mass creation.

    Functions / Excel export group

    Use this function to export all detail data for all member companies to an Excel file. Before you can export data, you need to Update GST data at least once.

    Functions / Tax invoice inquiry

    Error messages

    In addition to the generic error messages, the following messages can appear during the entry :

    Company '$1$' not assigned to a GST group.

    A company must be part of an active GST group for reporting to the ATO. To submit the GST report for a company with no affiliates, you must create a group for that company, even if it is the only company in the GST group.

    You can create and manage groups in GST groupings.

    Could not save the new GST data.

    You could receive this message if there are missing or incorrect VAT box settings.

    Tables used

    SEEREFERTTO Refer to documentation Implementation