How to track your ABN income and expenses without a spreadsheet

If you earn money through an ABN, there is a good chance your financial system started accidentally.

One client pays you by bank transfer. Another takes 30 days. Adobe comes out every month. You buy a hard drive for a job, grab parking on the way to a shoot, replace a broken cable and tell yourself, “I'll sort all this out later” — but ‘later’ often has a habit of becoming June.

For a lot of sole traders, the problem is not that their business finances are wildly complicated. It is that information is scattered across a bank account, email inbox, camera roll, invoice PDFs and a spreadsheet that only gets opened when something feels urgent.

Most sole traders have the same question: does keeping your ABN records organised have to feel like doing accounts? Every end of financial year, sole traders have four key questions:

1. How much ABN income have I actually received?
2. How much am I still waiting to be paid?
3. What business expenses have I recorded?
4. Do I have the records I may need to support those transactions later?

Answering those consistently throughout the year puts you a long way ahead of the “I'll reconstruct it at tax time” approach.

Why tracking ABN money gets messy so quickly

Picture a freelance photographer working three jobs in one month.

A café pays $1,200 the day after the shoot. A marketing agency is invoiced $2,800 on 30-day terms. A musician pays a $500 deposit now and the balance after the event.

At the same time, the photographer pays for cloud storage, editing software, parking, equipment hire and part of a mobile plan used for both personal and business purposes. Nothing there is especially unusual. But if every piece lives somewhere different, even a simple month becomes difficult to understand.

This is why good record keeping matters. Australian Government guidance says businesses need records of income and sales transactions, business expenses and other transactions relating to tax and registrations. Most business records need to be kept for five years, although some records need to be retained longer. The aim is not to become a bookkeeper, but to create one reliable place where the story of your ABN money makes sense.

Step 1: Separate “invoiced” from “received”

One of the easiest ways to confuse yourself is to look at every invoice you have sent and think of the total as money already earned and available. From a day-to-day cash-flow perspective, there is a useful difference between:

• $2,000 invoiced to a client
• $2,000 actually received in your account

If you sent the invoice yesterday and the client has 30 days to pay, that money is still outstanding. A practical tracking system should therefore show at least three things: what has been invoiced, what has been paid, and what is overdue.

That is an organisational view, not a rule about when income is taxable. Businesses can use cash or accrual accounting methods in different circumstances, and the tax treatment can depend on the accounting method and the nature of the income. If you are unsure which method applies to you, speak with your accountant or registered tax agent. For everyday visibility, however, keeping “money received” and “money still owed” separate is extremely useful.

Step 2: Record income when it happens

Your income record does not need to become a novel. For a simple sole trader, a useful income entry might contain:

• date
• client or source
• description of the work
• amount
• whether it has been received or is still invoiced
• linked invoice number, where relevant

That is enough context for ‘Future You’ to understand the transaction without having to decode a bank statement months later.

Step 3: Record expenses while you still remember what they were

This is where many sole traders get caught. A $38.99 transaction is obvious today — it was your design software subscription. Nine months later it is just “ADOBE*SERVICES” sitting between groceries and a streaming subscription. When you record a business expense, capture the context while it is fresh:

• merchant or description
• date
• amount
• category
• how much related to business use
• receipt or other supporting record
• whether it is a recurring expense

Government guidance notes that businesses need to keep records of business expenses, including cash purchases. If you claim a business deduction, you also need records that substantiate the claim.

The important distinction is that recording something as a business expense does not automatically make every dollar deductible. The tax treatment depends on the expense and your circumstances. Your record-keeping system should help organise the facts; your accountant or tax adviser can confirm the treatment.

Step 4: Deal with mixed business and personal use honestly

Not everything fits neatly into “work” or “personal”. Your phone might be used to call clients, shoot social content and send invoices. At the same time, you use your phone to message friends and scroll Instagram at midnight. Similarly, your laptop might be your editing machine during the week and your Netflix screen on Sunday.

For mixed-use expenses, the relevant business-use portion can matter. The ATO's guidance across work and business expenses makes clear that private use generally needs to be separated from income-producing use, and records should support how a percentage was worked out.

A practical workflow is simply to ask: “How much was for work?”

If the answer is 100%, record that. If it was partly for work, record a reasonable percentage and keep the evidence behind your calculation. If you are unsure, flag it for review instead of pretending you know. That is far better than making a confident guess at EOFY.

Step 5: Treat recurring costs as their own category of admin

Subscriptions are easy to ignore because they happen quietly. A designer might have Adobe, Canva, Dropbox, Google Workspace, a domain, hosting, an AI tool and a phone plan. Individually, none may feel significant. Across twelve months, they can become a meaningful part of business spending.

To stay on top of this, keep a list of regular business costs and review them as they renew. This has two benefits: your expense records stay current, and you can see what your business is costing you before you take on another subscription “for only $19 a month”.

Step 6: Store the receipt with the expense, not somewhere else

A receipt in your camera roll is better than no receipt. A receipt attached to the transaction it relates to is better again. Digital record keeping is accepted, and business.gov.au specifically lists accounting software, web-based systems and spreadsheets as digital record-keeping options. The system matters less than whether the records are complete, retrievable and kept for the required period.

The practical rule: if you would struggle to find a receipt again in 30 seconds, it is not really organised.

Step 7: Review your records regularly, not annually

The best time to organise a $165 coworking expense is not eleven months after you paid it. A weekly or fortnightly five-minute check is enough for many sole traders:

• add anything missing
• attach new receipts
• mark paid invoices
• follow up anything overdue
• confirm recurring costs
• review expenses where business use is unclear

Think of it like cleaning your camera gear after a shoot or resetting your tools at the end of a job. It is small maintenance that prevents a much bigger mess later.

What “ready for EOFY” should actually mean

EOFY readiness is not about having perfectly polished accounts on 30 June. For a simple sole trader, a much more useful goal is being able to hand over organised records showing:

• ABN income recorded
• invoices and payment status
• business expenses by category
• receipts and supporting documents
• business-use percentages where relevant
• unresolved items clearly flagged for review

That gives your accountant or tax adviser a cleaner starting point, and gives you a much better understanding of your own business throughout the year.

Where Indi fits

Indi is built around this simpler workflow. Instead of asking you to become an accountant, Indi helps you track what came in, what went out and what you are still owed. You can record income and expenses, store receipts, create and track invoices, confirm recurring costs and build an EOFY Tax Pack as you go.

The idea is simple: spend a few minutes staying organised during the year so June does not become an archaeological dig through your bank account.

Your financial companion. Your sole trader money, sorted.