FOR HANDMADE SELLERS
What went in.
What came back.
Check consignment stock and payout figures across your shops for one statement period.
Manual worksheet. No account. Nothing is saved when this tab closes.
Your period worksheet
Start with your records and each shop's statement. The optional example includes a matching shop, discrepancies and a missing statement.
Import only this tool's worksheet JSON (up to 1 MiB). Item CSV imports require your explicit column mapping and review. Downloaded files contain the values you enter.
Review item CSV import
Export aggregate per-item CSV first, with one row per SKU. This imports selected totals into an existing shop; it does not read transaction CSV, Excel or PDF statements.
Gross sales must be the row total, not a unit price. Confirm the file matches the current worksheet period and currency. Refunds, fees, payment and commission may not be covered; keep those entries manual.
Period check
Add a shop to begin, or try the worked example.
What this check assumes
Expected closing stock = opening + deliveries + customer returns - sold - stock returned to you. Customer returns add units back to the shop; returned stock leaves it. A negative expected count needs a records check.
Seller proceeds are net sales (gross sales minus refunds) after the same commission percentage, rounded to cents for each item. Refunds reverse commission at that rate. Enter amounts in one currency and fees separately; use your contract to confirm this treatment.
Expected closing balance = opening amount due + seller proceeds - fees - net payout received. A positive calculated balance is in your favor; a negative balance is a credit in the shop's favor. Compare it with your agreement and records. Negative payout means a repayment to the shop. This does not determine when a payment is due or whether anyone acted improperly.
A missing statement leaves every statement-derived result unknown. Blank sold or gross sales also leaves the corresponding calculation unknown. Blank reported closing stock or closing balance leaves its difference unknown. Differences identify records to compare, not their cause.
This is a per-period comparison of figures you enter, not a live inventory system or verification of a shop's records.
More tools for handmade selling
Compare a proposed bulk order, or check the stock and payout figures from a shop. See the handmade selling collection.