Free template · Excel

Stock Statement Format: Free Excel Template for Banks

A free stock statement format in Excel for your CC or OD limit. You get a blank format and a filled auto-parts example. Every column is explained, and drawing power is worked out. No sign-up.

Download the Excel template

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

FieldWhat to fill
Borrower and addressLegal name as on the sanction letter
Bank, branch, account numberThe CC or OD account this statement is for
Statement dateThe one date every figure is "as on", e.g. 31 Oct 2026
Sanctioned limitFrom the sanction letter
Stock and debtor marginsFrom the sanction letter. 25% on stock and 40% on debtors are common.
Debtor age limitFrom the sanction letter. Often 90 days.

Part A: stock (raw material, WIP, finished goods, stores and spares, packing)

ColumnWhat to fill
CategoryRaw material, work in progress, finished goods, stores and spares, or packing material
Item and locationEach line with where it sits: factory, store or job worker
Quantity and rateQuantity from your stock register. Rate at the lower of cost and realisable value.
ValueQuantity × 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

ColumnWhat to fill
Customer and invoiceOne line per unpaid bill
Invoice dateThe original invoice date, not the date of a part-payment
Amount dueWhat is still unpaid on that bill
Age bucket0–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

ColumnWhat to fill
Supplier and billOne line per unpaid purchase bill
Bill date and amountAs 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

  1. Fix the date. Use one "as on" date, usually month-end.
  2. Count store by store. Take quantities from the stock register, with job-worker stock on its own lines.
  3. Value at the lower of cost and realisable value. That is the AS 2 rule, never selling price.
  4. Mark what does not count. Check job-work, customer-owned and obsolete stock against your sanction letter. See our slow-moving inventory guide.
  5. List unpaid goods bills. Age customer bills from the invoice date.
  6. 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 lineWhere it comes from in TranZact
Stock by item and storeStock tracking with multi-store tracking: stock in, issue, bin card
Valuation and slow-moving linesInventory valuation and ageing
Material at job workersSub-contracting
Unpaid suppliersPurchase flow: PO → GRN → payment
Customer billsSales flow: order, dispatch, e-invoicing, payment
Your booksOne-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.

Book a demo →

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

LineQty × rate (₹)Value (₹)Counts?
RM: MS steel bars, factory store40,000 kg × 7028,00,000Yes
RM: aluminium ingots, factory store5,000 kg × 24012,00,000Yes
RM at job worker (plating)6,000 kg × 704,20,000No
WIP: machined parts20,000 pcs × 459,00,000Yes
FG: brake brackets15,000 pcs × 12018,00,000Yes
FG: old-model bushes (cost ₹30, will sell at ₹10)10,000 pcs × 101,00,000Yes
Stores and spares—3,00,000Yes
Packing material—1,00,000Yes
Total stock counted72,00,000

Table 2 (Example): creditors for goods

SupplierBill forUnpaid (₹)Deduct?
Steel supplierMS bars10,00,000Yes
Aluminium supplierIngots4,00,000Yes
Packing supplierCartons1,00,000Yes
Machine service firmAMC (a service)2,00,000No
Creditors for goods15,00,000

Table 3 (Example): book debts and ageing

AgeAmount (₹)Counts?
0–30 days30,00,000Yes
31–60 days15,00,000Yes
61–90 days5,00,000Yes
Over 90 days6,00,000No
Eligible book debts50,00,000

Table 4 (Example): drawing power

StepAmount (₹)
Total stock counted72,00,000
Less creditors for goods15,00,000
Paid stock57,00,000
Less 25% stock margin14,25,000
Drawing power on stock42,75,000
Eligible book debts50,00,000
Less 40% debtor margin20,00,000
Drawing power on book debts30,00,000
Total drawing power72,75,000
Sanctioned limit80,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.

MistakeEffect 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 outStock up ₹4,20,000. Drawing power overstated by ₹3,15,000.
Forgetting creditors for goodsPaid 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 creditorDrawing 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 lateAfter 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.

Book a demo →

Frequently asked questions

Can I use this format instead of my bank's own form?

If your bank prescribes its own form, use that form. Copy the totals from this workbook into it.

Does stock lying with a job worker count?

It depends on your sanction letter. Show it on its own line with its location so the bank can see it. In our example it is left out.

Does my auditor look at these statements?

For larger limits, yes. Under CARO 2020 clause 3(ii)(b), auditors report on quarterly returns filed with banks when working capital limits above ₹5 crore are sanctioned against current assets.

Can software give me these stock figures?

Yes. Manufacturing AI software such as TranZact tracks stock by item and store, values it and shows its age. You export the figures to Excel for your bank's form, and your accounts stay in Tally.

Don’t be the bottleneck.
Become the AI-Run Factory.

Book a demo

Born in India. Building for the world.