D Lahiri & Associates · Chartered Accountants
This portal is designed for borrowers to submit comprehensive stock audit data to their lending bank. Your submission will be compiled into a certified, time-stamped, IP-tracked PDF report and sent to the bank. Please read these instructions before filling in your details.
Enter borrower name, contact details, company name & type, registered address, PAN, and all GSTIN numbers. Use the "Add GSTIN" button for multiple registrations.
Select and fill in all Loan Accounts (CC, OD, TL etc.) and Other Accounts (Current, Savings, FD etc.) with account numbers and bank names.
Fill in the details table for all persons in charge — Name, Address, Occupation, PAN, Phone, and Email. Also enter the names of Account-In-Charge, Store Keeper, and General Manager.
Set the cut-off date first — all months in the summary tables will auto-populate based on this date (April onwards to the cutoff month). Then fill in Slow Moving Items, Stock in Transit, Monthly Turnover/Purchase, Inventory, Debtors/Creditors summaries.
Enter the Debtor Aging table as on the cutoff date (aging buckets: ≤90 days, 90–180 days, >180 days — totals auto-calculate). Fill in GST monthly details from GSTR-3B including taxable value, CGST, SGST, IGST.
For each required document — Sales & Purchase Transaction Statements, Stock Statements, Audit Report, Debtors & Creditors Lists and Statutory Licenses — indicate whether it is Will be Provided, Will Not be Provided, or Not Applicable. All documents marked as Provided must be sent via email to [email protected] along with the generated PDF report.
Review all data and choose an authentication method: Mobile OTP (simulated), Secure PIN, Name Declaration, or ID Reference. Your IP address, timestamp, and authentication token are embedded in the PDF on Page 1. All subsequent pages are deemed authenticated.
D Lahiri & Associates, Chartered Accountants
D Lahiri & Associates · Chartered Accountants · Bank Stock Audit Borrower Module v1.0
Basic identification and contact information
Add all GSTIN registrations. Click "+ Add GSTIN" for multiple registrations.
All banking facilities and accounts maintained
Details of authorised persons and key personnel
| # | Name * | Address * | Occupation * | PAN * | Phone * | Email * | Del |
|---|---|---|---|---|---|---|---|
| 1 |
Monthly summaries, slow moving items, stock in transit
| # | Product Name * | Quantity of Stock * | Value (₹) * | Del |
|---|---|---|---|---|
| 1 |
| # | Product Name * | Quantity * | Value (₹) * | Invoice No. * | Invoice Date * | Del |
|---|---|---|---|---|---|---|
| 1 |
| # | Month * | Turnover (₹) * | Purchase (₹) * |
|---|
| # | Month * | Raw Materials (₹) * | WIP (₹) * | Finished Goods / Stock in Trade (₹) * | Store Items (₹) * | Method of Valuation * |
|---|
| # | Month * | Debtors (₹) * | Creditors (₹) * |
|---|
Aging analysis and GST return data
| # | Name of Debtor * | Upto 90 Days (₹) * | 90–180 Days (₹) * | More than 180 Days (₹) * | Total (₹) — Auto | Del |
|---|---|---|---|---|---|---|
| 1 | ||||||
| TOTAL | 0 | 0 | 0 | 0 | ||
| # | Month / Quarter * | Taxable Value (₹) * | CGST (₹) * | SGST (₹) * | IGST (₹) * | Invoice Value (₹) — Auto |
|---|
Indicate document status for all required documents to be submitted
Indicate the status for each statutory document. Mark as Provided, Will Not be Provided, or Not Applicable based on your business type.
Verify all data, sign digitally, and download the complete PDF
Choose an authentication method to certify and submit your report. Your IP address and timestamp are automatically recorded.
An OTP will be simulated to the registered phone number on file.
Create a 4–6 digit PIN as your authentication token. This PIN will be embedded in the PDF as your authorization code.
Type your full legal name exactly as it appears on PAN card to authenticate this submission by name declaration.
Provide an official government ID reference to authenticate. The ID number will be embedded in the PDF as the authentication token.