On Monday morning, open a Google Sheet and your banking app before buying anything for the business. Name the file Business expenses — 2026–27. Your new sole trader expense records need to connect three things: what you bought, why it was for work, and the payment that settled it.
Monday: the first purchase is about to hit your personal card
Mixing personal and business spending from day one is the decision hardest to unwind later. Changing a spreadsheet category takes seconds. Reconstructing which of 80 supermarket, fuel and online purchases belonged to the business takes considerably longer.
Open a separate account used only for business, with its own payment card. A separate business account generally isn't compulsory for an Australian sole trader, but check your bank's account conditions. Route customer payments and business purchases through it.
Transfer starting funds into that account and label the transfer Owner contribution, not sales. Money moved back for personal use is Owner drawing, not an expense.
Already paid for printer paper personally? Keep the receipt and record Personal card — owner-paid in the payment-account field. If you later reimburse yourself, match that transfer to the existing purchase; don't create another expense.
Tuesday: the supplier charged GST, but are you registered?
An ABN does not automatically register you for GST. Before building formulas, add a Setup tab with these fields:
ABNBusiness start dateGST status: Registered / Not registered / CheckingGST registration effective date: blank until confirmedGST accounting basis: Cash / Non-cash / Not applicableBAS frequency and next due date: from your ATO accountNext GST turnover review date
For most businesses, compulsory GST registration starts at AUD 75,000 GST turnover, assessed using current or projected turnover—not profit. Registration is generally required within 21 days of becoming required to register. Exceptions apply, including taxi and ride-sourcing services regardless of turnover. Check the ATO's GST registration guidance for your circumstances.
If you're not registered, keep recording GST shown on receipts but set GST credit recorded to zero. If registered, that column needs review against the purchase's eligibility, business use and supporting document. Never calculate every credit as total divided by 11: some purchases contain no GST or a mixture of taxable and GST-free items.
If registration changes, retain its effective date and flag affected purchases for review rather than rewriting earlier rows indiscriminately. These are record-keeping practices, not tax advice; ask a registered tax or BAS agent about uncertain treatment.
Wednesday: turn the first receipt into a reusable row
Create an Expenses tab. Copy the field names below across row 1, one field per column. The second column shows one complete example record for row 2; amounts are AUD. This trader isn't GST-registered.
| Column heading | Example value |
|---|---|
| Expense ID | EXP-0001 |
| Receipt date | 2026-11-11 |
| Payment date | 2026-11-11 |
| Merchant | Officeworks |
| Receipt or invoice number | OW-118642 |
| Description and business purpose | Paper and folders for client job packs |
| Category | Office supplies |
| Total AUD | 132.00 |
| GST shown AUD | 12.00 |
| Business use % | 100% |
| Business portion AUD | 132.00 |
| GST credit recorded AUD | 0.00 |
| Payment account | Business debit •4821 |
| Bank match reference | 2026-11-11 / OFFICEWORKS / 132.00 |
| Receipt link | Link to stored receipt image |
| Review status | Checked — not GST-registered |
| Notes | All items for business |
Business portion AUD = Total AUD × Business use %. This records allocation, not an automatic tax deduction. Support mixed-use percentages in Notes; leave uncertain allocations marked Needs review rather than guessing.
Scan2Sheet can extract receipt data into your own Google Sheet, categorise expenses and link cloud-stored receipt images. Use it for capture, then check the extracted values and complete your purpose, payment and review fields. Keep categories consistent: don't alternate between Office supplies, Stationery and Office costs for identical purchases.
Second Friday: the bank shows a purchase the sheet doesn't
Start these three habits immediately:
- Capture at purchase. Photograph every page of a long receipt, including the totals. Check readability before discarding paper. A card slip proves payment but often lacks the item detail you need.
- Match payments every Friday. Compare the sheet with bank transactions. Investigate missing purchases and duplicate merchant/date/amount combinations; don't delete automatically because two legitimate purchases can match. Record refunds separately and reference the original expense.
- Close each month deliberately. Resolve
Needs reviewrows, check receipt links and save a dated sheet export plus a statement copy. Review GST turnover against your reminder.
Use 30 June as EOFY. If lodging quarterly BAS, standard due dates are 28 October, 28 February, 28 April and 28 July; confirm your actual deadline with the ATO. Most business records generally need keeping for five years, with longer periods for some records.
Create the tabs before your next purchase, then connect Scan2Sheet to make receipt capture part of paying—not an EOFY reconstruction.