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.
Quantity, rate, and total value of unprocessed stock. Work-in-Progress (WIP): Semi-finished goods valued at cost.
| H | I | J | K | L | |---|---|---|---|---| | | Closing Stock Value (₹) | Stock Pledged to Bank (₹) | Deficit (if any) | Remarks |
When downloading and using the Excel template, ensure the following columns are accurately filled:
This header section identifies your business and your specific credit account. Name of the Borrower / Business Entity Account Number (CC/OD Account) Name of the Branch canara bank stock statement form nf 902 excel format
Delayed submission can lead to "penal interest" or the account being flagged as "irregular," which might freeze your ability to withdraw funds. Canara Bank OCC Stock Statement NF 902 | PDF - Scribd
Your Excel form must contain:
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
Armed with his laptop and a printed copy of his Excel-generated NF 902, Arjun headed to the branch. Mr. Rao looked over the neat rows of data and the clear calculations. Ensure that the sales and purchase figures implied
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
(create these as headers in Row 1)
Drawing Power is the actual amount of money you are allowed to withdraw from your CC account at any given time. It is directly tied to the margins stipulated in your Canara Bank sanction letter. Standard Margin Example
The is a mandatory monthly declaration for businesses holding Cash Credit (CC) or Overdraft (OD) facilities. It provides a snapshot of current inventory and receivables, which the bank uses to calculate your Drawing Power (DP) —the actual amount you can withdraw from your sanctioned loan limit. 📂 Key Components of NF 902 Work-in-Progress (WIP): Semi-finished goods valued at cost
Captures details of raw materials, work-in-progress (WIP), and finished goods. It includes opening stock, purchases ("Stock In"), sales ("Stock Out"), and closing stock for the period.
This section provides a macro-view of your business's monthly financial activity.
Failure to submit can result in the bank reducing your drawing power to zero or charging penal interest on your CC account.
