Canara Bank Stock Statement Form Nf 902 Excel Format 〈100% EXCLUSIVE〉

Use one worksheet for the inventory table and a separate summary sheet for calculations. Freeze the header row for easy data entry. Enable Data Validation for the "Classification" column (allow only Raw Material, WIP, Finished Goods, Consumables).

This is the main body of the Excel sheet. It should be formatted with the following columns: canara bank stock statement form nf 902 excel format

| S.No | Particulars | Unit | Quantity | Rate | Value (Rs.) | | :--- | :--- | :--- | :--- | :--- | :--- | | 1 | Raw Materials | | | | | | 2 | Work in Progress | | | | | | 3 | Finished Goods | | | | | | 4 | Stores & Spares | | | | | | 5 | Total Stock | | | | =SUM() | Use one worksheet for the inventory table and

Note: The form usually requires a reconciliation between the book value (as per Tally/Books) and the market value, whichever is lower. This is the main body of the Excel sheet

Book Debts (Receivables) Section: | S.No | Age of Debt | Amount (Rs.) | | :--- | :--- | :--- | | 1 | Up to 30 Days | | | 2 | 31 to 60 Days | | | 3 | 61 to 90 Days | | | 4 | Over 90 Days (Usually excluded from DP) | |

If sending via email, protect the file to prevent accidental changes. Navigate to File > Info > Protect Workbook > Encrypt with Password.

Use one worksheet for the inventory table and a separate summary sheet for calculations. Freeze the header row for easy data entry. Enable Data Validation for the "Classification" column (allow only Raw Material, WIP, Finished Goods, Consumables).

This is the main body of the Excel sheet. It should be formatted with the following columns:

| S.No | Particulars | Unit | Quantity | Rate | Value (Rs.) | | :--- | :--- | :--- | :--- | :--- | :--- | | 1 | Raw Materials | | | | | | 2 | Work in Progress | | | | | | 3 | Finished Goods | | | | | | 4 | Stores & Spares | | | | | | 5 | Total Stock | | | | =SUM() |

Note: The form usually requires a reconciliation between the book value (as per Tally/Books) and the market value, whichever is lower.

Book Debts (Receivables) Section: | S.No | Age of Debt | Amount (Rs.) | | :--- | :--- | :--- | | 1 | Up to 30 Days | | | 2 | 31 to 60 Days | | | 3 | 61 to 90 Days | | | 4 | Over 90 Days (Usually excluded from DP) | |

If sending via email, protect the file to prevent accidental changes. Navigate to File > Info > Protect Workbook > Encrypt with Password.