Management Dashboard
Revenue
Selected period
COGS
Direct cost
Gross Profit
Margin 0.00%
EBITDA
Margin 0.00%
PBT
Profit before tax
PAT
Margin 0.00%
Cash & Bank
Closing balance
Working Capital
Current assets less current liabilities
Sales & Gross Profit Trend
Month-wise movement in Sales and Gross Profit
Sales
Gross
Profit
EBITDA Trend
Operating profitability by month
EBITDA
Profit Waterfall
How Sales converts into Gross Profit, EBITDA, PBT and PAT for the selected
month
Management / Cross-check Highlights
Automated exceptions from the MIS engine
Annual / Monthly TB Import
Import Tally TB Excel with Particulars + Closing Balance
(Dr/Cr). Blank amounts become 0.
TB Import Status
No annual TB imported yet. Upload the complete year-to-date workbook; the system will detect all available
months automatically.
Total Ledgers
30
Total Debit
Total Credit
Difference
Status
TB Balanced
Imported TB Preview
Raw imported values are not modified by mapping.
| Particulars | Closing Debit | Closing Credit |
|---|
Ledger Mapping Master
Auto-suggested mapping is editable. Unmapped ledgers must be reviewed.
Mapping for Selected Month
| Ledger | Debit | Credit | Parent Head | Head | Sub-Head | Schedule | Nature | Status | Action |
|---|---|---|---|---|---|---|---|---|---|
Schedules
This is the bridge between imported TB and final outputs.
Schedule Ledger Detail
| Ledger | Schedule | Nature | Debit | Credit | Signed Balance |
|---|
P&L
Calculated only from mapped schedules.
| Particular | Amount | Source |
|---|
Monthly Growth %
Current Month vs Previous Month. If previous month is zero, growth is shown as N/A.
| Metric | Current Month | Previous Month | Growth % |
|---|
Balance Sheet
Balance sheet schedules are shown separately from P&L schedules.
Assets
| Particular | Amount |
|---|
Liabilities & Equity
| Particular | Amount |
|---|
Financial Comparison & Benchmark Analysis
Period comparison and historical average benchmark analysis across financial periods.
Comparison Results
Key financial output metrics and variances
| Metric | Base Period | Comparison Period | Variance | Variance % | Status |
|---|---|---|---|---|---|
| Select analysis filters above to view comparison results. | |||||
Detailed Comparison
Schedule and ledger-level variance analysis across selected financial periods
| Schedule / Group | Ledger Name | Target Period | Comparison Period | Variance | Variance % |
|---|---|---|---|---|---|
| Select schedule and ledger filters above to view detailed comparison results. | |||||
Formula & Calculation Master
Transparent formula definitions used by the calculation engine.
| Output | Schedule Source | Formula / Logic | Editable |
|---|---|---|---|
| Revenue | Revenue Schedule | Sum of mapped Revenue credit balances | Yes |
| COGS | COGS Schedule | Sum of mapped COGS balances | Yes |
| Gross Profit | P&L | Revenue - COGS | Yes |
| EBITDA | P&L | Gross Profit - Employee Cost - Operating Expenses | Yes |
| PBT | P&L | EBITDA - Depreciation - Finance Cost | Yes |
| PAT | P&L | PBT - Tax | Yes |
| Working Capital | Balance Sheet | Total Assets - Total Liabilities & Equity | Yes |
Users & Access
Who can log in and which companies they can see. Clients see only the Dashboard, P&L, Balance Sheet, Comparison and Notices of their own companies, and cannot change anything.
Users
| Name | Access | Companies | Status | Last login | Actions |
|---|
CFO Observations
Automatically generated CFO-level interpretation from the imported Trial Balance.
CFO Commentary: This section converts the imported TB
into management observations. For the demo, the expected message is high profit but cash stuck in
receivables.
Key CFO Observations
CFO Action Tracker
Suggested management actions based on detected issues
| Priority | Observation | Why It Matters | CFO Action | Status |
|---|
CFO Executive Commentary
CFO View:
Import a Trial Balance to generate the CFO commentary. The commentary will highlight profitability, cash
conversion, receivables and working-capital risks.
MIS Checking & Exception Center
All detected issues for the selected month are listed here.
EBITDA is negative. Review operating cost schedules.
Abnormal COGS movement: -87.33% vs Apr.
Abnormal Operating Expenses movement: -87.76% vs Apr.
TB Check
Loaded
Loaded
Ledger Mapping
Complete
Complete
Variance Check
Review
Review
Unmapped Ledger
0
0
Balance Sheet
Review if not balanced
Review if not balanced
Abnormal Movement
Review
Review
Company Master 0 companies
Each company has its own TB history and ledger-mapping profile. One HTML file can
manage multiple companies independently.
Sheet Management
Choose what appears on the main navigation.
Main Screen Sheets
📄 Dashboard
📄 TB Import
📄 Ledger Mapping
📄 Schedules
📄 P&L
📄 Balance Sheet
📄 Comparison
📄 Formula Master
📄 Checking Center
📄 Revenue Working
📄 Opex Working
📄 COGS Working
📄 Employee Cost Working
Hidden / Available Sheets
Settings
Government Notices
Dashboard
Custom MIS sheet.
This sheet is available for your custom reporting structure. Use Excel import/export or add
it to the MIS workflow as required.
TB Import
Custom MIS sheet.
This sheet is available for your custom reporting structure. Use Excel import/export or add
it to the MIS workflow as required.
Ledger Mapping
Custom MIS sheet.
This sheet is available for your custom reporting structure. Use Excel import/export or add
it to the MIS workflow as required.
Schedules
Custom MIS sheet.
This sheet is available for your custom reporting structure. Use Excel import/export or add
it to the MIS workflow as required.
P&L
Custom MIS sheet.
This sheet is available for your custom reporting structure. Use Excel import/export or add
it to the MIS workflow as required.
Balance Sheet
Custom MIS sheet.
This sheet is available for your custom reporting structure. Use Excel import/export or add
it to the MIS workflow as required.
Comparison
Custom MIS sheet.
This sheet is available for your custom reporting structure. Use Excel import/export or add
it to the MIS workflow as required.
Formula Master
Custom MIS sheet.
This sheet is available for your custom reporting structure. Use Excel import/export or add
it to the MIS workflow as required.
Checking Center
Custom MIS sheet.
This sheet is available for your custom reporting structure. Use Excel import/export or add
it to the MIS workflow as required.
Revenue Working
Custom MIS sheet.
This sheet is available for your custom reporting structure. Use Excel import/export or add
it to the MIS workflow as required.
Opex Working
Custom MIS sheet.
This sheet is available for your custom reporting structure. Use Excel import/export or add
it to the MIS workflow as required.
COGS Working
Custom MIS sheet.
This sheet is available for your custom reporting structure. Use Excel import/export or add
it to the MIS workflow as required.
Employee Cost Working
Custom MIS sheet.
This sheet is available for your custom reporting structure. Use Excel import/export or add
it to the MIS workflow as required.