Canara Bank Stock Statement Form Nf 902 Excel Format [updated] -

This is the core computational area of the Excel sheet where formulas do the heavy lifting.

Securing and maintaining a working capital limit like a cash credit (CC) or overdraft (OD) facility requires regular compliance. For business owners and accounts professionals dealing with Canara Bank, submitting the monthly inventory and debtors report is a mandatory ritual. This reporting is done using a specific document known as .

: Typically submitted monthly or quarterly to the branch manager to determine the drawing power of a Cash Credit (CC) account.

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

If you have any specific questions about a certain type of inventory or a unique situation in preparing your statement, it's always a good idea to get in touch with your branch manager directly for the most current advice and formats.

The NF 902 form is essential for businesses for several reasons:

=TODAY()-[@InvoiceDate] to automatically track the age of your invoices. This is the core computational area of the

Always submit the statement by the 7th of every month (or as specified in your loan agreement) to avoid penalty interest.

: Use =SUM(Cell1:Cell2) to aggregate stock values and creditors.

Quantity, rate, and total value of unprocessed stock. Work-in-Progress (WIP): Semi-finished goods valued at cost. This reporting is done using a specific document known as

Form NF 902 requires you to declare your current insurance policy number, expiry date, and insured amount. Ensure your asset value never exceeds your insurance coverage limit.

: Sundry creditors represent unpaid stock. You must deduct them from the gross stock value to calculate net security.

Outline the for uploading this data to Canara Bank's corporate net banking portal.

: Final figures used for the drawing power calculation.