Stock statement format and calculate procedure for sbi

[Sundaraiah kollipara]

Sir,

A small business person Rs.12 lacs business loan from SBI bank

Question:

How to prepare procedure stock statement and any format for SBI bank

[YAGAY andSUN]

If you have taken a business loan or CC/OD limit from State Bank of India, the bank may require a monthly stock statement to assess your drawing power and working capital utilization.

A stock statement generally includes:

• Raw materials
• Finished goods
• Work-in-progress
• Receivables/debtors
• Creditors
• Stock hypothecated to bank

Banks use this for:

• Drawing Power (DP) calculation
• Working capital assessment
• Monitoring loan utilization

Procedure to Prepare SBI Stock Statement

1. Calculate Closing Stock
   Prepare details of:
   Opening Stock + Purchases - Sales = Closing Stock

Use:

• Purchase bills
• Sales register
• GST records
• Inventory/stock register

1. Classify Stock
   Typical categories required by SBI:

• Raw Material
• Finished Goods
• Semi-Finished Goods/WIP
• Stores & Consumables
• Sundry Debtors/Receivables

1. Debtors Ageing
   Mention:

• Debtors below 90 days
• Debtors above 90 days (normally ineligible for DP)

Example:

• Below 90 days: Rs. 3,00,000
• Above 90 days: Rs. 50,000

1. Deduct Creditors
   Mention supplier dues wherever required.

Basic Stock Statement Format

Particulars	Amount (Rs. )
Raw Material	2,50,000
Work in Progress	50,000
Finished Goods	4,00,000
Stores & Spares	25,000
Total Stock	7,25,000
Sundry Debtors (<90 days)	3,00,000
Gross Current Assets	10,25,000
Less: Creditors	2,00,000
Net Current Assets	8,25,000

Declaration:
"Certified that the above stock/book debts are true and correct and are not charged to any other bank/FI."

Also include:

• Business name
• Signature of Proprietor/Partner/Director
• Date and seal

Documents commonly attached:

• GST returns
• Stock register
• Debtors/creditors list
• Sales summary
• Stock insurance copy

Important Points:

• Submit monthly within due date
• Figures should broadly match books/GST data
• Avoid inflated stock values
• Keep bills ready for verification

[FCA Adv amit aggarwal]

there is no specific formats of it. sometimes bank accepts on loan below 20 lac value of closing stock with units and figures But it depends bank branch total loan handling capacity. some points need to consider

1. value of stock should be calculated as per IND AS 2.

2. CA may certify it. sometimes bank auditor made objection on without certified stock statement submitted by borrower.

3. branch auditor followed the guidance note on bank branch audit (2026 edition) to scrutinize the stock statements. so before making such statement, such guidance note should considered also.

AI Summary

Stock statements for bank finance must reflect closing stock, receivables, creditors, and supporting records for drawing power assessment. Monthly stock statements are commonly required by banks for business loans and cash credit or overdraft limits to assess drawing power, working capital utilisation, and loan monitoring. No single standard format is fixed; the statement is generally prepared from business records and should broadly agree with books, GST data, and supporting documents. Stock value is to be calculated on the basis of closing stock, using purchase bills, sales registers, inventory records, and related accounts, and may be expected to reflect accepted accounting treatment under Ind AS 2.