Canara Bank Stock Statement Form Nf 902 Excel Format -

The is the standard "OCC Stock Statement cum MSOD" used by borrowers with Cash Credit facilities to report monthly inventory and sales. While the official form is often distributed as a PDF, it is frequently converted into Excel format to automate the calculation of Drawing Power (DP). Standard Report Structure (NF 902)

: Always deduct Sundry Creditors. If you have not paid your suppliers for the raw materials, the bank will not finance those items.

Do not include debtors older than 180 days (or the specific timeline in your sanction letter) in your DP pool.

This section lists raw materials, semi-finished goods, and finished goods. Excel formulas must calculate the net value after deducting unpaid stocks to avoid double financing. Rate per Unit Total Value Less: Unpaid Stock / Sundry Creditors Net Value of Stock Raw Materials Data Data =Qty*Rate Data =Total-Unpaid Semi-Finished Data Data =Qty*Rate Data =Total-Unpaid Finished Goods Data Data =Qty*Rate Data =Total-Unpaid =SUM(...) =SUM(...) =SUM(...) 3. Book Debts / Sundry Debtors (Receivables) canara bank stock statement form nf 902 excel format

: Submit the statement before the 10th or 15th of every month (verify the exact date in your sanction letter). Late submission results in penal interest charges.

| S.No | Particulars | Unit | Quantity | Rate | Value (Rs.) | | :--- | :--- | :--- | :--- | :--- | :--- | | 1 | Raw Materials | | | | | | 2 | Work in Progress | | | | | | 3 | Finished Goods | | | | | | 4 | Stores & Spares | | | | | | 5 | | | | | =SUM() |

Do you need an integrated column built into the template? Share public link The is the standard "OCC Stock Statement cum

Provide the to automate the 90-day debtor filtering.

A section for debtors, usually categorized as 90 days. The Insurance Detail:

Always submit the statement by the 7th of every month (or as specified in your loan agreement) to avoid penalty interest. If you have not paid your suppliers for

If you are creating or downloading an Excel template for NF 902, it must contain three distinct sections to be compliant with Canara Bank standards.

: Monthly breakdown of opening stock, stock "in," stock "out," and final closing stock.

By following the guidelines and steps outlined in this article, customers can easily prepare and submit the Canara Bank stock statement form NF 902 in Excel format.