Bank Statements to Excel & CSV: A Rideshare Driver's Guide

It is the end of a long week behind the wheel. You have closed the app, the last airport run is done, and now a folder of PDF bank statements is waiting for you. Buried in those pages is everything the tax office wants: every platform payout, every commission the app skimmed off the top, the fuel you burned, the tolls, the licence renewal. But it is locked inside a PDF, and when you copy-paste it into Excel, three tidy columns collapse into one unreadable smear. If you are a self-employed rideshare, private-hire, or taxi driver 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 it, categorize it, reconcile the payouts against the fees, and either file yourself or hand tidy numbers to an accountant.

Drivers drive; nobody hands you a bookkeeping manual with your licence. The good news: once your bank data sits in a spreadsheet, separating gross fares from platform fees stops being a headache, and the whole job becomes a repeatable ten-minute habit instead of a January panic.

The bookkeeping reality of a rideshare or taxi driver

Whether you drive for a US rideshare platform and file a Schedule C, run a UK private-hire or hackney licence and file Self Assessment, or take direct and cash fares alongside app work, 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 account or card for driving income and driving costs makes every later step dramatically easier. Mixed accounts are the number one reason a driver’s books eat the whole weekend.
• Track income and deductible expenses. Your revenue (platform payouts, tips, direct and cash fares) and your costs (fuel or mileage, platform commission, insurance, licensing, tolls, cleaning) both live in your bank statements.
• Set aside for taxes. In the US, self-employed drivers generally pay quarterly estimated taxes rather than a single annual bill, and owe self-employment tax on top of income tax. In the UK, sole-trader drivers 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 US, all your driving income is reportable on Schedule C whether or not a platform sends you a form: platforms typically issue one form for your ride earnings and another for referrals or bonuses once you cross the reporting threshold, but the income is taxable even below it. Mileage is usually a driver’s single biggest deduction, and the tax authority sets a standard mileage rate that it revises periodically — apply the current rate for your tax year. In the UK, self-employed income above the trading allowance means you must register for Self Assessment by the deadline that follows the tax year you started, and Making Tax Digital for Income Tax is being phased in for higher-earning sole traders, which pushes record-keeping toward compatible software rather than a shoebox of receipts (a plain spreadsheet on its own is not a compliant filing method).

None of these duties are hard. They are just tedious — and every one of them depends 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 a payout amount lands on the wrong row.
• You cannot sort or filter. You cannot pull “all platform payouts” or “every fuel stop” out of a PDF — and a driver’s statement can carry dozens or hundreds of them.
• You cannot total anything. No SUM, no per-category subtotal, no year-to-date fares 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 fares and each expense group in seconds, and import the file into accounting software like QuickBooks or Xero. 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
Every payout read line by line	Filter to every platform payout or fuel stop 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 driver

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 payouts land in. If your driving 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 fares 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 driver with payouts from more than one platform, plus direct card fares, ends up with one consistent format. The tool runs on a simple credit system, with one credit per statement page, so a full year of statements is quick to process. And because a statement is sensitive, it matters what happens to the file afterwards — more on that below.

3. Categorize: income vs deductible expenses

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

Category	Typical driver transactions	Tax angle
Income	Platform payouts, tips, direct and cash fares	Report the gross fares — the platform’s form shows the full amount passengers paid
Vehicle / mileage	Fuel or charging, servicing, tyres, parking (or log miles for the standard rate)	Usually a driver’s single biggest deduction
Platform commission & fees	The percentage the app deducts, booking and card-processing fees	Deduct the fee, report the gross fare
Licensing & insurance	Taxi or private-hire licence, vehicle licence, background check, hire-and-reward insurance	Ordinary and necessary to operate
Tolls & road costs	Bridge, tunnel and road tolls, congestion charges	Deductible when incurred on the job
Cleaning & amenities	Car washes, valeting, cleaning supplies, passenger water and chargers	Work-specific costs are generally deductible
Phone & admin	Phone bill, data, navigation and accounting apps	Business-use portion

A word on mileage: in most systems you deduct either a standard mileage rate or your actual vehicle costs, not both, so pick the method that gives you more and keep a mileage log to back it up — and remember that the standard rate is meant to cover fuel, repairs, and depreciation, so you do not also deduct those separately on top of it. And a word on payouts: the amount that lands in your bank is usually net of the platform’s commission, but the platform’s tax form often reports the gross fare passengers paid. That mismatch is exactly why separating gross fares from fees in a spreadsheet matters — you report the gross and deduct the commission, rather than quietly reporting only the net.

To speed up tagging, sort by description and label transactions from the same payee in batches — a driver’s statement is highly repetitive, which works in your favour here. 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. Because platform payouts arrive net of commission, match each payout against the platform’s own weekly summary so the fees you deduct actually tie back to the fares you report. 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.

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

A worked example: one month of a driver’s statement

