Bank Statements to Excel or CSV for Physiotherapists

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. It records payer deposits, travel payments, equipment, and registration charges, while service batches and purchase purpose remain outside the bank feed. Copy-pasting the PDF into Excel turns three tidy columns into one unreadable smear. This guide shows a self-employed physiotherapist how to extract reviewable Excel or CSV rows and attach the evidence needed before filing or accountant handoff.

For an independent physio, the bank deposit is only the payment layer. A useful ledger also shows the payer, service batch, setting, and practitioner information needed to explain each receipt.

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 therapy receipts and supporting costs. Private, per-visit, contract, and clinic deposits share the account with travel, registration, CPD, equipment, room, and insurance payments that need service and invoice evidence.
• Track tax obligations separately. Payment dates and calculations depend on your jurisdiction and practice structure, so keep a tax-reserve line in the workbook and confirm the current schedule.
• Retain the service and equipment trail. Keep statements and reviewed exports with payer remittances, booking batches, travel logs, equipment invoices, and renewal evidence for the required periods.

Tax registration, professional-title rules, digital-record requirements, and expense treatment vary by country and practice structure. Keep registration, membership, equipment, and travel as separate review categories, then apply the current regulator and tax-authority guidance. The statement shows that money moved; it does not establish whether an item is deductible or capital.

The physio-specific task is explaining a payer receipt or equipment payment at service level. Structured rows make the lookup possible; remittances, bookings, and invoices finish it.

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

A physiotherapy bank PDF displays insurer, clinic, and supplier lines but cannot relate them to a therapy batch, setting, or asset record. Its text is positioned on a page rather than exposed as transaction cells. That is why:

• Payer text can shift away from its amount. Wrapped insurer or clinic descriptions are especially easy to paste onto the wrong row.
• Service settings remain mixed. A PDF cannot isolate home visits, private-clinic receipts, and contract payments for review.
• Equipment context is missing. The statement shows a supplier and amount, not whether the purchase was a consumable, an asset, reimbursed, or mixed-use.
• A PDF cannot carry service-level fields. Import and handoff workflows need reviewed rows plus the remittance or booking records that explain them.

Reviewed spreadsheet rows let a physio filter payer receipts, add service-setting fields, and flag equipment for asset review. CSV or XLSX may be imported separately if the destination accepts it; BankStatementLab does not create a live connection.

Here is the same information, before and after.

Physio payment in the PDF	Physio review after extraction
Insurer and clinic deposits are read one by one	Filter payer references and mark the service batch
Home-visit costs have no journey context	Attach setting, appointment, and mileage evidence
Equipment and consumables share supplier names	Add invoice, asset-review, and reimbursement fields
Registration and CPD payments are scattered	Group renewal evidence without deciding tax treatment
The ledger and bank balance are separate	Reconcile extracted rows to the statement closing balance

The bank-statement PDF conversion walkthrough covers extraction methods and output choices. For a physiotherapy account, validate one insurer or clinic deposit, one equipment payment, and the closing balance before adding service-level fields.

The step-by-step method for a physiotherapist

Here is the workflow from PDF statements to a reviewable handoff. Work in order and leave payer deposits open until the service-level record explains them.

1. Gather every statement

Download statements for the reporting period from every account that received clinic, insurer, or private-client money. Include relevant mixed-account statements and mark personal rows during review. Verify the month sequence and balance continuity, leaving any absent period flagged until you recover the source.

2. Convert the PDFs to Excel or CSV

Run a statement containing a payer deposit and an equipment or clinic-room payment, then compare descriptions, signs, posting dates, and the closing balance to the original PDF. Leave a payer receipt unresolved until the remittance or booking batch identifies it; extraction cannot infer the therapy service from a bank descriptor.

BankStatementLab supplies CSV, JSON, or XLSX files only, with no connector to accounting or practice software. Five credits are included. Standard extraction consumes one credit per page; advanced extraction consumes two. The uploaded source is deleted following success and may be retained for no more than 14 days after failure. Results persist until you delete them manually unless optional auto-delete is enabled. It is disabled at first, supports 1–30 days, and has an initial value of 14 days. Review the physio rows and add service evidence before any later file import.

