GBL Cash Projection Tool

These four masters are the single source of truth. Changes here flow into all other tabs. All data is auto-saved.

Brand master

Brand, Brand Group and Cohort are all free-text — enter exactly as you use them internally.

Brand

Brand group

Cohort

Brand	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 — enter as you like.

Partner

Model

Partner group

Partner	Model	Partner group

Brand → Partner-Model mapping

Brand and Partner-Model are selected from their masters above. Credit period and GMV grouping are free-text.

Brand

Partner — Model

Credit period (days)

GMV grouping

Brand	Partner	Model	Partner group	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.

Expense line item

Category

GST rate %

ITC eligible (Y/N)

Expense line item	Category	GST rate	ITC eligible

Pre-upload AOP NSV by partner model. Use the LE column to update latest estimates — these feed the collection projection.

FY27 Sales plan Values in ₹ Crores. Blue = AOP, editable = LE.

Partner	Type	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec	Jan	Feb	Mar	FY Total

Opening debtors upload (as of last month-end)

Upload monthly. Include MUDA, SOR-not-collectable, SOR-collectable and current ageing buckets.

MUDA (write-off)

SOR — not collectable

SOR — collectable

Current debtors

Partner	Total OS	MUDA	SOR (N/C)	SOR (Coll)	0-30d	31-60d	61-90d	91-120d	>120d	Collectable
Total

Monthly collection projection

Formula: Collectable debtors ÷ credit-period days × days-in-month + collections from current month sales

Total collectable (op debtors)

₹0.00 Cr

Projected H1 collections

₹0.00 Cr

Partner	Cr days	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec	Jan	Feb	Mar	Total

Opening creditors (vendor-wise with ageing)

Upload monthly. Map vendor to expense head. Ageing = days since invoice date.

Vendor	Expense head	Total OS	0-30d	31-60d	61-90d	>90d	Cr days	Due in Apr	Due in May	Due in Jun	Due in Jul+
Total

CODB payment schedule (from AOP)

Auto-calculated from AOP monthly CODB × credit period. Editable for known variances.

Expense head	Cr days	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec	Jan	Feb	Mar	FY Total

GST input credit calculation

Line item	Rate	Apr	May	Jun	FY Proj
Total input credit

GST output liability

Channel / partner	Rate	Apr	May	Jun	FY Proj
Net GST cash outflow

Monthly GST cash impact summary

Input credit accrued (Apr-Jun)

₹0.00 Cr

Output liability (Apr-Jun)

₹0.00 Cr

Net GST payable (Apr-Jun)

₹0.00 Cr

Estimated annual TDS

₹0.00 Cr

Opening cash (Apr)

₹0.00 Cr

FY projected collections

₹0.00 Cr

FY projected outflows

₹0.00 Cr

Net BAU cash required (FY)

₹0.00 Cr

Opening cash balance (₹ Cr) Internal funding / GBL support (₹ Cr / month)

Line item	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec	Jan	Feb	Mar	FY Total

ⓘ All values in ₹ Crores. Positive = cash inflow. Negative = cash outflow. Net BAU cash = inflows − outflows before funding. Funding requirement = max(0, −closing cash).