How to import an Amazon settlement report into QuickBooks Online

Amazon's settlement report can't be dropped into QBO like a bank feed. Here's why a settlement deposit needs a balanced journal entry instead of a transaction list, how to build one by hand, and the one-click shortcut if you'd rather skip it.

Why a bank-import CSV doesn't work for a settlement

QuickBooks Online's bank-import tool expects a flat list of Date, Description, Amount rows — fine for a PayPal or Shopify payout, where money mostly just moves in or out. An Amazon settlement is different: one deposit is really dozens of things netted together - product sales, shipping income, referral fees, FBA fulfillment fees, storage fees, refunds, sometimes a reserve holdback - and treating the lump sum as one "Sales income" line hides every fee as if it never happened. Getting this right means a balanced double-entry journal entry that splits the deposit back into its real pieces, not a transaction list.

Option 1: Build the journal entry by hand

Free, but easy to get wrong — and QBO won't tell you if it's wrong.

  1. In Seller Central, go to Reports → Payments → Date Range Reports and download the Settlement Report (Flat File) for the settlement period you're booking.
  2. Every row carries an amount-type and amount-description pair (e.g. "ItemPrice / Principal", "ItemFees / Commission") - that pair tells you which account the line belongs to.
  3. Credit Sales Income for every "ItemPrice / Principal" line (your product sales) and Shipping Income for every "ItemPrice / Shipping" line.
  4. Debit Amazon Selling Fees: Referral Fees for every "Commission" line - this is Amazon's cut of the sale.
  5. Debit Amazon Selling Fees: FBA Fulfillment Fees for every "FBAPerUnitFulfillmentFee" or "FBAWeightBasedFee" line.
  6. Debit Amazon Selling Fees: Subscription & Storage Fees for monthly subscription and storage fee lines.
  7. For a refund: debit Sales Income for the refunded "Principal" amount (it's negative in the report, reducing revenue) and credit Referral Fees for any "RefundCommission" line (Amazon gives back its cut too).
  8. Every line above should also hit a clearing account (call it "Amazon Clearing Account") on the opposite side - that's what makes the entry balance, and its net movement should equal the settlement's actual deposit.
  9. Add up every line item's amount and confirm it matches the settlement report's own reported total-amount (the real deposit) - if it doesn't, a row was missed or mis-copied.
  10. Before saving, add up every debit and every credit column separately. If they don't match to the penny, the entry is wrong — QuickBooks will let you save an unbalanced journal entry without warning you.
  11. In QuickBooks Online, go to + New → Journal Entry (or bulk-import via Settings → Import Data → Journal Entries on Advanced) and enter the lines above.

Option 2: Skip the manual math

Web App

Amazon to QuickBooks

Drop in your Amazon Settlement Report export, get back a QuickBooks-ready journal entry CSV — sales, referral fees, FBA fees, storage fees, and refunds split into their real accounts and balanced automatically, cross-checked against the report's own deposit total. Refuses to output an entry that doesn't balance.

Free sample · from $9
Try it

Changed your mind? How to undo an import

Our apps never touch your QuickBooks file, and your original export is never changed. This export converts into journal entries, which become real entries in your books once you import them. To take them back out of QuickBooks Online:

  1. Find the journal entries the import created: open the Journal report for the dates you imported, or search for journal entries in that date range.
  2. Open each entry and choose More → Delete at the bottom of the screen.
  3. If you work in QuickBooks Online Accountant, you can remove many entries at once with its batch delete/void tool instead.
  4. Fix whatever needed fixing, convert your original export again, and re-import.

Tip: run the Journal report again afterward to confirm nothing from that batch is left.

Frequently asked questions

Can I import an Amazon settlement report the same way as a bank export?
Not accurately. A bank import is a flat transaction list; a settlement bundles sales, fees, and refunds into one deposit that needs a balanced double-entry journal entry to book correctly, which a bank-import CSV can't represent.

Which QuickBooks Online plan can bulk-import journal entries from a CSV?
Only QuickBooks Online Advanced has a native journal-entry CSV importer. Other tiers need manual entry or a third-party importer like Transaction Pro or SaasAnt.

What accounts does an Amazon settlement journal entry debit and credit?
Sales and shipping income are credited as revenue; referral fees, FBA fees, and storage/subscription fees are debited as expenses; refunds reverse the matching revenue. Every line balances against a clearing account tied to the real deposit.

How do I know if my journal entry is right?
The line items should sum to the settlement's own reported deposit total, and total debits must equal total credits for the whole entry — QuickBooks won't warn you if either is off.

Convert other exports

← Back to DigitalBuilds.org