A stock statement is the monthly or quarterly return a business with a cash credit or overdraft limit gives its bank. It lists raw material, work in progress, finished goods, book debts and unpaid suppliers as on one date. The bank takes off unpaid suppliers and its margins to set your drawing power, the amount you can actually draw. Drawing power is the lower of that figure and your sanctioned limit. RBI rules say a bank should not rely on a stock statement more than three months old.
What is a stock statement?
It is also called a bank stock statement or inventory statement. Banks ask for it when a cash credit (CC) or overdraft (OD) limit is secured by stock and book debts. Your sanction letter sets how often, usually monthly.
What each column in the stock statement format means
The Excel has a header and five parts.
Header: borrower, bank, limit and margins
| Field | What to fill |
|---|---|
| Borrower and address | Legal name as on the sanction letter |
| Bank, branch, account number | The CC or OD account this statement is for |
| Statement date | The one date every figure is "as on", e.g. 31 Oct 2026 |
| Sanctioned limit | From the sanction letter |
| Stock and debtor margins | From the sanction letter. 25% on stock and 40% on debtors are common. |
| Debtor age limit | From the sanction letter. Often 90 days. |
Part A: stock (raw material, WIP, finished goods, stores and spares, packing)
| Column | What to fill |
|---|---|
| Category | Raw material, work in progress, finished goods, stores and spares, or packing material |
| Item and location | Each line with where it sits: factory, store or job worker |
| Quantity and rate | Quantity from your stock register. Rate at the lower of cost and realisable value. |
| Value | Quantity × rate |
| Counts for DP? | Yes or No, as your sanction letter says |
Goods at a job worker or another party's site may not count, so show them on their own line. Our closing stock guide covers getting the quantities right.
Part B: book debts and their age
| Column | What to fill |
|---|---|
| Customer and invoice | One line per unpaid bill |
| Invoice date | The original invoice date, not the date of a part-payment |
| Amount due | What is still unpaid on that bill |
| Age bucket | 0–30, 31–60, 61–90 or over 90 days |
| Counts for DP? | No for bills past the age limit, disputed bills or bills already financed |
See our sundry debtors guide for keeping the list current.
Part C: creditors for goods
| Column | What to fill |
|---|---|
| Supplier and bill | One line per unpaid purchase bill |
| Bill date and amount | As in your purchase register |
| For goods? | Yes for raw material, parts and packing. No for services like a machine AMC. |
Unpaid goods are funded by your supplier, not the bank. Our sundry creditors guide explains how to track these bills.
Part D: drawing power summary
Part D works out what you can draw: the lower of drawing power and your sanctioned limit.
Part E: insurance and declaration
Add the insurer, policy number, sum insured and expiry date. Check the sum insured covers the stock you declare. The owner, a partner or a director signs with name, designation and date.
How to fill in your stock statement, step by step
- Fix the date. Use one "as on" date, usually month-end.
- Count store by store. Take quantities from the stock register, with job-worker stock on its own lines.
- Value at the lower of cost and realisable value. That is the AS 2 rule, never selling price.
- Mark what does not count. Check job-work, customer-owned and obsolete stock against your sanction letter. See our slow-moving inventory guide.
- List unpaid goods bills. Age customer bills from the invoice date.
- Check and sign. Totals should agree with your stock register and Tally.
Where TranZact fills in the numbers for you
By hand, you pull numbers from the stock register, Excel and Tally, then check they agree. TranZact keeps the figures a stock statement needs up to date. You export them to Excel for the bank's form.
| Statement line | Where it comes from in TranZact |
|---|---|
| Stock by item and store | Stock tracking with multi-store tracking: stock in, issue, bin card |
| Valuation and slow-moving lines | Inventory valuation and ageing |
| Material at job workers | Sub-contracting |
| Unpaid suppliers | Purchase flow: PO → GRN → payment |
| Customer bills | Sales flow: order, dispatch, e-invoicing, payment |
| Your books | One-way sync to Tally or Zoho Books, with no double entry |
An honest limit: TranZact does not file the statement with your bank. Your bank's form and sanction terms decide what counts, so you still mark the Yes and No lines.
TranZact stock and valuation facts (as of the date checked)
- Stock tracking, inventory ageing and valuation, 65+ reports and sub-contracting are in Grow. Grow is ₹8,333/month billed yearly, with 4 users (pricing, checked 22 Oct 2026).
- Inventory features: see the inventory management page (checked 17 Nov 2026).
- Integrations: Tally, Busy, Zoho Books, Gmail, Excel / Google Sheets, and API integrations with any tool that offers an API. See the Tally and Excel and Google Sheets integration posts.
- Live in 2–3 weeks. Used by 10,000+ manufacturers.
Worked example: an auto-parts maker's stock statement as on 31 Oct 2026
All names and numbers here are made up to show the method. The sanction letter sets a ₹80,00,000 CC limit. Margins are 25% on stock and 40% on debtors, with a 90-day age limit.
Table 1 (Example): stock by category
| Line | Qty × rate (₹) | Value (₹) | Counts? |
|---|---|---|---|
| RM: MS steel bars, factory store | 40,000 kg × 70 | 28,00,000 | Yes |
| RM: aluminium ingots, factory store | 5,000 kg × 240 | 12,00,000 | Yes |
| RM at job worker (plating) | 6,000 kg × 70 | 4,20,000 | No |
| WIP: machined parts | 20,000 pcs × 45 | 9,00,000 | Yes |
| FG: brake brackets | 15,000 pcs × 120 | 18,00,000 | Yes |
| FG: old-model bushes (cost ₹30, will sell at ₹10) | 10,000 pcs × 10 | 1,00,000 | Yes |
| Stores and spares | — | 3,00,000 | Yes |
| Packing material | — | 1,00,000 | Yes |
| Total stock counted | 72,00,000 |
Table 2 (Example): creditors for goods
| Supplier | Bill for | Unpaid (₹) | Deduct? |
|---|---|---|---|
| Steel supplier | MS bars | 10,00,000 | Yes |
| Aluminium supplier | Ingots | 4,00,000 | Yes |
| Packing supplier | Cartons | 1,00,000 | Yes |
| Machine service firm | AMC (a service) | 2,00,000 | No |
| Creditors for goods | 15,00,000 |
Table 3 (Example): book debts and ageing
| Age | Amount (₹) | Counts? |
|---|---|---|
| 0–30 days | 30,00,000 | Yes |
| 31–60 days | 15,00,000 | Yes |
| 61–90 days | 5,00,000 | Yes |
| Over 90 days | 6,00,000 | No |
| Eligible book debts | 50,00,000 |
Table 4 (Example): drawing power
| Step | Amount (₹) |
|---|---|
| Total stock counted | 72,00,000 |
| Less creditors for goods | 15,00,000 |
| Paid stock | 57,00,000 |
| Less 25% stock margin | 14,25,000 |
| Drawing power on stock | 42,75,000 |
| Eligible book debts | 50,00,000 |
| Less 40% debtor margin | 20,00,000 |
| Drawing power on book debts | 30,00,000 |
| Total drawing power | 72,75,000 |
| Sanctioned limit | 80,00,000 |
| You can draw (the lower) | 72,75,000 |
How drawing power is calculated
[[IMAGE {"type":"steps","title":"Drawing power in five steps","items":["Add up the stock that counts","Take off creditors for goods","Take off the stock margin","Add book debts less debtor margin","Draw the lower of DP and limit"]}]]
Two RBI rules sit behind this. A bank should not rely on a stock statement more than three months old (RBI master circular, para 4.2.4). A CC or OD account can also be "out of order" (para 2.2.1). That happens if it stays above the limit or drawing power for 90 days in a row.
Common stock statement mistakes (and what each costs you)
Each row shows the effect on the worked example above. Errors cut both ways.
| Mistake | Effect on the example |
|---|---|
| Old-model bushes at full cost (₹30, not ₹10) | Stock up ₹2,00,000. Drawing power overstated by ₹1,50,000. |
| Finished goods at selling price (₹150, not ₹120 cost) | Stock up ₹4,50,000. Drawing power overstated by ₹3,37,500. |
| Counting job-worker stock the sanction leaves out | Stock up ₹4,20,000. Drawing power overstated by ₹3,15,000. |
| Forgetting creditors for goods | Paid stock up ₹15,00,000. Drawing power overstated by ₹11,25,000. Capped by the ₹80,00,000 limit, you could draw ₹7,25,000 more than you should. |
| Deducting the AMC bill as a goods creditor | Drawing power understated by ₹1,50,000. |
| Counting bills over 90 days, or restarting their age after a part-payment | ₹6,00,000 wrongly counted. Drawing power overstated by ₹3,60,000. |
| Submitting late | After three months the bank should not rely on the old statement. The ₹72,75,000 figure stops counting. |
Need other formats? Our bill of materials format is free too. Want this month's stock, job-work and payment figures in one place? We will show you on your own items.
Don't be the bottleneck. Become the AI-Run Factory.