Bank statement formats: what to ask clients to send (and what to refuse)

Ask for a bank-generated file, not a picture of one. A CSV or bank-feed export is best for importing, an official PDF statement is best for proving the balance, and screenshots or phone photos should be your last resort. Clients send awkward formats because nobody told them what you need, so the fix is mostly in how you ask.

The formats, best to worst

CSV export of transactions: imports into most accounting software and can be checked line by line
QBO or OFX file (the bank's 'Quicken' or 'Web Connect' download): imports with fewer mapping steps where the bank offers it
Official PDF statement downloaded from online banking: ideal for reconciling to the closing balance, but its transactions must be keyed in or converted
A bank feed connected to your software: no files at all, and the client only has to approve the connection
Scanned paper statement: readable, but slow and error-prone to convert
Screenshot or phone photo: partial, often cropped, and cannot be trusted as a complete record

Why screenshots and photos fail

A screenshot shows only what fits on the screen, so transactions are cut off and nobody can tell whether the page is complete. Photos add glare, skew and blur, and any text recognition on them makes mistakes you will not see until the reconciliation is out by a few cents or a few thousand. Neither shows the statement period and closing balance reliably, which are the two things you reconcile against.

Stop chasing clients for documents by hand.

DocNag sends the secure upload link and the reminders for you. Free plan: 3 active requests, no card, no client accounts.

Try it free or see the 1-minute demo

Use both a PDF and a CSV where you can

They answer different questions. The PDF is the bank's own statement of the opening and closing balance for the period, and the CSV is the data you import. If the two disagree, the difference is your first clue to a missing or duplicated transaction. If the client can only manage one, take the CSV for the data and ask for the PDF for any account you reconcile.

How to ask so you get the right file

Name the account, the period and the format in one sentence, and say where to click. For example: 'Please download the statement PDF and the transactions CSV for the Chase business checking account ending 1234, for 1 to 31 March, from online banking. Please do not send screenshots or photos.' Banks word their menus differently, so a short instruction with the words 'Statements' or 'Download' in it helps more than a long explanation. Consider a one-time screen recording or a PDF showing where the button is at your clients' two or three most common banks.

Common problems and fixes

Password-protected PDF: ask the client to re-download it, or to tell you the password through a separate channel, not in the same email
Statement covers the wrong dates: state the exact start and end dates in the request
CSV opens with scrambled dates or dropped leading zeros: the client opened and re-saved it in a spreadsheet; ask for the original download
Several accounts in one file: ask for one file per account so you can reconcile each
Only the last 90 days are available online: ask the client for older statements from the bank or branch, or use a bank feed for the history
Joint or personal accounts mixed with business: ask which transactions are business before you import

What to do when a client still sends a photo

Accept it so the work is not blocked, say politely that it is incomplete, and send the instructions again for next month. If you must work from photos, check that every page is present, that the opening and closing balances are visible and that the figures add up before you post anything. Putting the format in your onboarding checklist and engagement letter makes the next request easier.

Make the format part of the request

A checklist item that says 'March bank statement, PDF plus CSV' gets a better result than an email saying 'send statements'. In DocNag you write the item once, the client uploads against it from their phone or computer through one private link, and you see whether it is in. The checklist below is prefilled with the month-end items, including bank statements; edit the wording to name the format.

Looking for the full close process? See the month-end close checklist with a free Excel template.

Frequently asked questions

What is the best format for a client to send a bank statement?

A bank-generated file, not a picture of one. A CSV or bank-feed export is best for importing, and an official PDF statement is best for proving the balance. Screenshots and phone photos are a last resort.

Why are screenshots of bank statements a problem?

A screenshot shows only what fits on the screen, so transactions are cut off and nobody can tell whether the page is complete. They also do not reliably show the statement period and closing balance, which are what you reconcile against.

Should I ask for a PDF and a CSV?

Where you can, yes. The PDF is the bank's own statement of the opening and closing balance, and the CSV is the data you import. If the two disagree, that is your first clue to a missing or duplicated transaction.

What if the client's PDF is password-protected or covers the wrong dates?

Ask them to re-download it, or send the password through a separate channel, not in the same email. State the exact start and end dates in the request so the statement covers the right period.

Skip the copy-paste

Turn this into a request in two minutes. DocNag sends your client one private upload link, tracks what's missing and sends the reminders for you.

Use the "Month-end close" checklist in DocNag

Free plan, no card needed. Or see a live demo first.

Comparing tools? See the Financial Cents alternative and Content Snare alternative comparisons, or all comparisons.