Canara Bank Stock Statement Form Nf 902 Excel Format __full__ -
Creating an error-free stock statement is straightforward if you follow a systematic approach.
Typically monthly. Check your loan sanction letter. For large limits (> ₹5 crore), weekly or fortnightly statements may be required.
Manually filling out a paper-based NF 902 form is time-consuming and prone to mathematical errors. Utilizing an Excel template provides distinct operational advantages: canara bank stock statement form nf 902 excel format
=IF([@Age]<=90,[@Amount],0) to separate eligible book debts from ineligible ones.
: The table monitors specific tracking parameters across columns: Creating an error-free stock statement is straightforward if
After filling out the form, you need to submit it to the bank or depository participant. You can submit the form:
It helps the bank monitor the and ensure the stock coverage is adequate against the sanctioned limit. For large limits (> ₹5 crore), weekly or
You must deduct stock for which you have not yet paid your suppliers. Banks will not finance unpaid stock, as suppliers hold the primary lien on those goods. 3. Book Debts / Sundry Debtors (Receivables Aging) This section tracks the money your customers owe you.
: Typically submitted monthly or quarterly to the branch manager to determine the drawing power of a Cash Credit (CC) account.
: Sundry creditors represent unpaid stock. You must deduct them from the gross stock value to calculate net security.
Debtors must be broken down by age (e.g., less than 30 days, 30–60 days, 60–90 days, and above 90 days).