Balance Sheet Template for Client Accounts
Assemble reviewed account balances, check both periods and download an editable Excel workpaper.
Balanced
Both periods balance and retained earnings reconcile.
Arithmetic checks only. Entries stay on this device. Your classification and reporting review remain separate.
Statement of financial position
| Line item | Current | Comparative |
|---|---|---|
| Current assets | $40,000.00 | $30,000.00 |
| Non-current assets | $40,000.00 | $35,000.00 |
| Total assets | $80,000.00 | $65,000.00 |
| Current liabilities | $28,000.00 | $23,000.00 |
| Non-current liabilities | $22,000.00 | $22,000.00 |
| Total liabilities | $50,000.00 | $45,000.00 |
| Net assets | $30,000.00 | $20,000.00 |
| Contributed capital | $10,000.00 | $10,000.00 |
| Retained earnings | $20,000.00 | $10,000.00 |
| Other equity | $0.00 | $0.00 |
| Total equity | $30,000.00 | $20,000.00 |
| Assets less liabilities and equity | $0.00 | $0.00 |
| Unclassified debit balance | $0.00 | $0.00 |
| Trial balance debit less credit | $0.00 | $0.00 |
Retained earnings reconciliation
| Movement | Current |
|---|---|
| Opening retained earnings | $10,000.00 |
| Profit or loss | $16,000.00 |
| Less distributions | $6,000.00 |
| Documented adjustments | $0.00 |
| Expected closing balance | $20,000.00 |
| Entered closing balance | $20,000.00 |
| Difference | $0.00 |
Review findings
What a Balance Sheet Shows
A balance sheet shows an entity’s assets, liabilities and equity at a reporting date. This balance sheet template assembles entered balances, checks both periods and reconciles closing retained earnings.
An asset is an economic resource the entity controls because of past events. A liability is a present obligation to transfer an economic resource. Equity is the residual after liabilities are deducted from assets.
The AASB Conceptual Framework sets out these definitions. Net assets equal assets minus liabilities. The accounting equation expresses the same relationship as assets equal liabilities plus equity.
The fictional trading company has $80,000 of assets and $50,000 of liabilities. Its $30,000 net assets equal $10,000 contributed capital plus $20,000 retained earnings.
Capital contributed by owners is an equity balance. Cash received from that contribution is an asset. Borrowed funds create a liability, even when the borrowing finances business assets.
The statement captures balances at one date. Profit measures a period’s performance. Cash movements belong in the cash flow statement, so neither profit nor retained earnings is the bank balance.
Current classification considers the operating cycle, trading purpose and expected recovery or settlement. The twelve-month test is one criterion. Loan classification also depends on the right to defer settlement.
AASB 101’s presentation requirements explain the current and non-current distinction. Apply the client’s reporting framework and assess contractual terms before assigning the final classification.
Enter and Reconcile the Balances
Start with the reviewed closing trial balance after profit has been transferred to equity. Enter each debit as positive and each credit as negative. The statement shows liability and equity credit balances as positive amounts.
Choose Account to edit to move between accounts. Add an account for each reviewed balance and record its source. Enter the comparative balance in the same classification, splitting a row when the presentation differs.
A credit balance in a contra-asset account reduces assets. A debit balance in accumulated losses reduces equity. Negative equity can balance: $100 of assets minus $150 of liabilities gives net assets of -$50.
The check compares assets with liabilities plus equity separately for each period. The trial-balance row also includes unclassified amounts. An unclassified account needs review even when its balance is zero.
In the example, current assets total $40,000 and non-current assets total $40,000. Current liabilities total $28,000 and non-current liabilities total $22,000. Both periods balance.
Increase Bank from $24,500 to $24,600 without another entry. The current statement then has a $100 difference. Return to the source records before adding any balancing adjustment.
Closing retained earnings equal opening retained earnings plus profit, minus distributions, plus documented adjustments. Enter a loss as negative. Enter distributions as positive amounts deducted by the formula.
The example reconciles $10,000 opening retained earnings plus $16,000 profit minus $6,000 distributions to $20,000 closing retained earnings. The tool compares that amount with all accounts classified as Retained earnings.
Reconcile opening retained earnings to the comparative closing amount. Document the basis for any adjustment, including a correction to an opening balance.
The reconciliation checks the entered movements. It does not establish a lawful dividend, available cash or the proper accounting treatment.
Review the Statement Format
Download Excel saves an editable .xlsx workpaper with the statement, comparatives, entered accounts and retained earnings reconciliation. Download blank Excel saves the account template for preparation in Excel or Google Sheets.
The completed example compares $80,000 of current-period assets with $65,000 in the comparative period. Comparative liabilities are $45,000 and equity is $20,000. Reset example restores those balances and movements.
The workbook contains values without spreadsheet formulas. Editing an exported balance does not update its totals. Make changes in the browser workpaper and download again, or add and review your own spreadsheet formulas.
Review recognition and measurement before presentation. Check account aggregation, comparative consistency and supporting notes. Assess restrictions on cash, loan covenants and the current portion of borrowings from the underlying records.
Confirm whether the client applies AASB 101, AASB 18’s application requirements or another applicable reporting basis. A balanced template does not establish compliance with a reporting framework.
This workpaper covers a statement of financial position and a retained earnings check. Complete any other required statements and disclosures before issuing financial statements.
Entries stay in browser memory. Clear workpaper, leaving the page and restored navigation clear them. Downloaded files remain where you save them.