Barclays Not Downloading Into QuickBooks? Import It With a CSV

Short answer: If your Barclaycard balance updates in QuickBooks but no new transactions come through, the automatic feed broke on Barclays' side in early 2026, not on yours. The fix that works today is to download your Barclays activity as a CSV, convert it to a QuickBooks Web Connect (.qbo) file, and import that file into the card account. It takes about a minute and brings in every charge and payment cleanly.

This started hitting Barclays US cardholders around April 2026. People opened QuickBooks or Quicken, saw the balance refresh, and found no transactions behind it. Barclays support began telling customers it no longer uses the old Quicken download format and pointed them to statement downloads instead. Because Barclays Bank Delaware issues so many co-branded cards, the outage landed on a lot of accounts at once.

Which cards are affected?

Barclays issues most of the US travel and retail co-branded cards, so the broken feed touches a wide list. The AAdvantage Aviator (American Airlines), JetBlue, Hawaiian Airlines, Wyndham Rewards, Frontier Airlines, Emirates Skywards, Priceline, and Breeze cards all run on the Barclays platform, along with the general Barclaycard View account. If your card statement comes from Barclays Bank Delaware, the same download problem and the same CSV workaround apply.

Why did Barclays stop downloading into QuickBooks?

Barclays changed how it publishes transaction data in 2026, and the connection QuickBooks and Quicken used stopped returning line items. The telltale sign is that the balance still updates while the transaction list stays empty, or the connection errors out right after login. That pattern points to a data feed change at the bank, which is why reconnecting the account or re-entering your password does not bring the transactions back.

How to get a Barclaycard into QuickBooks with a CSV

The manual route skips the feed and gives you a file QuickBooks always accepts. Here is the full sequence.

1. Download the activity as a CSV. Sign in at barclaycardus.com, open the Activity or Statements section for your card, pick the date range or the statement you need, and export it as CSV or a spreadsheet. If only a PDF statement is offered, download that and convert it to a spreadsheet first.

2. Convert the CSV to a .qbo file. Upload the CSV to the Barclays CSV to QBO converter. It reads the date, description, and amount columns, standardizes the dates, and writes a QuickBooks Web Connect file with purchases as negative and payments as positive.

3. Import the .qbo into QuickBooks. In QuickBooks Online, go to Transactions, then Bank transactions, select the Barclays card account, and upload the .qbo. In QuickBooks Desktop, use File, Utilities, Import, Web Connect Files. Review the charges and accept them.

Set the card up as a Credit Card account

Add the Barclaycard as a Credit Card type in QuickBooks, not a bank account. That way purchases raise the balance you owe and payments lower it, which matches how the statement reads. If you set it up as a bank account by mistake, the signs invert and every reconciliation fights you. Getting the account type right before the first import saves a cleanup later.

Why a .qbo beats a raw CSV upload

QuickBooks Online can import a raw CSV, but it caps the file near 350 KB (about a thousand rows) and forces you through a column-mapping screen every time. A converted .qbo carries the mapping inside the file, imports in one step, and is not held to that size limit, so a full year of Barclays history goes in as a single file. QuickBooks Desktop does not accept a raw CSV of card transactions at all, so a .qbo is the only option there.

Some months you will only have the PDF statement to work from, especially for older activity Barclays no longer shows on screen. In that case you can turn the PDF statement into a clean spreadsheet first, then run that CSV through the converter and import the .qbo the same way.

Frequently asked questions

Will Barclays fix the QuickBooks connection?

Barclays may restore a feed later, but there is no committed date, and the direct download format it used before has been retired. Until a working connection returns, the CSV-to-.qbo import is the dependable way to keep your books current. It also gives you an exact copy of what to reconcile against the statement, which the aggregated feed never guaranteed.

Does the converted file cause duplicate transactions?

Only if you import the same date range twice. Import one statement or date range per .qbo and QuickBooks posts each charge once. If you do overlap ranges, QuickBooks flags the repeats during review so you can uncheck them before they post. Keeping each import to a single statement period is the simplest way to avoid duplicates.

Is my Barclays login safe?

Yes, because the converter never sees it. You download the CSV yourself while signed in at Barclays, then upload only that file. The tool reads the date, description, and amount to build the .qbo and asks for no banking credentials. Nothing about the conversion touches your Barclays account directly.

How to reconcile a Barclays card without a live feed

Losing the automatic feed does not mean losing clean reconciliations, it just changes the rhythm. Once each Barclays statement closes, download that statement period as a CSV, convert it to a .qbo, and import the whole period at once. Then run reconciliation in QuickBooks against the same statement, matching the ending balance and date. Because the .qbo carries every charge and payment from that statement, the two figures line up and you clear the reconciliation in one pass. Doing it statement by statement, rather than chasing a daily feed, also keeps duplicates from creeping in, since each period only ever enters your books a single time.

What to do if only a PDF statement is available

For older Barclays activity, the online account may only show a PDF statement rather than an export button. That is still workable. Save the PDF, turn it into a spreadsheet, then run that CSV through the converter exactly as you would a downloaded export. The end result is the same .qbo file QuickBooks imports in one step, so a gap in the online export history does not force you into manual data entry.

For the step-by-step on the conversion itself, see how to convert a CSV to QBO, and if you carry other issuers, the credit card CSV to QuickBooks guide covers the sign rules that keep every card reconciling cleanly.