Canara Bank Stock Statement Form Nf 902 Excel Format Guide

If you are a business owner or a trader holding a Cash Credit (CC) or Overdraft (OD) account with Canara Bank, you are likely familiar with the monthly ritual of submitting your stock details. The standard "Stock Statement" is a crucial document that the bank uses to assess the drawing power of your account based on your current inventory and receivables.

For years, borrowers have struggled with manual paperwork, but the digital age offers a simpler solution. In this post, we are sharing the Canara Bank Stock Statement Form NF 902 in Excel format to make your monthly reporting quick and error-free. canara bank stock statement form nf 902 excel format

Create an "Age in Days" column. Use a formula if you have receipt dates: =IF(TODAY() - Receipt_Date > 90, "Slow/Non-moving", "Fast Moving") Most banks will exclude or heavily discount stock older than 90–180 days from drawing power. If you are a business owner or a

Use one worksheet for the inventory table and a separate summary sheet for calculations. Freeze the header row for easy data entry. Enable Data Validation for the "Classification" column (allow only Raw Material, WIP, Finished Goods, Consumables). Create an "Age in Days" column

Follow these steps to create NF 902 in Excel: