Every balance accrues simple interest to the date above — principal × (1 + rate × days ÷ 365), counting both endpoints exactly as the workbook does. Rollups are computed live from the Transactions sheet, never read from the pasted Summary tab. Amounts in ₹.
Running total of credits less debits by the month each entry was booked. Interest is excluded, so the line shows capital movement only.
Accrued balance per party across every credit and debit. Bars running right in teal — you owe them; bars running left in red — they owe you.
Net accrued balance grouped by the rate on each entry. Deeper steps mark the higher rates.
Net accrued balance by how long each entry has been outstanding.
Principal booked each year — credits above the line, debits below. Interest excluded.
Asset register at stated valuations, less what you owe parties, plus what parties owe you.
Every party in the Transactions sheet, credits and debits alike. A positive net balance means you owe them; negative means they owe you. Click a row to expand its entries.
| Counterparty | Entries | Net principal | Interest | Net accrued |
|---|
Rows where the spreadsheet's own accrued columns are blank or point at the wrong cell. Every figure above uses the recomputed value; this table shows what the workbook says instead.