# Cash for the days ahead: will it be enough? | Free sheet

> Free Excel and PDF sheet for a gold shop's cash in the coming days: the balance day by day from expected cash in and out, with a warning below your minimum.

Source: https://qintar.app/en/sheets/shop-cashflow-week.html
Language: English
قنطار (Qintar)، qintar.app

---

# Cash for the days ahead: will it be enough?

Free sheet for goldsmiths and shop owners · With the cash I expect in and out, on which day would the cash fall below the minimum I need?

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.

[Download PDF136 KB](https://qintar.app/en/sheets/shop-cashflow-week.pdf)[Download Excel60 KB](https://qintar.app/en/sheets/shop-cashflow-week.xlsx)

Opens in Excel, or upload the file to Google Drive and open it with Google Sheets. You type in the yellow cells. [Or try it online without downloading](https://qintar.app/en/tools/shop-cashflow-week.html).

![Preview of the first page of the "Cash for the days ahead: will it be enough?" sheet, with the table and the worked example](https://qintar.app/en/sheets/shop-cashflow-week.png)

## How to use it

1. **The start:** Today's balance and the minimum.
2. **The days:** The cash you expect in and out each day.
3. **The balance:** The sheet works out the end of each day.
4. **The warning:** The day that falls below the minimum.
5. **Plan:** Arrange payments and collections.

## Example The calculation with numbers

Today's cash balance (example): 60,000.00 · Minimum cash (example): 20,000.00

| Day | Expected in | Expected out | Net for the day | Balance at day end | Status |
| --- | --- | --- | --- | --- | --- |
| Example: Saturday | 35,000.00 | 20,000.00 | 15,000.00 | 75,000.00 | OK |
| Example: Sunday | 30,000.00 | 62,000.00 | −32,000.00 | 43,000.00 | OK |
| Example: Monday | 28,000.00 | 15,000.00 | 13,000.00 | 56,000.00 | OK |
| Example: Tuesday | 25,000.00 | 48,000.00 | −23,000.00 | 33,000.00 | OK |
| Example: Wednesday | 40,000.00 | 18,000.00 | 22,000.00 | 55,000.00 | OK |

| Result | Value |
| --- | --- |
| Total in | 158,000.00 |
| Total out | 163,000.00 |
| Balance at the end | 55,000.00 |

Figures marked "Example" are for illustration, and the prices are approximate as of the date the sheet was made.

## 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.

## Read more

- [A gold shop's cash in the days ahead: avoiding a short day](https://qintar.app/en/articles/gold-shop-cash-forecast.html)A step-by-step guide with a worked example.
- [Cash forecast: will the cash last the coming days?](https://qintar.app/en/tools/shop-cashflow-week.html)The same sheet online, with today's prices.

## 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. Check tax matters with your accountant.

**Live prices in the app.** The Qintar app shows gold and silver buy and sell prices in Egypt, your holdings at today's price, and a zakat calculator. Free, with no ads.

[Open the web app](https://qintar.app/app/) [Get it on Google Play](https://play.google.com/store/apps/details?id=app.qintar)

## More free sheets

- [Gold savings goal: how much to put aside each month](https://qintar.app/en/sheets/gold-goal-planner.html)I want to reach a set number of grams in a set time. How much should I save each month?
- [Family gold register: every piece and who owns it](https://qintar.app/en/sheets/family-gold-register.html)How many grams of gold does the family own, who holds them, and what are they worth?
- [Comparing gold bar prices between sellers](https://qintar.app/en/sheets/bar-prices-compare.html)Bars of the same weight: which offer is cheapest per gram, and which has the smallest buy-back gap?

[All free sheets](https://qintar.app/en/sheets/)
