Bank Statements to Excel & CSV: An Osteopath's Guide

The last patient of the week is out the door, the treatment couch is wiped down, and the card machine has stopped chirping. Then you remember the other job — the one nobody trained you for. A folder of PDF bank statements is sitting in your online banking, and inside those pages is everything your tax return needs: your patient fees, your clinic room rent, your CPD, your indemnity insurance renewal. But it is locked inside a PDF, and when you paste it into Excel three tidy columns turn into one unreadable smear. If you are a self-employed osteopath doing your own books, this guide shows you how to turn those statements into a clean Excel or CSV file you can actually use — sort, categorize, reconcile, and either file yourself or hand to an accountant.

First, a point worth clearing up, because it changes who this article is for. In the UK, Australia, and much of Europe, an osteopath is a regulated manual-therapy practitioner — in the UK, registered with the General Osteopathic Council (GOsC); in Australia, registered with the Osteopathy Board of Australia through AHPRA. You are typically self-employed and private-pay: patients pay you directly, and some later claim on private health cover. That is a different job from a US “DO” (Doctor of Osteopathic Medicine), who is a fully licensed physician. This guide is for the manual-therapy osteopath, not the US DO. Everything below assumes a private clinic, direct patient payments, and a sole-trader tax return.

The bookkeeping reality of a self-employed osteopath

Whether you rent a room in a multidisciplinary clinic, run your own practice, do home visits, or work across two or three locations, you are effectively a small business of one. That comes with a short but non-negotiable list of duties.

• Separate business and personal money. Even one dedicated account or card for patient income and practice spending makes every later step far easier. Mixed accounts are the single biggest reason osteopath bookkeeping eats a whole weekend.
• Track income and deductible expenses. Your revenue (patient fees by card, cash, or bank transfer; clinic-share payouts) and your costs (room rent, equipment, CPD, registration and insurance, mileage) all live inside your bank statements.
• Set aside for tax. In the UK you report as a sole trader through Self Assessment and pay what you owe after the year end; many practitioners set money aside monthly so the bill is never a shock. In Australia, self-employed osteopaths generally manage tax through the ATO, often via PAYG instalments.
• Keep your records. Tax authorities can ask you to substantiate what you claimed, sometimes years later, so your statements and their spreadsheet summaries need to stay retrievable.

A few anchors worth knowing — though rules and figures change, so always confirm what applies to your tax year with the official tax authority rather than a blog. In the UK, self-employment income above the £1,000 trading allowance means you must register for Self Assessment; there is a registration deadline in the October following the tax year you started, so check the current date. Making Tax Digital for Income Tax is being phased in for higher-earning sole traders, which pushes record-keeping toward MTD-compatible software rather than a shoebox of receipts — a plain spreadsheet on its own is not a compliant filing method, so treat it as your working ledger, not the final submission. HMRC’s core test for any expense is that it must be “wholly and exclusively” for the business; where a cost is part-personal, you claim only the business share.

None of these duties are hard. They are just tedious — and they all depend on getting your bank data into a format you can sort and total.

Why the PDF statement is a dead end (and Excel/CSV changes everything)

Your bank gives you a PDF because it looks tidy and prints cleanly. But a PDF is a picture of a table, not a table. There are no real rows and columns underneath — just text placed at coordinates on a page. That is why:

• Copy-paste breaks. Dates, descriptions, and amounts collapse into one column, or amounts land on the wrong row.
• You cannot sort or filter. You cannot pull “all CPD payments” or “everything above £100” out of a PDF.
• You cannot total anything. No SUM, no per-category subtotal, no year-to-date income figure.
• Accounting software rejects it. Most bookkeeping tools import CSV, not PDF, when there is no live bank feed.

A spreadsheet flips all of that. Once your transactions are real rows in Excel or a CSV, you can sort by amount, filter by category, build a pivot table that totals your patient income and each expense group in seconds, and import the file into QuickBooks, Xero, or whatever your accountant uses. The statement stops being an image and becomes data.

Here is the same information, before and after.

In the PDF statement	In an Excel / CSV file
Fixed picture of a table	Sortable, filterable rows
Copy-paste scrambles columns	Clean Date / Description / Amount columns
No totals or subtotals	SUM, pivot tables, category totals
Can’t import to accounting software	One-click CSV import
Manual line-by-line reading	Filter to find every deduction at once

