Type your figures, or click Fill from Excel(or drop a file here) to fill the table from a workbook in the template's format, then click Analyse. Files are read in your browser and never uploaded. Use one unit throughout (for example ₹ crore). Leave rows you don't have blank and they're skipped. Rows marked * are required. Rows marked auto can be left blank: when you click Analyse they are calculated from their parts, as in the template, and shown in colour. A figure you type there is used as is. Cells accept sums such as 4.92+56.24, and you can paste a block copied from Excel.
| Item | FY24 | FY25 | FY26 |
|---|---|---|---|
| Balance sheet | |||
| Capital & liabilities | |||
| Capital | |||
| Reserve Fund | |||
| Other Reserve | |||
| Depositsauto | |||
| Deposits- Demand | |||
| Deposits- Term | |||
| Borrowingsauto | |||
| Borrowings- Interbank | |||
| Borrowings- Repo | |||
| Interest Payable | |||
| Other Liabilities - Derivatives, Sub Debt etc. | |||
| Profit (Loss) | |||
| Current Tax Liabilitiesauto | |||
| Assets | |||
| Cash + Balance with CB | |||
| Balances with other Banks | |||
| Balances with other Banks as FDR | |||
| Securities bought under repo | |||
| Investmentsauto | |||
| Investments (Amortised cost) | |||
| Investments (non-Amortised cost) | |||
| Loans & Advances (Amortised cost) | |||
| Interest Receivable | |||
| Bills Purchased & Discounted | |||
| Fixed Assets | |||
| Investment in properties | |||
| Other Assets | |||
| Total Assetsauto | |||
| Profit & loss | |||
| Income | |||
| Interest Income | |||
| Other Income | |||
| Total Incomeauto | |||
| Expenses | |||
| Interest Exp | |||
| Operating Exp | |||
| Other Operating Exp | |||
| Total operating Expauto | |||
| Provision (Loans & contingencies) | |||
| Profit | |||
| Profit before provisions & taxauto | |||
| Profit before taxauto | |||