3. Categorize: therapy receipts and cost candidates

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

Review label	Typical physio transactions	Evidence or treatment question
Therapy receipts	Private sessions, per-visit fees, contract pay, clinic payouts	Booking batch, invoice, contract, or payer remittance
Travel candidates	Fuel, parking, tolls, mileage-log entries	Service setting, journey purpose, and local travel rule
Registration & CPD	HCPC or state renewal, courses, certifications, body fees	Renewal/course evidence and current local treatment
Equipment & supplies	Treatment table, bands, ultrasound unit, consumables	Invoice, useful life, reimbursement, and asset review
Room rental & premises	Clinic room, sessional space, home-work area	Agreement, period, and business-use allocation
Insurance & admin	Indemnity, phone, practice-management software	Policy or invoice plus any personal-use share

For travel, capture the service setting, journey purpose, reimbursement, mileage, and vehicle method required by the rules for your location and year; a home-visit label alone does not settle the treatment. For a treatment table or ultrasound unit, retain the invoice, purchase date, business use, and reimbursement, then flag it for asset review. Different regimes can expense, depreciate, or otherwise treat larger equipment differently.

Sort by payer, clinic, equipment supplier, regulator, and processor to surface recurring physio transactions. Confirm whether a supplier line is consumables, a larger asset, or a reimbursement before copying its label across the batch. The Excel pivot-table workflow helps group descriptions while your evidence columns preserve those differences.

Add service-level fields to payer deposits

A deposit labeled only with an insurer name cannot explain which therapy work it settles. For US Medicare work, CMS maintains specific therapy-services billing guidance covering physical therapy and the information attached to claims. Keep service date or batch, payer, clinic or home setting, treating PT or PTA, remittance reference, and claim status beside the bank transaction. These are reconciliation fields; they do not replace the clinical record or establish that a claim is payable.

If the same spreadsheet also feeds reimbursements and internal costs, the guide to automating expense reporting from bank statements shows how to keep approval evidence attached without mixing it into patient billing.

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

After reconciling the bank balance and service batches, subtotal receipts and candidate costs by payer, clinic, and asset-review status. Do not paste those subtotals into a return before applying the current rules for engagement, travel, capital equipment, and mixed use. They can instead form the evidence schedule supplied to an accountant.

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.

• Physio-led preparation may suit one clinic and a simple private-pay flow, provided payer, travel, equipment, and local filing questions are still resolved.
• Accountant-led preparation can help where insurer adjustments, multiple settings, larger equipment, or mixed-use premises need judgment. Confirm the handoff fields and fee first.
• Shared preparation leaves service-level reconciliation with you and tax mapping with the adviser. The workbook may reduce queries only if it matches the agreed engagement.

A reviewed spreadsheet can make payer, equipment, and travel questions easier to locate, but any fee or time reduction depends on the accountant’s engagement. Ask which service-batch, remittance, and asset fields they want. The guide to preparing bank statements for an accountant provides a handoff checklist.

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

In this illustrative ledger, the categories show income of 2,460.00 and candidate business costs of 695.40. The 600.00 transfer to personal savings is an internal transfer, so it stays outside the income-and-cost subtotal. The arithmetic difference is 1,764.60 before tax adjustments; the current rules still determine whether equipment is capital, which travel qualifies, and how payer adjustments are treated.

Common mistakes and traps to avoid

Even careful physiotherapists trip on the same few things.

• Treating manual entry as self-validating. A typed payer deposit is a second copy that still needs comparison with the source statement.
• Mixing personal and business. If personal spending sits next to a registration renewal, every category needs more review. A separate account or dedicated card reduces that ambiguity. 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.
• Deciding equipment or travel from a payee. Keep the invoice, service setting, journey, reimbursement, and current rule open until the facts are documented.
• Missing a displaced payer or supplier line. Sample an insurer receipt, equipment payment, amount signs, and the closing balance against the original PDF.
• Skipping privacy-retention review. Physiotherapy statements reveal payer and clinic patterns, so verify deletion controls for both the source and generated result.

