How to Do Accounting for Amazon Settlement Reports Without Booking the Deposit as Revenue

An Amazon settlement deposit is the single most misread number in ecommerce bookkeeping. Money lands in the bank, the amount looks like sales, and it gets categorised as revenue. That one entry is wrong, it is extremely common, and it quietly destroys the usefulness of every report the business produces afterwards.

The deposit is a net figure. Sitting inside it are gross product sales, shipping credits, promotional rebates, customer refunds, referral fees, fulfilment fees, storage fees, advertising spend, your selling plan subscription and any reimbursements Amazon owed you. Book the deposit as revenue and you have understated your sales, erased every expense that was netted out of it, and produced a profit and loss statement where the top line is smaller than reality and the cost lines are missing entirely. Gross margin becomes meaningless. So does any decision you make from it.

This post shows the correct treatment with a worked settlement, a balanced journal entry you can check with a calculator, the chart of accounts the entry needs, how to handle a settlement that straddles a month end, and how to decide between doing it by hand and paying for a connector. It is written for QuickBooks Online because that is what most sellers land on, but the accounting logic is identical in any double entry ledger.

This is general information about bookkeeping practice, not tax or accounting advice. Confirm the treatment of anything here with your own accountant before you rely on it, because facts specific to your business change answers.

A note on how this site is paid: the QuickBooks links in this post are monetised affiliate links and Intuit pays us if you buy through one. Several other tools named below run through our redirects too, and the arrangements differ. The Synder and Finaloop links are also monetised and pay us. The A2X link is a plain link to that company with no tracking on it, so we earn nothing when you click it. Link My Books is linked directly to its own site because we have no arrangement with it at all. The Shopify, Bizee and Hiscox links in the closing section are affiliate links too and they pay us.

What the deposit actually is

Amazon does not pay you per order. It runs a settlement period, totals everything that happened inside it, subtracts what you owe, and transfers the remainder. The report behind that transfer is the settlement report, and it is the source document for your books. The bank statement is not the source document. The bank statement is the last line of the settlement report and nothing else.

Amazon’s own help hub at Seller Central is disallowed to automated readers by its robots file, so I could not fetch and quote Amazon’s own definitions of each transaction type this session. I am not going to print a settlement cadence, a fee schedule or a reserve policy I could not verify against Amazon’s documentation. What I can tell you is how to treat the categories once you have them in front of you, and you should open your own settlement report and read the actual line names off it rather than trusting any blog’s list, this one included.

Two Amazon figures I could verify on Amazon’s public seller pricing page: the Professional selling plan is listed at $39.99 a month and the Individual plan at $0.99 per item sold, and referral fees are stated as varying by category across a range running from 5 percent to 45 percent. Those are published numbers. Anything more granular belongs to your own account.

The wrong entry, and why so many sellers make it

The wrong entry happens because of how bank feeds work. A deposit appears in the QuickBooks banking screen. QuickBooks suggests a category. The suggestion is usually an income account, because deposits are usually income. You accept it, the transaction disappears from the review queue, and the books look done.

They are not done. They are now missing every expense Amazon netted out before paying you. If Amazon takes referral fees, fulfilment fees and advertising out of the gross before the transfer, and you never record those as expenses, then those costs exist nowhere in your ledger. Your profit and loss statement will show a lower revenue figure and a lower expense figure that happen to arrive at roughly the right net profit, which is exactly why the error survives for months. The bottom line looks plausible. Everything above it is wrong.

The damage shows up in three places. You cannot calculate a real gross margin, because your sales figure is net of costs that are not cost of goods sold. You cannot see whether advertising is working, because ad spend is invisible. And at tax time your revenue figure will not agree with the amount reported to the IRS on your Form 1099-K, which brings us to a genuinely useful verified fact further down this post.

A worked settlement, with the arithmetic shown

Here is a settlement I have constructed to demonstrate the treatment. These are illustrative figures I chose, not data from any real seller account, and yours will look different. The point is the structure and the fact that it balances.

Add the three positives and you get $31,439.99. Add the seven negatives and you get $13,439.99. Subtract and you land on the $18,000.00 that hit the bank. That is the whole trick: the deposit is an output, not an input.

