TidySettlement
Every line from product sales to reserves, reimbursements and sales tax, with the expected deposit and a fee breakdown.
PAYOUT RECONCILIATION · FREE XLSX
From settlement
From settlement
to a balanced entry.
One workbook for the monthly ritual: rebuild the settlement, match the bank, post the journal and close the period without a suspense account.
6 sheets.xlsx ExcelOct 2026 updated$0 with email
Best for: Sellers and bookkeepers reconciling Amazon or multi-channel settlements in QuickBooks, Xero or a spreadsheet ledger.
6 sheets,
no filler.
Bank match
Twelve payout slots with a one-cent tolerance, a short/over status and a place to write the explanation.
Journal entry
A balanced entry for cash, fees, promotions, refunds, reserve, sales, reimbursements and other income, with a debit/credit check.
Month-end close
A 12-step checklist with status, owner, due date and a completion percentage.
Reference
Settlement anatomy, why the deposit is not revenue, common reconciling items and sources.
A short,
repeatable workflow.
Pick one settlement
Enter the marketplace, period and currency, then copy every line with the sign Amazon uses.
Check the expected deposit
The settlement lines build the deposit. Sales tax stays a memo because Amazon collects and remits it.
Match the bank
Enter the deposit date and amount. A difference inside one cent is a match; anything larger needs an explanation.
Post and close
Copy the journal lines into your ledger, check debits equal credits, then work the month-end checklist.
What it does not do
It does not connect to Seller Central, file a claim, post to your ledger or give tax advice. It organizes the numbers and the evidence so the decision — or the filing — is faster and better.
Before you
download.
Why not book the bank deposit as revenue?+
The deposit is net of fees, refunds and reserves. Booking it as revenue understates both revenue and expenses and makes the P&L useless for pricing.
What is a reserve, and how do I book it?+
A reserve is cash Amazon holds back temporarily. It is still your asset: debit the reserve asset when it is held and credit it when it is released. It is not a fee.
Does this work for eBay, Etsy, Walmart or Shopify?+
The line names are marketplace-neutral. The example uses Amazon because its settlement has the most line types, but the structure works for any payout report with sales, fees, refunds and reserves.
Is the journal entry ready to post?+
It is a balanced draft with suggested accounts. Check the account names, tax treatment and rounding against your own ledger before posting.
Every payout,
perfectly in place.
TidyPayouts does for all your payouts what this workbook does for one.
Join the free beta Free during beta. No credit card.