What does this tool do?
The tool places two statements side by side, links each transaction in the first to its counterpart in the second, then shows what is left unmatched on each side. It supports three types of reconciliation:
- Bank vs. books: the bank account in your books against the bank statement.
- Customer: the customer's account in your books against the statement the customer sent.
- Supplier: the supplier's account in your books against the supplier's statement.
The result: matched items, items on one side only, the net difference, and the reconciliation statement.
How to use the statement reconciliation tool
- Choose the match type: bank vs. books, customer, or supplier.
- Upload the first statement (your books) and the second statement (the bank, customer or supplier) as Excel, CSV or PDF on the tool page.
- Choose the allowed date difference: from “Same day only” to 15 days; the default is 3 days.
- Click “Reconcile now”, then review the tabs: matched items, items on each side only, and the reconciliation statement.
- Enter the two closing balances if you want a full reconciliation statement, then download the report in Excel. Seeing the result and downloading require registering once with your mobile number and email.
Each statement must have a date column, and an amount column or debit and credit columns. The description and reference are optional, but they improve matching accuracy. Hijri dates are not supported at the moment.
How does the tool match transactions?
What is a debit in your books is a credit in the other party's statement, so the tool reverses the sign of the second statement automatically. If both statements use the same sign, turn on the “Both statements use the same sign” option.
The amount must match to the halala, then the tool matches in four stages, in order:
- By reference: the same reference on both sides, or the same digits in it (4 digits or more), so “CHQ2001” is matched with “2001”.
- By amount and date: the same amount on the same day.
- With a gap of days: the same amount within the allowed difference, such as a cheque cashed two days later. These are timing differences that do not affect the balance.
- By amount only: the same amount with no shared reference and no close date. These appear in a warning color and need manual review.
When there are several candidates, the transaction with the closest date is chosen. The tool also alerts you if an item on one side equals the total of two items on the other side on the same day, since it is usually a split transaction.
Worked example: reconciling the bank account for September
The books have five transactions and the bank statement has five transactions. This is the reconciliation result with an allowed difference of 3 days:
| Transaction in the books | Transaction at the bank | Method | Amount (SAR) |
|---|---|---|---|
| Cheque 2001 — supplier (09/01) | Cheque cashed, ref. 2001 (09/03) | By reference | 3,000 |
| Cash deposit (09/05) | Cash deposit (09/05) | By amount and date | 10,000 |
| Transfer from customer (09/10) | Incoming transfer (09/12) | With a two-day gap | 5,000 |
| Cheque 2002 — rent (09/28) | — | In the books only | 2,500 |
| Cash deposit (09/30) | — | In the books only | 4,000 |
| — | Direct deposit — customer (09/20) | At the bank only | 1,200 |
| — | Bank service charges (09/30) | At the bank only | 45 |
The tool matched 3 items, two items remain on each side, and the difference between the two transaction totals is 345 SAR.
Reconciliation statement for the example
The closing balance in the books is 63,500 SAR, and on the bank statement it is 63,155 SAR. Once you enter both balances, the tool builds the statement:
| Description | Amount (SAR) |
|---|---|
| Balance per books | 63,500 |
| Add: direct deposit from a customer not recorded in the books | 1,200 |
| Less: bank service charges not recorded in the books | (45) |
| Adjusted balance per books | 64,655 |
| Balance per bank statement | 63,155 |
| Add: deposit in transit not yet shown by the bank | 4,000 |
| Less: outstanding cheque not yet cashed | (2,500) |
| Adjusted balance per bank statement | 64,655 |
| Difference | 0 |
The two adjusted balances are equal, so the whole difference is explained. Record the direct deposit (1,200) and the charges (45) in your books, and follow up the cheque and the deposit on next month's statement. For details, read Bank reconciliation step by step.
Warnings and limitations
- Matching by amount only may link two transactions that are not actually related, so review them before relying on the result.
- Closing balances are entered with the sign of the other party's statement, so a positive bank balance corresponds to a debit balance in your books.
- The tool does not match an amount with a nearly equal amount: a difference of even one halala leaves both items unmatched.
- The tool reads Excel, CSV and text-based PDF files as issued by the bank or your system. A scanned PDF has no readable text, so download the statement from the bank again.
Both statements are read and matched inside your browser, and they are not uploaded to our servers or stored.
Frequently asked questions
How do I do a bank reconciliation in Excel?
What is a bank reconciliation statement?
Why doesn't the bank balance match the book balance?
Can I reconcile a customer or supplier statement?
Does the tool accept a PDF bank statement?
Do you upload the statements to your servers?
Content last reviewed: 2026-10-26