Canara Bank Stock Statement Form Nf 902 Excel | Format

Canara Bank generally excludes debtors older than 90 days from the drawing power calculation. 4. Creditors Information Total amount owed to suppliers.

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

"Excellent work, Arjun," Mr. Rao said, adjusting his glasses. "Most people forget to exclude stocks older than 90 days or forget to subtract their creditors. Your Excel sheet makes our audit much easier."

Including invoices older than 90 days (or the period specified in your sanction letter) is a compliance violation. canara bank stock statement form nf 902 excel format

: Automatically pulled from the debtor section.

: Ensure the final DP does not exceed the sanctioned loan amount. Formula: =MIN(Sanctioned_Limit, Calculated_DP)

: If you use accounting software like Tally, you can often generate a stock statement and export it directly to Excel using the Alt+P or Export function. Compliance Note Canara Bank Stock Statement NF-902 Form | PDF - Scribd Canara Bank generally excludes debtors older than 90

To create an efficient Excel template for your monthly submissions, follow these structural steps: Stock Statements to Bank - Dhruva Industrial Consultants

While the bank provides physical forms, the ideal way to submit the NF 902 is in a digital, editable format like Excel ( .xls or .xlsx ). Here are the standard methods to obtain the official format:

Form NF 902 is the official stock and debtors statement format prescribed by Canara Bank. Borrowers who enjoy working capital credit facilities against the security of hypothecated stock and book debts must submit this form monthly or quarterly, depending on their loan agreement. Your Excel sheet makes our audit much easier

Arjun opened his laptop and searched for the specific document his branch manager, Mr. Rao, had requested: Form NF 902

is the official stock statement format prescribed by Canara Bank for borrowers to declare: