Does QuickBooks Online import Amazon settlements natively?

No. QBO sees the Amazon deposit through the bank feed as one number and stops there. Nothing inside QuickBooks splits that deposit into referral fees, FBA fulfilment and storage, Sponsored Products spend, refunds, reimbursements, and the reserve movement. BeanHawk parses the settlement report, posts one balanced journal entry per period, and then you match the deposit against the Amazon clearing account.

How should the Amazon reserve appear in QuickBooks Online?

As an other current asset account, moved by the journal entry each period rather than adjusted by hand. Money Amazon has withheld is still yours, so it sits on the balance sheet until it is released. The test is simple: on any date, the balance in that account should agree with the unavailable balance Amazon shows. When they disagree, the settlement split is wrong, and posting anyway just moves the problem into next month.

Should Amazon deposits be recorded as revenue?

No. A deposit is what is left after Amazon subtracts referral fees, FBA fees, advertising, refunds, and whatever it moved into reserve. Booking the deposit as sales understates revenue and makes every expense Amazon withheld disappear from your profit and loss entirely. Record gross sales, record each fee type separately, and let the deposit clear a balance sheet account.

How do FBA reimbursements get booked?

As other income, paired with an inventory adjustment for the units that were lost or destroyed. Two things happened: Amazon paid you, and stock left your valuation. Only recording the cash leaves phantom inventory on the balance sheet, and recording it as sales revenue inflates a top line that investors and lenders will test against your marketplace reports.

Does QuickBooks Online import marketplace settlements natively?

No. QBO can pull the deposit in through the bank feed, and there are app-store connectors aimed at smaller sellers, but the bank feed only ever sees one net number. Nothing in QBO itself splits a settlement into commission, fulfilment fees, advertising, refunds, reimbursements, and reserve. That split has to be produced from the settlement file before it reaches the ledger.

Should I use a journal entry or individual sales receipts in QuickBooks Online?

Journal entries, once you are past a few hundred orders a month. Sales receipts per order fill the file with transactions QBO has to scan on every report, and performance degrades in a way you cannot undo without a file rebuild. A summarized journal per settlement period keeps reporting fast, and per-SKU detail belongs in a subledger where you can query it properly anyway.

Integrations

Amazon QuickBooks Online integration, reconciled to the penny

BeanHawk turns every Amazon payout into a clean, summarized QuickBooks Online journal: sales, fees, refunds, and taxes mapped to the right accounts, reconciled against the deposit that actually hit your bank.

Why Amazon books break in QuickBooks Online

•Amazon pays in settlements that bundle sales, referral fees, FBA fees, refunds, reserves, and reimbursements into one deposit, so recording deposits as revenue breaks your books.
•Amazon collects marketplace facilitator tax in most states, and it must not be booked as your income.
•FBA inventory events (lost, damaged, reimbursed) need balance-sheet entries that most connectors leave to manual adjustments. BeanHawk posts them automatically.

How the integration works

1
Connect Amazon
Secure, read-only authorization in about 60 seconds. Multiple accounts and marketplaces supported.
2
Connect QuickBooks Online
OAuth connection with professional default account mappings you (or your accountant) can adjust.
3
Review the first journal
BeanHawk parses each payout line by line and builds one summarized journal that must balance to the penny, or it will not post.
4
Reconcile in one click
The net deposit lands in a clearing account that matches your bank feed exactly. Every Amazon payout, accounted for.

Where each Amazon payout line belongs in QuickBooks Online

