Canara Bank Stock Statement Form Nf 902 Excel - Format |work|

Goods paid for but not yet physically received. 3. Aging of Book Debts (Receivables)

Estimated sales for the current accounting year. Actual Sales: Actual sales made during the month. Production: Production figures for the current year. Part C: Sundry Debtors (Receivables)

Excel formulas automatically compute totals, reduce manual errors, and calculate the Drawing Power (DP) instantly.

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. canara bank stock statement form nf 902 excel format

: Do not include dead, damaged, or slow-moving stock in your inventory values.

Filing an incorrect NF 902 form can result in your account being flagged, penal interest charges, or a temporary freeze on your withdrawals. Keep these rules in mind:

Quantity, rate, and total value of unprocessed stock. Work-in-Progress (WIP): Semi-finished goods valued at cost. Goods paid for but not yet physically received

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

Prevent the sheet from showing a borrowing capacity higher than your actual loan agreement. : =MIN(Calculated_DP_Cell, Sanctioned_Limit_Cell) Important Rules for Canara Bank Stock Submissions

Details actual production vs. estimates and age-wise analysis of receivables (debtors) and creditors. How to Use the Excel Format for Calculations Actual Sales: Actual sales made during the month

Enter your Company Name, Account Number, and the Date of the Stock Statement (e.g., as of 31st May 2026).

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