摊账For independent market stallholders

MARKET STALLS / HANDMADE GOODS / WEEKEND FAIRS

What did you sell?
What did you keep?

At the end of a market, compare receipts with costs. Try this free calculator to estimate one event’s operating surplus.

Download a free inventory checklist ↓

No account needed. Calculator inputs stay in this page and are neither uploaded nor saved.

Estimate this event

Chinese yuan · CNY
Event operating surplus¥221.34These are hypothetical example figures. Replace them with your own amounts.

Operating surplus = net receipts − cost of goods sold − losses and giveaways − event expenses. Taxes and any unentered labour or depreciation are excluded. Unsold stock ties up cash, so surplus is not net cash flow.

Three things to record when packing up

  1. Count what you bring home

    Brought − returned − lost or given away = sold. Include resalable customer returns in the quantity brought home.

  2. Record actual receipts

    Total receipts by product after discounts and refunds. List price multiplied by quantity can overstate receipts.

  3. Include all event expenses

    Stall and travel fees affect the result too. Do not count product costs again under expenses.

ONE PURCHASE · REUSE FOR EACH EVENT

Tanzhang v2 inventory worksheet pack

Record stock brought, stock returned, losses and receipts by product. The workbook calculates units sold, product contribution and event surplus. The paid workbook and its guide are in Chinese.

  • One macro-free XLSX workbook: event stock and expenses
  • Up to 100 products and 50 expense entries per event
  • Input checks, returned stock cost, sell-through ratio and a Chinese quick-start guide
  • Download locally and save a separate copy for each event

CNY 19.90 One-time digital download · Chinese workbook

Buy v2 on Afdian (CNY 19.90) ↓
Payments are handled by Afdian. After payment, receive a protected download page and access code by private message; use the code to download the ZIP. If the message does not arrive or the download fails, contact Tanzhang through Afdian private messages.

No custom services, online stock sync or tax filing. v2 passed native formula recalculation in LibreOfficeDev 26.8. Scoped checks passed in WPS macOS 12.1.26046: sample amount recalculation, invalid stock and missing-input guards, expense confirmation and cross-sheet links, and save/reopen. This does not establish compatibility for every scenario. Excel and mobile workbook use remain untested. v1 was previously delivered publicly, and removal of its public copy has not been confirmed. We do not claim the old version is now private.

Hypothetical example in CNY: receipts 1110, goods and losses 662, expenses 226.66, surplus 221.34
Hypothetical workbook example, not actual shop revenue or customer results. The workbook is in Chinese.

Before you use it

Is this an online bookkeeping system?

No. The webpage is a free single-event calculator. The optional pack is a locally downloaded spreadsheet. You do not need to share business records with us.

Does it calculate cash flow?

It estimates operating surplus. Inventory purchases, deposits, credit sales and refunds from previous events affect cash flow. This version does not keep a cash ledger or inventory across events.

How does the free checklist differ from the paid pack?

The free checklist provides column headings for manual records. The paid Chinese workbook adds formulas and input checks. Try the free tools first to see whether this way of recording suits you.