Skip to content
Data trust

Every figure declares what it is

Loading the live order set from Grist…
Measured
0 costs

Read straight from a real field — Order_Lines, Orders.invoice_total, the costing sheet, the shipment rows. In the current view: ₹0.

Assumed
4 rules

GST rate 18% · Snapmint EMI fee 4.5% net · Freight rate-card quote · period-cost apportionment. Hatched everywhere they touch a number. In view: ₹3,56,113.

Not tracked
2 gaps

Payment gateway fees · COD cash-in. Named gaps — never silently pretended to be ₹0. Packaging · Marketplace commissions graduated to an allocated period cost.

Assumptions ledger
GST rate
18% — No GST field exists anywhere in OMS or ERP.
assumed
Snapmint EMI fee
4.5% net — A rate applied to EMI orders, not a charge observed on any of them.
assumed
Freight
rate-card quote — Shipments.
assumed
Payment gateway fees
Load the monthly gateway invoice as a period cost, or ingest a per-order fee feed. An allocation must be labelled an allocation.
not tracked
COD cash-in
Load the COD remittance file and match on AWB.
not tracked

Sum of Orders.invoice_total, GST included, less cancelled orders. RTO still counts as a sale. NOT gross sales × 1.18 — the ex-GST measure divides a POST-adjustment customer value, so the two differ by ₹309.97 across 10 orders.

Live order set
● snapshot on disk
0 orders

4,546 order lines · 2,064 shipments, pulled from Grist. Recognised revenue is forced to ₹0 on 0 cancelled / RTO orders in view.

Certainty of this number0% measured
measured · COGS, discounts, free goodsassumed · freight quotes, EMI rate2 costs not tracked — no size to draw
Period costs

Advertising, software, warehousing — money that belongs to a month, not to an order. Enter a total and it is apportioned across that month’s orders. The share an order carries is always assumed — the total was measured, the split is a rule.

₹3,56,113
13 entries · 2 months
Read-only in previewno server

In the real app this is an admin form: enter a month or a date range, a category and an amount — or upload a CSV — and it is written to data/period-costs.json on the server, then apportioned across that month’s orders. This design preview is a static export with no backend, so the form is not rendered rather than shown as a button that would fail on click. The ledger below is live and shows every state it can draw.

August 2026₹59,8320 orderssplit equally
  • Meta + Google, August to dateAdvertisingPart month — the snapshot stops mid-August.₹17,025
  • Salaries & contractorsSalaries & contractors₹15,715
  • Shopify, Grist, Klaviyo, SlackSoftware & tools₹2,537
  • Influencer flight, 16 Jul – 15 AugAdvertising15/31 days of 2026-07-16 – 2026-08-15Entered as a RANGE and split pro-rata by day across the two months it spans.₹24,555

Split equally across the month's orders: the month recognised no revenue, so there is no revenue weight to apportion by.

July 2026₹2,96,2810 orderssplit equally
  • Meta + Google, JulyAdvertising₹1,41,109
  • Salaries & contractorsSalaries & contractors₹47,146
  • 3PL storage + pick-packWarehousing & fulfilmentBilled on closing stock, not on despatches.₹23,573
  • Cartons, tape, void fillPackaging & consumablesCSV₹19,317
  • Marketplace commissionsMarketplace commissionsCSV₹12,114
  • Shopify, Grist, Klaviyo, SlackSoftware & tools₹7,612
  • Bank charges, courier claimsMiscellaneous₹3,503
  • Photoshoot + retainerCreative & contentUser-added category — shows the non-built-in row treatment.₹15,715
  • Influencer flight, 16 Jul – 15 AugAdvertising16/31 days of 2026-07-16 – 2026-08-15Entered as a RANGE and split pro-rata by day across the two months it spans.₹26,192

Split equally across the month's orders: the month recognised no revenue, so there is no revenue weight to apportion by.

Revenue basis

Proof that the revenue basis holds before a single margin is quoted.

invoice_total vs the line-level rebuild

Σ invoice_total
The revenue basis · every invoiced order, cancellations included
Not yet tracked
Σ lines rebuilt
items × qty, plus shipping, less discount
Not yet tracked
Drift
Should be ₹0
Not yet tracked
Gross sales (invoice basis)
Σ invoice_total less 0 cancelled orders (by flag) · GST included · RTO still counts
Not yet tracked

Known traps this page guards

  • Split orders have no name
  • REMOVE lines are already gone
  • Free items carry no tag
  • Refunds on zeroed orders
Freight reconciliationNot yet tracked

There is no freight bill to reconcile against — courier_charge is 0 on every shipment row. Any freight figure this app ever shows will be a quote or a rate-card estimate, and will say so on the row.