How to Fill Your Bank's Credit Analysis Document Using AI

When you apply for a business loan at SBI, HDFC Bank, PNB, or any other scheduled commercial bank in India, the branch will hand you a document to fill before they can process your application. It goes by several names - CMA report, project report, credit appraisal memo - but it is the same thing: a structured financial picture of your business that the bank’s credit officer uses to decide whether to sanction the loan.

Most business owners either pay Rs.5,000-15,000 to a CA to prepare this, or make guesses that get flagged during scrutiny. With ChatGPT and a basic Excel sheet, you can build a first draft yourself in a few hours - one that is accurate, internally consistent, and ready for your CA to review and certify.

What the Document Actually Contains

Every bank in India follows the IBA (Indian Banks’ Association) CMA format. Whether you are applying at SBI, HDFC, PNB, or Canara Bank, the structure is the same. It has six core sections.

The first is your business profile - what you do, how long you have been operating, legal structure, and the promoter’s background. The second is your existing credit facilities, if any. The third and fourth are historical financials - your Profit and Loss account and Balance Sheet for the last two completed years. The fifth is the projected financials - P&L and Balance Sheet for the next three to five years. The sixth is the working capital assessment, where the bank calculates how much operating finance your business needs.

The section that trips up most applicants is the projections. Banks do not expect perfection. They expect internal consistency - your projected revenue must align with your stated capacity, your cost assumptions must be defensible, and your DSCR (the ratio of your annual net cash profit to your annual loan repayment obligation) must be above 1.25 for most lenders.

What You Need Before You Start

Gather these four things before opening ChatGPT or Excel:

Your last two years’ ITR with profit and loss and balance sheet. If you are a proprietorship, this is your personal ITR-3 or ITR-4. If you are a Pvt Ltd or partnership, it is the entity’s ITR-6 along with the audited financials.

Your last 12 months’ bank statements for the primary current account used for business transactions.

A rough breakdown of your monthly expenses - rent, salaries, raw material or inventory cost, electricity, and any existing EMIs on loans.

The loan amount you are requesting and what you plan to use it for - equipment purchase, working capital, expansion, or a mix.

Step 1 - Feed Your Historical Financials to ChatGPT

Open ChatGPT (GPT-4 or GPT-4o). Type the following:

“I am a [type of business - e.g. manufacturing unit / trading business / service provider] in India applying for a business loan. I need to prepare a CMA report in the IBA format. Here are my financials for the last two years. Help me organise them into the standard CMA P&L and Balance Sheet format.”

Then paste in the key numbers from your ITR - total sales, major expense heads, net profit, and the asset and liability totals from your balance sheet. ChatGPT will structure these into the IBA CMA format with the correct line items.

Do not paste your entire ITR as a PDF into ChatGPT - pull out the numbers manually. This takes 20 minutes but prevents errors from misread tables.

Step 2 - Build Your Projections With ChatGPT’s Help

This is where AI saves you the most time. Type:

“Based on my last two years of actual financials above, help me build three-year projections for the CMA report. My business plans to grow revenue by approximately [X]% per year. The loan I am taking is for [purpose]. Ask me any questions you need to make the projections realistic.”

ChatGPT will ask clarifying questions - whether costs are fixed or variable, what your raw material ratio is, whether you have any planned hiring, and so on. Answer these honestly. The output will be a projected P&L for each of the next three years.

Check two things in the projections before moving forward. First, the net profit margin should not jump dramatically from your actual figures without a clear reason. If your historical margin is 8% and your projection shows 22%, the bank will push back. Second, verify that your projected net profit each year, after adding back depreciation, is at least 1.25 times your proposed annual EMI. This is the DSCR check, and failing it is the most common reason projections get rejected.

Step 3 - Transfer to Excel and Write the Business Description

Download the free IBA CMA Excel template - search “IBA CMA format Excel free download” and you will find several versions. The RBI and IBA websites also have standard formats.

Open the template. You will see tabs for each statement. Transfer the numbers ChatGPT helped you structure into the relevant cells. The Excel template has built-in formulas that calculate ratios automatically - current ratio, debt-equity ratio, and the working capital requirement.

Do not modify the formula cells. Only enter data in the unlocked input cells. If a number you enter causes a ratio to show as an error, check whether you have a misplaced figure - the most common cause is entering a number in the wrong year column.

Once the numbers are in, turn back to ChatGPT for the narrative section.

The first section of the CMA - the business profile and project description - is the one most owners write poorly. It needs to cover what your business does, your market, your competitive position, and why you need this specific loan amount. Banks do not need a marketing document. They need a clear explanation of how the business generates cash.

Use this prompt:

“Write a 200-word business description for a bank CMA report. My business is [describe in plain terms]. I have been operating for [X] years. My main customers are [type]. I am applying for a loan of Rs.[amount] for [purpose]. The tone should be factual and professional, not promotional.”

Edit the output to add any specific details ChatGPT would not know - local market context, major clients if they are well-known names, any government registrations like Udyam, FSSAI, or industry-specific licences.

Step 5 - Get a CA to Review and Sign Off

A CA review before submission is not optional. Banks require the CMA to be certified by a practising Chartered Accountant for most loan sizes above Rs.10 lakh. What AI and Excel give you is a clean, internally consistent draft that your CA can verify in 30-60 minutes rather than rebuild from scratch. This typically reduces the CA fee from Rs.10,000-15,000 to Rs.2,000-5,000 for certification-only work.

When you send the draft to your CA, specifically ask them to check that the historical figures match your ITR exactly, that the projected depreciation is calculated correctly on your asset base, and that the working capital calculation uses the right number of operating cycles for your business type.

For the full list of documents you need alongside the CMA when submitting to a bank, read business loan documents required.

To understand how the bank uses your CMA to make their approval decision - and which ratios they scrutinise most closely - read why business loans get rejected.