Convert Lloyds Bank CSV to QuickBooks (.QBO)
Works with Lloyds Bank CSV and Excel exports Nothing uploaded
Lloyds Bank lets you export transactions as CSV (and QIF) from online banking, look for Export transactions (CSV, QIF) under your statement options. There is no .QBO or Web Connect download. Note the export limits: roughly a 90-day range or a few hundred transactions at a time, so longer periods need several exports.
Lloyds' CSV is well labelled but built for spreadsheets, not QuickBooks. The columns are Transaction Date, Transaction Type, Sort Code, Account Number, Transaction Description, Debit Amount, Credit Amount and Balance. The amount is split across separate Debit Amount and Credit Amount columns, there's a running balance, and the date is UK DD/MM/YYYY. QuickBooks Online's importer wants a slim 3- or 4-column file with one signed amount or a clean debit/credit pairing, Lloyds' eight-column layout falls outside that and routinely fails to map.
QBO Maker reads the Debit/Credit pair, merges it into correctly signed transactions, keeps the description (with the transaction type for context), drops the sort code, account number and balance, fixes the date order, and writes a standards-compliant .QBO for QuickBooks Web Connect. Everything runs in your browser, so your Lloyds statement is never uploaded. Convert your Lloyds CSV now.
.QBO QuickBooks accepts. For Lloyds Bank, its dates are usually DD/MM/YYYY, and amounts arrive as a separate debit/credit columns (Debit Amount / Credit Amount), both detected automatically.A typical Lloyds Bank export has columns like Transaction Date, Transaction Type, Sort Code, Account Number, Transaction Description, Debit Amount, Credit Amount, Balance and uses DD/MM/YYYY dates. QBO Maker auto-detects these, just confirm the mapping.
How to import Lloyds Bank statements into QuickBooks
- Export your transactions from Lloyds Bank online banking as CSV or Excel.
- Open the QBO Maker converter and drop the file in.
- Confirm the auto-detected date, amount (or separate debit/credit) and description columns.
- Choose .QBO as the output and click download.
- In QuickBooks Online: Transactions → Bank transactions → Upload from file, then select the .QBO. In Desktop: Banking → Bank Feeds → Import Web Connect File.
Lloyds Bank-specific things to watch for
- Split debit/credit columns. Lloyds separates spends and deposits into
Debit AmountandCredit Amount; QBO Maker merges them into a single signed value QuickBooks understands. - Sort code and account number columns. The export carries
Sort CodeandAccount Numberon every row, irrelevant to QuickBooks and dropped during conversion. - Running balance. The
Balancecolumn breaks QuickBooks' CSV importer and is ignored (QuickBooks recalculates the balance). - Export caps. Lloyds limits each export to about 90 days or 150 transactions, so you may convert several files, each is processed independently.
QuickBooks Online vs Desktop
QuickBooks Online: Transactions → Bank transactions → Upload from file → choose your .QBO. QuickBooks Desktop: Banking → Bank Feeds → Import Web Connect File. Desktop is stricter about the bank ID.
Frequently asked questions
Does Lloyds Bank offer a QBO or Web Connect download?
No. Lloyds provides CSV and QIF exports only, with no native .QBO or Web Connect. QBO Maker converts the Lloyds CSV into the .QBO file QuickBooks imports through Web Connect.
Why does QuickBooks reject my Lloyds CSV?
Lloyds exports eight columns including sort code, account number, a running balance, and split Debit/Credit amounts. QuickBooks Online only accepts a 3- or 4-column layout with one amount field, so the raw file won't map. Converting to .QBO removes the unsupported columns automatically.
I have several Lloyds files because of the 90-day limit, can I combine them?
You can convert each file separately and import each .QBO, or use Pro batch mode to process multiple Lloyds exports at once and save a reusable column template so you only map it once.
Does the QIF option work instead?
QuickBooks Online doesn't import QIF, and Desktop's QIF support is unreliable for bank accounts. Sticking with the CSV export and converting it to .QBO is the most dependable route. Your data stays in the browser throughout, verify on the validator if you wish.
Convert your Lloyds Bank statement now
Free, in your browser, nothing uploaded. We will set the date format and currency for you.
Open the converter