# Card and InstaPay checks: did all the money arrive?

> How to reconcile card, InstaPay and wallet payments in a gold shop with what reached the bank: the fee, what should arrive, the gap and its usual causes.

Source: https://qintar.app/en/articles/card-instapay-reconciliation.html
Language: English
قنطار (Qintar)، qintar.app

---

Did the card and transfer money reach the bank in full?

Paying by card and transfer has become a large part of the sales of gold shops. That money never goes into the drawer, so it needs a check of its own.

The idea is simple: every amount taken has a figure in your book. After the fee, a certain amount should reach your account. When the money arrives, compare.

In the example, EGP 48,000 was paid by card at an illustrative fee of 2%: EGP 47,040 should arrive, and EGP 47,040 did, so it matches. But on Sunday, of EGP 36,500, EGP 35,770 should have arrived and EGP 35,700 did: EGP 70 short.

The fee differs with your contract and the payment method, so type your own rate. Card settlement can be a day or two late; what matters is that the full amount arrives in the end.

If you make a habit of reconciling every week, any gap shows up early and you can ask about it while you still remember the sale.

## Why a gold shop should check every payment

Gold purchases are large, so a single card payment can be tens of thousands of pounds. A small percentage missing on such amounts quickly becomes real money.

The cash close sheet checks the drawer; this sheet checks everything that did not pass through it. Between the two, every pound of the day is accounted for.

## The example in plain words

On Saturday the shop takes EGP 48,000 by card and EGP 15,000 by InstaPay with no fee; both arrive in full. On Sunday a wallet payment of EGP 4,000 at 1% should bring EGP 3,960, and it does.

Over the two days EGP 103,500 was taken, EGP 1,730 went in fees, and EGP 101,770 should have arrived. EGP 101,700 did, so EGP 70 is missing, more than the EGP 5 tolerance, and the result says "Money is missing". The Sunday card line is where to look.

## The calculation

- Should arrive = amount × (1 − fee).
- Difference = actually arrived − should arrive.
- If the difference is within the tolerance, it "Matches". Take the fee from your contract; the example figures are illustrations.

## Example A worked example

Tolerance, EGP (example): 5.00

| Day | Method | Amount in your book | Fee | Should arrive | Actually arrived | Difference | Status |
| --- | --- | --- | --- | --- | --- | --- | --- |
| Example: Saturday | Card | 48,000.00 | 2.00% | 47,040.00 | 47,040.00 | 0.00 | Matches |
| Example: Saturday | InstaPay | 15,000.00 | 0.00% | 15,000.00 | 15,000.00 | 0.00 | Matches |
| Example: Sunday | Card | 36,500.00 | 2.00% | 35,770.00 | 35,700.00 | −70.00 | Short |
| Example: Sunday | Wallet | 4,000.00 | 1.00% | 3,960.00 | 3,960.00 | 0.00 | Matches |

| Result | Value |
| --- | --- |
| Total taken by card and transfer | 103,500.00 |
| Total fees | 1,730.00 |
| Should arrive | 101,770.00 |
| Actually arrived | 101,700.00 |
| Difference | −70.00 |
| Result | Money is missing |

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.

## Common causes of a difference

- A sale was recorded in the book at a different amount from the one charged on the machine.
- A transaction was cancelled or refunded and not recorded.
- The actual fee is different from the rate you had in mind.
- A settlement has not arrived yet.

## Terms used on this sheet

- **Card:** Any bank card paid at the machine. In Egyptian shops people often call any card "Visa" (فيزا), whatever the brand.
- **Mobile wallet:** A money account on a mobile phone (محفظة) that customers can pay from.
- **Settlement:** The bank paying the card takings, minus its fee, into the shop's account, often a day or more later.
- **Tolerance:** A small difference you accept, such as rounding. Anything bigger is reported as short or over.

## Step by step with the sheet

1. **The payments:** One line for each card, transfer or wallet payment.
2. **The fee:** The rate in your contract.
3. **Expected:** The sheet works out what should arrive.
4. **Arrived:** Type what arrived, from the account statement.
5. **The result:** Matches, short or over.

**The sheet is free:** [Card, InstaPay and wallet reconciliation](https://qintar.app/en/sheets/shop-payments-reconcile.html) (Excel and PDF), or [try it online](https://qintar.app/en/tools/shop-payments-reconcile.html) with today's prices.

## Frequently asked questions

**How much is the fee?**

It depends on your contract with the bank or the company. The figures in the example are illustrations, so type the rate in your contract.

**The money arrives a day or two late. Is that normal?**

It is normal for card settlements. Type what arrived when it arrives; the line shows "Short" until it is filled in.

**I found a gap. What do I do?**

Compare the transaction number on the card machine's receipt with the account statement, and ask the bank or the company about any missing amount.

**What is InstaPay?**

Egypt's instant bank-transfer service. A customer can pay the shop from a phone straight into its bank account. In the example it carries no fee, but type whatever applies to you.

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)
