Sole Traders

Your First Fortnight With an ABN: Set Up Expense Records That Stay Useful

Copy an expense-sheet template, record your GST position and establish three habits before personal purchases start muddying your business records.

A Monday-morning setup for your first two weeks in business.

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:

  • ABN
  • Business start date
  • GST status: Registered / Not registered / Checking
  • GST registration effective date: blank until confirmed
  • GST accounting basis: Cash / Non-cash / Not applicable
  • BAS frequency and next due date: from your ATO account
  • Next 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 headingExample value
Expense IDEXP-0001
Receipt date2026-11-11
Payment date2026-11-11
MerchantOfficeworks
Receipt or invoice numberOW-118642
Description and business purposePaper and folders for client job packs
CategoryOffice supplies
Total AUD132.00
GST shown AUD12.00
Business use %100%
Business portion AUD132.00
GST credit recorded AUD0.00
Payment accountBusiness debit •4821
Bank match reference2026-11-11 / OFFICEWORKS / 132.00
Receipt linkLink to stored receipt image
Review statusChecked — not GST-registered
NotesAll 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:

  1. 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.
  2. 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.
  3. Close each month deliberately. Resolve Needs review rows, 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.