Canara Bank Stock Statement Form Nf 902 Excel Format

A spot to list policy numbers and expiry dates (the bank needs to know the stock is covered). Declaration Clause:

Segregated by quantity and value.

Access the Canara Bank website or use reliable sources to download the NF902 in the desired format, such as PDF or Excel. NF 902 Stock Statement | PDF | Money - Scribd

: Use =SUM(Cell1:Cell2) to aggregate stock values and creditors.

Filter your aging report to separate debtors under 90 days from those over 90 days. Input these figures. canara bank stock statement form nf 902 excel format

. In the world of Canara Bank, this wasn't just a piece of paper; it was the "Inventory and Receivables" declaration that proved his business was healthy. He didn't want a static PDF. He needed a dynamic Excel format so he could: Auto-calculate the total value of raw materials. unpaid stocks to find the "Eligible Stock." Apply the margin (usually 25%) to see his drawing power. 💻 The Digital Transformation

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

: It helps track unpaid stocks and aging debtors.

Sign the declaration that the stock is insured and that all figures are accurate. Where to Download Canara Bank Stock Statement NF 902 You can obtain the form from: A spot to list policy numbers and expiry

Statement Date (usually the last day of the preceding month) Account Number and Branch Name 2. Inventory / Stock Details

Request an updated Excel template directly from your relationship manager.

: Description of commodity, quantity, unit rate, and total value.

Specify pieces, kilograms, meters, or tons. NF 902 Stock Statement | PDF | Money

: Typically submitted monthly or quarterly to the branch manager to determine the drawing power of a Cash Credit (CC) account.

Note: Your actual Drawing Power can never exceed your Sanctioned Limit. If your calculated DP is ₹50 Lakhs but your sanctioned limit is ₹40 Lakhs, your usable limit remains ₹40 Lakhs. Consequences of Delayed or Incorrect Submission

An Excel sheet allows you to pull data directly from your accounting software (like Tally Prime or Zoho Books), ensuring absolute alignment with your financial books.