Canara Bank Stock Statement Form Nf 902 Excel Format -

Use the formula =SUM(Range) to calculate the total gross value of the stock.

Form NF 902 is Canara Bank’s prescribed stock statement format for reporting inventory/stock positions. The Excel format offers a structured, tabular template for branches and clients to report opening balances, receipts, issues, adjustments, and closing balances for specified reporting periods. It’s designed to simplify reconciliation, regulatory compliance, and internal audit processes.

Generally found under the 'Downloads' > 'Forms' section, labeled as "Stock Statement - NF902." canara bank stock statement form nf 902 excel format

To set up your Excel formulas correctly, follow this standard mathematical logic used within the NF 902 structure:

Visit your nearest Canara Bank branch or ask your Relationship Manager for the official Excel reference format. Use the formula =SUM(Range) to calculate the total

Gross Stock Value [-] Sundry Creditors (Unpaid Stock) [=] Net Paid Stock [-] Bank Margin on Stock (e.g., 25%) [=] Eligible Value of Stock (A) Eligible Book Debts (Under 90 Days) [-] Bank Margin on Debtors (e.g., 40%) [=] Eligible Value of Debtors (B) Total Calculated Drawing Power = (A) + (B)

Details actual production vs. estimates and age-wise analysis of receivables (debtors) and creditors. How to Use the Excel Format for Calculations estimates and age-wise analysis of receivables (debtors) and

: Items like drugs or chemicals older than 6 months or expiring soon must be specifically disclosed. Canara bank stock statement form: Fill out & sign online