Free Excel template
Stock statement format for the bank
A common monthly format for the stock and debtors statement a bank asks for against a cash credit limit, with drawing power worked out from your figures.
Download the Excel fileWhat is in it
- Stock by type: raw material, work in progress, finished goods, stores
- Old, damaged and unpaid stock taken out before the margin
- Debtors by age, with those over 90 days left out
- Drawing power on stock and debtors, and the available limit against the sanction
How to use it
- Take opening stock from last month’s statement and purchases, production and sales from the books.
- Enter creditors for goods: stock you have not yet paid for is not your security.
- Enter debtors by age from the debtors ageing report.
- Use the margins and debtor age limit in your sanction letter, then copy the figures into the bank’s own form if it has one.
Read with it
Blue cells are for your figures; everything else is a formula. The first rows hold an example: replace them with your own. This is a general format, not professional advice for your case.
Want us to do this for you every month? Talk to us.