Canara Bank Stock Statement Form Nf 902 Excel Format

The Canara Bank Form NF 902 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)

Excluded Category Section: Values to be deducted for calculating drawing limits, such as: Stocks purchased on credit (Trade Creditors). Slow-moving or obsolete stocks. Goods in transit or held in outstation godowns.

Related Posts:

Canara Bank NF 902 form is a standard "Stock Statement cum MSOD" (Monthly Selection of Operational Data) used by business borrowers to report inventory levels for Cash Credit (CC)

| S.No | Particulars | Unit | Quantity | Rate | Value (Rs.) | | :--- | :--- | :--- | :--- | :--- | :--- | | 1 | Raw Materials | | | | | | 2 | Work in Progress | | | | | | 3 | Finished Goods | | | | | | 4 | Stores & Spares | | | | | | 5 | Total Stock | | | | =SUM() | canara bank stock statement form nf 902 excel format

Part A: Stock Statement: Details quantities and market values of Raw Materials, Work-in-Process (WIP), and Finished Goods.

Method 4: Create Your Own Master Excel Template

If you cannot find an official version, you can build a compliant NF 902 Excel file using the structure described above. Use Excel’s SUM, SUMIF, and IF functions to automate totals and drawing power. The Canara Bank Form NF 902 is the

In simple terms, this form is your declaration to the bank about:

A complete stock statement report typically includes the following sections: Slow-moving or obsolete stocks