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). No arbitrary CSV or shop-statement upload. Downloaded files contain the values you enter.
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.