Synchrony CSV to QuickBooks: Import Store Card Transactions

Short answer: Synchrony cards do not support QuickBooks Direct Connect, and many no longer offer a .qbo download, so the reliable way to book them is to export your activity as a CSV, convert it to a .qbo Web Connect file, and import that into QuickBooks. QuickBooks Desktop has no native CSV transaction import, and the aggregated feed for Synchrony cards drops often, which is why a converted file is the method that holds up month to month. The Synchrony CSV to QBO converter does the conversion in your browser, and the comparison of CSV to QBO converters covers how the paid alternatives differ.

Synchrony is the bank behind a huge share of the store and co-branded cards US businesses use to buy inventory, materials, and supplies: the Amazon Store Card, Lowe's, Sam's Club Mastercard, PayPal Credit, Venmo Credit Card, CareCredit, and many retail cards. Because they run on Synchrony's platform rather than a normal bank feed, they behave differently in QuickBooks, and that is the source of most of the import headaches bookkeepers hit with them.

Does Synchrony connect to QuickBooks automatically?

No, not through Direct Connect. Synchrony does not support OFX Direct Connect, so QuickBooks cannot pull its transactions automatically the way it can from a bank with a live two-way feed. Some Synchrony cards can be linked through Intuit's Express Web Connect aggregation, but those links routinely disconnect, duplicate charges, or miss pending transactions. If you have fought a Synchrony card connection in QuickBooks, you were hitting that limitation rather than doing anything wrong.

How do I export Synchrony card transactions to a CSV?

Sign in to the account site for your specific card. Synchrony services each card under its own portal, so the Amazon Store Card, Lowe's, Sam's Club, and CareCredit each have their own login, but the steps are the same. Open the Activity or Statements area, set the date range or pick a billing statement, and choose the download or export option. Select CSV or spreadsheet if it is offered. Some redesigned card sites only show CSV, Excel, or PDF now, and any of those can be turned into the file QuickBooks needs.

Can QuickBooks import a Synchrony CSV directly?

QuickBooks Online can import a CSV only when it matches a strict layout: a date column, a description column, and either one signed amount column or separate credit and debit columns. Synchrony exports rarely match that layout out of the box, so a raw upload either fails or maps the columns wrong. QuickBooks Desktop cannot import a transaction CSV at all. Converting the CSV to a .qbo removes both problems, because a .qbo carries the fields and account tags QuickBooks reads without any mapping.

How do I convert a Synchrony CSV to a .qbo file?

Upload the CSV to the converter, confirm the tool found the date, description, and amount columns in the preview, and download the .qbo. The converter normalizes the dates, strips dollar signs, and totals every row so you can check it against your statement before you export. Purchases come through as negative and payments as positive, the standard credit card convention, so the balance lines up with what Synchrony shows.

How do I import the Synchrony .qbo into QuickBooks?

In QuickBooks Online, go to All apps, then Accounting, then Bank transactions (on accounts still on the older layout the same screen sits under Transactions), pick the matching Synchrony card account, and upload the .qbo file. In QuickBooks Desktop, go to File, then Utilities, then Import, then Web Connect Files, and choose the .qbo. QuickBooks reads the transactions for review and posts them once you accept. Because it is a Web Connect file, you never see the column-matching screen a raw CSV forces on you.

Does this work for the Amazon Store Card and Sam's Club?

Yes. The Amazon Store Card, Amazon Business Prime cards, Sam's Club Mastercard, Lowe's Business, PayPal Credit, Venmo Credit Card, and CareCredit are all serviced by Synchrony and export activity as a CSV. Each converts to a .qbo the same way and imports into its matching credit card account in QuickBooks. If you carry several of these cards, keeping their purchase records clean matters for reimbursing projects and matching charges back to what you bought, and a tidy import feeds straight into whatever system you use to track purchasing.

Why are some Synchrony charges missing after import?

Missing charges almost always come from the aggregated feed, which can skip pending transactions or stop updating without warning. When you export the CSV yourself for a set date range, you get every posted transaction in that window, so nothing is silently left out. If you spot a gap, widen the date range on the Synchrony export, reconvert, and reimport; duplicates are caught during QuickBooks review before they post.

