Trial Balance Generator

What is a trial balance and why do you need one?

A trial balance is a report that lists every account in the general ledger alongside its debit or credit balance at a specific point in time. Its purpose is to verify that total debits equal total credits across the entire chart of accounts. If they don't balance, there is an error somewhere in the books that must be found and corrected before financial statements can be prepared. In double-entry bookkeeping, every transaction creates equal and opposite entries — so if debits and credits don't agree, at least one transaction has been recorded incorrectly.

Despite being a straightforward arithmetic check, the trial balance is one of the most important steps in the accounting cycle. It sits near the end of the period-close process — after all transactions have been posted, bank accounts reconciled, and adjusting journal entries recorded — and it is the direct source from which financial statements (the P&L and balance sheet) are prepared. For businesses working with an external accountant, a clean adjusted trial balance is typically the primary deliverable handed over at year-end, from which the tax return and statutory accounts are compiled.

A balanced trial balance does not mean the books are error-free — it only means debits equal credits. Errors of omission (a transaction not recorded at all), errors of commission (a transaction recorded to the wrong account), and compensating errors (two errors that cancel each other out) will not be detected by the trial balance alone. Those require careful review of individual account balances against expectations, which is why bank reconciliations and AP aging reviews are run alongside the trial balance as part of a complete month-end close.

How to use this generator

1. Enter your company name and trial balance date (typically the last day of the reporting period).
2. Work through each pre-populated account and enter the debit or credit balance from your general ledger. Add or remove accounts as needed to match your chart of accounts.
3. Monitor the balance indicator — it will confirm when total debits equal total credits. If they don't agree, trace back through your entries to find the discrepancy.
4. Download as PDF once balanced and file alongside your other period-end workpapers, or pass to your accountant as the basis for financial statement preparation.

What are common errors that cause a trial balance to be out of balance?

The most frequent causes of an imbalanced trial balance are: entering a debit to the wrong side (debiting a credit account or vice versa), posting a transaction to only one side of the ledger (a single-entry error), arithmetic mistakes in totalling sub-ledgers before posting to the general ledger, and data entry errors where the debit and credit amounts differ (transposition errors — e.g. entering $1,450 on one side and $1,540 on the other). When the trial balance is out of balance by an amount exactly divisible by 9, a transposition error is the most likely cause.

What is the difference between an unadjusted and adjusted trial balance?

The unadjusted trial balance is prepared before any period-end adjusting entries — it reflects the raw general ledger balances. The adjusted trial balance is prepared after all adjusting journal entries have been posted: accruals (e.g. accrued wages, accrued interest), prepayment amortisation (e.g. spreading annual insurance over 12 months), depreciation charges, and inventory adjustments. The adjusted trial balance is the version that feeds into the P&L and balance sheet. For Australian businesses, common adjusting entries also include GST reconciliation adjustments and superannuation accruals for the period.

How do GST accounts appear on an Australian trial balance?

GST-registered businesses maintain two GST clearing accounts: GST Collected (a current liability — the GST you have charged customers and must remit to the ATO, credit balance) and GST Paid / Input Tax Credits (a current asset — the GST you have paid on business purchases and can claim back, debit balance). The net of these two balances is what you remit to or receive from the ATO on your BAS. At period-end, these accounts should reconcile precisely to your BAS workpaper. PAYG Withholding Payable is a separate current liability representing tax withheld from employee wages that has not yet been remitted to the ATO.