# Convert Lloyds Bank CSV to QuickBooks (.QBO)

_Canonical: https://qbomaker.com/banks/lloyds-bank.html_

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.

## Steps

1. Export your transactions from Lloyds Bank online banking as CSV or Excel.
2. Open the QBO Maker converter and drop the file in.
3. Confirm the auto-detected date, amount (or separate debit/credit) and description columns.
4. Choose .QBO as the output and click download.
5. In QuickBooks Online: Transactions → Bank transactions → Upload from file, then select the .QBO. In Desktop: Banking → Bank Feeds → Import Web Connect File.

**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 free at https://qbomaker.com/#tool, runs entirely in your browser.