On the payout	Account	Why it matters
Product charges (principal)	Revenue: product sales	This is your gross sale before Amazon takes anything. If you only book the deposit, revenue is understated by every fee Amazon withheld, and every margin percentage built on that number is wrong.
Referral fee	Cost of sales: marketplace commission	It is charged per order, so it belongs with the sale it came from. Parked in general overhead, it vanishes from contribution margin and you cannot tell which SKUs actually pay for themselves.
FBA fulfilment fee (pick, pack, weight handling)	Cost of sales: fulfilment	It scales with units shipped. Treated as fixed overhead, any per-unit forecast or break-even price you build is off by the largest variable cost you have after product cost.
Monthly and long-term FBA storage fees	Operating expense: inventory storage	Storage tracks how long stock sits, not how much you sold. Mixed in with fulfilment fees, aging inventory stops being visible right up until the long-term fee lands.
Refunds: principal returned to the buyer	Contra-revenue: refunds and returns	Netting refunds straight against sales erases your return rate. Return rate is usually the first number that tells you a listing, a size chart, or a supplier has gone wrong.
Refund commission and administrative fee retained by Amazon	Cost of sales: marketplace commission	Amazon refunds most of the referral fee but keeps a slice. Booking the whole thing as a refund of revenue overstates the credit and quietly understates your true commission cost.
FBA inventory reimbursements for lost or damaged units	Other income: reimbursements, with an offsetting inventory adjustment	A reimbursement is not a sale. Counted as revenue it inflates the top line, and without the inventory offset your on-hand valuation still carries units that no longer exist.
Reserved or unavailable balance movement	Balance sheet: Amazon reserve (asset)	Reserve is money you have earned and cannot touch yet. Ignore it and the settlement total will never tie to the deposit, which is the single most common reason an Amazon clearing account refuses to go to zero.
Marketplace facilitator tax collected and remitted by Amazon	Pass-through tax account that nets to zero	Amazon collects it and Amazon remits it. Sitting in revenue it overstates income, and any state filing or tax estimate built off the profit and loss inherits the error.
Sponsored Products and other advertising charged inside the settlement	Operating expense: advertising	Ad spend is deducted before the deposit lands, so a seller who only looks at the bank line never sees it at all. That makes advertising look free and makes ACoS impossible to check against the books.

How a month actually closes on Amazon

Amazon closes a settlement period and deposits the net. Periods run roughly every two weeks but the boundaries move, and they almost never line up with a calendar month. Closing a month starts with pulling every settlement report whose date range touches that month, not the ones whose deposits landed in it.

When a settlement straddles month end, split it by transaction posting date rather than deposit date. That means two summarized journals from one settlement file, one for each month, and the two of them together have to add back to the settlement total exactly. Deposit-date accounting is faster and it will misstate both months, which matters more the closer you get to a year end or a due diligence request.

Everything routes through an Amazon clearing account. The journal debits clearing for the net earned, and the deposit credits it when the cash arrives. Whatever is left in clearing at month end should be the amount Amazon owes you but has not paid: the open period plus reserve. If that balance is a number you cannot explain, the journal is wrong, not the bank.

Reserve is where most reconciliations fail. The unavailable balance moves between periods, and if it is not carried on the balance sheet the settlement math stops working even though every fee line was mapped correctly. Compare the reserve account balance to the account-level balance Amazon shows on the same date, and investigate the gap before you post rather than after.

Sellers running multiple regions or multiple accounts need separate clearing accounts per marketplace and per currency. Convert at whatever rate your policy specifies, then let the difference between the booked rate and the rate you actually received land in a realised foreign exchange account when the payout hits. Pooling Europe and North America into one clearing account is a reconciliation you will not win.

The last check before posting is arithmetic: gross sales, minus fees, minus refunds, plus reimbursements, plus or minus the reserve movement, should equal the deposit to the penny. BeanHawk refuses to post a journal that fails this test. A journal that balances but does not foot to the settlement is worse than no journal, because it looks finished.

What QuickBooks Online does well, and where it needs help

BeanHawk posts into QuickBooks Online as a summarized Journal Entry per settlement period rather than as individual sales receipts. A QBO journal entry carries one date and has to balance to the penny, so we date it at the period end, put the settlement identifier in the memo, and keep SKU-level detail in our own subledger. That keeps QBO fast and keeps an auditor able to trace any number back to a source document.

The step people get wrong is the bank feed. When the marketplace deposit appears in QBO, it must be matched to the entry already sitting in the clearing account, never added. Clicking Add creates a second income transaction and doubles revenue for that deposit. If your revenue looks roughly twice what you expect, this is almost always the cause, and the fix is to find the added transactions and undo them rather than to adjust the journal.

