Convert Barclays CSV to QuickBooks (.QBO)
Works with Barclays CSV and Excel exports Nothing uploaded
Barclays online banking lets you export recent transactions, but only as CSV (or PDF), there is no Web Connect or .QBO download for personal or business current accounts. To get a CSV, open the account, click View all transactions, set a date range, hit Search, then Export all and choose CSV. The export window is limited, so you often need to pull a few months at a time.
The trouble starts when you try to feed that file to QuickBooks. Barclays splits amounts into two columns, Money out and Money in, and includes a running Balance. QuickBooks Online's CSV importer wants a single signed amount (or a clean two-column debit/credit pairing) and chokes on the extra balance column and Barclays' header layout. QuickBooks Desktop won't touch a raw CSV at all.
QBO Maker bridges the gap. Drop your Barclays CSV in, it reads the Money in / Money out pair, merges them into properly signed transactions, and writes a real .QBO file you can import straight through Web Connect. Everything runs in your browser, your statement never leaves your machine. Convert a Barclays CSV now.
.QBO QuickBooks accepts. For Barclays, its dates are usually DD/MM/YYYY, and amounts arrive as a separate debit/credit columns (Money out / Money in), both detected automatically.A typical Barclays export has columns like Date, Description, Money out, Money in, Balance and uses DD/MM/YYYY dates. QBO Maker auto-detects these, just confirm the mapping.
How to import Barclays statements into QuickBooks
- Export your transactions from Barclays online banking as CSV or Excel.
- Open the QBO Maker converter and drop the file in.
- Confirm the auto-detected date, amount (or separate debit/credit) and description columns.
- Choose .QBO as the output and click download.
- In QuickBooks Online: Transactions → Bank transactions → Upload from file, then select the .QBO. In Desktop: Banking → Bank Feeds → Import Web Connect File.
Barclays-specific things to watch for
- Two amount columns. Barclays uses
Money outandMoney inrather than one signed amount, so QuickBooks frequently misreads spends as deposits. QBO Maker merges them into correctly signed transactions. - Running balance column. The
Balancecolumn trips up QuickBooks' importer, QBO Maker ignores it automatically (the balance is recalculated by QuickBooks anyway). - Limited export window. Barclays caps how far back a single CSV export reaches, so you may need to convert several files; the converter handles each one independently.
- Barclaycard differs. Barclaycard credit-card exports use a different layout from current-account CSVs, so map columns carefully if you bank with both.
QuickBooks Online vs Desktop
QuickBooks Online: Transactions → Bank transactions → Upload from file → choose your .QBO. QuickBooks Desktop: Banking → Bank Feeds → Import Web Connect File. Desktop is stricter about the bank ID.
Frequently asked questions
Does Barclays let me download a QBO or Web Connect file directly?
No. Barclays current accounts and Barclaycard only offer CSV and PDF downloads, there is no native .QBO, .QFX or Web Connect option. That is exactly why a converter is needed: upload your Barclays CSV and QBO Maker produces the .QBO QuickBooks expects.
Why does QuickBooks say my Barclays CSV is the wrong format?
QuickBooks Online accepts a narrow 3- or 4-column CSV layout. Barclays' export has a Balance column and splits amounts across Money out and Money in, which falls outside that template. Converting to .QBO removes the guesswork, QuickBooks reads it as a bank statement, not a spreadsheet.
Can I convert a Barclays business account export the same way?
Yes. Barclays Business Banking exports use the same Money in / Money out structure as personal accounts, so the conversion works identically. Free accounts cover one full statement, unlimited transactions; Pro removes the limit and lets you save a reusable Barclays template.
Is my Barclays statement uploaded anywhere?
No. The entire conversion happens locally in your browser using JavaScript, nothing is sent to a server. You can confirm the output before importing on our validator page.
Convert your Barclays statement now
Free, in your browser, nothing uploaded. We will set the date format and currency for you.
Open the converter