Month-end bookkeeping can become difficult for Amazon sellers because Amazon sales rarely match the amount deposited into the bank.
The seller may see thousands of dollars in product sales, refunds, fees, taxes, reimbursements, and adjustments during the month. However, the bank feed shows only one or more net deposits.
The bookkeeper must explain how the Amazon activity became the final payout before the bank account can be reconciled correctly.
The Month-End Situation
Consider an Amazon seller with the following settlement activity:
Settlement activityAmountGross sales$50,000Shipping income$1,200Refunds-$2,800Amazon fees-$7,400Advertising charges-$1,500Reserve held by Amazon-$1,000Reimbursement$500Final payout$39,000
The bank feed shows a $39,000 Amazon deposit.
The bookkeeper cannot match the $51,200 sales total directly to the deposit because the payout already includes multiple deductions and adjustments.
Why Bank-Feed Categorization Is Not Enough
QuickBooks bank feeds show the amount received, but they do not explain the full Amazon activity behind the deposit.
If the $39,000 payout is simply categorized as sales income:
- Gross sales are understated
- Amazon fees are missing
- Refunds are not shown clearly
- Advertising costs may be omitted
- The reserve is not tracked
- The reimbursement is hidden inside the payout
The bank account may reconcile, but the profit and loss report may still be wrong.
The Role of an Amazon Clearing Account
An Amazon clearing account can help connect sales activity with the final bank payout.
The account works as a temporary holding account for money processed through Amazon.
Sales increase the clearing balance
Gross sales and related income are first recorded against the Amazon clearing account.
Fees and refunds reduce the balance
Marketplace fees, refunds, advertising charges, and other deductions reduce the amount Amazon owes the seller.
The payout moves money to the bank
When Amazon releases the payout, the amount is transferred from the clearing account to the business bank account.
This structure helps the bookkeeper see how the settlement changed from gross sales to the final deposit.
Example Clearing-Account Flow
Using the previous example:
ActivityClearing-account effectGross sales+$50,000Shipping income+$1,200Refunds-$2,800Amazon fees-$7,400Advertising charges-$1,500Reserve-$1,000Reimbursement+$500Transfer to bank-$39,000Remaining balance$0
When all activity is recorded correctly, the clearing-account balance should be zero unless Amazon is holding money, a payout is still pending, or a transaction has not yet been recorded.
Step-by-Step Month-End WorkflowStep 1: Collect the Amazon settlement data
The bookkeeper should collect the relevant settlement reports for the accounting period.
The data should include sales, shipping, refunds, fees, taxes, reimbursements, reserves, and payouts.
Step 2: Record the settlement activity
Each settlement category should be mapped to the appropriate income, expense, liability, or clearing account.
This ensures the profit and loss statement reflects the seller’s actual Amazon activity.
Step 3: Review the clearing-account balance
After sales and deductions are recorded, the remaining clearing balance should represent the amount Amazon is expected to pay.
If the balance is different, the bookkeeper should check for:
- Missing fees
- Unrecorded refunds
- Pending reserves
- Duplicate entries
- Incorrect settlement dates
- Reimbursements
- Currency differences
Step 4: Record the Amazon payout
The payout should move the settlement amount from the clearing account to the bank account.
It should not create a second sales entry.
Step 5: Match the bank-feed deposit
Once the payout is recorded, the bookkeeper can match Amazon settlements to bank deposits in QuickBooks.
The bank-feed deposit should match the payout amount already recorded through the clearing-account workflow.
Why Sellers Struggle with Amazon ReconciliationSettlement periods may cross months
An Amazon settlement may include sales from one month and a payout in the next. This creates timing differences during month-end close.
Reserves can remain outstanding
Amazon may retain part of the seller’s funds. The remaining balance should stay in the clearing account until it is released or adjusted.
Refunds can appear after the original sale
A customer refund may be included in a later settlement, making it difficult to compare one sales report with one bank deposit.
Fees can be grouped together
Amazon may deduct several types of fees within the same settlement. These may need to be separated for useful reporting.
Multiple marketplaces create more complexity
Sellers operating in several countries or currencies may need separate clearing accounts and account mappings.
When Automation Becomes Useful
A seller with limited monthly activity may be able to manage settlements with spreadsheets and manual journal entries.
Automation becomes more useful when the business has:
- High transaction volume
- Frequent payouts
- Multiple marketplaces
- Several currencies
- Many Amazon fee categories
- Regular refunds and reimbursements
- A bookkeeping team
- Monthly reconciliation delays
An Amazon QuickBooks integration can help bring sales, fees, refunds, taxes, and payout information into a structured accounting workflow.
The seller or accountant should still review account mappings, tax treatment, sync settings, and clearing balances.
Common Reconciliation MistakesAdding the deposit as new income
If sales are already recorded, adding the payout as income duplicates revenue.
Forcing the clearing account to zero
An outstanding balance may be valid when Amazon is holding reserves or a payout has not yet been released.
Matching deposits before recording fees
The payout may match the bank, but the financial reports will remain incomplete.
Using the wrong settlement period
Settlement dates and bank deposit dates may fall in different accounting periods.
Ignoring duplicate entries
Importing or syncing the same settlement twice can distort sales, fees, and clearing balances.
What a Clean Month-End Result Should Show
After the reconciliation is complete, the seller should be able to identify:
- Total Amazon sales
- Shipping and other income
- Customer refunds
- Marketplace fees
- Advertising expenses
- Taxes
- Reserves
- Reimbursements
- Pending Amazon balances
- Payouts deposited into the bank
The bank account should match the actual deposit, while the profit and loss statement should show the full marketplace activity.
Final Takeaway
Amazon reconciliation is not simply a matter of matching sales to the bank.
The correct workflow connects gross sales, refunds, fees, reserves, adjustments, and payouts through a clearing account before matching the final deposit.
This helps Amazon sellers avoid duplicate revenue, missing expenses, and unexplained balances during month-end close.
