---
title: "GST Returns NZ Dashboard"
canonical: "https://kb.myframeworks.com.au/space/FRAM/28401502/GST%20Returns%20NZ%20Dashboard"
format: markdown
---
> ⚠️ **Important:** Ensure you have the following populated before using the GST Returns Dashboard for the first time in [Company Maintenance ](https://sterlandsupport.atlassian.net/wiki/spaces/FRAM/pages/28382666):
> ⚠️ 
> ⚠️ 1. A valid **GST number** is required to be populated in the **A.B.N** field.
> ⚠️ 2. Under **GL Control Accounts** section ensure there is a **GST Clearing Account** entered. The actual GST Clearing Account is defined within [Chart of Accounts](https://sterlandsupport.atlassian.net/wiki/spaces/FRAM/pages/28390222).
> ⚠️ 3. Define the required **GST Return Format** to be **New Zealand (NZ).**

# Create a New GST Returns Report

To create a new GST Return report, perform the following: 

1. Click the **Frameworks Menu** and navigate to **General Ledger > Transaction Processing > GST Returns **from the navigation tree.
2. Click **New** and the **New GST Return **dialog box will display.

![image](media://433b9401-0eaa-43f7-b5bb-8586288eea7c)

3. From the **Company **drop-down menu, select the company you are reporting for.
4. In the **Period From **and **To **fields enter the Reporting period dates, or search using the **Date Picker** icon.

> ❌ If either of the dates entered fall inside an open reporting period a warning message will appear "**Warning**: The Reporting period is still open for posting in the GL"

5. Click **Save**. This generates the GST return record with the **Status: Calculating** and submits a task to the task scheduler to calculate GST return data. You can close the tab while the GST return is being calculated.

![image](media://be492576-f637-4e56-8920-3c9a25f29639)

> ⚠️ Depending on the size of your data this can take a sometime.

6. Once the scheduled task has completed you will be notified that the GST record has been updated. On the **GST Returns **dashboard, the **Status** field will updated to **Draft **and the **Task Status **field to** Complete. **

![image](media://d43d3c8f-84c3-42ef-b518-a1bbe9210554)

> ℹ️ On the **Home Dashboard**, under **Notifications** a **GST Return update Complete **will be displayed. Click the **Link** icon to go to the** Task Activity** where you can click on the **Output **tab to view the .csv output of the task results.

7. To view the report screen, from the **GST Returns **dashboard, click on the **Reference **hyperlink.

The report screen is divided into the following sections:

1. **Header Information **and reporting** Actions.**
2. **Sales and Income **and the related **General Ledger.**
3. **Purchases and Expenses **and the related **General Ledger.**
4. **Payment/Refund **and the related **General Ledger.**
5. **Attachments: **Click on the hyperlinks to download and view.
6. **Notes:** Click and type any additional notes if required.

![image](media://fc7d2bae-425d-48a4-baea-25d108e0a465)

<details>
<summary>For more information on each section, click here. </summary>

| **Sales and Income** | **Definition** | **General Ledger** | **Definition** |
| --- | --- | --- | --- |
| **Total Sales and Income** | All Sales Transaction (Based from GST Sales Report) | **GST Sales** | GST Sales (Based from GST Sales Report) |
| **Zero-rated Supplies ** | GST Free Transactions (Based from GST Sales Report) | **Sales Adjustments** | GST sales adjustment account |
| **Nett Sales and Income** | Difference between Total Sales and Income and Zero-rated Supplies | **GST Collected** | Sum of GST Sales and Sales Adjustment |
| **Total GST Debit ** | (Nett Sales and Income * 3) / 23 |  |  |
| **Debit Adjustment** | User Entered Value - editable field |  |  |
| **Total GST Collected ** | Sum of Total GST Debit and Debit Adjustment |  |  |

| **Purchases and Expenses** | **Definition** | **General Ledger** | **Definition** |
| --- | --- | --- | --- |
| **Total Purchases and Expenses** | All Purchase Transaction (Based from GST Purchases Report) | **GST Purchases** | GST Purchases (Based from GST Purchases Report) |
| **Not Reported** | Journals in the defined period with a matching BAS - "Not Reported" | **Purchase Adjustments** | GST purchase adjustment account |
| **Tax Free ** | Journals in the defined period with a matching BAS - "Tax Free" | **GST Paid ** | Sum of GST Purchases and Purchase Adjustments |
| **Total GST Credit** | (Nett Sales and Income * 3) / 23 |  |  |
| **Credit Adjustment** | User entered value fur adjusting ?? |  |  |
| **Late Claims** | Not included as of version 5.4 |  |  |
| **Total Credit Adjustments** | Credit Adjustment, ie total minus credit adjustments |  |  |
| **Total GST Paid ** | Difference between Total GST Credit and Total Credit Adjustments |  |  |

| **Payment/Refund** | **Definition** | **General Ledger** | **Definition** |
| --- | --- | --- | --- |
| **GST Payment/Refund** | Difference between Total GST Collected and Total GST Paid | **Payment/Refund ** | Difference between GST Collected and GST Paid |
</details>

# Recalculating and Updating an existing GST Returns Report

To recalculate or update a GST return, perform the following:

> ⚠️ Once **Finalise **you can not recalculate or update a GST return. Only GST returns with a **Draft **or **Blank **status can be recalculated or updated.

1. From the **GST Returns **dashboard, click on the required **Reference **hyperlink.
2. Click on the **Hyperlinks** above the **Notes **section to view the transaction details that make up each of the **Sales**, **Purchase**, and** GL Account** values.  
This will download a .csv file with each transaction included in the total value.
3. You can update the Sales and Income **Debit Adjustments** value, as well as the Purchases and Expenses **Credit Adjustments** value as required, by clicking in the fields an entering the values. Or make changes back in the transaction.

![image](media://03f93352-1279-487c-8e28-50aeccaf73aa)

4. Once updated, from the **Actions **button, select **Recalculate **from the menu. The screen will automatically return to the GST Returns Dashboard screen.

![image](media://71826b3a-5b44-4825-8140-53f1bcd7794d)

5. The Scheduled task will automatically run again, and once complete, the **Task Status** will be **Complete.**
6. Click on the **Reference **hyperlink to go back into the report.  The **Total GST Collected, GST Paid, and GST Payment/Refund **fields have been updated to reflect the Debit/Credit Adjustment made.

# Deleting an Unprocessed GST Return

To delete an unprocessed GST return, perform the following:

> ⚠️ Once **Finalise **you can not deleted a GST return. Only GST returns with a **Draft **or **Blank **status can be deleted.

1. From the **GST Returns **dashboard, click on the required **Reference **hyperlink.
2. From the **Actions **button, select **Delete **from the menu.

![image](media://d23dad9c-d318-4e7c-ab63-1e8910cab3b0)

3. Click **Yes** from the confirmation popup, and once completed, you will automatically return to the GST Returns Dashboard screen.

# Finalise the GST Returns Report

To finalise the GST return, perform the following:

1. From the **GST Returns **dashboard, click on the required **Reference **hyperlink.
2. From the **Actions **button, select **Finalise** from the menus once the GST report is ready.  This will nett off the Sales and Purchase GST accounts to the GST Clearing account. The clearing journal will occur within the final GL period of the GST Return you're processing.

![image](media://196da9bd-cf92-4193-82d9-b924458969b9)

3. Click **Yes** from the confirmation popup, which advises *Please confirm that the GST return is to be finalised. No further changes will be possible*
4. You will return to the GST Returns Dashboard. Refresh the Report listing; the report **Status **will now be set to **Finalised**, and **Date Finalised **column will now have a finalised date value.

> ℹ️ If you go back into the report you will notice from the **Actions **button you can no longer select the **Recalculate**, **Finalise** or **Delete **options, the only available option is **Print/Send.**

5. **Print/Send** the Finalised GST Report as required for record-keeping purposes

> ⚠️ This does not to submit to tax office.

# Additional Information

> ✅ <span style="color: #000000">From the </span><span style="color: #000000">[Reporting Dashboard ](https://sterlandsupport.atlassian.net/wiki/spaces/FRAM/pages/28380010)</span><span style="color: #000000"> run the </span>**Balance Sheet - Std Report**<span style="color: #000000"> for a standard Balance Sheet with Previous Month, Movement & Current Balance.</span>