Guide7 min read

How Far Back Can You Export Bank Transactions? CSV Limits by Bank (2026)

Sooner or later everyone hits the same wall: you need a year (or five) of transactions in a spreadsheet, you open online banking, and the export button quietly refuses to go back further than a few months. The transactions still exist, but only inside archived PDF statements.

This guide collects the commonly reported CSV export windows for major UK and US banks as of mid-2026, explains why the limits exist, and shows the fastest way to recover history the export button cannot reach.

The three conditions bank CSV export requires

A bank’s own CSV export solves a narrower problem than it first appears. It works when three things are all true: you are the account holder, you can log in, and the transactions you need are recent. Break any one of those conditions and the export button is useless: an accountant holding a client’s PDF cannot log into the client’s bank, a closed account has no login at all, and anything older than the export window simply is not offered.

That last condition surprises people the most, because the windows are shorter than almost anyone expects.

Commonly reported CSV export windows (mid-2026)

These are the limits bank customers and accountants commonly report. Banks change them without notice and some vary by account type, so treat them as a guide and check your own online banking for the current rules:

  • Barclays: transaction export covers roughly the last few months (users report 60 to 90 days); older history is only available as archived PDF statements
  • HSBC UK: around 6 to 8 weeks of CSV; older transactions are PDF-only, though PDFs go back up to 6 years, and several account types have lost CSV export entirely
  • Lloyds: about the last 12 months, downloaded in chunks (users report roughly 90 days or 150 transactions per download)
  • Santander UK: around the last 12 months
  • NatWest: statement history up to 7 years online, but structured CSV downloads cover a much shorter recent window for most customers
  • Chase (US): about 24 months, with files capped near 1,000 rows
  • Bank of America: roughly 60 to 90 days per download
  • Wells Fargo: 90 days by default, up to 18 months on some account types
  • Monzo, Starling, Revolut: the fintech exception, generally offering full-history exports

Beyond the window, the PDF is the record

Banks keep statements for six to seven years to meet their own record-keeping obligations, but they keep them as PDFs, not as data. That is why the situations that need long history, mortgage applications, HMRC enquiries, audits, catch-up bookkeeping, divorce proceedings, visa applications, all end up as a folder of PDF statements rather than a tidy CSV.

The gap between "the bank stores 7 years" and "the bank exports 3 months" is exactly the gap a statement converter fills: it turns the PDFs the bank does give you back into the structured data the bank will not.

When you were never the account holder

For accountants, bookkeepers, lenders, and solicitors the export window is irrelevant, because they never had a login in the first place. Clients send statements as PDF attachments, scans, sometimes phone photos. Asking a client to log in and export CSVs for a dozen accounts across two years is a follow-up email that stalls the job for weeks; converting the PDFs they already sent takes minutes.

How to get old transactions into your accounting software

The workflow is the same whether it is your own history or a client’s:

  • Collect the PDF statements for the period you need (banks let you download archived statement PDFs even when CSV export is capped)
  • Drop them onto PivotBank; parsing runs entirely in your browser, so the statements are never uploaded anywhere
  • Check the preview: the running balance is verified line by line, so a mis-parsed page is visible immediately
  • Export in the format your software wants: QBO for QuickBooks, OFX for Xero and Sage, QIF for Quicken and QuickBooks Desktop, or plain Excel and CSV

The short version

Bank CSV export is fine for recent activity in your own account. For anything else, the practical limits are 90 days to 18 months at most major banks, and the only complete record is the PDF statement. Converting those PDFs, privately, in the browser, is what PivotBank is for.

Convert a bank statement now

PDF to Excel or CSV in seconds, 100% in your browser. Free to start, no sign-up required.