Bank Statements to Excel & CSV: A Physio's Guide

You have wrapped up a full week of clinic appointments and home visits, the private clients have paid, and now a folder of PDF bank statements is sitting on your desktop. Somewhere in those pages is everything the tax office wants to see: your session income, your mileage between visits, your new treatment table, your registration renewal. But it is locked inside a PDF, and copy-pasting it into Excel turns three tidy columns into one unreadable smear. If you are a self-employed physiotherapist doing your own bookkeeping, 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.

Physios are clinicians, not bookkeepers. Nobody covered Schedule C or Self Assessment in your degree or your clinical placements. The good news: once your bank data is in a spreadsheet, the whole thing becomes a repeatable monthly habit instead of a year-end panic.

The bookkeeping reality of an independent physiotherapist

Whether you are a US physical therapist in private practice or a travelling PT on 1099, a UK physiotherapist working for yourself through Self Assessment, or an Australian physio running a private-practice caseload, 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 a single dedicated bank account or card for practice income and practice spending makes every later step dramatically easier. Mixed accounts are the number one reason physio bookkeeping eats a whole weekend.
• Track income and deductible expenses. Your revenue (private clients, clinic-session fees, per-visit charges, contract work) and your costs (equipment, room rental, registration, professional body dues, indemnity insurance, mileage) all live inside your bank statements.
• Set aside for taxes. In the US, self-employed earners generally pay quarterly estimated taxes to the IRS rather than one annual bill. In the UK, sole traders report through Self Assessment and pay National Insurance (mainly Class 4) alongside income tax — the exact classes and thresholds change over time, so confirm what applies to your tax year.
• 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 be 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-employed income above the £1,000 trading allowance means you must register for Self Assessment, with a registration deadline of 5 October following the end of the tax year in which you started. “Physiotherapist” and “physical therapist” are protected titles, so you must be registered with the HCPC to practise — and that registration fee, like your Chartered Society of Physiotherapy (CSP) membership, is a professional subscription you can generally claim. Making Tax Digital for Income Tax is being phased in for higher-earning sole traders, pushing record-keeping toward compatible software rather than a shoebox of receipts (a plain spreadsheet on its own is not a compliant filing method). In the US, mileage for home visits and off-site work is often a physio’s biggest single deduction, and the IRS sets a standard business mileage rate it revises periodically — apply the current rate for your tax year.

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 hands 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 fuel transactions” 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 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, How to Convert a Bank Statement PDF to Excel walks through the available methods and covers the CSV export from the same upload, along with the checks to run before importing.

The step-by-step method for a physiotherapist

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 you use for the practice. If your business 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 a physio with a clinic account at one bank and a personal-turned-business account 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 clients made. The tool runs on a simple credit system, with one credit per statement page, so a full year of statements is quick and low-cost to process.

3. Categorize: income vs deductible expenses

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

Category	Typical physio transactions	Tax angle
Income	Private-client sessions, per-visit fees, contract/locum pay, clinic-session payouts	Report all of it — deposits are visible to the tax office
Vehicle / mileage	Fuel, parking, tolls for home visits (or log miles for the standard rate)	Often a physio’s single biggest deduction
Registration & CPD	HCPC/state licence renewal, CPD courses, certifications, professional body fees (CSP/APTA)	Ordinary and necessary for practice
Equipment & supplies	Treatment table, resistance bands, ultrasound unit, consumables, linens	Work-specific items; larger kit may be capital
Room rental & premises	Clinic room hire, sessional space, home-office share	Business-use portion
Insurance & admin	Professional indemnity cover, phone, practice-management software	Business-use portion

A word on mileage: in most systems you deduct either the standard mileage 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 note that travel to a client’s home or an off-site facility usually qualifies where the drive to your own regular clinic does not. On bigger equipment such as a treatment table or an ultrasound machine, the treatment differs from a box of consumables: some systems let you write off qualifying equipment in the year of purchase while others require you to spread the cost, so check how capital items are treated for your tax year before you claim the lot at once.

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 from clients through a terminal or app, match the payout deposits against the processing fees. Catching a mis-keyed amount now is far cheaper than explaining it under audit 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 (Schedule C in the US, the self-employment pages of Self Assessment in the UK), 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 physiotherapists 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 a physio’s statement

Theory is easier to trust when you see it applied. Below is a single month from a self-employed physiotherapist’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 dollars, pounds, or Australian dollars.

Date	Description	Amount	Category
Mar 03	Clinic session payments — private clients	+1,920.00	Income
Mar 06	Treatment table & bands	-260.00	Equipment & supplies
Mar 10	Payment app payout — home-visit client	+540.00	Income
Mar 13	CPD course fee	-145.00	Registration & CPD
Mar 16	Professional indemnity insurance	-58.00	Insurance & admin
Mar 19	Transfer to personal savings	-600.00	Personal (exclude)
Mar 23	Fuel — home visits	-52.40	Vehicle / mileage
Mar 27	Clinic room rental	-180.00	Room rental & premises

