How it works

Your loan book, bureau-ready in seven steps.

BureauLens runs the whole cycle — load the book, record activity, accrue interest to the paisa, validate, generate every bureau file, and reconcile. Here's exactly how, stage by stage.

Step by step

From loan book to bureau-accepted, end to end.

Seven stages take you from setting up an entity to filing all four bureaus and reconciling every figure — without a single hand-edited row.

Set up your entity & bureau identities

Create your NBFC (or each entity in a group) and enter the member IDs, header user IDs, TL member codes and cycle IDs issued by each bureau. Nothing is hardcoded — every entity files under its own credentials, and a super-admin console oversees the group.

  • Member IDs for CIBIL, Experian, Equifax, CRIF
  • Per-entity isolation, one super-admin login
  • Configurable cycle ID and header identities

Load the loan book

Import parties, agreements and transactions from Excel, or enter them directly. Every borrower carries a PAN (format-checked and duplicate-blocked), constitution, addresses and directors; every agreement carries its segment, sanctioned limit, drawing power, asset classification and tranche schedule.

  • Excel import with row-level validation
  • ICDs, debentures (OCD/CCD/NCD) and consumer loans
  • Tranche-level — each drawdown at its own date and rate

Record activity as it happens

Post drawdowns and repayments through the year. Sanctioned limits are enforced at entry — a drawdown that would breach the limit is rejected with the exact headroom; over-repayments warn. Loans close with full history retained, and reopen if needed.

  • Sanctioned-limit checks on every drawdown
  • Duplicate PAN and account-number blocking
  • Closures retain history; cycle-aware for filing

Interest accrues to the paisa

An actual/365 engine accrues interest per tranche at each tranche's own rate. When a loan turns NPA, income recognition stops on the classified date — interest earned before that date is preserved, nothing after is accrued. Monthly and FYTD figures reconcile with your audited workbook exactly.

  • Actual/365, per-tranche rates
  • NPA stops accrual from the classified date
  • Monthly interest book ties to the workbook

Validate before you file

Run the pre-filing check for the cycle. Missing PANs, addresses, classifications and date problems surface as errors and warnings on screen — so you fix them here, not in a rejection email from the bureau three days later.

  • Errors vs warnings, per borrower and account
  • Catches what bureaus reject
  • Cycle-aware inclusion of closures and NPAs

Generate & submit

One click produces a single ZIP per cycle: commercial UCRF V3.9 pipe-files, consumer TUDF files, consumer data-submission Excels and a commercial working Excel — one set per bureau, named and formatted to spec, byte-faithful to previously accepted submissions.

  • UCRF txt + TUDF + Excel, all four bureaus
  • One ZIP per fortnightly cycle
  • Reproduces historical cycles exactly as filed

Report & reconcile

Weekly book, monthly loan book, monthly interest book and outstanding-as-on — each exportable to Excel and reconcilable line-by-line with your workbook. A dashboard shows the position as on any date, with a full transaction audit trail behind every figure.

  • Four reports, all Excel-exportable
  • As-on-date dashboard (month or FY)
  • Every transaction and user audited
How it works

From sign-up to shipping in minutes.

No setup, no training, no procurement cycles. Open a chat and start working.

  1. Load the book

    Import parties, agreements and transactions from Excel, or enter them directly.

  2. Record as you go

    Drawdowns, repayments, closures — validated against limits at entry.

  3. Validate the cycle

    Pre-filing checks confirm every borrower and account is bureau-complete.

  4. Generate & submit

    One ZIP: txt, TUDF and Excel for all four bureaus, named and formatted to spec.

By the numbers

Receipts, not promises.

Real performance from teams shipping with BureauLens every day.

0
Bureaus Covered
0
Cycles a Year
0
Day-Count Basis
0
Hand-Edited Rows
FAQ

Questions, answered.

Which bureau file formats does BureauLens generate?
Commercial UCRF V3.9 pipe-delimited text files, consumer TUDF files, consumer data-submission Excel workbooks, and a commercial working Excel (BS/AS/RS/CR sheets) — one set per member ID for TransUnion CIBIL, Experian, Equifax and CRIF High Mark, packaged as a single ZIP per cycle.
How accurate is the interest engine?
Actual/365 with inclusive day-count, applied per tranche at each tranche's own rate. NPA accounts accrue nil, matching standard income-recognition practice. Customers reconcile it against audited workbooks to the paisa.
Can we import our existing loan book from Excel?
Yes. Parties, agreements and transactions import from Excel templates with row-level validation — duplicates are blocked, limit breaches are skipped with reasons, and nothing silently changes.
How are bureau member IDs and headers managed?
Every member ID, short name, TUDF header user, TL member code and cycle ID is configurable per bureau in Settings. Nothing is hardcoded — each entity files under its own identities.
Does it support multiple NBFCs in one group?
Yes. BureauLens is multi-tenant: each entity's parties, loans, transactions and bureau settings are fully isolated, with a super-admin console for subscriptions across the group.
What about closures, NPAs and historical cycles?
Loans close with full history retained. Filing generation is cycle-aware: a loan live on the cycle date appears in that cycle even if closed later, so historical regeneration always matches what was actually filed.

The best AI assistant. Yours in 30 seconds.

Free forever to start. No credit card. Cancel anytime — but you won't want to.

Request a demo See how it works