ABC PRIVATE LIMITED
Monthly MIS – FY 2026-27
View Month
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
NameEmailAccessCompaniesStatusLast loginActions
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
Ledger Mapping

Complete
Variance Check

Review
Unmapped Ledger

0
Balance Sheet

Review if not balanced
Abnormal Movement

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
👁 Fixed Asset Working
👁 Debtor Working
👁 Creditor Working
👁 GST Working
👁 TDS Working
👁 Working Capital
👁 Chart Data
👁 Raw TB Data
👁 Audit Trail
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.