1
Upload
Jun-26
Jun-26
2
Map
by Brand
by Brand
3
Recon vs
Summary
Summary
4
Checks &
IC Loans
IC Loans
5
Full
Report
Report
Jun-26 Brand Files (21 brands expected)
ℹ️
Upload each brand's Jun-26 cash file. The tool reads the "3 tier CF - Direct method" sheet for reconciliation, and the Data sheet for transaction detail.
The consolidated report will combine your pre-loaded FY22–May26 history with the new Jun-26 data.
The consolidated report will combine your pre-loaded FY22–May26 history with the new Jun-26 data.
ℹ️
Reconciliation in progress...
ℹ️
How this works: We compare each brand's Data sheet totals against their own 3-tier CF summary. A mismatch means an error in the brand's file — not in your consolidation. All brands are consolidated regardless; mismatches are flagged for follow-up.
Brand Reconciliation — Jun-26
Confirm Brands for Consolidation
ℹ️
All 21 expected brands shown below. Red = not uploaded or recon mismatch — excluded by default. You can override recon failures by ticking them. Not-uploaded brands cannot be ticked.
IC Loans Check — Group Level (Jun-26)
ℹ️
Rule: Across all brands, Debt Investment - Internal (Loan given) must net to zero against Debt Repayments - Internal (Loan repaid) at group level. Valid only after all 21 brands are uploaded.
| Brand | Debit (Inflow ₹) All IC inflow lines | Credit (Outflow ₹) All IC outflow lines | Net (₹) | Status |
|---|
All Issues
View:
All FY
FY22
FY23
FY24
FY25
FY26
FY27
Jun-26 Only
3-Tier Cash Flow Statement
Other Line Items Check
Find and remap individual transactions — filter by Brand + Grouping
ℹ️
Find transactions mapped to the wrong CF line. Filter by Brand and/or Grouping label (raw name from brand file), then remap individual rows. Changes take effect immediately in the consolidated report.
IC Loan lines are included in the remap dropdown — you can remap any transaction to an IC line if needed. The IC Check tab will reflect changes immediately.
Brand
Grouping (raw label)
Current CF Line
Particulars keyword
Export Current Month —
Exports all consolidated transactions for with full detail:
Brand, Grouping, BANK, GL, Date, Particulars, Inflow, Outflow, Net, CF Line, Activity.
Cash Waterfall
Brand-Level Summary