Free calculator and template
Stock Statement Template with a Drawing Power Calculator
Enter the stock, creditors and book debts from your records and the margins from your sanction letter. The page works out your drawing power, compares it with the limit and the outstanding, and writes a stock statement in Parts A to E that you can copy, download or print for your bank.
All amounts in ₹ as on the statement date. Blank lines count as zero.
- 1 Take the figures from your books as on the statement date: stock at cost, unpaid suppliers of goods, and customer balances.
- 2 Set the two margins and the debtor age limit to what your sanction letter says. The defaults are only common practice.
- 3 Press Calculate. The result shows drawing power, the headroom against your limit, and a stock statement in Parts A to E to copy or download.
Drawing power as on the statement date
Stock statement, Parts A to E
The figures above, laid out the way most banks ask for them. Fill in the blanks, then paste it into your bank's own format if it prescribes one.
Does your bank want this statement certified?
Some sanction letters ask for the monthly or quarterly stock statement to be certified by a chartered accountant, usually above a limit size or when the account is being reviewed. For that, the same statement is checked against your books and records and signed: see the stock statement certificate for cash credit and overdraft limits.
What changes between this working and a certified statement
- Stock is agreed to the stock records and, where the bank asks, to a physical count.
- Book debts are agreed to the debtors' ledger and aged from the invoice date.
- The exclusions in your sanction letter are applied line by line, not estimated.
- The certificate says what was examined and what was not.
How to use it
What to enter in each line
Every figure is as on one date, the statement date. Take them from the books closed for that date, not from estimates.
| Line | What to enter | Where it comes from |
|---|---|---|
| Stock on hand | Raw material, work in progress, finished goods and stores at cost on the date | Stock register or the inventory valuation for the date |
| Stock that does not count | Obsolete, slow-moving, damaged or uninsured items, stock not yet paid for where the letter says so, and anything else the sanction letter excludes | Ageing of stock, the insurance policy, the sanction letter's exclusions |
| Creditors for purchases | What you owe suppliers of goods on the date; deducted so only paid stock is financed | Creditors' ledger, purchases only, not expenses |
| Book debts | Total customer balances on the date | Debtors' ledger |
| Debts over the age limit | Receivables older than the limit in your sanction letter, counted from the invoice date | Debtor ageing report |
| Margins | The percentage of paid stock and of eligible debts that the bank does not finance | Sanction letter; they vary by bank and industry |
| Limit and outstanding | The sanctioned limit and the balance drawn on the date | Sanction letter; the bank statement for the date |
What the number means
Drawing power, margins and the stock that does not count
A sanctioned limit is the most the bank will lend. Drawing power is how much of it the current stock and book debts support. The bank recomputes it from each stock statement, so it moves every month.
How the calculator builds it
The two margins and the age limit are read from your sanction letter. The calculator applies them; it does not decide them.
Why creditors, margins and age limits come off
Stock still owed to a supplier is already financed by that supplier, so most banks count only paid, adequately insured stock towards drawing power, as set in the sanction letter. The margin is the borrower's own share of the asset that the bank does not finance: margins are set in your sanction letter and vary by bank and industry; around 25% on stock and 40% on debtors is common.
Banks usually count book debts only up to an age limit in the sanction letter, often 90 days: the older a receivable, the less certain the bank is of collecting it.
Under RBI's asset-classification directions, drawing power based on a stock statement older than three months is treated as irregular. That is why the statement date matters and why a stale statement is not re-used.
A worked example with made-up figures
A trading firm with a cash credit limit of ₹15,00,000 prepares its statement as on the month end. The numbers are invented to show the arithmetic.
What the firm enters
- Stock on hand
- ₹20,00,000
- Stock that does not count
- ₹2,00,000
- Creditors for purchases
- ₹4,00,000
- Book debts
- ₹8,00,000
- Debts over the age limit
- ₹1,50,000
- Margins
- 25% stock, 40% debts
- Sanctioned limit
- ₹15,00,000
- Outstanding on the date
- ₹13,00,000
Had creditors been ₹7,00,000 instead, paid stock would fall to ₹11,00,000, stock after margin to ₹8,25,000 and drawing power to ₹12,15,000: below the outstanding, even though the limit is unchanged. That sensitivity is why banks recompute drawing power from every statement.
The template
The five parts of the stock statement this page writes
Stock statement formats are set by each bank, so use your lender's prescribed format where it has one. Most ask for the same five parts, which is what the copy-ready text follows.
Before you file
What this page does not do, and the mistakes that move the figure
What this page does not do
- It does not know your sanction letter. The margins, the age limit, what counts as stock and the format are set there, and the letter governs where the two differ.
- It does not classify the account. It shows whether the outstanding on the date sits within drawing power; what the bank does with that is the bank's decision.
- It does not check anything against your books, your stock records or your insurance policy. The statement is only as right as the figures typed in.
- It is not a certificate. Where the bank asks for a chartered accountant's certification, the statement is examined and signed separately.
- It stores nothing. Close the page and the figures are gone; download or copy the statement if you want to keep it.
Mistakes that change drawing power
- Stock at selling price. Stock is stated at cost (or the lower value the accounts use), not at what it will sell for.
- Counting stock that does not count. Obsolete, damaged, uninsured or excluded items inflate the figure and are the first thing a stock audit removes.
- Forgetting creditors. Drawing power is on paid stock; leaving suppliers out overstates it by the margin-adjusted amount.
- Old debts in Part B. Receivables past the age limit are listed but do not count.
- Stock that is not yours to pledge. Goods held for others, goods in transit and stock at a job-worker's premises follow the sanction letter, which often leaves them out.
- A stale date. A statement is as on one date and is filed by the due date in the sanction letter; drawing power from a statement older than three months is treated as irregular.
Terms used on this page
Four terms behind the figure
Sources and review
What this page relies on
No margin, age limit or rule on this page comes from memory. Each one is listed here with where it was checked and its status.
| Statement used | Source | Status |
|---|---|---|
| Drawing power based on a stock statement older than three months is treated as irregular | RBI, Master Direction on income recognition, asset classification and provisioning (consolidated April 2025), and the circular it draws on | Verified wording; sign-off by a chartered accountant on 23 October 2026 |
| Margins are set in the sanction letter and vary by bank and industry; around 25% on stock and 40% on book debts is common | Bank practice, not law; hedged | Stated as practice, tied to the sanction letter |
| Book debts count only up to an age limit in the sanction letter, often 90 days | Bank practice, not law; hedged | Stated as practice, tied to the sanction letter |
| Only paid, adequately insured stock counts towards drawing power | Bank practice, not law; hedged | Stated as practice, tied to the sanction letter |
| Drawing-power discipline traces back to the Tandon and Chore committee norms RBI once adopted; banks now set their own methods | RBI history volumes | Verified in the corrected wording |
| CARO 2020 clause 3(ii)(b): quarterly returns to banks tested where working capital limits above ₹5 crore are sanctioned on current-asset security | Ministry of Corporate Affairs, CARO 2020 order, 25 February 2020 | Verified |
| Stock statement formats are set by each bank | No standard bank-wide format could be verified from an official source | Stated as practice; the bank's own format governs |
| The formula and the example | Arithmetic applied to the figures entered; the example uses invented figures | Not a claim |
Review and version
- Content reviewed by
- Subham Jhunjhunwala, CA Finalist 23 October 2026
- Regulatory and banking statements signed off by
- CA Sundram Gupta 23 October 2026
- Calculation version
- 2026-10-19 draft; the version changes when a formula or a source in the table changes
- Re-checked when
- The RBI asset-classification directions or CARO 2020 change, or a bank-practice statement is found to be out of date