Total the categories and the picture is instantly clear. Income: 2,460.00 (the clinic-session payments plus the home-visit payout). Deductible expenses: 695.40 (the treatment table and bands, the CPD course, indemnity insurance, fuel, and room rental). The 600.00 transfer to personal savings 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 physios overstate either side of their books. Net taxable position for the month: 2,460.00 minus 695.40, or 1,764.60. Do this twelve times and your return is already written.

Common mistakes and traps to avoid

Even careful physiotherapists trip on the same few things.

• Retyping by hand. It is slow and it introduces errors — a transposed digit in a deposit misstates your income. Let a converter read the figures.
• Mixing personal and business. If your weekly grocery run sits next to your HCPC 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-app income. Deposits are the easy part; make sure home-visit payments through payment apps or terminals are captured too. Undeclared income is what audits are built to find.
• Treating capital kit like a consumable. A £30 resistance band and a £2,000 treatment table are not always deducted the same way. Check how larger equipment is handled for your tax year before you write the whole thing off at once.
• Guessing at deductions. Claim what you can substantiate, 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 between contracts or a seasonal dip in referrals is survivable, and flags months where spending crept up.
• Estimate taxes as you go. With categorized income visible month by month, setting aside the right amount for quarterly estimates stops being guesswork.
• Mine your statements for missed deductions. A surprising number of legitimate write-offs 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 physios who take payment at the point of treatment — 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. And if you also want to see how the same method works for another clinical profession, our nurse’s guide to bank statements in Excel and CSV covers the parallel case.

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 deposit. 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 physiotherapy income and your deductible 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 mileage, registration, CPD, equipment, and room rental, 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 and get people moving again, 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 physiotherapist?

Long enough to survive a query. As a rule of thumb, US physical therapists in private practice keep records supporting income and deductions for at least three years, and many keep six or seven, because the tax authority has a longer window to look back when income may have been under-reported. In the UK, sole traders are expected to keep records for around five years after the Self Assessment filing deadline for that tax year. 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 — see how long to keep bank statements when self-employed.

Can I claim my HCPC registration and CSP or APTA membership as expenses?

Generally yes. Registration with your regulator is a legal requirement to practise, and professional body membership is directly related to your work, so both are usually allowable as professional subscriptions — in the UK that means HCPC registration and CSP membership, in the US your state licence renewal and APTA dues, in Australia AHPRA registration and APA membership. Two caveats to confirm for your tax year: the cost of obtaining your first licence is sometimes treated differently from a renewal, and some professional-body dues have a small portion the tax authority treats as non-deductible. Keep the statement line that shows each payment, and claim what the current rules allow.

Do I pay tax on the full client payment or on what lands after the card fee?

You generally report the gross amount as income and then deduct the card-processing or platform fee as a business expense — you do not simply ignore the fee and report the net. It usually nets out to the same taxable figure, but doing it the correct way matters if the tax authority ever compares your declared income against the deposits it can see. In your spreadsheet, tag the incoming payout as income and record the fee (whether deducted at source or billed separately) as its own expense line.

How do I handle a treatment table or ultrasound machine — expense or asset?

It depends on the cost and your tax system. Small consumables like resistance bands, tape, or linens are ordinary expenses you deduct in the year you buy them. Larger equipment such as a treatment table, plinth, or ultrasound unit may count as a capital asset, and some systems let you write off qualifying equipment in full in the year of purchase while others require you to spread the cost over several years. Record the purchase in your spreadsheet with a clear description, keep the statement line, and confirm how capital items are treated for your tax year before you decide how much to claim.

Can I claim mileage for home visits and travel between clinics?

Usually yes, but only for genuine business travel. Driving to a client’s home, a care facility, or an off-site clinic typically qualifies, whereas your regular commute to a fixed base of work often does not — so keep a mileage log that distinguishes the two. In most systems you choose either the standard mileage rate or your actual vehicle running costs, not both, and you apply the current rate the tax authority sets for your year. Parking and tolls for a client visit are generally claimable on top of the mileage rate; capture them as their own lines when they appear on your statement.

My clinic and personal payments are all in one account — can I still build clean books?

Yes. Plenty of physios start out taking client payments into a personal account before opening a dedicated one. Convert the whole statement, add a Category column, and tag every business row while marking personal spending and transfers as “exclude.” The result is a clean ledger of your practice income and costs even though the underlying account was mixed. It is more work than a separate account would be, so it is worth opening a dedicated card or account going forward — here is how to separate the two.

Related articles

• Bank Statements to Excel & CSV: A Nurse’s Guide
• How to Convert a Bank Statement PDF to Excel or CSV
• Hidden Tax Deductions Freelancers Miss on Bank Statements
• How to Organize Bank Statements for a Tax Audit When Self-Employed