Free CA Tool — Bank CMA Format

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.

ITR-5 & 6Auto-read JSON
MPBFTandon Method II
DSCREvery projected year
₹0PDF + Word
The Generator

Build your CMA report in 6 steps

Takes about 5 minutes. You can edit every figure before the report is generated.

Project Report Builder
Free CMA report for bank loan applications
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.

Please review and approve all years before proceeding.
Step 3: Current Year Provisional Figures
Provisional

All amounts in Rs. Lakhs.

Profit & Loss
Balance Sheet
Liabilities
Total Liabilities
Assets
Total Assets
Assets and Liabilities don't tally - difference of Rs. Lakhs. You can still proceed; double-check the figures if this matters for your submission.
Step 4: Forecasting Assumptions

Set growth percentages for each projected year.

Parameter
Step 5: Project Cost & Means of Finance

Optional - leave zero if this report is for working capital assessment only.

Project Cost (Rs. Lakhs)
Total Project Cost
Means of Finance (Rs. Lakhs)
Promoter's Equity
Term Loan
Subsidy / Grant
Total
Debt-Equity Ratio:
Project Cost and Means of Finance should tally.
Loan Repayment Terms
Loan Amount (Rs. Lakhs)
Interest Rate (%)
Tenure (Years)
Moratorium (Months)
Project Report
Entity
PAN
Report Period
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 CostRs. Lakhs%
Total100%
Means of FinanceRs. Lakhs%
Promoter's Equity
Term Loan
Subsidy / Grant
Total100%
Debt-Equity Ratio:
Working Capital Assessment (MPBF - Tandon Method II)
Standard formulas shown for reference - confirm current margin % and bank conventions before relying on these figures for an actual submission.
Current Assets (Debtors + Stock + Cash + Other)
Current Liabilities (excl. bank borrowings)
Working Capital Gap
MPBF (75% of CA - CL)
Drawing Power
Key Financial Ratios
RatioValueCommentary
TOL/TNW
DSCR
ROCE
Working Capital Cycle
Financial Charts & Dashboard
Revenue & PAT Trend (Rs. Lakhs)
Margin Trends (%)
Debt-Equity Ratio Trend
Interest Coverage Trend (EBIT / Interest)
Loan Amortization Schedule (Rs. Lakhs)
Get this report by email and WhatsApp
You'll receive both a PDF and a Word (.docx) version by email, and the PDF on WhatsApp.
✓ Verified
Why Switch

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
See The Output

This is what you'll download.

The same layout the generator produces. Switch the tabs to see each part of the report.

Download Sample PDF
CMA Report – Sharma Traders Pvt Ltd.pdf

Sharma Traders Pvt Ltd

CMA Report · FY 2023-24 to 2028-29 · ₹ in Lakhs

Bank-ready
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

Working capital gap52.40
Less: 25% long-term funds− 14.20
MPBF 38.20
Term loan ₹50 L · 10.5% · 5 years 76% repaid by Year 4
 
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

Working capital gap52.40
Less: 25% from long-term funds− 14.20
MPBF 38.20
Term loan ₹50.00 L · 10.5% · 5 years 75.8% repaid by Year 4
 
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.

What's Inside

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.

Implementation Process

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.

01
Under 30 mins

Upload ITR JSON

Last two years, straight from the Income Tax portal.

02
1–2 days

Check the figures

We read them for you — edit anything that looks off.

03
Same day

Add projections

Growth %, project cost and loan terms.

04
Ongoing

Download & submit

PDF and Word, ready for your bank or CA.

Who It's For

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

Cash credit / overdraft — new or renewal
Working capital enhancement
Term loan for expansion or machinery

Starting a new business? This tool needs 2 years of filed ITR, so it suits existing businesses.

The Basics, Explained

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.

01

MPBF

Maximum Permissible Bank Finance

The most working capital a bank will lend. Method II expects 25% of current assets from long-term funds.

02

DSCR

Debt Service Coverage Ratio

Cash available for repayment ÷ loan repayments. Banks commonly look for 1.25 or higher.

03

TOL / TNW

Outside Liabilities vs Net Worth

Shows how much of the business is funded by outside liabilities versus owners.

04

Current Ratio

Current Assets ÷ Current Liabilities

Measures short-term liquidity. Many banks expect at least 1.33 for working capital.

ERP Group Accounting

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.

Common questions

Frequently Asked Questions About ERP Group CRM Software.

Yes. The full report in PDF and Word is free, with no watermark and no sign-up.

Log in to incometax.gov.in, go to e-File → Income Tax Returns → View Filed Returns, choose the assessment year and download the JSON. Repeat for the previous year.

ITR-5 (partnership firms, LLPs) and ITR-6 (companies). You can edit any figure after upload.

The report follows the standard CMA structure used by Indian banks. Requirements vary by bank and many ask for a CA's certification, so we recommend a CA review before you submit.

Your ITR files are used only to generate your report and are not shared with anyone.

The tool needs two years of filed ITR, so it is built for existing businesses. A new business usually needs a detailed project report (DPR) instead.

MPBF (Maximum Permissible Bank Finance) is the maximum working capital a bank can lend. This tool uses Tandon Committee Method II, where you fund at least 25% of current assets from long-term sources.

Most banks look for an average DSCR of 1.25 or more. The report shows DSCR for every projected year so you can see where you stand.

Yes. Every figure read from your ITR can be edited in step 2, and you can go back to any step before generating the report.

PDF and Word (.docx). You can also print it or get both files by email.
Free CA Tools

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