TidyOne payout.
Two months.
Settlement periods don't respect month ends. Split a payout across the months it actually covers — by day count in seconds, or exactly, by pasting the dated transactions — and get the month-end accrual entries that put each dollar of revenue, refunds, fees and tax into the right period.
The payout to split
One payout, one currency. Enter positive amounts — the splitter applies the signs.
Each month gets a share of every line in proportion to the days of the settlement period that fall in it. Quick, defensible, and the usual month-end shortcut.
Only if your sales figure includes the tax the marketplace collected. Otherwise 0.
Paste dated lines from a settlement or transaction export — one per line, with a date and an amount (tabs, commas or semicolons all work; the last number on each line is taken as the amount). Pick what the lines are, add them, repeat for each type.
Account names used in the suggested entries
Month by month
Suggested entries
Accrue each month's share to a receivable at month end; clear the receivable when the payout lands. If the last segment and the payout fall in the same month, you can post that segment straight from the payout instead.
Estimates from the numbers you enter, not accounting advice. Day-weighting assumes activity is spread evenly through the period — use exact transactions when it isn't.
Cash-basis books lie
a little, every month.
Read more in The Tidy Ledger
or try the other free tools.
What goes wrong without a split
A payout for September 26 to October 9 posted on October 16 puts five days of September sales — and their fees — into October. Do that every two weeks and every month's revenue is a blend of the one before it. Margin trends smear, sales tax reports drift from the marketplace's own figures, and year-end gets a December payout that is really half November.
Day-weighted vs exact
- Day-weighted assumes activity is even across the period and allocates every line by the day count in each month. Fast, and fine for steady sellers.
- Exact buckets each transaction by its own date. Use it when a promotion, launch or holiday made the period lumpy — or whenever an auditor might ask.
- Rounding never breaks the tie: the last month takes the residual cent, so the months always sum to the payout.
- Keep refunds with their refund date, not the original sale date — that is how the marketplace reports them, and how the cash moved.
Quick answers.
Want every payout split automatically, by transaction date? That's TidyPayouts ↗
Which months does a settlement period belong to?+
Every month it touches. Revenue belongs to the month the sale happened, fees to the month they were charged, refunds to the month they were issued. The payout date only decides when the cash entry is posted.
Is day-weighting acceptable for accrual accounting?+
It is a common, defensible estimate when the amounts are modest and sales are steady, and it is far better than posting the whole payout to the deposit month. For material periods, or lumpy ones, bucket the actual transactions — this tool does both.
What is the “marketplace receivable” account?+
A current-asset account holding money the marketplace owes you for sales already made. The month-end entry puts the month's net there; the payout entry moves it to the bank. If you already use a clearing account for payouts, use that name instead.
Does this work for Shopify, eBay or Etsy payouts too?+
Yes. Any payout with a period and a date can be split — Shopify payouts spanning a month end, eBay or Etsy weekly deposits, Walmart bi-weekly settlements. Use one payout and one currency at a time.
Every payout, in the
right month, automatically.
TidyPayouts posts marketplace activity by transaction date, so month-end is already done.
Join the free beta →Free during beta. No credit card.