Why do bank feeds only show 90 days?

Most UK banks limit Open Banking bank feeds to 90 days of transaction history by default. This is an industry standard set by Open Banking regulations. For older transactions, you need to manually download and import PDF or CSV statements.

How do I import a PDF bank statement into Xero without a bank feed?

Xero doesn't accept PDF bank statements directly. You must first convert the PDF to Excel or CSV using a tool like BankScan AI, then import the file via Xero's 'Import Bank Statement' feature under the account's 'Manage Account' menu.

Can I import historical bank statements into QuickBooks?

Yes. Download the historical bank statement PDF, convert it to Excel or CSV, and use QuickBooks' import tool (Gear icon > Import Data > Bank Transactions). QuickBooks Desktop users should note that Intuit is sunsetting QB Desktop support.

Import Bank Statements Without a Bank Feed — The Complete Guide

You've set up a bank feed for a client. It's pulling transactions. But there's a problem: it only goes back 90 days.

If you're onboarding a new client mid-year, or doing year-end accounts that need the full 12 months of data, those missing 9 months of transactions are a headache. This guide shows you exactly how to fill the gap — without manually typing hundreds of transactions.

The problem: Open Banking regulations limit most UK bank feeds to 90 days of transaction history. For transactions older than 90 days, you're on your own. The bank's online portal typically lets you download PDF statements going back years — but your accounting software won't accept them directly.

Step 1: Download the Bank Statement PDFs

Every major UK bank lets clients download PDF statements from their online banking portal. Here's where to find them:

HSBC: Statements → Select account → Choose date range → Download PDF
Barclays: Statements & documents → Select period → Download
Lloyds: View statements → Select month → Download as PDF
NatWest: Statements → Select account & period → Download
Monzo: Account tab → Statement history → Download PDF

Ask your client to download PDFs covering the period before the bank feed started. Most banks let you go back 5+ years.

Step 2: Convert PDF to Excel (Not Manual Entry)

Your accounting software won't accept PDFs. You need a spreadsheet. You have three options:

Manual copy-paste: Open the PDF, copy transactions row by row, paste into Excel. 15–30 minutes per statement. Error-prone.
CSV export: Some banks offer CSV downloads alongside PDFs. If available, this is the easiest path — but not all banks support it, and CSV exports often have inconsistent formatting.
AI-powered converter: Upload the PDF to a tool like BankScan AI and get a formatted Excel file in seconds. Handles messy formats like HSBC multi-line and NatWest references automatically.

Why AI conversion beats manual entry: A 3-page HSBC statement can contain 80+ transactions with multi-line descriptions, embedded transaction codes, and running balances that change mid-page. Manual copy-paste takes 20+ minutes and almost always introduces errors. An AI converter does it in under 10 seconds.

Step 3: Import into Your Accounting Software

Once you have the Excel or CSV file, importing it depends on your software:

Importing into Xero

Go to the relevant bank account in Xero
Click Manage Account → Import a Bank Statement
Select your CSV or Excel file
Map the columns (Date, Description, Amount)
Xero will attempt to match transactions — review and confirm

Importing into QuickBooks Online

Go to Transactions → Banking
Click Upload transactions
Select your CSV file (QuickBooks Online prefers CSV over Excel)
Map columns and confirm

Importing into Sage

Go to Bank accounts → Select the account
Click Import → Choose your CSV file
Map the columns to Sage's format

Importing into FreeAgent

Go to Banking → Bank Accounts
Select the account → Upload Bank Statement
Choose your CSV file and confirm

A Better Workflow for Onboarding New Clients

The 90-day bank feed limit means every new client onboarding involves this same manual PDF-to-Excel dance. Here's how to make it painless:

Ask for PDFs upfront: When onboarding a new client, ask them to download the full year's PDF statements before setting up the bank feed
Batch convert: Run all PDFs through a converter like BankScan AI at once
Import first, then connect: Import the full year of transactions, then set up the live bank feed going forward

Pro tip: If you're dealing with a client who's switched banks mid-year, you'll need statements from both banks. BankScan AI supports all major UK banks, so you can process statements from different banks in the same batch.

Convert Your Client's Older Statements in Seconds

Upload any UK bank statement PDF — HSBC, Barclays, Lloyds, Monzo, and more — and get a clean Excel file ready for import. No signup needed.

Try Free Now →

Last updated: 8 May 2026. Bank import steps checked against Xero, QuickBooks Online, Sage Business Cloud, and FreeAgent as of this date.

How to Import Bank Statements Without a Bank Feed