SMART Notebook 18

    Various financial portals, CA websites, and forums provide editable NF 902 templates. Ensure the layout matches the bank’s current guidelines. Check for the following:

    Exclude damaged, expired, or non-moving inventory from your valuations.

    under the "Downloads" section. Many third-party financial platforms also offer fillable Excel templates that mirror the official structure for easier digital submission. step-by-step guide

    A complete stock statement report typically includes the following sections:

    Banks subtract unpaid creditors from your total stock value. This is because goods that you haven't paid for yet cannot be fully financed by bank funds. 5. Drawing Power (DP) Calculation Matrix

    Forgetting to deduct Sundry Creditors is the most common reason banks reject stock statements.

    : Borrowers must specify the location/address where the stock is stored. Part B: Production and Sales Statement

    Keeps your monthly data structured uniformly, making historical comparisons easier for your finance team.

    Using the NF 902 form in Excel format offers several benefits, including:

    Goods paid for but not yet physically received. 3. Aging of Book Debts (Receivables)

    If your loan facility includes drawing power against book debts, you must list your outstanding invoices. Canara Bank requires an aging breakdown because older debts are considered riskier:

    : Eligibility depends on your specific sanction terms.

    : It ensures the loan is backed by sufficient inventory.

    If you're a business owner with a working capital loan from Canara Bank, you're likely familiar with the monthly hustle of submitting stock statements. The

    : It determines your actual Drawing Power (DP).