Aantar Books
Reconcile a bank or credit card account
Tick the transactions in your books against the bank or card statement until the difference is zero, then sign the statement off.
Where: Banking ▸ Reconcile · Home ▸ Reconcile
Reconciling proves that your books agree with your bank. Once a month, when the statement arrives, you tell Aantar Books the statement's date and ending balance, then tick every transaction in your books that appears on the statement. When the ticked transactions bring you exactly to the statement's ending balance — DIFFERENCE reads 0.00 — you sign the statement off. The ticked transactions are then locked to that reconciliation and do not appear the next month.
You can reconcile any account set up on the Bank Feeds screen: chequing, savings, credit cards and lines of credit. You do not need a bank feed or an imported statement; a paper or PDF statement is enough.
Note: Reconciling has three steps: Begin Reconciliation (account, statement date, beginning and ending balance, service charge and interest earned), then the Reconcile window with Checks and Payments and Deposits and Other Credits, Mark All, Unmark All, Modify and Reconcile Now, then the report choice of Summary or Detail.
Before you start
- Enter everything for the month: cheques, deposits, card charges, transfers, bill payments. Anything missing will show as a difference.
- Have the statement in front of you: its closing date, its ending balance, and any bank fees or interest on it.
- If you have never reconciled this account, check that its opening balance matches the statement balance on the day your books start. The Beginning Balance comes from it.
Opening Begin Reconciliation
- Banking ▸ Reconcile
- Reconcile in the Banking panel of the Home Page
- Reconcile on an account's card on the Bank Feeds screen (Banking ▸ Bank Feeds), which opens the same questions in a window for that account.
Step 1: Begin Reconciliation
| Field | What to enter / what it means |
|---|---|
| Account | The bank or credit card account to reconcile. Under it, Last reconciled … shows the statement date of the last reconciliation. |
| Statement Date | The closing date printed on the statement. Only transactions dated on or before it are listed. |
| Beginning Balance | Filled in for you: the ending balance of the last reconciliation, or the account's opening balance if it has never been reconciled. It should match the opening balance on your statement. If it does not, stop and see Common problems. |
| Ending Balance | The closing balance printed on the statement, typed exactly. Continue without it says Enter the ending balance from your statement under the box and puts the cursor there. |
| Service Charge and Account | Any fee the bank charged on the statement that you have not entered, and the expense account for it. The account starts on Bank Charges (the account named that way on your chart), or on the one you picked last time on this computer. |
| Interest Earned and Account | Any interest the bank paid on the statement that you have not entered, and the income account for it. The account starts on Interest Income, or on the one you picked last time on this computer. With no such account on the chart the box starts empty: pick one. |
The service charge and interest are posted on the statement date, and only if you finish the reconciliation. If you leave without finishing, nothing is posted.
Three buttons under the account help before you begin:
- Import Statement… imports the bank's statement file for this account (see Bank Feeds).
- Locate Discrepancies opens the account's reconciliation history, where you can open each past reconciliation's report. Undo Last Reconciliation undoes the latest completed one, after asking why (the reason stays on the record); its cleared lines become uncleared, ready to reconcile again. See Previous Reconciliation and undoing a reconciliation.
Choose Continue.
Step 2: Tick the transactions
The Reconcile window shows the account's name and statement date at the top, the Ending balance (which you can still correct), and the buttons Modify, Mark all and Unmark all. Below are two lists, named as the bank names them:
- Cheques and Payments — money that left the account: cheques, bill payments, card charges, transfers out, fees.
- Deposits and Other Credits — money that came in: deposits, transfers in, interest.
On a credit card account the lists follow the card: charges are the money going out of the card, and payments to the card are credits.
Each list has the tick box on the left of every line, then DATE, REF, PAYEE, TYPE (the kind of transaction, in the list's colour; the dates and the ticks are in the ordinary black), MEMO (the entry's memo or note, when it has one) and AMOUNT (and NUM, the document's number, when the books keep one apart from the reference), and at the top its own Mark all and Unmark all and how many of its lines are ticked.
The columns are the same as every list's, and each list keeps its own on this computer:
- Widen or narrow a column by dragging the edge of its heading; a long reference such as PO2026/00412 reads whole at the usual width.
- Move a column by dragging its heading onto another.
- Show or hide a column from Columns above the list, or by right-clicking a heading; Restore column order there puts the columns back where they were.
- A− / A+ beside Unmark all at the top make the lists' text smaller or larger: Small, Normal, Large or Extra large. The size is kept on this computer for you, in this company.
- The tick column always stays first. Only transactions not yet signed off by an earlier reconciliation, dated on or before the statement date, are listed. Nothing outstanding means the list is empty.
Work down the statement. For each item on it, click the matching line to tick it; anywhere on the line will do, not only the box. Click again to untick it. Each tick is saved as you make it.
To look at the transaction behind a line, double-click it or press Enter on it: the cheque, bill payment, customer payment, deposit or entry opens over Reconcile. Esc (or Back) brings you back to Reconcile with every tick, the ending balance and anything changed with Modify as you left them, and the cursor on the same line. A double-click opens the line without ticking it.
Mark all at the top ticks every line in both lists; Unmark all at the top clears both lists. To tick or clear one list only, use the Mark all and Unmark all at the head of that list (Cheques and Payments or Deposits and Other Credits); the other list is left as it is. Marking all and then unticking the few that are not on the statement is often quicker.
Note: The Mark All and Unmark All at the top act on both lists; the pair on each list acts on that list only.
Watch the summary at the bottom:
| Line | What it means |
|---|---|
| Beginning balance | Where the statement starts. |
| Cleared deposits · n | The total of the ticked deposits and how many. |
| Cleared payments · n | The total of the ticked cheques and payments, as a negative. |
| Service charge | The fee you entered at the start, as a negative. Shown only if you entered one. |
| Interest earned | The interest you entered at the start. Shown only if you entered some. |
| Cleared balance | Beginning balance plus everything above. |
| Ending balance | The statement's ending balance. |
| DIFFERENCE | Ending balance minus cleared balance. Red until it is zero; green at 0.00. |
Modify
Modify reopens the statement's figures without losing your ticks: Statement date, Ending balance, Service charge with its expense account (to expense) and Interest earned with its income account (to income). Choose Continue to go back to ticking. Changing the statement date reloads the lists, because which transactions belong depends on the date.
Ticking from the keyboard
Click a line once, and the lists take the keyboard. The line the cursor is on is highlighted, with a bar at its left edge.
| Key | Does |
|---|---|
| ↓ / ↑ | Move to the next or previous line in the list. |
| ← / → | Move across to Cheques and Payments or Deposits and Other Credits. |
| Space | Tick the line the cursor is on, or untick it. |
| Enter | Open the transaction behind the line; Esc comes back to the same line. |
Note: The tick column is on the left and Space ticks the highlighted line.
Step 3: Reconcile now
When DIFFERENCE reads 0.00, choose Reconcile now. Aantar Books asks Reconcile … ? and explains that the ticked transactions are locked to this reconciliation and drop out of the next one, and that undoing it later releases them again — nothing is deleted. Choose Reconcile now to sign off, or Not yet to keep working.
If the difference is not zero, Reconcile now says Difference must be 0.00 before you can reconcile. and keeps you where you are.
When it is done, Aantar Books confirms Reconciled — n line(s) signed off. and asks whether to Show the report of this reconciliation, to print or save it? Choose Summary or Detail to open that report (with a PDF button to print or save it), or Close.
What happens in the books
- The ticked transactions are marked cleared and tied to this reconciliation. They no longer appear when you reconcile the account again.
- If you entered a service charge, it is posted on the statement date: the expense account is debited and the bank account credited. Interest earned is posted the other way. Both are ticked automatically, because they are on the statement.
- The account's last reconciled date and balance are updated. The next reconciliation's Beginning Balance is this one's ending balance.
Nothing about the transactions themselves changes. A cleared transaction can still be opened and changed, but any change to its amount, or deleting it, means the reconciliation it was cleared in no longer adds up. (Deleting a cheque or card charge warns you of this.) Such changes show in Reconciliation Discrepancy.
Permissions
Ticking lines and completing a reconciliation need Reconcile. Undoing one needs Undo a Reconciliation.
Tips
- Reconcile every month, in order. A difference is far easier to find in one month than in six.
- Tick by amount: sort the statement by amount in your head, or tick the large items first, and the small differences stand out.
- A difference that is exactly the amount of one transaction usually means that transaction is missing from the books or was ticked by mistake. A difference that divides evenly by 9 often means two digits were swapped when the transaction was entered.
- If you use Undeposited Funds, make each deposit match one deposit on the statement; see Make Deposits.
Common problems
The Beginning Balance does not match the statement's opening balance. A transaction that was part of an earlier reconciliation has been changed, deleted or voided since, or an earlier reconciliation was undone. Open Reports ▸ Banking ▸ Reconciliation Discrepancy for this account to see what changed, and put it right before reconciling. See Reconciliation Discrepancy.
A transaction on the statement is not in the list. It has not been entered, it is dated after the statement date, it was entered against a different account, or it was cleared in an earlier reconciliation. Enter it or correct it, then use Modify or come back to the reconciliation.
The difference will not go to zero. Check the Ending balance you typed; check for a bank fee or interest you have not entered; check that every ticked line really is on the statement, and that the amounts match to the cent.
I signed off the wrong month or the wrong balance. Undo it from Previous Reconciliation and reconcile again.
Related articles
Related articles
Something unclear or out of date? Write to support@aantar.com and name this page.