Class and location tracking, which is how most sellers separate channels inside one company file, is available on the higher QuickBooks Online plans rather than every plan, and Intuit has changed plan naming and inclusions over time. Check what your current subscription includes. If classes are not available to you, the workable alternative is a separate set of income and fee accounts per channel: uglier in the chart of accounts, but it works on any plan and it reports cleanly.

QuickBooks Online's built-in inventory uses FIFO and has no native landed cost handling, so freight, duty, and prep costs cannot be pushed into unit cost inside QBO itself. High-volume sellers usually stop fighting this and keep perpetual SKU valuation in a subledger, posting a periodic inventory and cost of goods sold journal instead. That is the approach BeanHawk takes, which is also why our journals stay small enough for QBO to handle at scale.

Automated Sales Tax in QBO is built for tax you collect and owe. Marketplace facilitator tax is neither, so routing it through the sales tax module invites QBO to include it in a liability you do not have. Send facilitator tax to a pass-through account that nets to zero within the same journal, and keep your own nexus tax, if any, in the sales tax module where it belongs.

One reporting quirk worth knowing before you panic: journal entries are accrual transactions, so a cash-basis profit and loss in QBO can present summarized marketplace journals in ways that look wrong at first glance. Run the accrual view when checking a settlement, and reconcile the clearing account rather than reading the bank balance, since the clearing account is where the timing difference is supposed to live.

Frequently asked questions

Does QuickBooks Online import Amazon settlements natively?: No. QBO sees the Amazon deposit through the bank feed as one number and stops there. Nothing inside QuickBooks splits that deposit into referral fees, FBA fulfilment and storage, Sponsored Products spend, refunds, reimbursements, and the reserve movement. BeanHawk parses the settlement report, posts one balanced journal entry per period, and then you match the deposit against the Amazon clearing account.
How should the Amazon reserve appear in QuickBooks Online?: As an other current asset account, moved by the journal entry each period rather than adjusted by hand. Money Amazon has withheld is still yours, so it sits on the balance sheet until it is released. The test is simple: on any date, the balance in that account should agree with the unavailable balance Amazon shows. When they disagree, the settlement split is wrong, and posting anyway just moves the problem into next month.
Should Amazon deposits be recorded as revenue?: No. A deposit is what is left after Amazon subtracts referral fees, FBA fees, advertising, refunds, and whatever it moved into reserve. Booking the deposit as sales understates revenue and makes every expense Amazon withheld disappear from your profit and loss entirely. Record gross sales, record each fee type separately, and let the deposit clear a balance sheet account.
How do FBA reimbursements get booked?: As other income, paired with an inventory adjustment for the units that were lost or destroyed. Two things happened: Amazon paid you, and stock left your valuation. Only recording the cash leaves phantom inventory on the balance sheet, and recording it as sales revenue inflates a top line that investors and lenders will test against your marketplace reports.
Does QuickBooks Online import marketplace settlements natively?: No. QBO can pull the deposit in through the bank feed, and there are app-store connectors aimed at smaller sellers, but the bank feed only ever sees one net number. Nothing in QBO itself splits a settlement into commission, fulfilment fees, advertising, refunds, reimbursements, and reserve. That split has to be produced from the settlement file before it reaches the ledger.
Should I use a journal entry or individual sales receipts in QuickBooks Online?: Journal entries, once you are past a few hundred orders a month. Sales receipts per order fill the file with transactions QBO has to scan on every report, and performance degrades in a way you cannot undo without a file rebuild. A summarized journal per settlement period keeps reporting fast, and per-SKU detail belongs in a subledger where you can query it properly anyway.

Connect Amazon to QuickBooks Online free

Start with the free reimbursement audit, then flat all-channel pricing from $19/mo. No per-channel fees.

Also see: Amazon + Xero · eBay + QuickBooks Online · eBay + Xero · Shopify + QuickBooks Online · all guides