Lloyds Bank Statement to Excel Converter

Converting Lloyds Bank Statements to Excel

A Lloyds Bank statement gives each transaction a short Type code alongside its date, description and amount. That extra detail is useful, but it is also what usually goes wrong when you copy a statement into a spreadsheet: the type merges into the description, money in and money out collapse into one column, and Excel may read 05/04 as 4 May. Finlyzers reads the statement row by row and keeps each value where it belongs.

How a Lloyds Statement Is Usually Laid Out

• Header: account name, sort code, account number and the statement period.
• Summary: typically a balance at the start of the period, total money in, total money out and the balance at the end.
• Transaction table: columns usually covering Date, Description, Type, Money In, Money Out and Balance. The exact order and wording can vary between account types and older statements.
• Page breaks: balances carried from one page to the next are balances, not transactions, so they are not added to your transaction list.

Lloyds Type Codes

The type column tells you how each payment was made. Codes you will commonly see include:

• DEB: a debit card payment, in a shop or online.
• DD and SO: direct debits and standing orders.
• FPI and FPO: Faster Payments coming in and going out.
• CPT: a cash machine withdrawal.
• TFR: a transfer, often between your own accounts.

Because the code stays with each transaction, it becomes a quick filter. A landlord can filter for FPI to list rent received, and a sole trader can separate DEB card spending from bills paid by direct debit.

Lloyds CSV Exports and Statement PDFs

Lloyds Internet Banking usually lets you export recent transactions as a CSV file, with debit and credit amounts in separate columns. If you only need the last few weeks of your own account, that export is a good place to start.

Converting the PDF makes more sense when:

• you need older months that are only available as statements;
• the account has been closed;
• someone has sent you the PDF, for example a client, a tenant applying to rent from you, or a relative whose finances you help with;
• you want the figures from the official statement for a lender, an accountant or your own records.

Self Assessment and Making Tax Digital

A UK tax year runs from 6 April to 5 April, which rarely lines up with statement dates. To total a year's rental income or business expenses, convert each monthly statement, combine them in one sheet and filter on the date column to keep only that tax year. Because dates are read in UK order, the filter will not mix up April and May.

If you keep your records in Making Tax Digital compatible software, converted statements can also give that software a history for the months before you started using it.

Getting Lloyds Transactions Into Accounting Software

• QuickBooks: download QBO and import it into the matching bank account.
• Xero, FreeAgent or Sage: use OFX, or CSV if you prefer to map the columns yourself.
• Excel only: keep the spreadsheet for mortgage applications, budgeting or a year-end review with your accountant.

Halifax and Bank of Scotland

Halifax and Bank of Scotland are both part of Lloyds Banking Group, and their statements often follow a similar structure. You can upload them here as well, though it is worth checking the columns in your download, as the layout is not always identical.

Other Banks and Statement Types

Banking elsewhere too? See the NatWest and HSBC converter pages. For Lloyds credit card statements, use the credit card converter. For paper statements that have been scanned or photographed, try the scanned statement converter.