Now look at what booking $18,000 as revenue does. Your true gross sales were $31,200 before returns and rebates, and $29,000 after them. Recording $18,000 understates the top line by $11,000 against net sales, hides $11,239.99 of real operating expense, and loses $239.99 of other income. Nothing in that sentence is a rounding difference.

The correct entry, and it must balance

The settlement becomes one journal entry, not one deposit. Every line on the report gets its own account, and the bank line is just one debit among many. Here is the same settlement expressed as a journal entry.

Both columns come to $31,439.99. If yours do not balance, you have missed a line on the settlement report, and the difference is the size of the line you missed. That is the built in check, and it is the reason to do this as a journal entry rather than as a categorised bank deposit: a deposit cannot fail to balance, so it cannot tell you anything is wrong.

Notice what is absent from that entry. Cost of goods sold is not there. The units you sold were bought at some earlier point and their cost is either sitting in inventory or already expensed, depending on how you handle stock. The settlement report tells you what Amazon charged you, not what your goods cost you. Those are two different journeys and mixing them is the second most common error in this area, right behind booking the deposit as revenue. If you are still deciding how to structure the accounts underneath all of this, the sequencing matters and I walk through it in the guide to setting up QuickBooks for an ecommerce store in the order that prevents rework.

Where each line goes in your chart of accounts

You need roughly a dozen accounts and no more. Resist the urge to build one account per Amazon transaction type, because the settlement report has dozens and most of them are pennies.

The sales tax row deserves a warning. In most US states Amazon collects and remits marketplace facilitator tax on your behalf, and in that case the tax never becomes your liability and should not sit on your balance sheet as one. In situations where it does flow through to you, it is a liability and never income. Which of those applies to you depends on your states, your registrations and the marketplace rules in force, and it is precisely the sort of question to put to a CPA rather than to a blog post. Do not guess it.

The settlement that straddles a month end

Settlement periods do not respect calendar months. A period running from the last week of one month into the first week of the next produces a single deposit containing sales from both, and if you post the whole thing on the deposit date you have pushed part of one month’s revenue into the following month.

At low volume, nobody cares. At any volume where you are actually reading your monthly reports, it matters, because a September that borrowed four days of October sales is not a September you can compare to anything.

The fix is a clearing account and a split. Create a current asset account called something like Amazon Clearing. Post the settlement activity in two journal entries, one dated the last day of the earlier month covering the transactions that fall in it, and one dated inside the later month for the rest, with the balancing side going to Amazon Clearing rather than to the bank. Then, when the deposit lands, debit the bank and credit Amazon Clearing for the full transfer amount.

Done correctly, Amazon Clearing goes to zero after the deposit posts. If it does not, the residue is money Amazon owes you that has not yet moved, which is exactly what a receivable should look like on your balance sheet at month end. That balance is a feature. It is also a very good early warning that something has gone unrecorded, because a clearing account that never returns to zero is a clearing account with a missing entry in it.

Why your revenue will never match your Form 1099-K

This one is verified and it is worth knowing before your accountant raises it. The IRS instructions for Form 1099-K define the gross amount in Box 1a as the total dollar amount of reportable payment transactions “without regard to any adjustments for credits, cash equivalents, discount amounts, fees, refunded amounts, shipping amounts, or any other amounts”.

Read that carefully. The figure reported to the IRS is not reduced by fees. It is not reduced by refunds. It is not reduced by discounts. So the number on your 1099-K will be materially larger than the deposits you received and will not equal any single line in your books unless you have recorded the settlement gross, exactly as described above. A seller who booked net deposits as revenue is going to have a revenue figure far below the 1099-K, which is an unpleasant conversation to have in April.

The IRS also states on its own page that you should use Form 1099-K with your other records to figure and report your taxable income. It does not say the form is your revenue figure. Your books are your revenue figure, and the reconciliation between the two is a normal part of a return. How the whole filing sequence fits together is covered in the walkthrough on filing taxes as an ecommerce seller step by step, and none of this replaces advice from your own tax professional.

By hand, or pay a connector to do it

