Lloyds Statement to CSV/Excel — QuickBooks & Xero Import
Lloyds gives users unusually concrete guidance for statement access, including a shorter web archive, a deeper app archive, and a separate rule for credit-card PDFs. Exact Statement converts Lloyds statement PDFs into clean CSV or Excel while preserving the UK-specific rows that matter during reconciliation.
Files are validated locally, split into chunks, then uploaded directly to secure storage.
Official Lloyds guidance: up to 7 years of statements in online banking · at least 10 years in the app · credit card PDFs may require app download or chat request
Where To Download Lloyds Statements
Lloyds is worth treating as its own page because the app, online banking, and credit-card PDF rules are not all the same.
Online banking goes back up to 7 years
Lloyds says you can access statements up to 7 years old in online banking.
The app can go back at least 10 years
Lloyds says its app can show statement history going back at least ten years.
Mobile path is explicit
Lloyds says you log in, select the account, open the three-dot menu, then choose Download or print statement.
Credit-card PDFs use a different rule
Lloyds says credit-card statement PDFs may need app download or an online chat request instead of the normal online-banking route.
What Usually Matters In Lloyds Statements
This page should acknowledge that Lloyds statement access is product-sensitive, especially between bank accounts and cards.
App archive depth is stronger than web archive depth
That difference changes how far back a user should search before assuming a statement is unavailable or needs a different channel.
UK payment semantics still drive reconciliation
Direct debits, standing orders, Faster Payments, and merchant card rows should remain legible after cleanup.
Credit-card PDFs are not the same workflow
Lloyds itself separates the rule for credit-card statements, so the content should not pretend everything lives behind one menu.
Long history increases manual-error risk
Once users start backfilling years of PDFs, copy-paste mistakes around dates and balances compound quickly.
Target-accounting format still matters
QBO and Xero need clean columns, not just extracted PDF text.
Protected files need manual unlock
If the PDF is protected, unlock it before upload. Exact Statement does not remove Lloyds PDF passwords for you.
Common Lloyds Import Pitfalls
Lloyds problems usually appear when users assume every product uses the same access and export path.
Looking in online banking for a credit-card PDF
Lloyds says some credit-card PDFs need app download or chat support instead of the default bank-account flow.
Ignoring the app’s deeper archive
Users may think old statements are gone when the web view stops at 7 years but the app still goes back at least 10 years.
Losing UK payment-type context
Rows such as DD and SO need to survive the export, not disappear into one generic description cell.
Importing raw PDF columns into accounting software
The final format still needs signed amounts and target-specific mapping.
Preview A Cleaned Lloyds Export
These rows reflect a UK statement export that keeps payment types and balance review intact.
| Date | Amount | Payee | Description | Reference | Transaction Type | Balance | Currency | Account ID |
|---|---|---|---|---|---|---|---|---|
| 07/03/2025 | -2800.00 | Client payment | FASTER PAYMENT FROM CLIENT | FPS | Debit | 6882.30 | GBP | ****4107 |
| 08/03/2025 | 33.00 | Xero | DD XERO SUBSCRIPTION | DD | Credit | 6849.30 | GBP | ****4107 |
| 09/03/2025 | 9.40 | Transport for London | CARD TFL TRAVEL CHARGE | CARD | Credit | 6839.90 | GBP | ****4107 |
| 10/03/2025 | 1450.00 | Office rent | SO OFFICE RENT | SO | Credit | 5389.90 | GBP | ****4107 |
| 10/03/2025 | -2.11 | Interest | INTEREST CREDIT | INT | Debit | 5392.01 | GBP | ****4107 |
Sample rows for preview only. Lloyds examples emphasize archive-friendly current-account cleanup, not card-only assumptions.
How Lloyds Fields Map Into Accounting Imports
The key is preserving UK payment semantics while producing a software-ready final file.
| Field In Statement PDF | Exact Statement Output | QuickBooks Online | Xero CSV |
|---|---|---|---|
| Statement date | Normalized Date | Date | Date |
| Merchant / payment text | Payee + Description split | Description | Payee + Description |
| Amount | Signed Amount | Amount or Credit/Debit | Amount + Transaction Type |
| DD / SO / FPS / card ref | Reference | Optional | Reference |
| Running balance | Balance for XLSX review | Not required | Not required |
Sources: Lloyds download statements help · Lloyds statements hub · Intuit CSV format guide · Xero CSV import guide.
Lloyds Statement to CSV — Frequently Asked Questions
Lloyds says online banking can access statements up to 7 years old, while the app can go back at least 10 years.
Lloyds says you log in, select the account, open the three-dot menu, then choose Download or print statement.
Lloyds says credit-card PDF statements may require app download or online chat support, so they do not always follow the same path as bank-account statements.
Lloyds publishes different archive expectations for the two surfaces: up to 7 years in online banking and at least 10 years in the app. That is exactly why older statement retrieval can feel inconsistent if you only check one channel.
Unlock it before upload. Exact Statement does not remove Lloyds PDF passwords for you.
Need the official help pages? Lloyds download statements help · Lloyds statements hub · support@exactstatement.com.
Convert Your Lloyds Statement Now
Upload a Lloyds statement PDF and export a clean CSV or Excel file for QuickBooks Online, Xero, or UK bookkeeping review.