All templates

BAS Template and GST Reconciliation

Reconcile entered GST figures with control balances and download a BAS preparation workpaper.

Period and basis

GST accounting basis

GST reporting

GST figures

Before the adjustments entered below.

Before the adjustments entered below.

GST control bridge

Payable balances are positive; receivables are negative.

Use the same sign convention as the opening balance.

GST component only. A net refund is negative.

Increases are positive. Explain timing and other entries below.

Review record

GST reconciliation

Figures reconcile

Entered GST control agrees with the bridge.

GST net before cents omitted

$3,200

Expected closing control

$3,200

Control difference

$0.00

Review items remaining

6

Proposed GST labels

G1
$104,775
1A
$7,850
1B
$4,650

Accounts method only. Entries and downloads stay on this device. A zero difference still needs source review.

Missing support

  • Reviewer reference
  • Source reports match the period and basis
  • Purchase and adjustment evidence checked
  • GST payments and refunds matched
  • Control differences explained
  • Reviewer sign-off note

Set the BAS Period and Basis

This BAS template compares your entered GST figures with the movement in the client’s GST control account. It keeps the reporting basis, source references and review tasks with an Excel-compatible workpaper.

Use the client’s registered GST accounting basis when preparing the source reports. Cash reporting generally follows payments received or made. Non-cash reporting generally follows the earlier invoice or payment event, subject to the attribution rules and evidence for credits. The ATO accounting-method guidance explains that distinction. Changing the basis selector records your choice; it does not convert entered totals.

This workpaper supports the accounts method for Simpler BAS and full GST reporting. Simpler BAS uses G1 total sales, 1A GST on sales and 1B GST on purchases. Full reporting also records G2 export sales, G3 other GST-free sales, G10 capital purchases and G11 non-capital purchases. Choose the method on the client’s activity statement using the ATO GST reporting instructions.

Enter G1 and the full-reporting labels from reviewed reports, with the GST inclusion basis required for those labels. G1 includes sales that carry no GST, so dividing G1 by eleven does not establish 1A. G10 and G11 are purchase amounts, while 1B is the GST credit amount. The workpaper does not infer entitlement from a ledger tax code.

The supported figures cover GST only. GST instalments, the G-labelled calculation worksheet, PAYG withholding and other BAS obligations need their own preparation. This BAS statement template is a preparation record. Lodge using the activity statement issued to the client.

Reconcile GST and Adjustments

Enter sales GST and purchase GST before the adjustments entered in this workpaper. Increasing adjustments add to 1A and decreasing adjustments add to 1B under the accounts method. Keep the adjustment note, reason and attributable period in the source reference. An adjustment already included in the report must not be added again.

The ATO instructions for completing GST labels explain the accounts method and adjustment treatment. A later event that changes a correctly reported transaction is an adjustment. A figure that was wrong when lodged is an error. Assess an earlier error under the ATO correction rules before including it in another period.

The control bridge adds opening GST control and the period’s net GST, subtracts GST payments less refunds, then adds other control movements. Enter payable control balances as positive and receivables as negative. GST payments are positive; refunds are negative. Use the GST component of a payment, excluding PAYG and other obligations.

For cash reporting against an accrual ledger, other control movements can explain the change in GST on unpaid sales and purchases. Enter that bridge from a supporting schedule. Use the review note to explain it. Do not use an unexplained balancing amount to force agreement or post an adjustment from this workpaper.

The control difference is entered closing control less expected closing control. A non-zero difference needs investigation. Compare the opening ledger, report basis, settlement allocation and adjustment entries. A zero difference proves arithmetic agreement only; offsetting mistakes and incorrect tax codes can still remain.

Review Before Lodgment

The tool opens with a fictional cash-basis example. Sales GST is $7,800 and purchase GST is $4,600. A $50 increasing adjustment and a $50 decreasing adjustment produce 1A of $7,850 and 1B of $4,650. The net GST is $3,200.

The opening control is $2,450 and GST payments are $2,450, with no other movements. Adding the $3,200 period net gives an expected closing control of $3,200. The entered closing control agrees. If it were $3,225, the workpaper would show a $25 difference to explain.

Review each checklist item against the records before confirming it. Record the preparer and reviewer references, then describe the review and sign-off in the note. Missing references remain on the missing-support checklist. You can download a workpaper with open items so another staff member can complete the review.

Download Excel XML creates a local .xml spreadsheet that Excel can open. Save it in your practice’s workbook format if you need a BAS spreadsheet template in Excel. The file contains numeric amounts, proposed labels and source references, with the control bridge and review record. It is a snapshot without spreadsheet formulas; after editing it, recalculate and reconcile the figures again.

The workpaper retains cents for the control comparison. Proposed BAS labels omit cents without rounding up, following the ATO BAS completion rules. Separate label truncation can change the proposed GST-only net from the untruncated bridge amount. Review that difference when transferring figures.

The local file neither lodges the BAS nor accesses the client’s ATO account. Entries stay in the current browser page, without a saved draft or upload. Keep the downloaded workpaper with its supporting records and complete your practice’s review before lodging.