Skip to main content

PennyWise

Calendly Book a Meeting
Email

info@pennywiseusa.com

Short answer: record each Amazon settlement as a whole, not just the deposit. Post the settlement’s sales, fees, refunds and reserves into an Amazon clearing account in QuickBooks Online, then match the bank deposit to that clearing account. When it is done right, the clearing account only holds money Amazon still owes you, and your income statement shows true sales and true fees.

Why the bank deposit is not enough

Amazon pays you a net amount: sales minus referral fees, fulfillment fees, refunds, promotions and sometimes advertising, adjusted for any funds held back. If you record only the deposit as income, your sales and expenses are both wrong, even if your bank balance is right.

Step 1: Set up the accounts

  • Amazon clearing account (balance sheet, often set up as a bank-type or other current asset account)
  • Income accounts for product sales and shipping income
  • Expense accounts for Amazon selling fees, fulfillment fees and advertising
  • A contra-income or expense account for refunds and promotions
  • Inventory and cost of goods sold, if you track inventory (see how Amazon sellers track inventory and COGS)

Step 2: Get the settlement data

In Seller Central, open the payments area and download the settlement report or statement for the period. Each settlement shows sales, fees, refunds, other transactions and the amount transferred to your bank.

Step 3: Record the settlement

Create one entry per settlement (a journal entry or a deposit into the clearing account):

  1. Product sales and shipping credits go to income.
  2. Referral, fulfillment and other Amazon fees go to their expense accounts.
  3. Refunds and promotional rebates go to their own account so you can see them.
  4. Amounts held back go to the clearing account, as Amazon still owes them to you. Read Amazon deferred transactions in QuickBooks, explained for more on held funds.
  5. The net total equals the payout Amazon sends to your bank.

Step 4: Match the payout

When the payout lands in your bank feed, record it as a transfer from the Amazon clearing account to your bank account, not as income. Each deposit should match one settlement exactly.

Step 5: Check it every month

  • Every Amazon deposit matches a settlement payout.
  • The clearing account balance is close to what Seller Central shows as still owed to you.
  • Monthly sales in QuickBooks are close to Seller Central’s sales report.

Use a connector for volume

For an active seller, entering settlements by hand is slow and error-prone. Connectors such as A2X read each settlement and post a summarized entry into QuickBooks automatically, mapped to your accounts.

Want it set up properly?

PennyWise is A2X certified and works with Amazon sellers in QuickBooks Online and Xero. See our bookkeeping for Amazon sellers, or start with a free QuickBooks Health Check to see whether your Amazon numbers tie out.

Leave a Reply

Your email address will not be published. Required fields are marked *