Talk to an expert

Tell us what you need and we will call you back.

🇮🇳 +91

    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.

    Work out drawing power
    All amounts in ₹ as on the statement date. Blank lines count as zero.
    Part A · Stock paid for and insured
    Part B · Book debts receivables from customers
    Margins from the sanction letter
    Your limit optional, for the headroom check

    A working for your own use. Your bank's sanction letter decides what counts, at what margin and in which format.

    1. 1 Take the figures from your books as on the statement date: stock at cost, unpaid suppliers of goods, and customer balances.
    2. 2 Set the two margins and the debtor age limit to what your sanction letter says. The defaults are only common practice.
    3. 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.
    Running total
    Stock after margin₹0
    Book debts after margin₹0
    Drawing power so far₹0
    Updates as you type. Press Calculate for the breakdown, the checks and the statement.
    Nothing is fetched, nothing is stored The calculation runs in your browser. No margin, rate or limit is pulled from anywhere: you enter the figures, the page applies the arithmetic. Your numbers are not sent to us unless you choose to ask for a certified statement.

    Drawing power as on the statement date

    ₹0

    No limit entered

      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.

      
      
      Figures as entered; nothing is checked against your books or your sanction letter.

      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.

      What to enter in each calculator line and where the figure comes from
      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

      1Eligible stock = stock on hand less the stock that does not count.
      2Paid stock = eligible stock less creditors for purchases. If creditors are larger, paid stock is taken as nil.
      3Stock after margin = paid stock × (1 − stock margin).
      4Eligible book debts = book debts less debts over the age limit; debts after margin = eligible debts × (1 − debtor margin).
      =Drawing power = stock after margin + debts after margin. Available to draw = the lower of drawing power and the sanctioned limit.

      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.

      Drawing-power discipline traces back to the Tandon and Chore committee norms RBI once adopted; banks now set their own assessment methods, which is why two banks can treat the same statement differently. When the outstanding on the date is above drawing power, the page shows the excess. How the bank then treats the account is the bank's decision under its own rules and depends on how long the excess lasts.

      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
      Eligible stock: 20,00,000 − 2,00,000₹18,00,000
      Paid stock: 18,00,000 − 4,00,000₹14,00,000
      Stock after the 25% margin: 14,00,000 × 0.75₹10,50,000
      Eligible book debts: 8,00,000 − 1,50,000₹6,50,000
      Debts after the 40% margin: 6,50,000 × 0.60₹3,90,000
      Drawing power: 10,50,000 + 3,90,000₹14,40,000
      Available to draw: the lower of 14,40,000 and the 15,00,000 limit₹14,40,000
      Outstanding 13,00,000 is within drawing power; headroom₹1,40,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.

      Stock Stock by category: raw material, work in progress, finished goods, stores and spares; the stock that does not count; creditors for purchases; paid stock.
      Book debts Receivables split by age; only those within the sanction letter's limit count towards drawing power.
      Creditors Suppliers of goods unpaid on the date, the same figure deducted in Part A.
      Insurance Policy number, insurer, sum insured and validity for the stock the bank holds as security.
      Certification The borrower's declaration that the stock is owned, paid for and insured and that the debts are correct, with signature, name, designation and date.

      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.
      This calculator gives a working from the figures you type in. It is not a certificate, it is not advice on any facility, and it does not verify any value against a document or a sanction letter. Each bank's sanction letter governs what counts, at what margin and in which format.

      Terms used on this page

      Four terms behind the figure

      Cash credit limit The revolving working capital facility the stock statement is filed against. You draw up to the lower of the limit and drawing power.
      Book debt Money your customers owe you. With stock it forms the base the bank lends against, after the age limit and the margin.
      Primary security The asset the facility is created against. On a cash credit limit that is the stock and the receivables in this statement.
      QIS statement The quarterly return on sales, stock and receivables that larger limits also file. The monthly stock statement feeds it.

      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.

      Statements used on this page, with sources and 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

      Talk to a chartered accountant

      Tell us what your bank has asked for and the right person calls you back.

      🇮🇳 +91

        By sending this form you agree to our privacy policy.