Receipts/purchases brought into the facility during the month. Consumption/dispatches moving out of the facility. Closing volumetric stock and individual item unit rates. Part B: The Production and Sales Review

Statement Date (usually the last working day of the previous month) 2. Inventory / Stock Details (Item-wise Valuation)

Securing and maintaining a working capital limit like a cash credit (CC) or overdraft (OD) facility requires regular compliance. For business owners and accounts professionals dealing with Canara Bank, submitting the monthly inventory and debtors report is a mandatory ritual. This reporting is done using a specific document known as .

: Banks use the statement to determine the maximum amount you can withdraw from your CC limit based on the "Net Value" of your stock after applying a margin (often 25%). Compliance

Securing and maintaining a working capital limit, such as a Cash Credit (CC) or Overdraft (OD) facility, requires consistent compliance. For Canara Bank borrowers, the most critical monthly compliance task is submitting the stock statement.

: Split into imported and indigenous goods. This isolates high-risk or long-transit items.

: Save each month’s Excel file with a clear naming convention (e.g., Canara_NF902_March_2026.xlsx ) along with the corresponding inventory reports from your accounting software. To help customize this template for your business, tell me:

: A formal statement confirming the goods are the borrower's property, are fully insured, and are valued accurately. 📊 Excel Format Structure

A: You can download the NF 902 form from the Canara Bank website by visiting the "Forms" or "Downloads" section.

The sum of the funded stock value and funded debtor value. Step-by-Step: How to Calculate Drawing Power in Excel

S.No | Item | Unit | Open | Purchase | Sale | Close | Rate | Close Value | Pledged 1 | Steel Coils | Kgs | 500 | 300 | 400 | 400 | 150 | 60,000 | 60,000 2 | Cement bags | Nos | 200 | 100 | 50 | 250 | 400 | 1,00,000 | 1,00,000 | | | | | | | | 1,60,000 | 1,60,000

Gross Stock Value [-] Sundry Creditors (Unpaid Stock) [=] Net Paid Stock [-] Bank Margin on Stock (e.g., 25%) [=] Eligible Value of Stock (A) Eligible Book Debts (Under 90 Days) [-] Bank Margin on Debtors (e.g., 40%) [=] Eligible Value of Debtors (B) Total Calculated Drawing Power = (A) + (B)