This is the most critical block in the Excel sheet. It automatically applies bank margins to arrive at the final eligible drawing limit.
: Applies the bank's predefined safety margin percentage to establish the final net Drawing Power. Step-by-Step Guide to Formulating the Excel Sheet
under the "Downloads" section. While the bank primarily provides PDF versions, you can find editable formats on platforms like to export into Excel or Word. Key Components of Form NF 902 The statement generally consists of two parts: Part A: Stock Statement Commodity Details canara bank stock statement form nf 902 excel format
Ensure that the sales and purchase figures implied by your stock variations align closely with your monthly GSTR-1 and GSTR-3B filings. Tax auditors and bank inspectors cross-verify these numbers.
The NF 902 form is known as the "OCC Stock Statement Cum MSOD" (Open Cash Credit Stock Statement Cum Monthly Statement of Outstanding Debtors). It serves two primary purposes: This is the most critical block in the Excel sheet
: Navigate to the Downloads section of the Canara Bank official site; it is listed as "NF 902 - Stock Statement".
| Particulars | Amount (₹) | Remarks | | :--- | :--- | :--- | | | ₹ 18,71,500 | | | Less: Excluded Category (e.g., Stocks Purchased on Credit) | ₹ 27,53,261 | Negative? -> Report figure likely an example; in actual practice, value under this head is deducted | | Less: Margin (e.g., 25%) | ₹ ... | | | Net Drawing Power | ₹ ... | | Step-by-Step Guide to Formulating the Excel Sheet under
The primary purpose of Form NF 902 is to calculate the of your account. The bank uses this data to verify that the value of your current assets (inventory and outstanding debtors) adequately covers the amount of money you have borrowed. Why You Need Form NF 902 in Excel Format
The Canara Bank Stock Statement Form (also known as the "OCC Stock Statement cum MSOD") is available for download on the official Canara Bank website
Form NF 902 is the standardized stock and receivables statement format prescribed by Canara Bank. It acts as a financial health monitor for the bank to assess the value of the primary security hypothecated against a working capital loan. Why Banks Require Form NF 902
: The table monitors specific tracking parameters across columns: