Recurring monthly routine

Monthly platform payout reconcile folder

Marketplaces, app stores, and payment processors rarely pay you order by order. They batch a period's sales into one payout, subtract their fees, and send a single lump sum. That gap between "what customers paid" and "what landed" is where records get fuzzy. This page gives you one repeatable monthly routine: download each payout statement, file it in a dated folder, match the payout to the orders or invoices it covers, note the fees that were deducted, and set aside anything that does not reconcile so it does not get lost. Cash Workspace is a free place to keep those statements and matching notes organized month after month. You upload the statements yourself, attach them to records, and write down what each payout covers. The workspace does not connect to your bank or platform, does not read your statements, and does not reconcile anything on its own. This is organizational guidance, not accounting or tax advice.

The problem

Why platform payouts are hard to reconcile

A payout statement is a summary, not a list of sales. One deposit might cover sixty orders across nine days, minus marketplace commission, payment-processing fees, ad charges, refunds, and a chargeback or two. By the time the money hits, the numbers no longer line up cleanly with anything you remember selling. Without a fixed monthly routine, statements pile up unread, fees go unnoticed, and a payout that is short by a refund you forgot about looks like a mystery instead of a known adjustment.

  • A single payout bundles many orders across a settlement window, so the deposit amount never matches one invoice or one sale.
  • Fees are netted out before you ever see the money: commission, processing, ad spend, and refund clawbacks are buried inside the statement.
  • Different platforms pay on different cycles (weekly, biweekly, on a threshold), so a single month can hold several statements of different shapes.
  • Refunds, chargebacks, and adjustments from a prior period show up in this period's payout, breaking any naive order-to-payout match.
  • When a payout total does not match your matched orders, the difference is easy to ignore and impossible to find six months later.

The monthly routine

Run this once a month, per platform

Pick a fixed day each month (for example, the 3rd, once last month's final payout has settled). Repeat these steps for every platform that pays you. The goal is not perfect bookkeeping; it is a filed statement, a clear match, and a short list of anything left over.

  1. 1

    1. Download and upload the period's statements

    From each platform's payout or settlement area, download every payout statement dated in the month. Upload them into the month's folder, for example Payouts/2026-05/Etsy-payout-2026-05-08.pdf. Cash Workspace does not pull these in for you; you download from the platform and upload them manually. One record per payout keeps each deposit traceable.

  2. 2

    2. Create one record per payout

    For each statement, make a payout record with the platform, payout date, gross sales, total fees, and net deposited. Attach the statement PDF to that record. If the platform gives a payout or settlement ID, record it so you can find the exact deposit on your bank side later without any sync.

  3. 3

    3. Match the payout to the orders or invoices it covers

    List the order numbers or invoice records that fall inside the payout's settlement window. In a notes or match field, write the order IDs (or link your invoice records) the payout settled, e.g. 'Covers orders #4471-#4503, May 1-7.' This is the match: a payout record pointing at the specific orders behind it.

  4. 4

    4. Note every fee deducted

    Read the fee lines off the statement and record them on the payout record: commission, transaction/processing fee, ad or promoted-listing charges, and any refund or chargeback deducted. Recording fees as their own line in your note explains why net is lower than gross, so the gap is documented instead of mysterious.

  5. 5

    5. Park unmatched items for follow-up

    When an order will not match (a refund from a prior month, an adjustment with no order, a deposit you cannot account for), move it into an Unmatched record inside the month folder with a one-line note on what is unclear. Do not force a match. Revisit the Unmatched record next month when the related statement or refund appears.

  6. 6

    6. Confirm and close the month

    When every payout in the month has a record, a statement attached, a match note, and fees logged, and the only open items are in Unmatched, the month is reconciled for filing purposes. Add a short closing note (date, who reviewed, anything carried forward) and leave the folder as your filed record for the period.

Record structure

What to record on each payout

These are the fields to capture per payout statement so the deposit, its orders, and its fees stay together. Keep them on the payout record with the statement attached.

Platform / source
Which marketplace, app store, or processor sent the payout (e.g. Etsy, Amazon, Stripe, DoorDash). One field so a mixed month stays sortable by source.
Payout date
The date the platform reported the payout, used to file it into the correct month folder.
Payout / settlement ID
The platform's own reference for the deposit, so you can find the matching line on your bank side manually without any sync.
Settlement window
The date range of sales this payout covers (e.g. May 1-7), which defines which orders should match.
Gross sales
Total order value before fees, taken from the statement summary.
Fees deducted
Commission, processing, ad spend, refunds, and chargebacks netted out, listed individually so the net is explained.
Net deposited
The amount actually paid out after fees; this is what should reconcile against the deposit you received.
Orders / invoices matched
The order numbers or linked invoice records this payout settled; the heart of the match note.
Status
Matched, or Unmatched / follow-up, so open items are visible at a glance.
Notes
Free text for anything odd: a prior-period refund, a partial payout, a hold released this period.

Example setup

An example payout folder layout

A workable structure for a seller paid by two platforms. Each month is its own folder; each payout is a record with its statement attached, plus one shared Unmatched record for follow-up items.

Payouts / 2026-05 / Etsy

Records: Etsy-payout-2026-05-08 (gross $1,240, fees $214, net $1,026, covers orders #4471-#4503), Etsy-payout-2026-05-22 (net $988, covers #4504-#4540). Each has the payout PDF attached and an order-match note.

Payouts / 2026-05 / Stripe

Records: Stripe-payout-2026-05-15 (net $2,310, covers invoices INV-0211 through INV-0219) and Stripe-payout-2026-05-30. Statement attached, fee lines noted (processing 2.9% + 30c), invoice records linked in the match note.

Payouts / 2026-05 / _Unmatched

Follow-up record: 'May 22 Etsy payout $36 short, likely refund on order #4488 from April, confirm next statement.' One line per open item; cleared as the matching statement appears.

Payouts / 2026-04 (closed)

Prior month, same structure, with a closing note: 'Reconciled 2026-05-03 by owner. One item carried to May Unmatched.' Left as the filed record for April.

Common mistakes

Common mistakes to avoid

  • Treating the net deposit as your sales total and never opening the statement to see the fees that were taken out.
  • Trying to match a payout to a single order when the deposit covers a whole settlement window of orders.
  • Forgetting that refunds and chargebacks from a prior month reduce this month's payout, then chasing the 'missing' money.
  • Forcing every line to reconcile instead of parking genuinely unclear items in an Unmatched record for next month.
  • Mixing several platforms' payouts into one undated pile so you cannot tell which deposit covered which orders.
  • Skipping the month when it is busy, then facing a quarter of unread statements you can no longer untangle.

How it helps

How Cash Workspace helps with this routine

A dated folder per month

Make a Payouts/YYYY-MM folder for each period so every statement lands in the right month and last month's filing stays untouched once closed.

One record per payout, statement attached

Create a payout record, fill in the fields above, and attach the statement PDF you downloaded. The deposit, its fees, and its orders stay in one place.

Match notes that link to your invoices

Write which orders or invoice records a payout covers right on the payout record, so a sent invoice and the deposit that settled it are connected by your own note.

An Unmatched holding spot

Keep a follow-up record inside the month folder for anything that does not reconcile, so open items are visible instead of lost, and revisited next month.

Export when you hand off

When an accountant or bookkeeper needs the period, export the month's payout records and attached statements as an accountant-ready set. Cash Workspace organizes; it does not do the accounting.

Free, with no bank or platform connection

The workspace is free. It does not sync with your bank or platform and does not read your statements, so you stay in control of what gets uploaded and matched.

FAQ

Frequently asked questions

Does Cash Workspace pull my payout statements in automatically?
No. Cash Workspace does not sync with your bank, your marketplace, or your payment processor. You download each payout statement from the platform yourself and upload it into the month's folder. The workspace is where you file and match them, not a connection to the platform.
Does it read the statement and match the orders for me?
No. There is no OCR or automatic reading, and no automated reconciliation. You write the match note yourself, listing which orders or invoices each payout covers and which fees were deducted. The workspace keeps that note, the statement, and the payout record together.
How do I handle a payout that does not match my orders?
Park it. Put the item in an Unmatched record inside the month folder with a one-line note on what is unclear, such as a refund from a prior period or an adjustment with no order. Do not force a match. Revisit it next month when the related statement appears.
What about platforms that pay weekly or on a threshold?
File every statement dated in the month into that month's folder, however many there are. A weekly payer simply produces four or five records in one month folder. To plan around those cycles ahead of time, the creator platform payout schedule records page covers payout timing.
Is this tax or accounting advice?
No. This is organizational guidance for keeping payout statements and match notes tidy. It is not tax, accounting, or bookkeeping advice, and the workspace is not accounting software. For how the numbers should be treated, talk to a qualified professional.

What this page does and does not do

This is a record-organization routine, not accounting or tax advice and not automated reconciliation. Cash Workspace does not sync with your bank, marketplace, or payment processor; you upload payout statements manually. It does not read statements, extract figures, or match orders for you. You enter the matches and fee notes yourself, and "reconciled" here means your statements are filed and your match notes are complete, not that any books have been closed. For how payouts and fees should be recorded for accounting or tax purposes, consult a qualified professional.

Start filing your payouts this month

Open a free Cash Workspace, make a Payouts/2026-05 folder, and file this month's first payout statement with its match note. Next month the routine is already set up and waiting. It is free, and there is nothing to connect: you upload, you match, you stay in control. Questions? Reach the operator, HELPERG LLC, at info@helperg.com.