Australian sole traders live in their bank statements at tax time — every business deduction, every GST credit, and every dollar of income the ATO expects to see is sitting in a Commonwealth Bank PDF. When you convert Commonwealth Bank statement PDF to Excel, that pile of documents becomes one working ledger: income separated from expenses, GST tagged, deductions categorized the way your tax agent needs them. This guide walks through the CommBank workflow for sole traders: downloading a complete year from NetBank, converting in a batch, building the deduction categories the ATO recognizes, and reconciling the final workbook before your return goes in.
What the ATO expects from a sole trader's records
The ATO requires business records that explain every transaction — what it was, when it happened, and how much GST was involved. For a sole trader, the bank statement is usually the primary record, and PDFs are a poor version of it: they cannot be filtered, summed, or searched, which makes substantiating deductions and reconciling BAS figures painful. A spreadsheet solves the structural problem. One row per transaction with real dates and numeric amounts means your accountant can filter to business-only activity, pivot by category, and tie every reported figure back to the source. If you are registered for GST, the same workbook produces your BAS: GST collected on sales minus GST credits on purchases, quarter by quarter. Our PDF-to-Excel conversion guide covers the general technique behind this workflow.
Step 1: Download a full year from NetBank
- Log in to CommBank NetBank (or the CommBank app) and open the account your business runs through.
- Go to Statements and download each month of the financial year — July to June — as a PDF.
- Download the official monthly statements, not transaction-history exports: the statement carries opening and closing balances your tax agent reconciles against.
- If business and personal money share the account, download the personal statements too — separating them in the workbook is honest work, but it is necessary work.
- Name files clearly: commbank-biz-2025-07.pdf keeps a July-to-June batch in order.
CommBank keeps several years of statements online, so a full financial year is easy to assemble. More CommBank specifics are on our Commonwealth Bank page.
Step 2: Convert every PDF to Excel in one session
Upload each CommBank PDF to Convert Statement in your browser — nothing to install — and download the Excel file. Batch discipline matters:
- Convert in financial-year order (July first) so the merge lands chronologically.
- Identical settings every file so column order matches across all twelve months.
- Spot-check one month completely — totals against the PDF — rather than glancing at all twelve.
- Merge into one sheet by pasting every month's rows under the first header: one continuous table beats twelve tabs.
Most monthly CommBank statements convert within the free tier. If your tax agent imports into accounting software, keep a CSV copy as well — the CSV guide shows the expected column layout.
Step 3: Build ATO-friendly deduction categories
Add a Category column and tag every row with labels your tax agent can map straight to the return:
- Business income: every client payment and platform payout. Mark transfers between your own accounts separately — moving money is not income.
- Cost of sales: materials and subcontractors directly tied to jobs.
- Home office: the business-use share of internet, phone, and utilities. Tag the full bill and note the business percentage in a separate column — your agent applies the apportionment.
- Motor vehicle: fuel, servicing, insurance, and registration, with business kilometres logged against each.
- Software and subscriptions: the tools that run the business, all deductible.
- GST tag: add a GST column marking which expenses carried GST — this is what makes the BAS a filter instead of a forensic exercise.
A pivot table of Category by Month gives your tax agent every line of the return. Two habits multiply the value: expand CommBank's truncated payee descriptions into plain English while the year is fresh, and flag anything you cannot identify with a "?" rather than guessing. Our reconciliation guide shows how to prove the workbook ties to the PDFs before it goes anywhere.
Step 4: Reconcile and hand off securely
Final verification before filing: opening balance matches the July PDF, closing matches the June PDF, no duplicate rows from overlapping periods, and no owner transfers sitting in income or expense categories. Then send the workbook through your tax agent's secure portal — never plain email. A full year of banking data is exactly the kind of document our data-security best practices are written to protect. Include the original PDFs so the agent can verify against source documents, and add a one-line cover note with the account list and anything unusual (a new loan, an asset purchase). That context saves rounds of follow-up questions.
Frequently asked questions
Do I need to keep the original CommBank PDFs?
Yes. The ATO can request supporting documents, and the PDF is the source record — the Excel workbook is your working copy. Keep both for at least five years.
What if I mix business and personal spending in one CommBank account?
Add a Business/Personal column and tag every row. Then open a separate business account for next year — it is the single biggest simplification a sole trader can make.
Can I claim GST credits on expenses from the workbook?
Yes, if you are GST-registered: filter to business expenses with the GST tag and total the GST column per quarter. Your tax agent will confirm the claim, and the workbook makes the evidence trivial to show.
What about income in US dollars?
Record the original amount and the AUD equivalent at the transaction date in separate columns. The ATO wants AUD figures, but the audit trail should show the original currency.
Your deductions are only as good as your records. Convert your Commonwealth Bank statements to Excel free today, categorize once, and hand your tax agent a workbook instead of a headache — or check pricing when a full financial year exceeds the free tier.