What financial consolidation means in a lending file
In day-to-day finance, consolidation often means group accounts: combining a parent and its subsidiaries, eliminating intercompany balances and translating currencies. That work has its own specialist tools. The consolidation this article covers is the one an Indian borrower or its chartered accountant actually performs, which is pulling the figures for a business into a single, consistent set of statements that a bank can read across several years.
The file usually carries three layers: audited history, the current year's provisional figures, and projections for the years the loan will run. Keeping those layers consistent is the real task, because the closing balance of one year becomes the opening balance of the next, and a change in one assumption has to flow through the operating statement, the balance sheet and the ratios.
Where a borrower operates through more than one concern, the same discipline applies within each set of books, and the bank is shown the position concern by concern. The common thread in every version is that the figures should agree with one another without a round of manual reconciliation at the end.
Why assembling the pack by hand is slow and fragile
A pack can be assembled in a spreadsheet, and for a single year it often is. The difficulty is repetition and linkage:
- Each year is a separate workbook, so a revised figure has to be traced through copies by hand.
- Opening balances are keyed in rather than carried forward, which is how comparatives drift apart.
- Statements that should agree, such as the balance sheet, the fund flow statement and the MPBF computation, are prepared separately and reconciled afterwards.
- Projected years are built on assumptions that live in someone's notes rather than in the file.
None of this is a criticism of the spreadsheet as a tool. It is what happens when a linked set of statements is rebuilt every year in a general-purpose application, and the cost shows up as the reconciliation work at the end of the process rather than at the start.
What Finxora holds together
Finxora keeps the structure that makes a multi-year pack consistent. The modules share data inside the application, so a finished balance sheet year can seed the historical years of a CMA report or a project report instead of being keyed in again. That single source is what removes the differences that appear when the same figures are entered twice.
The pieces that come together in one file are:
- Statements from a shared set of inputs: operating statement, balance sheet analysis, comparative statement of current assets and current liabilities, fund flow, cash flow and ratio analysis.
- Working-capital computations: maximum permissible bank finance under both methods and the turnover-method requirement, so the assessed limit can be read from the same balance sheet.
- Debt-service measures: DSCR for each projected year, with an average row.
- Supporting schedules: the depreciation chart and EMI repayment schedules, and on the project side the break-even and sensitivity analysis.
- A ratio set covering liquidity, profitability, leverage, activity, expense and growth, calculated from the figures rather than typed in.
Years that carry forward
The reason a consolidated pack stays consistent is that each year's closing position becomes the next year's opening figures. In Finxora, years can be marked audited, provisional or projected, which matches how banks ask for financials: past audited years, the current provisional year and future projected years side by side. Depreciation, reserves and loan balances follow through the whole span rather than being re-entered per year, and the comparative layout places the reporting year beside the previous one, column for column.
That carrying-forward is also what makes a renewal cheaper to prepare than a first application. A working-capital limit is normally reviewed each year, and the review needs updated provisional figures and revised projections. Because the borrower's master stays saved, the exercise updates the later years instead of rebuilding the file, and the movement the bank wants to see is visible in the comparatives.
What "real time" means here
Real-time consolidation is a phrase that is easier to promise than to deliver, so it is worth being literal. What Finxora offers is live recalculation: because every statement draws on the same inputs, a change to an assumption recalculates the operating statement, the balance sheet, the fund flow, the MPBF computation and the ratios together. There is no manual re-keying step and no separate reconciliation between documents, which is usually the delay between a figure being decided and a figure appearing in the pack. It is not a live feed from a bank or an enterprise resource planning system, and Finxora does not present itself as one.
Building the pack, step by step
- Set up the borrower and the years to be reported, marking each year audited, provisional or projected.
- Enter the historical figures, or carry them forward from a balance sheet already prepared in Finxora.
- Import the trial balance from Tally if the books live there, and review the mapping before it is applied.
- Set the projection assumptions and check the ratios, fund flow and MPBF that the application calculates from them.
- Confirm that the balance sheet tallies and the comparatives agree, then export the pack.
Where Finxora fits, and where it does not
Finxora is built for the statements an Indian bank asks a borrower for: CMA data for working-capital limits, project reports for term loans and new units, and balance sheets in the standard Schedule III presentation. If the task is group consolidation accounting with intercompany eliminations and multi-currency translation, that is a different problem, and a different class of software is designed for it.
Within its scope, the counterpart is that the pack is consistent by construction. The balance sheet software handles the statements and notes, the CMA and project report modules handle the borrowing documents, and every one of them draws on the same figures.
Exports and review
Each report downloads as a formatted, print-ready PDF, and also as an Excel workbook or a Word document for further working. You choose which statements go into a download, so a renewal file and a first application can carry different annexures while still drawing on one master. The samples collection shows how the statements print, and the plans are listed on the pricing page.
In summary
Consolidation for a bank submission is about one consistent set of figures spanning audited, provisional and projected years, with supporting computations that agree with the statements. Hold the figures once, let each year carry forward into the next, and let every document draw on the same data. The pack then agrees with itself, which is the point the credit team is checking.
