# Card, InstaPay and wallet reconciliation | Free sheet

> Free Excel and PDF sheet for a gold shop to reconcile card, InstaPay and wallet payments with the bank: the fee, what should arrive, and any shortfall.

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

---

# Card, InstaPay and wallet reconciliation

Free sheet for goldsmiths and shop owners · Did the card and transfer money reach the bank in full?

The more customers pay by card and transfer, the more it matters to check that the money arrived in full after the fee. This sheet reconciles each amount on its own line.

[Download PDF142 KB](https://qintar.app/en/sheets/shop-payments-reconcile.pdf)[Download Excel60 KB](https://qintar.app/en/sheets/shop-payments-reconcile.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-payments-reconcile.html).

![Preview of the first page of the "Card, InstaPay and wallet reconciliation" sheet, with the table and the worked example](https://qintar.app/en/sheets/shop-payments-reconcile.png)

## How to use it

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.

## Example The calculation with numbers

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.

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

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

## Read more

- [Card and InstaPay checks: did all the money arrive?](https://qintar.app/en/articles/card-instapay-reconciliation.html)A step-by-step guide with a worked example.
- [Card and transfer reconciliation calculator](https://qintar.app/en/tools/shop-payments-reconcile.html)The same sheet online, 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)

## More free sheets

- [Buying used gold from customers: a daily log](https://qintar.app/en/sheets/shop-used-gold-buying.html)On average, what did I pay today for each gram of pure gold in the used gold I bought?
- [Selling on installments: payment, mark-up and balance](https://qintar.app/en/sheets/shop-installment-sales.html)If I sell on installments, what is the monthly payment, and how much will the customer pay in the end?
- [Zakat for a gold shop: the base and the nisab](https://qintar.app/en/sheets/shop-zakat.html)How much is the shop's zakat this year?

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