Bookkeeping Template for Client Records
Prepare a local bookkeeping workbook with account totals and unresolved entries for review.
Ready for review
Journal entries balance. Review the source records before reporting.
Entries stay on this device. GST classifications are supplied by you. The workbook keeps unresolved items.
Debit and credit totals
| Stage | Debit | Credit |
|---|---|---|
| Opening | $12,500.00 | $12,500.00 |
| Journal | $1,100.00 | $1,100.00 |
| Closing | $13,600.00 | $13,600.00 |
Closing account balances
| Account | Debit | Credit |
|---|---|---|
| Bank | $13,600.00 | $0.00 |
| GST payable | $0.00 | $100.00 |
| Opening equity | $0.00 | $12,500.00 |
| Service income | $0.00 | $1,000.00 |
Unresolved entries
- No issues found by these checks. Source review remains separate.
Enter the Opening Records
This bookkeeping template turns entered account balances and transactions into a local workbook. Review the balance checks, then download the editable Excel workbook.
Use a practice reference for the business. Set the transaction period and copy the confirmed opening balances from the previous closing records. Account codes must be unique.
The Accounts tab holds your chart of accounts and opening balances. A cashbook records money entering and leaving a cash account. The Cashbook tab shows the account selected in Cash account code.
A journal records each transaction’s debit and credit lines together. The Journal tab keeps those lines in entered order. A double-entry ledger groups both sides by account.
The Ledger tab shows each account’s opening balance, movements and closing balance.
Keep the CSV headers in the two input boxes. Each account row needs Code, Account, Type, Opening debit and Opening credit. Types are Asset, Liability, Equity, Income and Expense.
Each journal line needs Journal, Date, Reference, Account code, Debit, Credit, GST classification, Source record and Note. Use the same journal ID for all lines of one transaction.
Enter dates as YYYY-MM-DD. Keep journal rows in date order for the cashbook’s running balance. Put commas inside quoted CSV cells. Blank amount cells count as zero.
Source record can hold a document reference or a link you already have. The tool keeps that text without opening it. It connects to neither bank feeds nor accounting software.
Check Debits, Credits and Totals
A debit increases an asset or expense account. It decreases a liability, equity or income account. A credit has the opposite effect. Debit does not mean money leaving every account.
In the fictional example, Bank opens with a $12,500 debit and Opening equity with a $12,500 credit. A $1,100 customer receipt debits Bank by $1,100.
The matching credits are $1,000 to Service income and $100 to GST payable. The practitioner supplies that split. Both journal columns total $1,100. Closing balances are $13,600 on each side.
The opening check compares opening debits with opening credits. Each journal is checked separately, so two opposite mistakes in different journals still appear. The closing check compares the net account balances.
Change the Service income credit to $900 to see a $100 journal difference. The workbook preserves the entry and the difference. Enter a reversal on the opposite side, or use a negative amount once.
The unresolved list also flags missing details, duplicate lines and references reused across different journals. Repeating a reference within one balanced journal is expected. Every flag keeps the original entry.
Choose GST classifications from your own assessment of the source records. The labels are Taxable sale, GST-free sale, Input-taxed sale, Taxable purchase, Purchase without GST, Outside scope and Review.
These are descriptive workbook labels, not BAS reporting codes. The tool neither calculates GST nor infers treatment from transaction text. Mixed transactions need separate lines with the classifications you supply.
The ATO distinguishes taxable, GST-free and input-taxed sales. Its GST record-keeping guidance explains which records support the amounts and decisions you enter.
Review and Export the Workbook
Download Excel workbook creates an Excel accounting spreadsheet with Setup, Accounts, Journal, Cashbook, Ledger and Unresolved tabs. Open the .xlsx file in Excel or a compatible spreadsheet application.
The Accounts and Journal input cells stay editable. Formula cells are protected without a password against accidental edits. Cashbook and Ledger formulas recalculate from the input tabs, with 200 account slots and 1,000 journal slots.
The Journal difference column recalculates each journal’s debit less credit. Ledger shows opening net balance, debit and credit movements, then closing net balance. Closing net equals opening net plus debits minus credits.
The Unresolved tab records the checks at export. It is a snapshot. After workbook edits, paste the updated input rows back into the tool to regenerate duplicate, date and GST-review findings.
Unbalanced records can be exported for investigation. Malformed amounts, missing account codes or an invalid period stop the export. Correct those marked fields first. The tool never creates a balancing entry.
This small-business bookkeeping template is a review workpaper. A complete client ledger system also manages ongoing posting and reconciliations. Final financial statements require the practitioner’s adjustments and reporting decisions.
Equal totals do not establish completeness or correct classification. ACCA’s explanation of accounting errors shows why some errors leave a trial balance equal.
Compare the cashbook with the source bank records and resolve the listed items before using the balances. Your entries stay in browser memory and clear when you leave. Downloaded workbooks remain where you save them.