GST Calculation Worksheet Example
Example document for GST Calculation Worksheet. Use this as a reference when creating your own.
Professional Review Recommended
This document may have legal or financial implications. We recommend having a qualified professional review the final version before use.
Document: GST Calculation Worksheet
Example Document
Last updated 7/30/2026
GST Calculation Worksheet
Business Name: Smiths Plumbing Services ABN: 12 345 678 901 BAS Period: 01/07/2023 to 30/09/2023 Reporting Method: Cash
1. Total Sales (G1)
| Description | Total Amount ($) | GST Amount ($) | Tax Code |
|---|---|---|---|
| GST Free Sales (No GST) | $ 0.00 | $ 0.00 | GST-FREE |
| Input Taxed Sales (No GST) | $ 0.00 | $ 0.00 | INPUT-TAXED |
| Taxable Sales (Includes GST) | $ 33,000.00 | $ 3,000.00 | TA |
| Total Sales (G1) | $ 33,000.00 |
2. GST on Sales (1A)
| Calculation Component | Amount ($) |
|---|---|
| GST on Taxable Sales | $ 3,000.00 |
| Adjustments (e.g. Bad Debts) | $ 0.00 |
| Total GST on Sales (1A) | $ 3,000.00 |
3. Total Purchases (G10)
| Description | Total Amount ($) | GST Amount ($) | Tax Code |
|---|---|---|---|
| Purchases with no GST (Bank Fees) | $ 150.00 | $ 0.00 | GST-FREE |
| Capital Purchases (New Drill) | $ 1,100.00 | $ 100.00 | CA |
| Other Purchases (Materials) | $ 10,450.00 | $ 950.00 | CR |
| Total Purchases (G10) | $ 11,700.00 |
4. GST on Purchases (1B)
| Calculation Component | Amount ($) |
|---|---|
| GST Credits on Capital Purchases | $ 100.00 |
| GST Credits on Other Purchases | $ 950.00 |
| Adjustments (e.g. Private Use) | $ 0.00 |
| Total GST on Purchases (1B) | $ 1,050.00 |
5. Net Calculation
| Field | Amount ($) |
|---|---|
| Total GST on Sales (1A) | $ 3,000.00 |
| Less Total GST on Purchases (1B) | $ 1,050.00 |
| Net Amount to Pay or Refund | $ 1,950.00 |
Declaration:
I declare that this worksheet is a true and accurate record of the business transactions for the period stated.
Name: John Smith Date: 25/10/2023 Position: Owner
Notes
- Sales include GST. The GST component of $33,000 is $3,000 ($33,000 divided by 11).
- Bank fees are GST free, so no credit is claimed.
- The new drill is a capital acquisition over $1,000. The GST of $100 is claimed.
- Materials are everyday business purchases. The GST of $950 is claimed.
- The business owes the ATO $1,950 for this quarter.
About this Example
Part of the GST Calculation Worksheet document collection
Document Type
GST Calculation Worksheet
A tool to help businesses record sales and purchases to calculate the net Goods and Services Tax amount to report or claim on their Business Activity Statement.