Theory is easier to trust when you see it applied. Below is a single month from a self-employed driver’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
Jun 03	Rideshare platform payout	+612.40	Income
Jun 06	Fuel	-58.30	Vehicle / mileage
Jun 09	Card terminal — direct fares	+285.00	Income
Jun 10	Card processing fee	-11.40	Platform commission & fees
Jun 12	Rideshare platform payout	+548.75	Income
Jun 14	Toll — bridge crossings	-24.00	Tolls & road costs
Jun 17	Hire-and-reward insurance	-142.00	Licensing & insurance
Jun 19	Rideshare platform payout	+671.20	Income
Jun 21	Car wash & valeting	-22.50	Cleaning & amenities
Jun 24	Transfer to personal account	-800.00	Personal (exclude)
Jun 27	Phone & data	-38.00	Phone & admin
Jun 29	Rideshare platform payout	+503.10	Income

Total the categories and the picture is instantly clear. Income: 2,620.45 (four platform payouts plus the direct card-terminal fares). Deductible expenses: 296.20 (fuel, the card-processing fee, the toll, insurance, the car wash, and phone). The 800.00 transfer to a 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 drivers overstate either side of their books. Net taxable position for the month: 2,620.45 minus 296.20, or 2,324.25. Do this twelve times and your return is already written.

One subtlety worth flagging: those four platform payouts already have the app’s commission taken out before they reach your bank, so they land net. If you want to claim that commission — and you should — pull the gross fare figure from your platform’s own weekly summary and record the fee as its own expense line, exactly as the card-processing fee already appears here on the direct fares. Report the gross, deduct the fee; never quietly report only the net.

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

You do not have to choose all-or-nothing. Most self-employed drivers 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 or two income streams, 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. A driver’s statement is the worst offender here, because it is hundreds of near-identical payout lines. Hand your accountant 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.

Common mistakes and traps to avoid

Even careful drivers trip on the same few things.

• Retyping by hand. It is slow and it introduces errors — a transposed digit in a payout misstates your income. Let a converter read the figures.
• Reporting only the net payout. The money that lands is net of the app’s cut, but the tax form often shows the gross fare. Report the gross and deduct the commission; reporting only the net can leave your declared income lower than what the tax office can see.
• Mixing personal and business. If your weekly grocery run sits next to your licence 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 direct fares. Payouts are the easy part; make sure cash jobs and direct card fares are captured too. Undeclared income is what audits are built to find.
• Double-dipping on mileage. If you claim the standard mileage rate, you cannot also deduct fuel and repairs separately — those are already baked into the rate. Pick one method and stay consistent.
• 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.

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 driver whether fuel and insurance are quietly eating the week’s fares, and flags months where costs 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 never issue invoices and your whole record is the bank feed — the norm for app-based drivers — 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.

A note on privacy: your statement is sensitive data

Your bank statement is one of the most revealing documents you own. It lists your name, your account number, where and when you fuel up, the hours you work, and every fare that reached your account. A driver’s movements and earnings are written into every page, so before you upload it anywhere, it is worth knowing what happens to the file afterwards.

BankStatementLab processes your statement and then discards the source PDF — your original file is not stored after the conversion. It is read, converted to the format you asked for, and dropped, rather than sitting on a server waiting to be breached. Whichever tool you use, prefer one that processes and discards rather than retains, and be wary of anything that keeps your statements around “for your convenience.”

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 payout — and a driver’s statement, with its dozens of near-identical lines, is exactly where hand-typing goes wrong. 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 driving 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, separate gross fares from platform fees, tag payouts against mileage, insurance, tolls, and licensing, 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 got your licence to drive, not to fight with PDFs. Let the software do the data entry.

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

Frequently asked questions

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

Long enough to survive a query. As a rule of thumb, US self-employed drivers 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 pay tax on the full fare or only on what the platform pays me after commission?

You generally report the gross fare as income and then deduct the platform’s commission as a business expense — you do not simply ignore the commission and report the net that landed in your account. It usually nets out to the same taxable figure, but doing it the correct way matters because the platform’s tax form often reports the gross fare passengers paid, and the tax authority can compare that against what you declare. In your spreadsheet, record the gross fare from your platform summary as income and the commission (whether withheld at source or billed separately) as its own expense line.

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

As a sole trader or independent contractor, you are usually not required to have a dedicated business account — your driving 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 platform payouts. A single dedicated account or even one card used only for driving income and driving costs 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 mileage and fuel at the same time?

Usually not. In most systems you choose either the standard mileage rate or your actual vehicle costs for a given vehicle, and you cannot combine them. The standard mileage rate is designed to cover fuel, servicing, repairs, and depreciation in one figure, so if you claim it you do not also deduct those costs separately. If you use the actual-cost method instead, you deduct the business-use share of fuel, insurance, maintenance, and depreciation, but not a mileage rate on top. Keep a mileage log either way, and confirm the current rate and the rules for switching methods for your tax year.

Do I have to report cash fares and tips?

Yes. Income is income whether it arrives as a platform payout, a card-terminal deposit, a tip, or cash. App payouts and card fares land in your bank statement, so they are easy to capture — the trap is the cash job that never touched your account and the tip that was handed over directly. Keep a simple record of cash takings and reconcile it 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 payouts come from more than one platform — can I still build one clean file?

Yes, and this is common for drivers who work two apps plus their own direct fares. Convert each source 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 makes this painless, so two different statement styles end up as one uniform ledger you can total in one place. See how to batch several statement PDFs into one spreadsheet.

Related articles

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