If you want the deeper mechanics of the conversion itself, we cover both formats in detail in How to Convert a Bank Statement PDF to CSV (3 Methods) and How to Convert a Bank Statement PDF to Excel.

The step-by-step method for an osteopath

Here is the full workflow, from a folder of PDFs to a filed return or a tidy handoff. Block out one hour and do it in order.

1. Gather every statement

Download your PDF statements for the whole tax year from your bank’s online portal — ideally from the account your patient fees land in. If your practice and personal money are mixed, pull everything; you will separate it in the spreadsheet. Aim for a complete run of months with no gaps, because a missing month is a missing chunk of income the tax office will notice.

2. Convert the PDFs to Excel or CSV

This is the step that used to eat your evening. Instead of retyping, run each PDF through a converter that reads the statement and outputs real spreadsheet rows — Date, Description, Amount — with the figures extracted faithfully. A purpose-built bank statement converter handles the messy layouts (multi-line descriptions, running balances, split debit/credit columns) that generic PDF tools mangle.

BankStatementLab converts a PDF statement to Excel (.xlsx), CSV, or JSON in a few seconds, keeps your dates and amounts intact, and works across banks and languages — so an osteopath with a business account at one bank and a card at another gets one consistent format. Crucially for anyone handling sensitive banking data: your source PDF is not stored after the conversion. The file is processed and discarded, not kept on a server — which matters when the document lists your name, account number, and every payment your patients made. The tool runs on a simple credit system, with one credit per statement page, so a full year of statements is quick to process.

3. Categorize: income vs deductible expenses

Add a Category column and tag every row. For a self-employed osteopath the buckets usually look like this.

Category	Typical osteopath transactions	Tax angle
Income	Patient fees (card, cash, transfer), clinic-share payouts	Report all of it — deposits are visible to the tax office
Clinic room / premises	Room rental, clinic-share of rent, business rates, utilities	Deductible where used for the practice
Equipment & supplies	Treatment couch, couch roll, consumables, small kit	Work-specific items generally deductible
CPD & registration	GOsC/AHPRA registration, CPD courses, professional body (e.g. iO) fees	Maintaining an existing professional skill is generally allowable
Insurance & admin	Professional indemnity cover, phone, booking/notes software	Business-use portion
Vehicle / mileage	Fuel, parking, tolls for home visits (or log miles for the flat rate)	Only genuine business travel, not the commute

Two points that trip osteopaths up specifically. On mileage, in most systems you deduct either the flat per-mile rate or actual vehicle costs, not both, so pick the method that gives you more and keep a mileage log to back it up — and remember your ordinary commute to a fixed clinic is generally not claimable, whereas a home visit usually is. On training, the rule is that keeping an existing skill current (your mandatory CPD, registration, and indemnity to keep practising) is treated very differently from learning an entirely new trade, so log routine CPD as CPD and check the position on any course that teaches a genuinely new discipline.

To speed up tagging, sort by description and label transactions from the same payee in batches. If you find yourself doing this every month, it is worth learning to auto-categorize transactions with pivot tables.

4. Reconcile

Reconciling just means checking that your spreadsheet matches reality. Confirm the closing balance on your last statement equals the running total in your sheet, so nothing is missing or double-counted. If you take card payments, match the processor’s payout deposits against the fees they skim, because the payout that lands in your account is usually net of a charge you can also deduct. Catching a mis-keyed amount now is far cheaper than explaining it under enquiry later.

5. File it yourself or hand it to an accountant

With a clean, categorized spreadsheet you can either total each category and drop the numbers straight onto your return (the self-employment pages of Self Assessment in the UK, or your ATO return in Australia), or export the file and send it to your accountant. Which brings us to the money question.

DIY vs delegating — and how clean files cut your accountant’s bill

You do not have to choose all-or-nothing. Most self-employed osteopaths land somewhere in the middle: they do the data prep themselves and let a professional handle the filing.

• Full DIY works if your setup is simple — one account, one income stream, straightforward deductions. A spreadsheet and the current thresholds may be all you need.
• Delegating everything buys peace of mind but costs the most, especially if you hand over a folder of PDFs and let the accountant do the data entry at their hourly rate.
• The middle path is usually best value: you convert and categorize, and the accountant reviews, optimizes, and files.

