# A gold shop's cash in the days ahead

> How to plan a gold shop's cash for the coming days: the balance day by day from expected cash in and out, a minimum, and arranging payments in time.

Source: https://qintar.app/en/articles/gold-shop-cash-forecast.html
Language: English
قنطار (Qintar)، qintar.app

---

# A gold shop's cash in the days ahead: avoiding a short day

With the cash I expect in and out, on which day would the cash fall below the minimum I need?

A shop can be profitable on paper and still not have enough cash on the day it pays the wholesaler or the salaries. That happens when large payments bunch up on one day.

The fix is simple: write down the cash you expect in and out each day next week, and work out the balance at the end of each day.

The minimum is the amount you must keep to buy from customers who come in to sell. If the balance is heading below it, you have time to act.

Acting can mean moving a payment by two days, collecting a credit balance early, or splitting a large payment.

## Why the cash runs both ways in a gold shop

A gold shop does not only take money in. It pays out to customers who sell gold, pays the wholesaler for stock, and pays salaries and rent. On some days more goes out than comes in.

The weekly total can look fine while one day in the middle dips too low. That is why the sheet works day by day and not on the week as a whole.

## The example in plain words

The shop starts with EGP 60,000 and wants never to drop below EGP 20,000. Saturday brings a net EGP 15,000, so the balance is EGP 75,000. On Sunday it pays the wholesaler and the day nets −32,000, leaving EGP 43,000.

Monday adds EGP 13,000 (EGP 56,000), Tuesday is salary day and nets −23,000 (EGP 33,000), and Wednesday adds EGP 22,000 to end the week at EGP 55,000. Over the five days EGP 158,000 comes in and EGP 163,000 goes out.

The lowest point is EGP 33,000 on Tuesday, still above the minimum, so every day shows "OK". Had any day dropped below EGP 20,000, the sheet would have marked it "Below minimum" days in advance.

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

## Example A worked example

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. Type your own figures in the sheet or the calculator.

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

## Step by step with the sheet

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.

**The sheet is free:** [Cash for the days ahead: will it be enough?](https://qintar.app/en/sheets/shop-cashflow-week.html) (Excel and PDF), or [try it online](https://qintar.app/en/tools/shop-cashflow-week.html) 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)
