A frustrating amount of US banking infrastructure still treats CSV exports as a premium feature. Some banks let you download 90 days of history but charge for anything older. Some give CSVs for personal checking but not for business. Some don't offer CSV exports at all — you get PDFs and that's it.
If you're a bookkeeper and your client's bank falls into one of those buckets, here's the practical playbook. This isn't a complaint about banks (well, it's partially a complaint) — it's what you actually do when you can't get the data in the format you want.
The short version: If the bank gives PDFs only, convert them to Excel/CSV using a bank-statement-specific converter. If the bank charges for CSVs, decide whether the time you save justifies the cost (it usually does for catch-up work but not for ongoing). If the bank gives nothing, ask the client to grant you online access to download statements directly.
Why this happens
Banks have historically treated transaction data as proprietary — their cost to give you a CSV is essentially zero, but charging for it is "industry standard." Three patterns you'll see:
- Free CSV but limited history. Most major banks (Chase, BoA, Wells Fargo) give 90 days of CSV exports free. Anything older requires a paid statement copy.
- Free CSV with paid premium tiers. Some banks restrict the more useful CSV formats (the ones with full transaction descriptions) to higher-tier accounts.
- No CSV at all. Some smaller banks, most credit unions, and a surprising number of business banking products only provide PDF statements.
The bookkeeping side has dealt with this by getting good at PDF conversion. It's a workaround, but it's a reliable workaround.
What to do, by scenario
Scenario 1: Bank gives PDFs but no CSVs
This is the most common case. The solution is a PDF-to-Excel converter built for bank statements.
The workflow:
- Download the PDF statements from the bank's online portal (or have the client send them)
- Run each PDF through a converter that outputs a QBO-ready CSV or Excel file
- Upload that CSV to QBO via the Bookkeeping → Transactions → Upload from file flow
- Verify the imported total matches the statement's beginning-to-ending balance change
The key is using a converter that's purpose-built for bank statements, not a generic PDF-to-Excel tool. The bank-statement-specific tools know to skip running balance columns, merge multi-line ACH descriptors, and ignore back-page check images.
This is what we built YourStatementConverter for. Upload a PDF, get back a reconciled Excel ready for QBO. 25 pages free, no credit card. Try it on a statement.
Scenario 2: Bank charges for older CSV exports
Most major banks let you download the last 90 days of activity as a CSV for free. Anything older, they want $3-$15 per statement copy.
For ongoing monthly work, this isn't a problem — you're always within the 90-day window. For catch-up engagements covering 6+ months, the math matters:
| Approach | Cost | Time |
|---|---|---|
| Pay bank for 12 months of CSVs at $5 each | $60 | 30 min admin |
| Download 12 PDFs free, convert via tool | $0-39 | 30 min download + 30 min convert |
For most catch-up engagements, paying the bank is fine if the client will absorb it. For ongoing work, PDF conversion is cheaper.
Scenario 3: Bank gives PDFs but client can't access them
This usually means the client never set up online banking, or they forgot their password and gave up. The fix is to have the client either:
- Reset their online banking access and grant you view-only login credentials
- Request paper statements from the bank (slow, expensive, but works)
- Visit a branch and request statement reprints for the period you need
This is a client-management issue more than a technical one. Once they've granted access, the workflow is the same as Scenario 1.
Scenario 4: Bank has a CSV but the format is unusable
Some banks technically offer CSVs but the format is garbage — descriptions truncated to 20 characters, all transactions in one combined "amount" column with no sign convention, dates in unusual formats.
In this case, the PDF (which has full descriptions and proper formatting) is often better than the bank's CSV. Convert the PDF instead.
The case for moving the client to a friendlier bank
If your client banks somewhere that consistently makes your job harder — no CSVs, broken QBO integration, paywalled exports — it's worth raising the conversation about switching.
The banks with the friendliest data access for bookkeepers in 2026:
- Capital One Spark Business — CSV exports free, broad date range, good QBO integration
- Chase Business Complete Banking — 90 days CSV free, longer history via Chase Online Statements, solid QBO feed
- Mercury — built for startups, great CSV exports and API access
- Relay — built for small business bookkeeping, excellent data access
- Novo — clean data, good integrations
You're not going to convince every client to switch. But for new clients setting up business banking, you can recommend the data-friendly options upfront.
The workflow that actually works
Whatever bank your client uses, the workflow that holds up across scenarios:
- Use the bank's live QBO feed for ongoing transactions (last 90 days)
- For historical periods beyond 90 days, download PDF statements and convert them
- Use a converter that reconciles — you want errors caught at conversion, not at QBO import
- Keep a record of what you've imported (which months, from which source) so you can spot gaps
Done this way, "the bank doesn't give CSVs" stops being a problem. It's a small extra step, not a blocker.
What this looks like for catch-up engagements
Catch-up engagements are where the "no CSV" problem hurts most. You need 12-24 months of history; the bank gives you 90 days of CSV and a stack of PDFs for everything else.
For the full playbook on managing catch-up work when you're starting from a stack of PDFs, see our 24-month catch-up guide.
For the QBO import side once you have a clean CSV, see our PDF-to-QBO walkthrough.
The honest take
"The bank won't give me a CSV" is a solved problem. It's annoying that it's a problem at all, but the workflow for handling it is well-established. Pick a converter, build it into your process, move on. The clients with awkward banks are the same clients who need bookkeeping help most — they're rarely going to switch to Mercury just to make your life easier.