That middle path is where the real savings hide. Accountants often bill by time, and a large share of that time is pure data entry — retyping transactions off statements. Hand them a clean Excel or CSV with categories already applied and you remove that work entirely; they spend their time on advice, not typing. It is the difference between “here are twelve PDFs” and “here is a reconciled workbook.” Our guide on how to prepare bank statements for your accountant walks through exactly what to send.

Convert your bank statements to Excel or CSV in seconds — start with BankStatementLab

A worked example: one month of an osteopath’s statement

Theory is easier to trust when you see it applied. Below is a single month from a self-employed osteopath’s account, converted from PDF and tagged with a Category column. The labels are generic on purpose — this is exactly what a converted statement looks like before you total it. Amounts are shown without a currency symbol so the example reads the same whether you bill in pounds, dollars, or euros.

Date	Description	Amount	Category
Mar 03	Patient fees — card takings	+1,920.00	Income
Mar 06	Clinic room rental	-360.00	Clinic room / premises
Mar 10	Fuel — home visits	-58.40	Vehicle / mileage
Mar 13	CPD course	-145.00	CPD & registration
Mar 17	Indemnity insurance	-42.00	Insurance & admin
Mar 20	Transfer to personal account	-700.00	Personal (exclude)
Mar 24	Couch roll & consumables	-31.60	Equipment & supplies
Mar 28	Patient fees — bank transfers	+540.00	Income

Total the categories and the picture is instantly clear. Income: 2,460.00 (the card takings plus the bank-transfer fees). Deductible expenses: 637.00 (room rental, fuel, CPD, indemnity insurance, and consumables). The 700.00 transfer to your personal account is neither income nor an expense — it is your own money moving between your own accounts, so you exclude it, and forgetting to do so is one of the most common ways osteopaths overstate either side of their books. Net taxable position for the month: 2,460.00 minus 637.00, or 1,823.00. Do this twelve times and your return is already written.

Common mistakes and traps to avoid

Even careful osteopaths trip on the same few things.

• Retyping by hand. It is slow and it introduces errors — a transposed digit in a day’s takings misstates your income. Let a converter read the figures.
• Mixing personal and business. If your weekly shop sits next to your indemnity renewal, sorting takes hours. Separate accounts, or at least a dedicated card, fix this at the source. See how to separate personal and business expenses.
• Forgetting cash and card takings. Bank transfers are the easy part; make sure cash payments and card-machine payouts are all captured. Undeclared income is exactly what enquiries are built to find.
• Claiming your commute. Travel to a fixed clinic is generally not deductible, while a genuine home visit usually is — don’t blur the two.
• Guessing at deductions. Claim what you can substantiate under the “wholly and exclusively” test, and keep the statement that proves it. When unsure whether something qualifies, check the current rules or ask your accountant rather than inventing a rule.
• Trusting a scrambled export. Generic PDF-to-Excel tools often shift amounts onto the wrong row. Always eyeball the converted file against the statement before you total anything.
• Uploading sensitive statements to a tool that keeps them. Your statement is a goldmine of personal data. Prefer a tool that processes and discards the file rather than storing it.

Going further: build a system, not a scramble

Once you have done this once, turn it into a light monthly rhythm instead of an annual ordeal.

• Convert monthly. Ten minutes at the end of each month beats a lost weekend in tax season, and your numbers stay current enough to steer.
• Keep one master workbook. Batch several statements into a single spreadsheet so your whole year lives in one file — see how to batch convert multiple statement PDFs into one spreadsheet.
• Watch cash flow. A running total tells you whether a quiet month after the holidays is survivable, and flags where spending crept up.
• Set aside tax as you go. With categorized income visible month by month, putting away the right share for your bill stops being guesswork.
• Mine your statements for missed deductions. A surprising number of legitimate write-offs — registration, CPD, indemnity, couch consumables — hide in plain sight; hidden tax deductions freelancers miss on bank statements is worth a read before you finalize.

If you have no invoices and your whole record is the bank feed — common for a private-pay osteopath whose patients tap a card and leave — the statement effectively is your books, and that is a perfectly valid way to work. Our guide on bookkeeping from bank statements when you have no invoices shows how.

Three ways to convert a statement, compared

If you are weighing how to actually get the numbers out of the PDF, here is the honest trade-off between the three routes, using the month above as the yardstick.