What if my Synchrony card only gives me a PDF?

Some Synchrony retail cards only offer a PDF statement on the redesigned site. In that case, turn the PDF into a spreadsheet first, then convert that spreadsheet here. The rest of the process is identical: check the parsed total against the statement, download the .qbo, and import it into the matching account. A converted file reconciles the same whether it started as a CSV or a PDF you turned into rows.

How far back can I import Synchrony transactions?

A live QuickBooks feed usually reaches back only about 90 days, but Synchrony keeps statements online much longer, and you can select a custom date range or older statements when you export. That makes converting the reliable way to backfill months or a full prior year that no feed can reach. Bring in the older CSV, convert it, and import the .qbo to fill the gap without hand-entering anything.

Is a Synchrony card a bank account or a credit card in QuickBooks?

Set up each Synchrony card as a Credit Card type account in QuickBooks, not a bank account. That way purchases increase the balance you owe and payments reduce it, and the account nets against your statement correctly. If a Synchrony account was mistakenly created as a bank type, the signs will look inverted on every import. Fix the type or recreate the account as a credit card before you import the converted .qbo, so the charges and payments post the right way.

Will importing a Synchrony CSV create duplicate transactions in QuickBooks?

Not if you import the converted .qbo rather than the raw CSV. Every OFX and .qbo transaction carries a FITID that is unique within the account, and QuickBooks skips any FITID it has already accepted. A plain CSV carries no transaction identifier at all, so QuickBooks has nothing to compare and a repeated CSV upload duplicates every row silently.

One caveat that surprises people: QuickBooks remembers a FITID even after you delete the transaction, so re-importing the same file to restore a row you deleted by mistake will not bring it back. Re-enter that row manually instead. The same memory is what makes overlapping .qbo files safe, as long as both came from the same converter and the same account.

Why did my Synchrony bank feed stop working in QuickBooks?

Synchrony cards reach QuickBooks through an aggregated Express Web Connect style feed rather than Direct Connect, and that feed refreshes on Intuit's schedule, roughly every 24 hours. When it breaks, the error code tells you whether the problem is fixable at your end or whether you are waiting on someone else.

None of these are worth waiting out at month end. Downloading the CSV and converting it takes a couple of minutes and produces a file with proper transaction identifiers, which is a more durable record than a feed that may or may not backfill what it missed.

How do I record Synchrony promotional financing in QuickBooks?

Record the purchase at full price on the card account when it happens, exactly like any other charge. Deferred interest promotions do not change the cost of the item, so nothing extra posts at purchase. Interest becomes a real transaction only when Synchrony actually charges it, and then it posts as interest expense against the card, not as an adjustment to the original purchase.

The practical risk is the promotion expiring unnoticed. If deferred interest is charged retroactively it can arrive as one large line covering the whole promotional period, which looks wrong next to a small monthly statement and is easy to miscategorize as a fee or a correction. Import the statement activity every month rather than in an annual catch up and that line shows up when you can still recognize it.

How do I reconcile a Synchrony card in QuickBooks?

Reconcile to the statement, not to the portal balance. Enter the statement ending date and ending balance from the PDF statement, then clear the imported transactions until the difference is zero. Portal balances include pending authorizations that are not on the statement yet, which is why reconciling against the live balance almost never comes out clean.

What date format should a Synchrony CSV use for QuickBooks?

MM/DD/YYYY for a US company file. The trap is that the Intuit CSV formatting article most people find is the global edition, which recommends DD/MM/YYYY. Apply that to a US file and every charge dated on or before the twelfth of a month lands in the wrong month, while anything after the twelfth simply fails to import.

Opening the CSV in Excel introduces a second problem. Excel rewrites two digit years, turning 00 to 29 into 2000 to 2029 and 30 to 99 into 1930 to 1999, and a file that has moved between Windows and Mac shifts by four years and a day because the two default to different date systems. Convert the download as the portal wrote it and neither issue arises.

For the full walkthrough and the tool, use the Synchrony CSV to QBO converter. To handle other issuers, see the American Express CSV to QBO converter and the Discover CSV to QBO converter, learn the sign rules in the credit card CSV to QuickBooks guide, and follow the steps to import a QBO file into QuickBooks.