Barclays CSV to QBO Converter: Convert a Barclaycard CSV to QuickBooks

Not reliably anymore. Starting around April 2026, Barclays US cards stopped sending transactions to QuickBooks and Quicken through the direct download and aggregated feeds, even though the account balance still updates. Barclays support has told cardholders it no longer uses the old Quicken download format and points people to statement downloads instead. Until Barclays restores a working feed, exporting the activity yourself and importing a converted .qbo is the method that gets your charges into QuickBooks.

Because Barclays changed how it publishes transaction data in 2026, and the feed QuickBooks and Quicken relied on stopped returning line items. The symptom is specific: the balance refreshes but no new transactions appear, or the connection throws an error after login. This is a change on Barclays' side, not a setting you can fix in QuickBooks. Downloading a CSV and importing a .qbo built from it sidesteps the broken feed entirely.

Export your Barclaycard activity as a CSV, then upload it in the converter at the top of this page. The tool detects the date, description, and amount columns, normalizes the dates, strips dollar signs, and checks the parsed total against your file before it writes the .qbo. Download the .qbo and import it into the matching Barclays credit card account in QuickBooks. The whole pass takes under a minute, with nothing typed by hand.

Sign in at barclaycardus.com, open the Activity or Statements area for your card, and choose a date range or a specific billing statement. Select the download or export option and pick the CSV or spreadsheet format. If your card view only offers a PDF statement, download that instead and turn it into a spreadsheet first, then convert that file here. Pull each statement you still need to record, since Barclays limits how far back the on-screen activity goes.

With the automatic feed down, the realistic choice is between waiting on a connection that may not return and a clean manual import you control. This table lays out what a Barclays US card supports right now and what each option means for your books.

Yes. The AAdvantage Aviator, JetBlue, Hawaiian Airlines, Wyndham Rewards, Frontier, Emirates Skywards, Priceline, and Breeze cards are all issued by Barclays and export activity as a CSV the same way. Convert that CSV to a .qbo and import it into the matching credit card account in QuickBooks. Purchases import as negative and payments as positive, the standard card convention, so the balance reconciles against your Barclays statement.

Add the Barclaycard as a Credit Card account, not a bank account, so purchases increase the balance you owe and payments reduce it. In QuickBooks Online, open the Chart of Accounts, add a new account, choose the Credit Card type, and name it for the card. Then import the converted .qbo into that account. Setting the type correctly up front keeps the running balance matching your statement and avoids sign errors during reconciliation.

In QuickBooks Online, open Transactions, then Bank transactions, select the matching Barclays card account, and use the upload option to add the .qbo file from your computer. QuickBooks reads the file, shows the charges and payments for review, and posts them once you accept. Because it is a Web Connect file rather than a raw CSV, you skip the column-mapping screen that raw CSV uploads force you through.

In QuickBooks Desktop, go to File, then Utilities, then Import, then Web Connect Files, and choose the .qbo you downloaded here. QuickBooks Desktop has no native import for a plain CSV of card transactions, so a .qbo is the only file it accepts for this. Match it to the correct Barclays credit card account when prompted and the charges post straight to that register.

QuickBooks Online caps a raw CSV upload at 350 KB, roughly a thousand rows, which splits long histories into several files. A .qbo import is not held to that CSV limit, so converting lets you bring a full year of Barclays activity into QuickBooks in one file. To process several statements at once, the bulk CSV to QBO converter handles them in a single batch.

Yes, and the accuracy check is the point. Before the .qbo downloads, the converter totals every transaction it parsed and compares that against your Barclays file. If a row is missing or misread, you see it in the preview instead of during reconciliation weeks later. The tool only reads the transaction rows, date, description, and amount, to build the file, and never asks for your Barclays login.