Form Nf 902 Excel Format __top__ | Canara Bank Stock Statement

: A breakdown of outstanding customer invoices, classified by age (usually up to 90 days and above 90 days).

Net Eligible Stock=Total Value of Stock−Sundry Creditors for Paid Stock EligibilityNet Eligible Stock equals Total Value of Stock minus Sundry Creditors for Paid Stock Eligibility canara bank stock statement form nf 902 excel format

Bold header with branch address, loan a/c number, and statement period. Row 7: Column headers – Sl No, Item Description, HSN Code, UOM, Qty, Rate, Value, Stock Type, Aging (Days), Remarks . Rows 8-25: Inventory data with alternating row colors for readability. Row 26: TOTAL : =SUM(Value_Range) . Row 28: Less: Obsolete/Stock > 90 days : manually entered or extracted via SUMIF . Row 29: Eligible Stock Value : formula. Row 30: Margin @ 25% : =Eligible*0.25 . Row 31: Drawing Power : =Eligible - Margin . Row 33-40: Declarations – "We hereby certify that the stock is insured...", signature line, date, place. Row 41: Prepared by and Checked by with date stamps. : A breakdown of outstanding customer invoices, classified

Copy the quantities and values into the respective Raw Material, WIP, or Finished Goods columns. Rows 8-25: Inventory data with alternating row colors

: Late submission attracts penal interest rates. Key Components of Form NF 902 Excel Template

To obtain the Canara Bank stock statement form NF 902 in Excel format, follow these steps:

:Filter out old invoices based on your sanction criteria (e.g., excluding debtors older than 90 days). Excel Formula: =SUM(Debtors_Under_90_Days_Cells)