- Qintar
- Calculators
- Card and transfer reconciliation calculator
Card and transfer reconciliation calculator
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. This calculator is the same as the "Card, InstaPay and wallet reconciliation" sheet. It runs in your browser and saves no data.
Result
Who this calculator is for
This is the online version of the "Card, InstaPay and wallet reconciliation" sheet, made for goldsmiths and shop owners. A sheet that checks every amount taken by card, InstaPay or mobile wallet: the amount in your book, the fee, what should arrive, what actually arrived, and whether it matches, is short or is over.
The question it answers: Did the card and transfer money reach the bank in full?
How to use it
- The payments: One line for each card, transfer or wallet payment.
- The fee: The rate in your contract.
- Expected: The sheet works out what should arrive.
- Arrived: Type what arrived, from the account statement.
- The result: Matches, short or over.
Worked example
Tolerance, EGP (example): 5.00
With the example figures in the table above (the rows marked "Example"), the calculator gives:
| 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 |
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
- 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.
Want to keep your work? Download the sheet as Excel or PDF. For a step-by-step explanation: Card and InstaPay checks: did all the money arrive?.
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.
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?