GBL Cash Projection Tool

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

AOP Source Brand(s)

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

	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 (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

	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

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

CODB Line Item	Expense Line Item

Marketplace Deduction Mapping

For each Brand → Partner-Model, tick which CODB line items are deducted by the marketplace (reduces Collectable — not a separate cash payment).

Use the Brand and CODB item dropdowns in the table header to filter rows/columns.

AOP Data Upload

Upload AOP plan data — same format as the source file (SKU-level rows are aggregated automatically).
Columns: Brand | Partner | Model | FY | Mth | (metric columns...)
Mth: 4=Apr 5=May 6=Jun 7=Jul 8=Aug 9=Sep 10=Oct 11=Nov 12=Dec 1=Jan 2=Feb 3=Mar
Scope: One or multiple brands/sub-brands per paste.
Overwrite rule: Overwrites at Sub Brand × FY × Month level. Upload FY28 for a brand without touching its FY27 data.
GBL Garden: Upload sub-brands (Hipkoo, Pet Crux etc.) directly — tool aggregates into GBL Garden via Brand master.
Multi-year cycles: Tool picks FY27 data for Jul–Mar months and FY28 data for Apr–Jun months automatically.

Admin only — replaces AOP for brands included in paste.

GMV Estimate — Month wise (AOP shown for reference)

Ratio / Rate Overrides — leave blank to use AOP ratio

Derived LE P&L — calculated from LE GMV × ratios

Opening Debtors — Partner-Model wise

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)

Seasonal

S40

Core

Non-Core

MUDA / Dead Stock

Stock Movement — by season

Seasonal and Non-Core inwards are entered manually (₹ Cr). S40 and Core 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.

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