Qintar logoQintar
  1. Qintar
  2. Calculators
  3. Card and transfer reconciliation calculator

Card and transfer reconciliation calculator

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. This calculator is the same as the "Card, InstaPay and wallet reconciliation" sheet. It runs in your browser and saves no data.

Settings and prices

The table

Rows marked "Example" are for illustration: edit or delete them. Empty cells calculate as soon as you type.

DayMethodAmount in your bookFee (%)Should arriveActually arrivedDifferenceStatusDelete

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

  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.

Worked example

Tolerance, EGP (example): 5.00

With the example figures in the table above (the rows marked "Example"), the calculator gives:

ResultValue
Total taken by card and transfer103,500.00
Total fees1,730.00
Should arrive101,770.00
Actually arrived101,700.00
Difference−70.00
ResultMoney 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

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

All calculators · All free sheets