Schema CPA

How to Collect Bank Statements From Clients

By Schema CPAPublished Updated

To collect bank statements from clients, ask for the bank's own monthly PDF statements, downloaded from online banking, for every account and every month the engagement covers. Give clients a short download guide, list each account by name and last four digits, and track each month as its own line so a missing statement is visible.

Which bank statement format should you ask clients for?

The most useful bank statement format is the monthly PDF statement the bank itself produces. It shows the account holder, the account number, the statement period, the opening and closing balance and every transaction. A CSV export or a paper copy can fill a gap, but the official PDF is the version to request first.

A bank statement PDF carries details the other formats tend to drop. The bank's name and logo, the masked account number and the printed period tie the document to one account and one month. The opening balance of one statement should equal the closing balance of the one before it, which is how a reviewer confirms that a run of statements is unbroken.

A CSV or spreadsheet export from online banking is a list of transactions over whatever date range the client picked. It is easy to load into a spreadsheet, but it usually has no balances printed as the bank issued them and no fixed period. Two exports can overlap or leave a few days out without anyone noticing. Treat a CSV as a working file next to the PDF, not a replacement for it.

Paper statements are still official documents. A client who receives statements by mail can scan them or bring them in. The post on drop-off vs digital tax document collection covers how a firm can accept paper without letting it slow everyone else down.

Statements matter beyond the numbers. IRS Publication 583 notes that when a canceled check is not available, a taxpayer may be able to prove payment with certain financial account statements, as long as they are highly legible and show details such as the payee, amount and posting date (IRS Publication 583). That is one more reason to ask for the full, readable statement rather than a summary.

Once statements are in, many firms convert them to a spreadsheet. That step has its own set of guides in the bank statements to Excel category.

Where do clients download bank statements in online banking?

Clients download bank statements from the account's statements or documents area in online banking, usually reached by signing in, opening one account and choosing a menu labelled something like Statements, Documents or eStatements. The label varies from bank to bank, so the client guide should describe what to look for, not name a single button.

Many clients have never opened that part of their banking site. They know how to check a balance or move money, and assume a "statement" means the transaction list on the home screen. A short, numbered guide closes that gap. Send it with the request, not after the first wrong upload.

A client step list for downloading monthly PDF statements

This is an example guide a firm might send. Adjust the account names and months for each client.

  1. Sign in to your bank's website on a computer if you can. Phone apps sometimes hide older statements.
  2. Open one account, for example "Everyday Checking XXXX-4821".
  3. Look for a menu called Statements, Documents, eStatements or Account documents.
  4. Choose the year we asked for, then open each monthly statement one at a time.
  5. Save each statement as a PDF. Do not print it to paper and do not take a screenshot.
  6. Repeat for each month on our list, then for each other account.
  7. Upload every file to the link we sent you, or reply to our email with them attached.

Two notes help. First, tell clients the file names do not matter, because a firm reads the statement itself, not the name. Second, tell them what to do when a month is not listed online. If a month does not appear online, the client may need to ask the bank for a copy. The client should say which months they could not find rather than skip them silently.

For clients who struggle with any online step, an adult child or a branch visit may be the faster route. The phone call often takes less time than a third email.

Collecting bank statements for every account a client holds

Collecting bank statements for every account means building a list of accounts before asking for any months. Clients forget savings accounts, old accounts at a second bank and accounts opened partway through the year. Start the list from last year's documents and the client's other paperwork, then ask the client to confirm it.

Several sources point to accounts a client did not mention:

  • Last year's statements and forms. If a bank sent a 1099-INT last year, the account that earned the interest probably still exists.
  • Transfers on the statements you have. A checking statement showing "Transfer to Savings XXXX-0937" names a second account.
  • Loan and credit card payments. A payment to a loan or card points to a statement the firm may also need.
  • The client's general ledger. For a business client, every bank account in the books should have its own run of statements.

A per-account tracking grid of months received

A grid with one row per account and one column per month makes gaps obvious. Here is an example for a fictional client, Marisol Vega, for a calendar year.

Account (example)JanFebMarAprMayJunJulAugSepOctNovDec
Lakeshore Bank checking XXXX-4821YesYesYesYesYesYesNoYesYesYesYesYes
Lakeshore Bank savings XXXX-0937YesYesYesYesYesYesYesYesYesYesYesNo
Pinecrest Credit Union share XXXX-5512NoNoNoYesYesYesYesYesYesYesYesYes

The grid tells a story the folder alone does not. The checking account is missing July. The savings account is missing December. The credit union account has nothing before April, which could mean the account was opened in April or that three statements are missing. Only the client knows which, so the request should ask the question rather than demand three files.

A gap in a run of statements is easier to spot when balances are compared month to month. The post on finding gaps in a run of bank statements explains how to confirm that a run is complete using the balances themselves. When a gap is confirmed, the wording for asking the client is covered in how to request missing bank statements from a client.

Bank statements from joint, closed and business accounts

Joint, closed and business accounts are the bank statements clients most often leave out. A joint account may be "my spouse's account" in the client's mind. A closed account feels finished. A business account may seem like a separate matter. Each still needs its own statements for the months it was open during the period.

Joint accounts. A joint account belongs to two or more people. Ask the client to send its statements even if the other holder is the one who usually manages it. If the other holder is also a client of the firm, note on both files which statements came from whom, so the same statement is not processed twice.

Closed accounts. An account closed during the year still produced statements up to the month it closed. The last statement, often showing a zero balance, is the proof that the account ended and that no months are missing. If the client can no longer see the account online, they may need to ask the bank for copies. Ask early, so the request is not the last thing holding up the file.

Business accounts. A sole proprietor may run business income through a separate account, or through a personal account. Ask directly which accounts carry business activity. For a business entity, every account in the books needs a full run, and the person who can download statements may be a bookkeeper or office manager rather than the owner. The same question of who has access comes up with payroll, covered in how to collect payroll reports from clients.

For bookkeeping clients who send statements every month rather than once a year, a fixed monthly cutoff keeps the run current. That routine is described in setting a monthly document cutoff for bookkeeping clients.

Bank statement collection mistakes: screenshots and partial months

Bank statement collection mistakes usually come down to submissions that look like statements but cannot be used: screenshots of a transaction list, exports covering part of a month, a single page of a multi-page statement, or a statement for the wrong account. Each one creates a follow-up request, so the first request should name these as things not to send.

Screenshots. A screenshot of the banking app shows a scrolling list of transactions. It has no statement period, no opening or closing balance and often no account number. It cannot be tied to the statements before and after it. Ask for the PDF instead, and say why in one sentence so the client does not send screenshots again next month.

Partial months. A date-range export from the 3rd to the 28th looks complete until the balance does not carry forward. Statement periods also do not always match calendar months. A statement running from the 16th of one month to the 15th of the next is still one statement, and the request should ask for statements by period, not by calendar dates.

Missing pages. Statements with many transactions run several pages, and the last page often holds the balance summary or check images. A client who prints and scans may send page one only. When a statement shows "Page 1 of 4", count the pages before marking it received.

The wrong account or year. A client with two checking accounts at the same bank may send the same account twice. Compare the last four digits on every statement against the grid before ticking a box.

Accepting "that's everything." Clients send what they can find. The account list and the grid are the check, not the client's sense of being done.

Schema CPA reads each bank, savings and loan statement it receives, ties out the balances from one month to the next and calls out gaps in the run. The document categories on the homepage list the statement types it handles.

All posts in Collecting client documents