Masters & Config — single source of truth. Changes here flow into all other tabs. All data is auto-saved.
Brand master
Brand and Brand 2 are free-text. Brand group and Cohort are fixed options.
📋 Paste from Excel — columns: Brand | Brand 2 | Brand group | Cohort
Brand
Brand 2
Brand group
Cohort
Partner-Model master
Partner is the channel (e.g. Myntra). Model is the commercial arrangement (e.g. PPMP). Partner Group is for roll-up reporting. Channel Group is a second, independent roll-up (QCom / ECom / Others). Partner + Model must be unique.
📋 Paste from Excel — columns: Partner | Model | Partner group | Channel group
Partner
Model
Partner group
Channel group
Brand → Partner-Model mapping
Brand and Partner-Model are selected from their masters above. Credit period is in days. GMV grouping is either GMV or Pry.
📋 Paste from Excel — columns: Brand | Partner | Model | Credit days | GMV grouping
Brand
Partner
Model
Credit period
GMV grouping
Expense line item master
Expense name and category are free-text. GST rate is a number. ITC eligible is Y or N.
📋 Paste from Excel — columns: Expense line item | Category
Expense line item
Category
Brand Expense Mapping
Set GST rate and creditor days per brand and expense line. Columns: Brand | Expense Line | GST Rate % | Creditor Days
📋 Paste from Excel — columns: Brand | Expense Line | GST Rate % | Creditor Days
Brand
Expense Line
GST %
Creditor Days
CODB Line Items
Define CODB line items and link each to an expense line item from Master 4.
📋 Paste — columns: CODB Line Item | Expense Line Item
CODB Line Item
Expense Line Item
CAC Deduction Mapping
For each Brand → Partner-Model, tick if the marketplace deducts the CAC from its payout, and the month it is deducted in. Mth 0: the marketplace deducts the CAC (with GST) from the payout for the same month's sales, as before. Mth +1 / Mth +2: the CAC bill comes later and is deducted one / two months after the CAC month. CAC stays in the P&L in the month it is incurred; the CAC block shows it again as Deductable CAC in the month it is deducted. In Creditors (CAC line) all CAC is added with GST; CAC the marketplace deducts comes out as − Deducted by marketplace in the month it is deducted instead of being paid, so until then it stays in closing creditors and direct and indirect cash match. In Debtors it is in − Deductions (Mkt) of that month. CAC not deducted is paid through Creditors, as before. For now only CAC incurred within the cycle moves: CAC of months before the cycle start is not carried in, so on Mth +1 / +2 channels the first one or two cycle months show no deduction for earlier months.
For each Brand → Partner-Model, tick which CODB line items are deducted by the marketplace (CAC is in the CAC deduction mapping pill) (reduces Collectable — not a separate cash payment).
Use the Brand and CODB item dropdowns in the table header to filter rows/columns.
AOP Upload — admins only · stored in aop.json, current FY only
Columns: Brand | Partner | Model | FY | Mth | P&L columns (Secondary Sales, Net Sales af Prov, COGS, CM1 …). SKU rows are added up automatically. Brand: the Brand column is used (e.g. Chumbak, Hipkoo); Sub Brands add up into their Brand. GBL Garden adds up its brands via the Brand master. Everything is kept: every numeric column is stored (standard P&L lines and any extra columns). Only text columns are left out, and listed. Mth: 4=Apr … 12=Dec, 1=Jan … 3=Mar (month names also work). One FY per file. Full or partial file: only the Brand × Month combinations in the file are replaced; everything else stays as it is. Financial year: the current FY (FY27), or ahead of time the next FY (FY28), which is held aside and becomes the current AOP when the FY moves. Check first: nothing is saved until you review the check — new months, changes to AOP already loaded (old → new), and lines no longer in the file (set to 0).
Only admins can upload the AOP.
or paste below
AOP loaded — months with data, by Brand
AOP upload history
Financial Year
YTD Actuals Upload — admins only · stored separately in actuals.json
Same format as the AOP: Brand | Partner | Model | FY | Mth | P&L columns (Secondary Sales, Net Sales af Prov, COGS, CM1 …). SKU rows are added up automatically. Brand: the Brand column is used, exactly as for the AOP (e.g. Chumbak, Hipkoo); Sub Brand is kept underneath it. GBL Garden adds up its brands via the Brand master. Everything is kept: every numeric column is stored (standard P&L lines and any extra columns), so reports can change without a re-upload. Only text columns are left out, and listed. Mth: 4=Apr … 12=Dec, 1=Jan … 3=Mar (month names also work). FY: only the current FY (FY27) is accepted. Full or partial file: only the Brand × FY × Month combinations in the file are replaced; everything else stays as it is. Check first: nothing is saved until you review the check — new months, corrections to months already loaded (old → new), and lines no longer in the file (set to 0).
or paste below
Actuals loaded — months with data, by Brand
Upload history
GMV Estimate — Month wise (AOP shown for reference)
Not Due collects across the credit period — these invoices are raised within
creditDays of the cycle start, so they fall due over the first creditDays days.
0–30 and 31–60 are placed by the channel’s own credit period —
the bucket is age since invoice, so it falls due creditDays − age from now, and anything already
past due collects in month 1. On 30d terms both land in month 1; on 60d, 31–60 in month 1 and
0–30 in month 2; on 90d, 31–60 in month 2 and 0–30 in month 3.
61–90, 91–120, >120, SOR and MUDA are never collected automatically —
recover them with the ± Adj Override row in the collections working below, or they stay in closing debtors all cycle.
📋 Paste — columns: Partner | Model | Not Due | SOR | 0–30 | 31–60 | 61–90 | 91–120 | >120 | MUDA
Collections Working — Rolling Forecast
Auto-calculated. Use adjustment row to override per partner-model.
Opening Creditors — Vendor wise
Paste vendor balances and/or payment overrides. Opening buckets pay on fixed slots — >180 in month 1, 121–180 in month 2, 91–120 in month 3, 61–90 in month 4, 31–60 in month 5, 0–30 in month 6 — independent of credit terms, so a cycle shorter than 6 months leaves the later buckets unpaid. Not Due pays after the credit period. Paste to override per vendor per month.
📋 Opening Balances
Vendor | Expense Line | Not Due | 0–30 | 31–60 | 61–90 | 91–120 | 121–180 | >180
💸 Payment Overrides
Vendor | Expense Line | Jul | Aug | Sep | Oct | Nov | Dec
Opening Inventory — by season (₹ Cr)
Stock Movement — by season
Seasonal and Non-Core inwards are entered manually (₹ Cr). S40, Core, Purple and Diamond are solved from the target cover below. Outwards are derived from the Season Split sub-tab. MUDA is never inwarded.
Below CM3 Expenses — AOP vs LE
AOP values auto-populated. Enter LE monthly values (₹ Cr) — feeds into GST Input Credit below.
Overheads - Direct — line items — YTD, LE and AOP by line (₹ Cr, 4 decimals as the lines are small); the LE total is the Overheads - Direct LE above
📋 Paste from Excel — columns: Line | one column per month (LE, ₹ Cr, as in the Download)
GST Movement — ITC vs Output
Input tax credit accumulates monthly. Output GST from LE NSV. Net cash impact = ITC utilized − Output GST paid.
Internal Loan Movement
Internal Interest Movement
External Loan Movement
External Interest Movement
Primary Sales — Partner-Model wise, with Shipping, WH and Packaging from the MIS
Pry Gross Qty = Sales Qty · Pry Net Qty = Sales Qty + Returns Qty (returns are negative) · NSV = Sales NSV + Returns NSV (from the primary upload) ·
Shipping = MIS "Shipping Fee - WH to MP/Consumer" · WH = MIS "WH Cost" · Packaging = MIS "Packing Cost" (MIS = the YTD Actuals upload).
Rows in amber are Partner-Models not mapped to this brand.
Primary Sales Upload — anyone with edit access to the brand · stored separately in primary.json
Columns: Month | Partner | Model | Sales Type | Qty | NSV | Brand. Rows for the same Brand, Month and Partner-Model are added up. Month: mmm-yy (e.g. Apr-26); only the current FY (FY27) is accepted. Sales Type: Sales or Returns. Returns: Qty and NSV negative. NSV must be in full rupees (₹), not in ₹ Cr or ₹ Lakh — e.g. 1,25,000, not 0.0125. The view converts it to ₹ Cr / ₹ Lakh. A file whose NSV is under ₹1 per piece is stopped at Check (it is almost certainly in Cr). Checks: Brand must be in the Brand master and editable by you; Partner-Model must be in the Partner-Model master. Any failing row stops the upload. A Partner-Model not mapped to the brand is accepted and shown in amber. Full or partial file: only the Brand × Month combinations in the file are replaced; everything else stays as it is. Nothing is saved until you review the check — new months and corrections to months already loaded (old → new).
or paste below
Primary sales loaded — months with data, by Brand
Upload history
Stores — Fixed Costs - Offline and Overheads - Rent — Store and Kiosk channels (₹ Cr, 4 decimals): Fixed Costs - Offline by header you add, Overheads - Rent by store (YTD, LE and AOP)
📋 Paste from Excel — columns: Store | Partner — Model | Line | one column per month (LE, ₹ Cr, as in the Download)
+ Add a store not in the AOP:
+ Add a Fixed Costs - Offline header:
Brand Marketing — activities — each activity and its amount by month (₹ Cr); for planning only, it does not feed any other tab yet
📋 Paste from Excel — columns: Activity | one column per month (₹ Cr, as in the Download). New activity names are added.
+ Add an activity:
Compare Cycles — two cycles of the same brand, months both cover, every Cash Flow line
Consolidated — a saved selection of one cycle per brand · YTD Actuals month-wise, then LE month-wise from each cycle · Cash Flow format · shows only the brands (and, for view users, the published cycles) you have access to