Everything above can be done manually. Download the settlement report, summarise it, key one journal entry, reconcile. At two settlements a month that is perhaps thirty minutes of work each if your accounts are already set up and you are comfortable with journal entries. At higher volume, or across several marketplaces, it stops being thirty minutes and starts being an afternoon.

The alternative is a settlement connector. These tools read the settlement report, produce the summarised journal entry, and post it into your ledger with the clearing account handled for you. They do not replace an accountant and they do not fix a wrong chart of accounts, but they remove the keying and the arithmetic, which is where errors come from.

A2X publishes the cleanest price ladder of the four, and the Amazon tiers run $29 for up to 200 orders a month, $59 for 1,000, $79 for 5,000 and $159 for 10,000, with published steps continuing up to $1,499 for 250,000 orders. Those were read from A2X’s own Amazon pricing page. Synder’s ladder runs $65, $129, $299 and $599 a month, with annual equivalents of $52, $103, $240 and $480, and the transaction ceilings attached are 500, 3,000, 20,000 and 40,000. Link My Books does not publish a static tier list at all, and I am not going to invent one from a calculator I did not run.

The honest test for whether a connector earns its keep is simple arithmetic. A2X Mini at $29 a month is $348 a year. If keying settlements by hand takes you two hours a month, that is 24 hours a year, and $348 divided by 24 is $14.50 an hour. If your time is worth more than that, and it almost certainly is, the connector pays for itself before you count the errors it prevents. At the top of the ladder that maths reverses, because $1,499 a month is $17,988 a year and at that volume you have a bookkeeper anyway.

Which QuickBooks plan this actually needs

The journal entry above works on every QuickBooks Online tier, including Simple Start at $38 a month. Journal entries are not a gated feature. What is gated is inventory tracking, which Intuit’s inventory page places on Plus and Advanced only, so an FBA seller who carries stock and wants QuickBooks to value it is looking at $140 a month at list, which is $1,470 in year one with the three month discount and $1,680 a year after that.

That is a meaningful gap against Simple Start at $456 a year in steady state, and it is worth being deliberate about. Plenty of sellers track units in a spreadsheet or in their operations tool and use the ledger purely for financial reporting, in which case Simple Start does the job described in this post perfectly well. Plenty of others want one system of record. Both are defensible. What is not defensible is paying $1,680 a year for inventory tracking you never open, and I have costed every tier both ways in the full breakdown of QuickBooks pricing for year one and year two.

If you sell on more than one channel, the ranking changes again, because the connector ecosystem matters more than the feature list. That comparison is in the guide to the best accounting software for ecommerce ranked by where inventory starts.

What I could not verify for this post

Being straight about the gaps. Amazon Seller Central’s help hub is disallowed by robots to automated fetches, so no Amazon help documentation is quoted here and no settlement cadence, reserve policy or fee schedule is printed from it. The two Amazon figures I do quote, the $39.99 Professional plan and the $0.99 per item Individual plan along with the 5 percent to 45 percent referral fee range, come from Amazon’s public seller pricing page and nowhere else.

Link My Books does not publish static plan prices, so none appear here. Finaloop’s pricing was not published on the page I could reach, so none appears here either. QuickBooks does not publish payment processing rates anywhere I could find, and I am not quoting one. Every QuickBooks price in this post was read from Intuit’s own pricing page in this session.

Running the business behind the books

Correct settlement accounting tells you the truth about a business. It does not make the business better. If your gross margin after referral fees, fulfilment and advertising is thin, the ledger will now show you that clearly, and the answer is upstream in what you sell rather than downstream in how you record it.

If you are choosing what to sell, start from the list of profitable high ticket niches and look for categories where one order covers a month of software and fees.

The reason a higher average order value changes every number in this post is worth understanding before you commit to a category, and I set it out in the explanation of how the high ticket dropshipping model works.

Your margin is decided at the supplier conversation more than anywhere else, so work through the complete step by step supplier sourcing guide before you accept a first price list.

Get the entity right early, because it decides how these books are structured and what your accountant needs at year end. The walkthrough is in my guide to business formation for high ticket dropshipping.

