What a bank actually asks for in a loan file
Bank loan reports are the financial documents a lender reads before it sanctions or renews credit. What the branch asks for depends on the facility, and knowing the list in advance removes most of the back-and-forth that slows an application.
- Working capital facilities — cash credit, overdraft and working capital demand loans are assessed on CMA data (Credit Monitoring Arrangement): past and projected operating statements, balance sheet analysis, comparative statement of current assets and current liabilities, MPBF computation, fund flow, cash flow and ratio analysis.
- Term loans — plant and machinery, building or equipment finance is appraised on a project report, also called a detailed project report or DPR: project cost, means of finance, projected statements, EMI repayment schedule, DSCR, break-even and ratios.
- Both — audited balance sheets and profit and loss statements for the last few years, provisional figures for the current year, income tax returns, bank statements and the firm's registration details.
Requirements differ from bank to bank and scheme to scheme, so confirm the exact annexures with the relationship manager before you start. The statements themselves, though, change very little.
Why manual preparation is slow
The same data is asked for in three or four different shapes. Sales and expenses appear in the operating statement, the profit and loss account and the cash flow. The balance sheet is required on its own and again inside the MPBF working and the comparative statement. When each document is built in its own spreadsheet, the preparer ends up entering the same figures repeatedly and reconciling them line by line afterwards.
The linkages create the second problem. Ratios, DSCR and MPBF must be computed from the balance sheet figures, and a late change to an assumption invalidates every calculation that followed it. In a manual file, the change has to be traced through each sheet, which is where reporting time quietly doubles.
Where automation removes the work
| Task | Without automation | With software |
|---|---|---|
| Entering historical figures | Rekeyed into each new document | Entered once, reused across CMA data, project report and balance sheet |
| Building linked statements | Separate formulas per sheet and year | All statements calculated from one set of inputs |
| Ratios, DSCR and MPBF | Typed and rechecked by hand | Calculated, with both MPBF methods shown together |
| Formatting for the bank | Retyped or pasted into a fixed layout | Exported as PDF, Excel or Word in the standard format |
| Renewal and enhancement | Rebuilt from last year's file | Updated in the existing master, with comparative years shown |
Matching the tool to each part of the pack
One part of the loan file usually takes the longest, so the sensible approach is to automate that first rather than convert everything at once.
Balance sheet. The balance sheet software turns a grouped trial balance into a schedule-wise balance sheet that tallies, with the Trading and Profit & Loss Account, capital account, depreciation schedule and ratio analysis produced from the same figures. If the books live in Tally, export the Trial Balance as XML from TallyPrime or Tally.ERP 9 and upload it; the software suggests a mapping for each group and ledger, which you review and correct before importing, then you enter the closing stock to complete the build.
CMA data. The CMA report software builds the complete pack a working capital proposal needs, including the operating statement, balance sheet analysis, comparative statement, both MPBF methods, turnover method, fund flow, cash flow, DSCR, ratio analysis and the depreciation and EMI schedules. Audited and provisional figures already prepared in the balance sheet module can seed the historical years instead of being typed again.
Project report. For a term loan, the project report software assembles the project cost, means of finance, projected statements, EMI schedules, DSCR, ratio analysis, break-even and the turnover method and MPBF working, with the report years set in the project master.
A faster preparation sequence
- Confirm the facility and the annexures the bank wants before entering anything.
- Collect the source documents: audited financials, provisional figures, ITR, bank statements, loan sanction letters and repayment position.
- Post the last few years into the balance sheet master once, importing the Tally trial balance where the books allow it.
- Reuse those years in the CMA data or the project report, then set the projection assumptions for the current and future years.
- Review the calculated ratios, DSCR, fund flow and MPBF, adjusting assumptions rather than formulas.
- Export each document in the format the branch prefers and check the annexures against the request list.
Build the file once, then renew from it
Working capital limits are reviewed every twelve months, and each review asks for fresh provisional figures and revised projections. Once the borrower's master holds the audited years, the loan terms and the opening balances, a renewal becomes an update rather than a rebuild. Closing balances carry forward, the comparative statements show the year-on-year movement the bank wants to see, and the ratio and MPBF working recalculates from the updated figures without any fresh formulas.
The same logic applies to a project report. The project master keeps the cost lines, the funding pattern and the loan schedules, so a revised projection means changing an assumption rather than redoing the document. Over a few years the saved data becomes the real time saving, because the second and third submissions start from figures that were already checked once.
Checks that repay the time they take
Automation removes arithmetic errors, not judgement errors, and a short review before submission still earns its keep. Look at the numbers a credit officer looks at. A current ratio that has slipped below the usual benchmark, a DSCR that is thin in the early repayment years, total outside liabilities to net worth (TOL/TNW) that has crept up, or a fall in the margin of safety all need an explanation in the file rather than a correction after the query.
Then confirm the mechanics: the balance sheet tallies in every year, the comparative statement matches the standalone statements, the MPBF working sits on the same figures as the balance sheet, and the totals on screen match the download. If the report uses rounding on the projected years, check that the same rounding is applied in every format you send.
Getting started
Before committing to a tool, look at a finished document. The samples page carries completed CMA data, project report and balance sheet files in PDF, Word and Excel, which is the quickest way to see whether the format matches what your bank has been asking for. From there, prepare the part of the file that takes you longest and expand once the first report is out.
