Convert Lloyds Bank CSV to QBO / QFX / OFX
Drop your Lloyds Bank CSV or Excel export below and get a Lloyds Bank → QuickBooks/Quicken/Xero file in seconds. Private — nothing leaves your browser.
Advanced — bank identifiers (for "file not recognized" issues)
QuickBooks/Quicken use INTU.BID to recognize the file. Pick your bank above to autofill, or paste your own.
Free: up to 25 transactions per file. Pro (one-time $29): unlimited.
How to export your transactions from Lloyds Bank
Export as CSV. Columns: Transaction Date (DD/MM/YYYY), Transaction Type, Sort Code, Account Number, Transaction Description, Debit Amount, Credit Amount, Balance.
Once you have the file, drop it into the converter above. LedgerBridge auto-detects the date, amount and description columns — adjust the mapping if needed, choose QBO for QuickBooks (or QFX for Quicken, OFX for Xero), and download.
Tips for Lloyds Bank files
- Choose DD/MM/YYYY as the date format if auto-detect guesses wrong.
- If withdrawals come in as positive numbers, tick “Flip amount sign”.
- For credit-card exports, set the account type to Credit card.
- If QuickBooks rejects the file, open Advanced and confirm the INTU.BID — selecting “Lloyds Bank” in the bank dropdown autofills it.
FAQ
How do I export a CSV from Lloyds Bank?
Export as CSV. Columns: Transaction Date (DD/MM/YYYY), Transaction Type, Sort Code, Account Number, Transaction Description, Debit Amount, Credit Amount, Balance.
Is my Lloyds Bank data uploaded anywhere?
No. The conversion happens entirely in your browser. Your statement and account number never leave your device — safe even for client confidentiality requirements.
Will the file import into QuickBooks?
Yes. We generate a valid OFX 1.0.2 (SGML) document with the correct header and identifiers. Convert a small file free first to confirm it imports cleanly, then unlock unlimited.