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.

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, open Transactions, then Bank 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.

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.