Amazon Accounting: Settlement-Based Bookkeeping Process

Month-end closes late because Amazon sales, fees, refunds, and reserves live in separate exports. Meanwhile, the bank deposit never matches daily order totals in QuickBooks. A reliable amazon accounting process starts by recognizing that these reports describe different events.

Orders explain customer activity. Settlement detail explains how Amazon calculates seller proceeds. The bank confirms when cash arrives. Trying to make one report replace all three creates missing expenses, duplicated revenue, and unexplained balances.

Use a repeatable sequence: collect reports → map components → post through clearing → match the bank. Then review cutoff and inventory separately so a matched deposit does not become your only test of accurate books.

Build an amazon accounting report pack

Start with the settlement or payment transaction detail for each relevant marketplace and currency. Retain the settlement identifier, covered dates, payout reference, and original export. Report names and available fields can vary, so confirm what each download includes before building your spreadsheet.

Add bank activity, refund details, fee support, and reserve information. For FBA sellers, include reimbursement and inventory movement reports when relevant. Seller-fulfilled sellers should retain shipping and inventory records from their own fulfillment process. These supporting files explain classifications; they should not automatically become additional revenue imports.

Save the reports together with a reconciliation worksheet. Record which date field you used and whether the export includes pending or posted activity. A later reviewer should be able to reproduce your totals without guessing which filters were applied.

Map settlement components before posting

Create a mapping table that assigns each transaction type to a consistent QuickBooks account. Review unfamiliar descriptions rather than sending everything unknown to miscellaneous income. Keep the original description alongside the mapping so changes remain traceable.

Use these starting categories, adapting them to your established accounting policy:

• Product sales: recognized sales before settlement fee withholdings, separated from customer refunds.
• Customer refunds: a sales returns account, with associated fee credits mapped separately where supported.
• Marketplace fees: referral, fulfillment, storage, and other charges, grouped or separated according to reporting needs.
• Reimbursements and adjustments: reviewed individually; a recovery, reversal, or existing receivable settlement is not automatically product revenue.
• Reserves: amounts Amazon retains or releases, generally tracked as a balance sheet movement rather than an ordinary operating expense.
• Payouts: movements from the marketplace balance to the bank, not another sale.

FBA does not change the basic reconciliation sequence. It adds fulfillment, storage, and inventory events that need their own support. Seller-fulfilled shipping costs may come from Amazon fee lines, carrier bills, or another system. Identify the source before posting so the same label purchase is not expensed twice.

Settlement exports also do not replace inventory accounting. Purchases, inventory movements, and cost of goods sold need a consistent process connected to your inventory records. Check whether another application already posts those entries before adding manual adjustments.

Use clearing to separate activity from cash

An Amazon clearing account tracks the marketplace balance between recorded activity and cash received. In the examples below, it is a current asset account. Keep separate tracking by marketplace and currency when needed to avoid hiding differences through unrelated offsets.

Choose a reserve convention and apply it consistently. Here, retained amounts move to a separate Amazon reserve receivable account. Another approach can leave supported reserves within clearing, but mixing approaches will make reconciliation harder.

The following illustrative example assumes no opening balance, no other adjustments, and no activity already recorded elsewhere. All amounts are in USD. The reserve movement is separately supported by Amazon reports:

• Product sales: $10,000.
• Customer refunds: $500.
• Marketplace fees: $1,500.
• New reserve retained: $800.
• Cash payout: $7,200.

The bridge is $10,000 minus $500 minus $1,500 minus $800, leaving $7,200 payable to the bank. The $800 remains an asset awaiting release; it is not included in fee expense.

Example: record settlement activity

This entry records the components once. If your order connector already records sales and refunds, do not post this full journal on top. Instead, reconcile those existing entries and record only the missing components using a workflow designed for that setup.

Example: record the payout

When the illustrative payout reaches checking, record the movement below and match the downloaded bank transaction to it:

After these entries, this settlement contributes nothing to clearing, while the reserve receivable still holds $800. That supported reserve balance should remain visible until released or otherwise resolved.

If Amazon later releases it, move the supported release from reserve receivable into clearing as part of that settlement. The subsequent payout reduces clearing. The release is not new product revenue.

Steps to close Amazon activity in QuickBooks Online

1. 1

   Confirm scope and ownership

   List the marketplaces, currencies, settlements, and reporting period being closed. Identify which system owns sales, inventory, and payout entries before importing anything.

2. Collect and check reports: Save the complete settlement detail and supporting exports. Check for missing settlements, overlapping downloads, and duplicated identifiers. Include payouts that are still in transit at the reporting date.

3. Apply the component mapping: Classify sales, refunds, fees, reserves, and adjustments. Review unfamiliar lines individually. Keep unresolved items on an exception list with an owner rather than burying them in a balancing entry.

4. Reconcile the settlement bridge: Explain how opening balances and activity produce retained balances and payouts. Confirm that the supported payout agrees with Amazon's reported transfer amount before recording it in QuickBooks.

5. Post or review activity: Use your existing posting method consistently. Attach support and include settlement references. Check balanced debits and credits, account mapping, and whether any connected application already recorded the same activity.

6. Record and match cash: Create or identify the payout movement from clearing to checking. In the bank feed, match the deposit to that existing transaction rather than adding it as income again.

7. Review the closing balances: Reconcile clearing and reserve receivables to their supporting schedules. Review cutoff, inventory entries, and outstanding exceptions before marking the month complete.

Check cutoff when settlements cross month-end

A settlement can span two reporting periods, and its bank deposit can arrive in a third date range. Do not assume the payout date is the appropriate date for every underlying sale, refund, or expense.

For accrual reporting, use transaction detail and your established recognition policy to allocate activity to the correct period. Ask your accountant to define a consistent cutoff method where needed. Split settlement activity or use documented period-end adjustments without changing the underlying payout reference.

Keep a schedule linking the full settlement to each period's postings. When the remaining activity is posted, check that the complete settlement has been recognized exactly once. Reverse temporary accruals where appropriate to avoid duplicating the later import.

Troubleshoot differences without forcing a match

The deposit differs from the settlement calculation. Check payout references, reserve movements, prior balances, and reversals. Compare the same currency and settlement scope. Do not assume an order date range describes a payout.

Clearing still has a balance. Separate supported reserves, unsettled activity, and transfers in transit from unexplained differences. Investigate older items by settlement reference. Clearing need not always be zero, but it must always be explainable.

Revenue looks too high. Look for order imports, settlement journals, and bank deposits all recording the same sales. Choose one revenue source and correct duplicates with an audit trail rather than deleting support blindly.

Fees look too low or too high. Check whether fee withholdings were netted against revenue or recorded again through bills or card feeds. Reconcile fee categories to supporting reports, including credits and reversals.

A balance disappears only after an adjustment. Reopen the supporting calculation. A plug can hide a missing report, duplicate transaction, or cutoff error. Document the actual cause and correction instead of treating agreement as proof.

Keep the process repeatable

Maintain one mapping register, one settlement checklist, and a short exception log. Save the reports and posting references together. The next close should start from supported opening balances, not from rebuilding the previous month's explanation.

For the detailed matching sequence, use the Amazon settlement reconciliation guide. If you want help making this workflow repeatable, explore ClearPayout's Amazon and QuickBooks integration and review pricing when it suits your setup.

The goal is straightforward: explain every component, record it once, and match the cash without turning the deposit into another sale.