Free CMA Report Generator straight from your ITR
Upload last two years' ITR JSON and the figures fill in automatically. Add projections and download a complete bank loan report in PDF and Word.
Build your CMA report in 6 steps
Takes about 5 minutes. You can edit every figure before the report is generated.
Step 1: Upload ITR JSON Files
Upload ITR-5 or ITR-6 JSON files from the Income Tax Portal for the last 2 financial years. All extracted figures are in Rs. Lakhs. You can edit any value before proceeding.
Step 3: Current Year Provisional Figures
All amounts in Rs. Lakhs.
| Total Liabilities |
| Total Assets |
Step 4: Forecasting Assumptions
Set growth percentages for each projected year.
| Parameter | Projected | |
|---|---|---|
|
%
|
Step 5: Project Cost & Means of Finance
Optional - leave zero if this report is for working capital assessment only.
| Total Project Cost |
| Promoter's Equity | |
| Term Loan | |
| Subsidy / Grant | |
| Total |
| Loan Amount (Rs. Lakhs) | |
| Interest Rate (%) | |
| Tenure (Years) | |
| Moratorium (Months) |
Project Report
| Entity | |
| PAN | |
| Report Period |
1. Executive Summary & Credit Appraisal Overview
Comparative Profit & Loss (Rs. Lakhs)
| Particulars | |
|---|---|
Comparative Balance Sheet - Capital Structure (Rs. Lakhs)
| Particulars | |
|---|---|
Cash Flow Summary (Rs. Lakhs)
| Particulars | |
|---|---|
Project Cost & Means of Finance (Rs. Lakhs)
| Project Cost | Rs. Lakhs | % |
|---|---|---|
| Total | 100% |
| Means of Finance | Rs. Lakhs | % |
|---|---|---|
| Promoter's Equity | ||
| Term Loan | ||
| Subsidy / Grant | ||
| Total | 100% |
Working Capital Assessment (MPBF - Tandon Method II)
| Current Assets (Debtors + Stock + Cash + Other) | |
| Current Liabilities (excl. bank borrowings) | |
| Working Capital Gap | |
| MPBF (75% of CA - CL) | |
| Drawing Power |
Key Financial Ratios
| Ratio | Value | Commentary |
|---|---|---|
| TOL/TNW | ||
| DSCR | ||
| ROCE | ||
| Working Capital Cycle |
Click "Generate AI Insights" above for benchmark commentary against banking norms on each ratio.
Risk Analysis & Mitigation
| Category | Description | Level | Mitigation |
|---|---|---|---|
Financial Charts & Dashboard
Loan Amortization Schedule (Rs. Lakhs)
No term loan entered in Step 5 - amortization schedule not applicable.
Year-wise repayment of the term loan of Rs. Lakhs at % p.a. over years with a moratorium of months.
| Year | Opening | Interest | Principal | EMI | Closing |
|---|---|---|---|---|---|
ERP Group vs Paid CMA Tools vs Excel Templates
Most online CMA tools let you preview for free, then charge ₹499–₹999 to download. Here's what you get without paying a rupee.
| Feature | ERP Group | Paid CMA Tools | Excel Template |
|---|---|---|---|
| Cost & Access | |||
| Full report with no per-report fee | ₹499–₹999 | ||
| No sign-up or login needed | Often required | ||
| Download without watermark | Paid plan | ||
| Data Entry | |||
| Figures auto-read from ITR JSON | |||
| Edit any figure before generating | Paid plan | ||
| Balance sheet tally check | Manual | ||
| Bank-Ready Output | |||
| MPBF by Tandon Method II | Manual formulas | ||
| DSCR & key ratios for every year | Manual formulas | ||
| Loan repayment schedule | Manual | ||
| PDF + Word download | Paid plan | Excel only | |
This is what you'll download.
The same layout the generator produces. Switch the tabs to see each part of the report.
Download Sample PDFSharma Traders Pvt Ltd
CMA Report · FY 2023-24 to 2028-29 · ₹ in Lakhs
| Particulars | Actual | Projected | ||
|---|---|---|---|---|
| Particulars | FY24 | FY25 | FY26 | FY27 |
| Revenue from operations | 182.40 | 214.75 | 246.96 | 284.00 |
| EBITDA | 21.60 | 26.30 | 30.87 | 36.07 |
| Interest | 4.10 | 4.60 | 5.25 | 4.71 |
| Depreciation | 2.80 | 3.10 | 3.40 | 3.60 |
| Net profit after tax | 11.20 | 14.05 | 16.66 | 20.82 |
| Ratio | FY26 | FY27 | Status |
|---|---|---|---|
| DSCR | 1.62 | 1.74 | Good |
| Current ratio | 1.38 | 1.41 | Good |
| TOL / TNW | 2.10 | 1.92 | Watch |
| Debt : Equity | 1.85 | 1.52 | Good |
MPBF · Tandon Method II
| Year | Opening | Interest | Principal | Closing |
|---|---|---|---|---|
| Year 1 | 50.00 | 4.97 | 8.20 | 41.80 |
| Year 2 | 41.80 | 4.01 | 8.90 | 32.90 |
| Year 3 | 32.90 | 3.03 | 9.90 | 23.00 |
| Year 4 | 23.00 | 1.99 | 10.90 | 12.10 |
| Ratio | FY26 | FY27 | Status |
|---|---|---|---|
| DSCR | 1.62 | 1.74 | Good |
| Current ratio | 1.38 | 1.41 | Good |
| TOL / TNW | 2.10 | 1.92 | Watch |
| Debt : Equity | 1.85 | 1.52 | Good |
MPBF · Tandon Method II
| Year | Opening | Interest | Principal | Closing |
|---|---|---|---|---|
| Year 1 | 50.00 | 4.97 | 8.20 | 41.80 |
| Year 2 | 41.80 | 4.01 | 8.90 | 32.90 |
| Year 3 | 32.90 | 3.03 | 9.90 | 23.00 |
| Year 4 | 23.00 | 1.99 | 10.90 | 12.10 |
Illustrative figures. Your report uses the numbers from your own ITR.
Built around what your bank's credit officer checks
Repayment capacity
DSCR for every projected year — the first number most banks look at.
Working capital limit
MPBF by Tandon Method II, with working capital gap and drawing power.
Leverage
TOL/TNW and debt-equity ratio, past and projected.
Liquidity
Current ratio and working capital cycle in days.
Growth trend
Revenue, PAT, margin and interest coverage charts.
Loan schedule
Year-wise interest, principal and outstanding balance.
From ITR to bank-ready report in 4 steps
Most Indian businesses go live on ERP Group within 3–7 days. There is no long implementation cycle, no consulting fees, and no disruption to your daily operations.
Made for the people who prepare loan files
CAs & accountants
A first draft for a client in minutes, instead of rebuilding the Excel model every time.
MSME owners
Know your DSCR and eligible limit before you walk into the bank.
Loan consultants & DSAs
Check a file's numbers quickly before you take it forward.
Useful for these loans
Starting a new business? This tool needs 2 years of filed ITR, so it suits existing businesses.
What Is a CMA Report?
A CMA (Credit Monitoring Arrangement) report shows a bank your business's past performance and projected finances. Banks use it to decide how much to lend and whether you can repay — mainly for cash credit, overdraft and term loans.
Your filed ITR already contains your P&L and balance sheet, so reading it directly avoids typing errors and hours of data entry. You still review every figure before the report is built.
Why it matters
A CMA turns your financial figures into the key lending indicators a bank can review.
MPBF
Maximum Permissible Bank Finance
The most working capital a bank will lend. Method II expects 25% of current assets from long-term funds.
DSCR
Debt Service Coverage Ratio
Cash available for repayment ÷ loan repayments. Banks commonly look for 1.25 or higher.
TOL / TNW
Outside Liabilities vs Net Worth
Shows how much of the business is funded by outside liabilities versus owners.
Current Ratio
Current Assets ÷ Current Liabilities
Measures short-term liquidity. Many banks expect at least 1.33 for working capital.
Stop pulling figures from ITR every year
Keep P&L, balance sheet and GST books up to date all year — bank reports take minutes, not days.
Frequently Asked Questions About ERP Group CRM Software.
More Free Tools for CAs & Accountants
Finish client work faster with our free accounting, GST and tax tools — no login required.
Balance Sheet Generator
Schedule III balance sheet, P&L and notes to accounts in minutes
GSTR-1 JSON Generator
Convert your sales Excel into a GST portal-ready GSTR-1 JSON file
Income Tax Calculator
Compare old vs new regime and see your client's tax liability instantly
TDS Calculator
Calculate TDS on salary, rent, professional fees and contracts
GSTIN Validator
Check if a client's or supplier's GSTIN is valid before you file
HSN/SAC Finder
Find the right HSN or SAC code and GST rate for any product or service