Free formats for lenders
Collection sheets and import formats used by Indian NBFCs, Nidhi companies, microfinance institutions and credit co-operatives. CSV — opens in Excel or Google Sheets. No signup.
Daily Collection Sheet format
One row per borrower due today — what the field agent carries and fills in.
12 columns · collection-sheet-format.csv
Customer master import format
Bulk-load your existing borrower list. These are the exact columns Byaj Batta imports.
15 columns · customer-import-format.csv
Loan book import format
Bring a live book across with balances intact — one row per running loan.
13 columns · loan-import-format.csv
Member shareholding format (Nidhi)
Initial share allotment per member — folio, shares and nominee.
8 columns · shareholding-format.csv
These are the formats the software actually reads
They are not illustrative samples. The column names above are the ones Byaj Batta's importers match on, so a file you fill in today uploads into a trial without being reshaped — customers, a live loan book with balances, or a Nidhi member share register.
The importer matches columns by name rather than position, shows you the mapping to confirm, and reports the rows it could not match before anything is written.
Frequently asked
Are these formats free to use?
Yes. Download, edit and use them in your own business — no signup, no watermark, no attribution needed.
What should a daily collection sheet contain?
The collection date, the agent, and one row per borrower falling due that day with loan number, name, mobile, EMI due, any overdue, total due, and a blank column for the amount actually collected. Anything more and the agent stops filling it in.
Can I import these straight into Byaj Batta?
Yes — these are the column sets the importers expect. Fill the file, start a free trial, and upload it. The importer maps columns automatically and tells you which rows it could not match before anything is saved.
Do I need to keep the column order?
No. The importer reads column names, not positions, and shows you the mapping to confirm before it commits.