# Convert Barclays CSV to QuickBooks (.QBO)

_Canonical: https://qbomaker.com/banks/barclays.html_

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.

## Steps

1. Export your transactions from Barclays online banking as CSV or Excel.
2. Open the QBO Maker converter and drop the file in.
3. Confirm the auto-detected date, amount (or separate debit/credit) and description columns.
4. Choose .QBO as the output and click download.
5. In QuickBooks Online: Transactions → Bank transactions → Upload from file, then select the .QBO. In Desktop: Banking → Bank Feeds → Import Web Connect File.

**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 free at https://qbomaker.com/#tool, runs entirely in your browser.