- Qintar
- Calculators
- Cash forecast: will the cash last the coming days?
Cash forecast: will the cash last the coming days?
Sometimes a shop is profitable and still runs out of cash on the day of a big payment. This sheet works out the balance day by day and tells you which day might fall below the minimum. This calculator is the same as the "Cash for the days ahead: will it be enough?" sheet. It runs in your browser and saves no data.
Result
Who this calculator is for
This is the online version of the "Cash for the days ahead: will it be enough?" sheet, made for goldsmiths and shop owners. A sheet that works out the cash balance day by day from the opening balance and the cash you expect in and out, and warns you if the balance would fall below the minimum you set.
The question it answers: With the cash I expect in and out, on which day would the cash fall below the minimum I need?
How to use it
- The start: Today's balance and the minimum.
- The days: The cash you expect in and out each day.
- The balance: The sheet works out the end of each day.
- The warning: The day that falls below the minimum.
- Plan: Arrange payments and collections.
Worked example
Today's cash balance (example): 60,000.00 · Minimum cash (example): 20,000.00
With the example figures in the table above (the rows marked "Example"), the calculator gives:
| Result | Value |
|---|---|
| Total in | 158,000.00 |
| Total out | 163,000.00 |
| Balance at the end | 55,000.00 |
This is exactly the same calculation as in the sheet. Change the numbers in the table above and the result updates by itself.
The calculation
- Net for the day = in − out.
- Balance at day end = opening balance + the sum of the net of every day so far.
- If the balance is below the minimum you type, the day is marked "Below minimum".
Terms used on this sheet
- Minimum cash
- The least the shop must keep in the drawer and the bank at all times. You set it.
- Credit collected
- Money customers pay toward pieces they bought on credit (الآجل).
- Day book
- The shop's daily record of every sale and purchase (اليومية). It tells you what happened; this sheet looks ahead.
Want to keep your work? Download the sheet as Excel or PDF. For a step-by-step explanation: A gold shop's cash in the days ahead: avoiding a short day.
Frequently asked questions
How much should the minimum be?
The amount you must always keep to buy gold from customers and run the shop. It is your own figure.
The figures are only expected. What if things turn out differently?
Update the sheet every day with the actual and the new figures.
Does this replace the day book?
No. The day book records what happened; this sheet plans what is coming.
Why does a gold shop need cash on hand?
Because customers come in to sell gold as well as to buy it, and the shop pays them on the spot. Without enough cash, it has to turn them away.
Prices and calculations are for information only. They are not financial advice, an offer to buy or sell, or a religious ruling.
Related calculators
- Cash close calculator: count the drawer and compareDoes the cash in the drawer match what should be there, or is there a gap?
- Credit book: each customer's balance after every entryHow much does each customer owe, how much have they paid, and what is left?
- Scrap and refining calculator: how much pure gold?How many grams of pure gold are in my scrap, and how much comes back after refining?
- Wholesaler account: balance in pure gold and making chargeHow many grams of pure gold and how many pounds of making charge do I owe the wholesaler?
- Gold shop monthly profit calculatorHow much did the shop make this month after expenses?