Complete loan book
ICDs, inter-corporate deposits, debentures (OCD/CCD/NCD) and consumer loans — tranche-level, with sanctioned limits, drawing power, asset classification and closures, all in one register.
A complete loan book of record, an actual/365 interest engine that reconciles to the paisa, and submission files accepted by TransUnion CIBIL, Experian, Equifax and CRIF High Mark.
A complete loan book of record, an interest engine that reconciles to the paisa, and submission files accepted by all four bureaus.
ICDs, inter-corporate deposits, debentures (OCD/CCD/NCD) and consumer loans — tranche-level, with sanctioned limits, drawing power, asset classification and closures, all in one register.
An actual/365 per-tranche accrual engine that ties to your audited workbook to the last paisa. Per-tranche rates, NPA accounts accrue nil, and every month reconciles.
UCRF V3.10 commercial pipe-files, TUDF V3.74 consumer files and data-submission Excels for all four bureaus — generated as one ZIP per cycle, byte-faithful to accepted submissions. Weekly cycles carry only what changed; month end carries the full book.
Missing PANs, addresses, classifications and date inconsistencies are reported as errors and warnings before generation, rather than on rejection by the bureau.
Weekly book, monthly loan book, monthly interest book and outstanding-as-on — plus dues dashboards for collections and interest — every one exportable to Excel and reconcilable line-by-line with your workbook.
Sanctioned-limit checks on every drawdown, duplicate-PAN and account-number blocking, role-based access, per-entity isolation, and a full transaction audit trail.
Load the book once, then run each reporting cycle as a repeatable process with validation before submission.
Import parties, agreements and transactions from Excel, or enter them directly.
Drawdowns, repayments, closures — validated against limits at entry.
Pre-filing checks confirm every borrower and account is bureau-complete.
One ZIP: txt, TUDF and Excel for all four bureaus, named and formatted to spec.
The operating parameters Bureaulens is built to hold on every reporting cycle.
What changes when the loan book, the interest engine and the bureau files are one system rather than a chain of workbooks.
| Capability | Bureaulens | Spreadsheets + manual filing |
|---|---|---|
| Bureau files | Generated, spec-exact | Hand-built each cycle |
| Interest accrual | Per-tranche engine, 365-day | Formulas that drift |
| Validation | Before submission | On rejection by the bureau |
| Limit & PAN controls | Enforced at entry | Found at audit |
| Closures & NPAs | Cycle-aware automatically | Adjusted by hand each cycle |
| Multi-entity | Isolated tenants, one login | One workbook per entity |
| Audit trail | Every transaction, every user | Limited and manual |
A 30-minute walkthrough on your own data — your agreements, your reporting cycle and your bureau member IDs.