How to Import Lloyds Bank Bank Statement into Sage Accounting

To import your Lloyds Bank statement into Sage Accounting: download your PDF from lloydsbank.com → Internet Banking → Accounts → Statements, convert it to CSV using Bank Statement Converter (free, under 20 seconds), then upload via Sage Accounting → Banking → [Bank Account] → Import. No manual re-keying — all transactions transfer automatically.

Step 1: Download Your Lloyds Bank Statement

  1. 1. Log in at lloydsbank.com and select your account from the accounts list
  2. 2. Click 'Statements' in the account navigation tabs
  3. 3. Use the date range selector to choose the statement month you need
  4. 4. Click 'View statement' to open the PDF
  5. 5. Use the download icon within the PDF viewer to save the file

Step 2: Convert PDF with Bank Statement Converter

Upload your PDF to Bank Statement Converter — select CSV output — download in under 20 seconds.

Step 3: Import into Sage Accounting

  1. 1. Open Sage Accounting and go to Banking in the left menu
  2. 2. Select the bank account you want to reconcile
  3. 3. Click 'Import' or 'Import Statement' from the account toolbar
  4. 4. Select 'CSV' as the file type
  5. 5. Choose your CSV file downloaded from Bank Statement Converter
  6. 6. Sage will display a column-mapping screen — map Date, Description, Amount columns
  7. 7. Review the import preview and click 'Import' to load transactions
  8. 8. Sage will flag any duplicates — review and confirm your import

Frequently Asked Questions

How do I download my Lloyds Bank bank statement?
Log in at lloydsbank.com and select your account from the accounts list → Click 'Statements' in the account navigation tabs → Use the date range selector to choose the statement month you need → Click 'View statement' to open the PDF → Use the download icon within the PDF viewer to save the file
What file format does Sage Accounting accept for bank import?
Sage Accounting accepts CSV and OFX. CSV is the most flexible option. Convert your bank statement PDF to CSV using Bank Statement Converter, then import via Banking → [Account] → Import.
Does Sage Accounting auto-match imported transactions?
Yes. After import, Sage compares transaction amounts and dates against unreconciled entries and suggests matches. Manual override is available for any unmatched transaction.
Can I import into Sage 50 or Sage 200 as well?
Yes, though the import path differs. Sage 50: Bank → Import Statement. Sage 200: Cash & Treasury → Bank Reconciliation → Import. All versions accept CSV from Bank Statement Converter.
Is my Lloyds Bank data safe to upload?
Yes. Bank Statement Converter processes files in-memory and deletes them immediately after conversion. No data is stored, logged, or used for model training. No account is required.
Convert Free — No Signup