For the stack, Shopify runs the storefront alongside the marketplace because its connector ecosystem into accounting tools is the deepest available. Company formation and registered agent filings go through Bizee.

General liability cover comes from Hiscox, which suppliers often ask to see before they open a dealer account.

Frequently Asked Questions

Can I just categorise the Amazon deposit in the bank feed and move on? You can, and it will be wrong. The deposit is net of fees, refunds and advertising, so categorising it as income understates revenue and omits every expense Amazon subtracted. Use a journal entry that balances instead.

Do I need a separate journal entry for every settlement? One per settlement is the clean approach because it matches the source document. If a settlement straddles a month end, split it into two entries at the month boundary and route the balancing side through a clearing account.

Where does cost of goods sold fit in? Not in this entry. The settlement report tells you what Amazon charged you, not what your goods cost. Cost of goods sold comes from your inventory records or your supplier invoices and is recorded separately.

Why is my Form 1099-K bigger than my sales? Because the IRS instructions define the Box 1a gross amount as reported without regard to adjustments for fees, refunds, discounts or shipping. It is a gross figure by design. Your books should reconcile to it, not equal it. Ask your accountant how to present that reconciliation.

Does QuickBooks do this automatically? Not from a raw settlement report. A connector such as A2X or Synder produces the summarised entry, and QuickBooks posts it. Without one, you are keying the entry yourself.

Which QuickBooks plan do I need? Journal entries work on every tier including Simple Start at $38 a month. If you want QuickBooks to track and value inventory, Intuit’s inventory page places that on Plus and Advanced only, so the entry point becomes $140 a month at list.

Is any of this tax advice? No. This is general information about bookkeeping practice. Sales tax treatment, marketplace facilitator rules and the correct handling of reserves all depend on facts specific to you. Confirm with your own CPA or the relevant taxing authority.

Bottom Line

The Amazon settlement deposit is an output of a calculation, not a revenue figure, and treating it as revenue is the single most damaging habit in marketplace bookkeeping. On the worked example in this post, booking the $18,000 deposit as income would have understated net sales by $11,000 and made $11,239.99 of genuine operating expense disappear from the accounts entirely.

The fix costs one journal entry per settlement, twelve accounts in your chart of accounts, and a clearing account for the periods that cross a month end. Both columns of the entry must total the same number, and that requirement is the only automatic error check you get. If a connector removes the keying for less than the value of the hours it saves, buy the connector. If not, do it by hand and do it properly.

If you would rather have the entire store built, sourced and launched for you rather than assembling the stack piece by piece, that is exactly what my done for you high ticket dropshipping build and launch service does.

Related Articles

How to Reconcile Shopify Payouts in QuickBooks Without Double Counting Revenue

QuickBooks vs Bench 2026: Software You Run or Bookkeeping Someone Else Does

How to Set Up QuickBooks for an Ecommerce Store: The Order That Prevents Rework

QuickBooks Pricing 2026: Every Plan Costed for Year One and Year Two

Best Accounting Software for Ecommerce 2026: Ranked by Where Inventory Starts

Trevor Fenner

Trevor Fenner is an ecommerce entrepreneur and the founder of Ecommerce Paradise, a platform focused on helping entrepreneurs build and scale profitable high-ticket ecommerce and dropshipping businesses. With over a decade of hands-on experience, Trevor specializes in high-ticket dropshipping strategy, niche and product selection, supplier recruiting and onboarding, Google & Bing Shopping ads, ecommerce SEO, and systems-driven automation and scaling. Through Ecommerce Paradise, he provides free education via in-depth guides like How to Start High-Ticket Dropshipping, advanced training through the High-Ticket Dropshipping Masterclass, and fully done-for-you turnkey ecommerce services for entrepreneurs who want a faster, more hands-off path to growth. Trevor is known for emphasizing sustainable, real-world ecommerce models over hype-driven tactics, helping store owners build scalable, sellable, and location-independent brands.

Still deciding what to sell?

Grab the free list of 1,000+ niches that work for high-ticket dropshipping, sorted by category.

Free. Unsubscribe any time.

80

SHARES

Share on Facebook

Post on X

Save

Share