Always submit your stock statement within the stipulated time (usually within 10-15 days of the month-end). Delayed submissions can lead to a reduction in your Drawing Power or penalties from the bank.
An Excel sheet allows you to pull data directly from your accounting software (like Tally Prime or Zoho Books), ensuring absolute alignment with your financial books.
Extract an aging report from your accounting software (like Tally or Zoho Books). Copy only the eligible debtors (usually those under 90 days old) into the designated Excel section. Step 4: Apply Bank Margins canara bank stock statement form nf 902 excel format
Preparing the Canara Bank stock statement form NF 902 in Excel format is a straightforward process. Here are the steps to follow:
Submitting the Canara Bank stock statement form NF 902 offers several benefits, including: Always submit your stock statement within the stipulated
Detailed breakdown of Raw Materials, Work-in-Progress (WIP), and Finished Goods.
: Breakdown of raw materials, work-in-progress (WIP), finished goods, and stores/spares. Extract an aging report from your accounting software
Debtors must be broken down by age (e.g., less than 30 days, 30–60 days, 60–90 days, and above 90 days).
The final section where the bank's margin (typically 25%) is deducted from the net stock value to arrive at the DP. How to Prepare the Statement in Excel
We use cookies to deliver website content. By continuing without changing your preferences, you agree to our use of cookies.