Skip to content
stmtai

Convert Halifax statements to QuickBooks.
Checked against the printed balances first.

Halifax's Statement options export is CSV or QIF for a short date range, and neither is a QuickBooks Web Connect file.

Drop your bank statements here

One file or a whole year. PDF, scanned image, CSV, QIF or OFX. Up to 12 files at a time; long PDFs are split for you.

Not ready to upload your own? See a sample result

5 pages free, no account. The QuickBooks download appears on the results page.

Download the statement from Halifax

  1. Sign in to Halifax Online Banking and select the current account from the account overview.
  2. On the account page choose "Statement options", then the download option, and pick the statement period from the drop-down.
  3. Choose PDF and save the file; each statement period saves as its own document.
  4. Credit card statements cannot be downloaded from Halifax Online Banking at all; Halifax tells you to ask for a PDF through online chat or to use the app instead.
  5. In the Halifax app: open the account, tap the three-dot menu, then "Download or print statement", choose the month and year, and save. The app reaches back at least ten years against seven in Online Banking, and it is the only self-service route to card statement PDFs.

Then drop the file above. Several months at once is fine; each statement comes back as its own .qbo file.

Before you upload: is the PDF password-protected?

Halifax statements saved from Online Banking or the app open without a password. Card statement PDFs sent after a chat request have also arrived unprotected on the ones we have handled; if a file does ask for one it was added after it left Halifax.

Halifax and QuickBooks

Halifax's Statement options export is CSV or QIF for a short date range, and neither is a QuickBooks Web Connect file. Converting the PDF gives QuickBooks a .qbo with a stable FITID per row, checked against the Balance on lines at the top and bottom of the statement before the file is written.

Under "Statement options" there is an export choice that produces CSV or QIF for a date range you pick. The range is short: the Lloyds Banking Group platform generally offers a few months per file, though the picker on Bank of Scotland allows a tax year, so on Halifax check what the date boxes accept for your account rather than assuming. The CSV has Transaction Date, Transaction Type, Sort Code, Account Number, Transaction Description, Debit Amount, Credit Amount and Balance, so unlike many bank exports it does carry a balance per row. What it lacks is the statement framing: no "Balance on" opening line, no Money In and Money Out totals, and the type code sits in its own column rather than in the description your bank rules were written against. Halifax quotes seven years of statements in Online Banking and at least ten in the app, so for anything past the export window the PDF is the only complete record and it is the one that ties out.

Import into QuickBooks

  1. Drop the statement on the home page. Fix any flagged row (or swap debit/credit if the bank prints them reversed) until the badge is green.
  2. Click QuickBooks (.qbo).
  3. QuickBooks Online: Transactions → Bank transactions → Link account ▾ → Upload from file → choose the .qbo → pick the account → Next.
  4. QuickBooks Desktop: File → Utilities → Import → Web Connect Files → choose the .qbo → select the account.
  5. Review the imported transactions in the For Review tab and add them.

What usually goes wrong

  • Money In is printed before Money Out, the opposite of Lloyds and most other UK banks; columns are read by heading, so the sign follows the label rather than the position.
  • Statement periods do not always run a calendar month, and on quieter accounts one PDF can cover two or three months; the running balance on every row still ties from the first Balance on line to the last.
  • Reward payments and the monthly account fee arrive as their own lines and are easy to mistake for interest; in the check they are ordinary credits and debits.
  • Reversed signs: money out imported as deposits. The most common complaint about statement converters. We show you the totals and let you swap before export.
  • Duplicate transactions on re-import because the FITID changes each time. Ours is derived from the row content, so the same statement always produces the same IDs.
  • "QuickBooks found an error" on upload, usually from a missing INTU.BID, unescaped ampersands or a bad date. Check any .qbo with our free QBO checker.

None of this is bank-specific configuration. The balance check catches these cases for every bank; this list just explains what you will see on a Halifax file.

Already have a .qbo that QuickBooks rejects?

Run it through the free QBO checker. It reads the file in your browser (nothing is uploaded) and lists exactly what QuickBooks will object to: missing INTU.BID, duplicate FITIDs, bad dates, unescaped ampersands, sign mismatches.

Halifax and QuickBooks questions

Why is Money In before Money Out on my Halifax statement when Lloyds prints them the other way round?

Halifax kept its own statement template when it joined Lloyds Banking Group, and the column order is one of the leftovers. It makes no difference to the result because columns are read by their headings: a figure under Money In becomes a credit and a figure under Money Out a debit whichever side of the page it sits on. The output uses the same column order for every bank, so Halifax and Lloyds sheets stack cleanly in one workbook.

My Halifax statement covers three months in one PDF. Should I split it before converting?

No need. The statement has one opening "Balance on" line and one closing "Balance on" line, and the running balance is printed on every row in between, so the whole period is checked as a single run. Convert it as one file and filter the sheet by month afterwards if you post monthly. Splitting it by hand would only remove the balance lines the check depends on.

Does it work with QuickBooks Online and Desktop?

Yes. The .qbo is OFX 1.02 with the INTU.BID QuickBooks requires, which both accept. Desktop imports via Web Connect.

What if QuickBooks rejects the file?

Run it through the QBO checker at /tools/qbo-checker; it explains what QuickBooks objects to. If the issue is with a file we produced, email support with the conversion ID and we fix the reader.

Can I get Halifax transactions into QuickBooks without the bank's own export?

Yes. Download the statement PDF from Halifax, drop it on this page and wait for the balance check, which compares the rows with the balances printed on the statement. Then download the QuickBooks file and import it with the steps above. No Halifax template is involved; the statement is read the way a person reads it, and the balance check is what tells you the rows are complete.

More for this bank

All banks and formats · See a sample result