If you carry the Amazon Store Card, your statement comes from Synchrony Bank, and learning to convert Amazon Synchrony bank statement PDF to CSV is the fastest way to get those purchases into QuickBooks Online without retyping them. The card is handy at checkout, but its monthly statement is a PDF full of Amazon orders, payments, interest charges, and promotional financing lines — exactly the kind of file that eats an evening if you enter it by hand.
This guide walks through the whole job: downloading the right statement, turning it into a clean CSV, cleaning up the rows that confuse QuickBooks, and importing the result as a credit card account. By the end, a month of Amazon spending becomes a reconciled QuickBooks account instead of a pile of PDFs.
Where to download your Amazon Synchrony statement
Start in your Synchrony account rather than in your Amazon order history. Amazon shows what you bought, but only the Synchrony statement shows the account activity QuickBooks needs: the statement period, the opening and closing balances, every charge and payment, interest, and fees. Sign in to your Synchrony account, open the Amazon Store Card account, and download the monthly statement as a PDF.
Download the official monthly statement, not a custom activity printout. The monthly statement is the document of record, with page totals that let you check your work later. If you hold more than one Synchrony retail card, double-check you picked the Amazon card — importing the wrong card into the wrong QuickBooks account is a classic month-end headache. Save the PDF with a clear name, such as amazon-store-card-2026-09.pdf, so you can find it at tax time.
Converting the PDF to a QuickBooks-ready CSV
A converter reads the statement's transaction table and rebuilds it as rows with Date, Description, and Amount columns. Upload the PDF, choose CSV as the output, and check the preview before downloading: every charge should be one row, payments should carry the opposite sign to charges, and the row count should roughly match the number of transactions printed on the statement.
Two details matter more than anything else here. First, keep the date format consistent — QuickBooks expects one format for the whole file, so convert any month-day-year mix-ups before import. Second, strip currency symbols and commas from amounts. A cell that reads $1,234.56 looks fine to a human but can fail a QuickBooks import or, worse, import as text that never adds up. Our Amazon Synchrony conversion guide covers the statement layout in more detail.
Cleaning up promotional financing, interest, and returns
Synchrony statements have quirks that plain bank statements do not. Promotional purchases — the 6- or 12-month special financing offers — appear as charges when you buy, and interest may be deferred rather than charged immediately. Do not delete those rows: they are real account activity. Instead, give them clear descriptions, such as Promotional purchase — appliance, so you can track when the promotional period ends. Deferred interest that later posts is a real expense when it posts, not when you bought the item.
Returns need the same care. An Amazon return posts as a credit, sometimes weeks after the original charge and sometimes split across two credits. Match each credit to its original charge in the description rather than deleting it, or your spending totals will overstate what you actually kept. Payments from your checking account are transfers, not expenses — record them as payments to the card account in QuickBooks, never as new spending. For a similar card-import walkthrough, see our TD Bank conversion guide, which covers the same upload flow.
Importing the CSV into QuickBooks Online
In QuickBooks Online, open Banking, then Bank transactions, then Upload from file, and select the credit card account for your Amazon Store Card — not your checking account. Map Date to Date, Description to Description, and Amount to Amount, then study the preview. QuickBooks shows you exactly what it understood before anything lands in your books, so scan for text in amount cells, swapped dates, or a payment that imported as a charge.
Import one month at a time, oldest to newest, and reconcile each month before importing the next. If a month refuses to import, the cause is almost always a formatting slip: a header row, a dollar sign, or a blank line at the end of the file. Fix the file and re-upload; the preview step means you can iterate without polluting your books. QuickBooks will try to match payments to the transfer from your checking account — accept the match only when the amount and date agree.
Reconciling and avoiding double-counted spending
Once imported, reconcile the card account against the statement: the QuickBooks ending balance should equal the statement's closing balance to the penny. If it does not, the difference is usually one of three things: a return you categorized as a new purchase, a payment recorded twice, or a promotional charge whose date fell in the next statement period. Hunt the difference down now — a small gap this month becomes a mystery balance by year end.
The other trap is importing the same month twice. Never run both a bank feed and a file import for the same card account, and never re-upload a corrected file without first deleting the earlier import from the For review tab. Our PNC conversion guide explains the same one-import-path rule for bank accounts. A monthly routine — download, convert, clean, import, reconcile — takes about twenty minutes and keeps the card account trustworthy all year.
Frequently asked questions
Is my Amazon Store Card statement the same as my Amazon order history?
No. Order history shows purchases; the Synchrony statement shows account activity — charges, payments, interest, fees, and balances. QuickBooks needs the statement, because only it proves what you owe and what you paid.
Can I import the CSV straight into QuickBooks?
Yes, through Banking and Upload from file, mapped into the credit card account for the Amazon Store Card. Preview the rows before importing, and reconcile against the statement balance afterward.
How do I handle a promotional financing purchase?
Keep the charge row, label it clearly as a promotional purchase, and watch for deferred interest posting when the promotional period ends. Do not delete the row or treat the purchase as free.
What if my statement is password protected?
Enter the password at conversion time. The file is unlocked only to read its transaction table, and you should keep the password handy before you start so the job is not interrupted.
A month of Amazon card spending should take minutes, not an evening. Convert your Amazon Synchrony statement to a QuickBooks-ready CSV and import the whole month in one clean pass.