Method	Time for one month	Reliability	What happens to the columns
Retype by hand	20-40 minutes per statement	Error-prone — one transposed digit misstates your income	Perfect layout, but only if you never mis-key
Generic PDF-to-Excel tool	A few minutes, plus cleanup	Hit or miss on bank layouts	Amounts often shift onto the wrong row; multi-line descriptions break
Dedicated bank statement converter	Seconds	Built for messy statement layouts	Clean Date / Description / Amount columns, ready to categorize

The manual route feels cheap until you count the hour and the risk of a mistyped total. Generic tools save typing but hand you a file you have to police line by line. A purpose-built converter reads the statement structure — running balances, split debit and credit columns, wrapped descriptions — and gives you rows you can total without eyeballing every one. Whichever you choose, always compare the converted file against the original statement before you trust the totals.

The bottom line

Your bank statements already contain a complete, honest record of your patient income and your deductible practice costs. The only thing standing between that PDF and a filed, optimized tax return is the format. Convert your statements to Excel or CSV, tag income against room rent, CPD, registration, indemnity, equipment, and mileage, reconcile, and you have turned an anxious annual scramble into an hour of clean work — whether you file yourself or hand tidy books to an accountant who charges you less for the privilege.

You trained to treat patients, not to fight with PDFs. Let the software do the data entry.

Turn your PDF bank statements into a clean, spreadsheet-ready file — try BankStatementLab now

Frequently asked questions

How long do I need to keep my bank statements as a self-employed osteopath?

Long enough to survive a query. In the UK, sole traders are generally expected to keep business records for around five years after the Self Assessment filing deadline for that tax year, and in Australia the ATO typically expects records kept for around five years too — but confirm the exact period for your situation, and lean toward keeping longer rather than shorter. A dated Excel or CSV export of each statement is the easiest way to stay retrievable, because it sits neatly alongside the original PDFs — see how long to keep bank statements when self-employed.

Do I legally need a separate bank account for my osteopathy practice?

As a sole trader you are usually not required to have a dedicated business account — your patient income and personal money can legally sit in one place. But mixing them makes bookkeeping painful and enquiry-prone, because every statement then blends your food shop with your indemnity renewal. A single dedicated account, or even one card used only for the practice, pays for itself the first time you categorize. If you are already mixed, you can still separate everything in the spreadsheet — here is how.

Can I claim my GOsC (or AHPRA) registration, CPD, and indemnity insurance as expenses?

Generally yes. Mandatory registration with your regulator, the professional indemnity cover you must hold to practise, and the CPD you complete to keep your registration current are all costs of maintaining your existing profession, which are typically allowable against your self-employment income. Membership of a professional association such as the Institute of Osteopathy usually sits in the same bucket. Keep the statement line that shows each payment, tag it under CPD & registration or Insurance, and confirm the treatment for any unusual course with your accountant.

How do I record card takings when the payout is net of a processor fee?

Record the gross patient income and deduct the processor fee separately, rather than only banking the net figure. The payout that lands in your account has usually had a small percentage skimmed off; that fee is itself a deductible business cost. In your spreadsheet, tag the payout as income at the gross amount where you can see it, and record the processing fee as its own expense line — it usually nets out to the same taxable profit, but doing it properly matters if the tax office compares your declared income against your deposits.

Is the drive to my clinic a deductible business mile?

Usually not. Travel between home and a regular, fixed place of work is generally treated as an ordinary commute and is not claimable, whereas travel to see a patient at their home, or between clinics during the day, typically is genuine business mileage. Keep a simple log of the business journeys so you can back up the claim, and remember you deduct either the flat per-mile rate or your actual vehicle costs — not both.

My statements come from two different banks — can I still build one clean file?

Yes, and it is common for an osteopath with a business account at one bank and a card or savings pot at another. Convert each bank’s PDF separately, then combine the rows into a single workbook with consistent Date, Description, Amount, and Category columns. A converter that outputs the same column layout regardless of the source bank makes this painless, so two different statement styles end up as one uniform ledger. See how to batch several statement PDFs into one spreadsheet.

Related articles

• Bank Statements to Excel & CSV: A Nurse’s Guide
• How to Convert a Bank Statement PDF to CSV (3 Methods)
• Bookkeeping From Bank Statements When You Have No Invoices
• How to Organize Bank Statements for a Tax Audit When Self-Employed