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 excluded here β use the IC Check tab for those.
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