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

You finished a run of agency shifts, the private-duty invoices are paid, and now a folder of PDF bank statements is staring at you. Somewhere in those pages is everything the tax office wants: your income, your mileage, your scrubs, your license renewal. But it is trapped in a PDF, and copy-pasting it into Excel turns three neat columns into one useless mush. If you are a self-employed nurse doing your own bookkeeping, this guide shows you how to turn those statements into a clean Excel or CSV file you can actually work with — sort, categorize, reconcile, and either file yourself or hand to an accountant.

Nurses are clinicians, not bookkeepers. Nobody covered Schedule C or Self Assessment in nursing school. The good news: once your bank data is in a spreadsheet, the whole thing becomes a repeatable weekend habit instead of a January panic.

The bookkeeping reality of an independent nurse

Whether you are a US 1099 travel nurse, a UK agency nurse working for yourself, a private-duty caregiver, or a nurse practitioner running your own practice, 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 or card for work income and work spending makes every later step dramatically easier. Mixed accounts are the number one reason nurse bookkeeping takes all weekend.
• Track income and deductible expenses. Your revenue (agency pay, per-diem, private clients, per-visit fees) and your costs (mileage, licensing, scrubs, equipment, agency or platform fees) both live in your bank statements.
• Set aside for taxes. In the US, self-employed earners generally pay quarterly estimated taxes to the IRS rather than a single annual bill. In the UK, sole traders report through Self Assessment.
• 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 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 shoebox of receipts (a plain spreadsheet on its own is not a compliant filing method). In the US, mileage is often a nurse’s single biggest deduction, and the IRS sets a standard business mileage rate that 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, 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 nurse

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 work. 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 travel nurse 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 nurse the buckets usually look like this.

Category	Typical nurse transactions	Tax angle
Income	Agency pay, per-diem, private clients, 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)	Often a nurse’s single biggest deduction
Licensing & CEUs	License renewal, certifications, continuing education, professional body fees	Ordinary and necessary for practice
Uniforms & supplies	Scrubs, PPE, stethoscope, small equipment	Work-specific items are generally deductible
Agency & platform fees	Staffing agency cuts, booking platform fees	Deduct the fee, report the gross
Insurance & admin	Malpractice/indemnity cover, phone, software subscriptions	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 on scrubs — the rule is usually that clothing must be specific to the work and not suitable for everyday wear, which is exactly why scrubs and PPE qualify where a plain cardigan would not.

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 clients, match the payout deposits against the 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 nurses 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 nurse’s statement

Theory is easier to trust when you see it applied. Below is a single month from a self-employed nurse’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
Mar 02	Agency deposit	+1,840.00	Income
Mar 05	Fuel	-64.20	Vehicle / mileage
Mar 09	Payment app payout — private client	+420.00	Income
Mar 12	Scrubs & PPE	-78.00	Uniforms & supplies
Mar 15	License renewal	-110.00	Licensing & CEUs
Mar 18	Transfer to personal savings	-500.00	Personal (exclude)
Mar 22	Phone & scheduling software	-46.00	Insurance & admin
Mar 27	Parking — client visit	-18.50	Vehicle / mileage

Total the categories and the picture is instantly clear. Income: 2,260.00 (the agency deposit plus the private-client payout). Deductible expenses: 316.70 (fuel, scrubs, licensing, phone and software, and parking). The 500.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 nurses overstate either side of their books. Net taxable position for the month: 2,260.00 minus 316.70, or 1,943.30. Do this twelve times and your return is already written.

Common mistakes and traps to avoid

Even careful nurses 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 grocery run sits next to your license 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 private-client payments through 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, 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 a travel nurse whether that 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 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 self-employed agency nurses — 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 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 nursing 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, licensing, scrubs, and agency fees, 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 care for 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 nurse?

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

Do I legally need a separate bank account for my nursing income?

As a sole trader or 1099 nurse, you are usually not required to have a dedicated business account — your work income and personal money can legally sit in one place. But mixing them makes bookkeeping painful and audit-prone, because every statement then blends grocery runs with agency pay. A single dedicated account or even one card used only for work income and work 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.

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

You generally report the gross amount as income and then deduct the agency 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.

Can I claim my phone and nursing software subscriptions as expenses?

Usually yes, but only the business-use portion. If you use your phone for both personal calls and coordinating shifts or clients, you deduct a reasonable business share rather than the whole bill. Scheduling apps, invoicing tools, and note-taking or documentation software you pay for to run your practice are typically deductible in full when they are used only for work. Keep the statement line that shows the charge, and be ready to justify the split if it is ever questioned.

Do I have to report money private clients send me through a payment app?

Yes. Income is income whether it arrives as an agency deposit, a bank transfer, cash, or a payment-app payout from a private-duty client. App 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 app payouts against your statement so nothing slips through. 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 travel nurses who switch accounts between contracts or keep one account per assignment. 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

• How to Convert a Bank Statement PDF to CSV (3 Methods)
• How to Convert Bank Statement PDFs to Spreadsheets for Bookkeeping
• Bookkeeping From Bank Statements When You Have No Invoices
• How to Organize Bank Statements for a Tax Audit When Self-Employed