Going further: build a system, not a scramble

Review the physiotherapy ledger after each payer or clinic cycle, before remittance and service-batch context goes stale.

• Close each payer batch. Match insurer and client receipts to service-level records, then keep equipment and reimbursement evidence in their own review queue.
• Append reviewed months to a service-aware workbook. Keep source, payer, clinic, and batch fields when following the multiple-statement workflow.
• 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.
• Maintain a provisional reserve from reviewed receipts. Update the estimate for the current jurisdiction and practice structure, and keep equipment or payer exceptions outside the confirmed base.
• Surface overlooked physio review items. Use the statement cost checklist to find registration, cover, room, travel, and equipment candidates, then verify each one.

For point-of-treatment payments, the bank feed can start a physio receipt schedule even when invoices are not routine. It still omits patient-level bookings, cash, remittance adjustments, equipment purpose, and travel evidence. The bank-statement-only bookkeeping guide shows how to flag those gaps; the nursing workflow illustrates a different assignment-led evidence model.

Three ways to convert a statement, compared

Compare the routes on physiotherapy evidence: can the output preserve a payer reference, equipment line, amount sign, and closing balance before service fields are added?

Route	Therapy-led workflow	Physio-specific review	Result
Manual entry	Key payer receipts and clinic costs	Recheck references, equipment amounts, and balances	A custom sheet with transcription risk
General table extraction	Recover tables and repair their structure	Inspect wrapped payer and supplier descriptions	A table that may need column cleanup
Bank-statement extraction	Extract rows, then add service-level context	Match a payer receipt, equipment line, and closing balance	CSV, JSON, or XLSX; no direct posting

Whichever route you choose, compare the export with the statement before trusting totals. Sample an insurer deposit and a client payment, and verify the payer or service-level fields explain each one without exposing clinical details in the ledger.

The bottom line

Your statements show the payment layer of the physiotherapy practice, while service records and remittances explain it. Convert and reconcile the PDFs, then deliver the reviewed CSV or XLSX with the evidence needed to assess equipment, travel, registration, and room costs.

You trained to treat patients and get people moving again, not to fight with PDFs. Let the software do the data entry.

Frequently asked questions

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

The period depends on the country, return, payer arrangement, and any professional record rules that apply. Check the current official guidance and keep the original statement, reviewed export, invoices, and remittance evidence together. The record-retention guide for self-employed workers explains the file structure without hard-coding a deadline here.

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

Keep regulator fees and professional memberships in separate review rows. Country, year, practice entity, reimbursement, first registration versus renewal, and excluded portions of dues can change the treatment. Retain the renewal notice, membership invoice, and bank line, then apply the current official rule to each component.

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

Preserve the extracted deposit as the net amount received, then use the processor settlement to add separate gross, fee, adjustment, and net fields. Do not estimate missing components from the bank line. Once the batch reconciles, apply the receipt and cost rules for the relevant jurisdiction and practice structure.

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

Flag a treatment table, plinth, or ultrasound unit for asset review rather than treating the bank payment like a consumable. Keep the invoice, purchase date, expected use, business allocation, financing, and reimbursement. Thresholds and reliefs vary by jurisdiction, year, and entity, so consult the current rules before deciding whether and when the cost enters the return.

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

Record origin, destination, service setting, journey purpose, mileage, and reimbursement for each trip. The current rules for the country, year, work base, and vehicle method determine how home visits, off-site clinics, commuting, parking, and tolls are treated. The mileage log supports that decision but does not make it.

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

• Automate Expense Evidence From Bank Statements
• Prepare Payer and Equipment Records for an Accountant
• Batch Multiple Clinic Statements Into One Spreadsheet
• Separate Personal and Physiotherapy Transactions

Extract physiotherapy statement data to CSV, JSON, or XLSX with BankStatementLab