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

The locum contract wrapped up Friday, the private consultations for the month are settled, and now a folder of PDF bank statements is sitting on your desktop waiting for you. Everything the tax authority wants is somewhere in those pages: your locum and consultation income, the miles you drove between clinics, your indemnity premium, your board 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 doctor doing your own bookkeeping between shifts, 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.

You trained for a decade to practise medicine, not to keep ledgers. Nobody taught Schedule C or Self Assessment in medical school. The good news: once your bank data is in a spreadsheet, the whole thing turns into a repeatable weekend habit instead of a filing-deadline emergency.

The bookkeeping reality of a self-employed doctor

Whether you are a US 1099 locum tenens physician, a UK locum GP invoicing your own sessions, a private-practice doctor, or a consultant with income outside a salaried post, 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 a doctor’s bookkeeping eats the whole weekend.
• Track income and deductible expenses. Your revenue (locum sessions, per-diem cover, private consultations, per-visit fees) and your costs (mileage, indemnity, licensing, CME/CPD, equipment, professional subscriptions) both live in your bank statements.
• Set aside for taxes. In the US, self-employed physicians generally pay quarterly estimated taxes to the IRS rather than a single annual bill, plus self-employment tax on net earnings. In the UK, self-employed doctors report through Self Assessment and pay Income Tax and National Insurance.
• 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. 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 drawer of receipts. Note that many NHS roles are salaried and pensioned — self-employment rules apply to your locum, sessional, or private work, not to a substantive employed post. In the US, self-employed physicians make estimated payments across the year (typically due in April, June, September, and the following January — confirm the current dates), and the IRS sets a standard business mileage rate that it revises periodically, so 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, 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 a doctor

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 practice income. 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 locum working across several trusts or clinics with statements from two different banks 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 you received. 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 doctor the buckets usually look like this.

Category	Typical physician transactions	Tax angle
Income	Locum sessions, per-diem cover, private consultations, per-visit fees	Report all of it — deposits are visible to the tax office
Vehicle / mileage	Fuel, parking, tolls (or log miles for the standard rate)	Travel between clinics and to home visits
Indemnity & insurance	Malpractice cover (US), medical defence subscription such as MDU/MPS/MDDUS (UK)	Ordinary and necessary; premiums generally deductible
Licensing & registration	Board/state license fees (US), GMC registration (UK), specialty body dues	Required to practise
CME / CPD	Courses, conferences, exams, journals, learning materials	Continuing education to maintain practice
Equipment & subscriptions	Medical equipment, phone, EHR or dictation software, professional memberships	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. On indemnity — whether it is US malpractice cover or a UK medical defence union subscription, the premium you pay is generally an allowable business expense, but confirm the treatment for your own arrangement rather than assuming.

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 also take card payments from private patients, match the payout deposits against the processor 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 doctors 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. Medical and specialist 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, on your quarterly estimates or Self Assessment, not on 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 doctor’s statement

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

Date	Description	Amount	Category
Apr 03	Locum session payment	+3,200.00	Income
Apr 06	Fuel	-72.40	Vehicle / mileage
Apr 10	Medical defence subscription	-240.00	Indemnity & insurance
Apr 13	CME conference registration	-180.00	CME / CPD
Apr 17	Private consultation payout	+560.00	Income
Apr 19	Transfer to personal savings	-800.00	Personal (exclude)
Apr 24	Board / registration renewal	-90.00	Licensing & registration
Apr 28	Parking — home visit	-16.00	Vehicle / mileage

Total the categories and the picture is instantly clear. Income: 3,760.00 (the locum session plus the private-consultation payout). Deductible expenses: 598.40 (fuel, indemnity, CME, the registration renewal, and parking). The 800.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 doctors overstate either side of their books. Net taxable position for the month: 3,760.00 minus 598.40, or 3,161.60. Do this twelve times and your return is already written.

Common mistakes and traps to avoid

Even careful doctors trip on the same few things.

• Retyping by hand. It is slow and it introduces errors — a transposed digit in a locum payment misstates your income. Let a converter read the figures.
• Mixing personal and business. If your weekly shop sits next to your indemnity premium, 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 private and card-app income. Deposits are the easy part; make sure private consultation payments through card readers or payment apps are captured too. Undeclared income is what audits are built to find.
• Guessing at deductions. Claim what you can substantiate, and keep the statement that proves it. When unsure whether something qualifies — an exam fee, a share of your phone bill, a conference trip — 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 at filing time, 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 a locum whether the gap between contracts 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 or your Self Assessment bill 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 a doctor paid directly for sessions — 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 payment. 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 locum and consultation 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, indemnity, licensing, and CME, 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 look after 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 doctor?

Long enough to survive a query. As a rule of thumb, US self-employed physicians 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, the self-employed are generally 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.

Do I legally need a separate bank account for my locum or private income?

As a sole trader or 1099 physician, you are usually not required to have a dedicated business account — your practice income and personal money can legally sit in one place. But mixing them makes bookkeeping painful and audit-prone, because every statement then blends your weekly shop with your locum pay. A single dedicated account, or even one card used only for practice income and practice spending, 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 indemnity or malpractice cover as an expense?

Generally yes. Medical defence or professional indemnity cover in the UK (an MDU, MPS, or MDDUS subscription) and malpractice insurance in the US are ordinary, necessary costs of practising, so the premiums are typically treated as allowable business expenses. Record each payment as its own expense line and keep the statement entry that proves it. As with any deduction, confirm the treatment for your specific arrangement — how you are engaged and who carries the cover can affect it — rather than assuming it always applies.

Are CME, CPD, board fees, and GMC registration deductible?

Usually, when they relate to maintaining your current practice. Continuing education (CME in the US, CPD in the UK), exam and course fees, professional journals, licensing or board renewals, GMC registration in the UK, and specialty body memberships are commonly claimed by self-employed doctors. The nuance is that training which qualifies you for an entirely new profession may be treated differently from education that keeps your existing skills current, so if you are unsure about a large course fee, check the current rules or ask your accountant. Keep the statement line that shows each charge.

Do I have to report money private patients pay me by card reader or app?

Yes. Income is income whether it arrives as a locum session payment, a bank transfer, cash, or a card-reader or payment-app payout from a private patient. App and card payouts land in your bank statement as deposits, so they are easy to capture — the trap is forgetting the ones that never touched your main account. Reconcile your payout reports against your statement so nothing slips through, and record the processor fee as its own expense while reporting the gross. Undeclared income is precisely what audits are designed to surface, so capture every payment stream from the start.

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

Yes, and this is common for doctors who keep one account per contract or switch banks between assignments. 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