Why US bank statements are awkward for bookkeeping
US clients usually have two kinds of bank data:
- Official PDF statements from the bank.
- Transaction exports from online banking, if the account offers them and if the date range goes back far enough.
For bookkeepers and accountants, the PDF is often the safer source record. It shows the statement period, account identity, opening balance and closing balance. But PDF is not a working format. You still need clean rows for Excel, QuickBooks or Xero.
That is the gap this guide covers: keep the PDF as the source, convert it into a working file, and check the converted file before it enters the books.
What the IRS expects your records to prove
The IRS says good records help a business monitor progress, prepare financial statements, identify income sources, track deductible expenses, prepare tax returns and support items reported on tax returns.
It also says businesses may choose any recordkeeping system that clearly shows income and expenses, except in a few cases where special records are required.
For bank statements, that means:
- keep the original statements with the client file
- keep enough detail to prove income and deductions
- keep records for the applicable limitation period
- keep employment tax records for at least 4 years after the tax becomes due or is paid, whichever is later
The converted Excel or CSV file is useful for work. The original PDF statement is still the source document.
How long to keep US bank statements
IRS retention periods depend on what the record supports. The IRS lists these common periods for income-tax records:
| Situation | IRS period |
|---|---|
| General income-tax records, when no special rule applies | 3 years |
| Claim for credit or refund after filing | 3 years from filing or 2 years from payment, whichever is later |
| Worthless securities or bad debt deduction | 7 years |
| Unreported income over 25% of gross income | 6 years |
| No return filed or fraudulent return | Indefinitely |
| Employment tax records | At least 4 years |
For a bookkeeping team, the practical answer is simple: keep the source PDF statements with the records, and don't replace them with the spreadsheet.
The US date-format trap
US bank statements and accounting files commonly use MM/DD/YYYY. That can cause problems when a file is opened or imported in software set to another region.
A date like 04/05/2026 can mean:
- April 5 in US month-first format
- 4 May in many day-first settings
Before importing a converted US bank statement, check a few dates that cannot be guessed from the month alone. If the statement shows March 14, make sure the converted file still shows March 14, not an invalid or swapped date.
This matters most when a US file is being handled by an offshore bookkeeping team, a CA firm, or an accountant whose Excel regional settings use day-first dates.
Importing US bank statement data into QuickBooks
QuickBooks is the most common destination for US small-business bank data. It supports two CSV layouts for bank transactions:
| Format | Columns | When to use it |
|---|---|---|
| 3-column CSV | Date, Description, Amount | When payments are negative and deposits are positive |
| 4-column CSV | Date, Description, Credit, Debit | When you want money in and money out separated |
QuickBooks also warns that bank CSV files vary. A file can fail because of zeros, column names, dates, or debit/credit layout.
For a converted PDF statement, use the QuickBooks 3-column or QuickBooks 4-column output rather than a generic spreadsheet. Then check:
- date format
- payments and deposits signs
- blank values instead of zero values where required
- credit card payments and refunds
- duplicate transactions when a bank feed already exists
Importing US bank statement data into Xero
Xero can import bank statements from CSV. Xero's US help says the date and amount are the minimum fields needed to create statement lines. Descriptions are not just nice to have: they are what make reconciliation practical.
Use the Xero CSV output when the destination is Xero. After upload, check:
- Xero mapped the date column correctly
- money out and money in have the right sign
- transfers are matched instead of duplicated
- bank-feed transactions are not already present for the same period
Manual import is especially useful when a client gives you historical PDFs for a period before the bank feed was connected.
US bank guides
We are building individual guides for the US banks bookkeepers ask about most often:
| Bank | Guide |
|---|---|
| Chase | Chase statement to Excel, CSV and QuickBooks |
| Bank of America | Bank of America statement to Excel, CSV and QuickBooks |
| Wells Fargo | Wells Fargo statement to Excel, CSV and QuickBooks |
| Capital One | Capital One statement to Excel, CSV and QuickBooks |
| American Express | American Express statement to Excel, CSV and QuickBooks |
Each bank guide focuses on what can be verified from public sources: how the bank provides statements, how far back statements are publicly documented, and how to get the data into accounting software.
Workflow for US bookkeepers and accounting firms
When a client sends US bank statements, use this workflow:
- Collect the source PDFs. One account, one period, no screenshots.
- Check for missing months. Statement periods should be continuous.
- Convert to the right output. Excel for review, CSV for generic work, Xero CSV for Xero, QuickBooks CSV for QuickBooks.
- Run a balance check. If balances are shown, opening balance + deposits − withdrawals should equal closing balance.
- Separate transfers. Transfers between client accounts are not revenue.
- Store the PDFs. The converted file is a working file; the PDF is the record.
For CAs, CPAs and bookkeepers handling several clients, the biggest time saving is batch upload: upload a client's monthly statements together, choose the output once, then review a structured file instead of retyping from a PDF.
What to do when a bank export is not enough
A bank export can be useful, but it often has limits:
- it may cover only recent activity
- it may not include statement opening and closing balances
- it may not match the accounting software's import layout
- it may not be available for old accounts or closed periods
- it may not be what the client actually sends you
When that happens, convert the official PDF statement instead. You get the working spreadsheet while keeping the source statement intact.