Aantar

Aantar Books

Previous Reconciliation and undoing a reconciliation

Open the Summary or Detail report of any past reconciliation, print it, see what changed since, undo the last reconciliation if it was signed off by mistake, and delete one that was undone.

Where: Reports ▸ Banking ▸ Previous Reconciliation · Banking ▸ Reconcile ▸ Undo Last Reconciliation · Banking ▸ Bank Feeds ▸ Reconciled

Every reconciliation you complete is kept. Previous Reconciliation lists them for one account and opens the report of any of them — the Summary, the full Detail of what cleared and what was still outstanding, or what has Changed since. From the same list you can undo the last reconciliation, which releases the transactions it cleared so the statement can be reconciled again, and delete a reconciliation that has been undone.

Opening Previous Reconciliation

  • Reports ▸ Banking ▸ Previous Reconciliation. Aantar Books first asks you to specify the account: it lists your bank and credit card accounts, each with its type, the last digits of the account number if recorded, and last reconciled date. Click the account.
  • On Banking ▸ Reconcile (Begin Reconciliation), Locate Discrepancies opens the history of the account shown. Undo Last Reconciliation undoes the account's latest completed reconciliation there and then: it names the statement date, asks Why (required, kept on the record) and, on Undo it, the lines it cleared become uncleared. Only the latest one can be undone; to undo an older one, undo the later ones first.
  • On Banking ▸ Bank Feeds, Reconciled opens the history of every account together.

Note: Aantar Books lists every statement for the account and opens any of them, as a Summary or Detail. Undo is on the latest signed-off reconciliation only.

The reconciliation history

The page Reconciliation history lists every signed-off reconciliation for the account, newest first. Reconciliations that were undone are hidden: when there are any, a Show undone (N) button at the top shows them too, and Hide undone hides them again.

Column What it means
Statement date The statement's closing date.
Account The account reconciled.
Statement balance The ending balance the reconciliation was signed off against.
Cleared balance What the books' cleared transactions came to at sign-off.
Status signed off, or undone for one that was taken back.
Report Opens the report.
Undo Takes the reconciliation back. Only on the latest signed-off reconciliation for the account.
Delete Removes an undone reconciliation from the history. Only on undone rows.

Back returns to where you came from.

The report

Report opens Previous Reconciliation for that statement, headed with the account and period ending date. Choose the view at the top:

Summary

Line What it means
Beginning Balance Where this statement started.
Cleared Cheques and Payments — n items Money out that was ticked.
Cleared Deposits and Credits — n items Money in that was ticked.
Total Cleared Transactions The two together.
Cleared Balance Beginning balance plus total cleared.
Statement ending balance The statement's closing balance.
Difference Should be zero.
Uncleared Cheques and Payments — n items Money out dated on or before the statement date that was not on the statement (outstanding cheques).
Uncleared Deposits and Credits — n items Money in not yet on the statement (deposits in transit).
Total Uncleared Transactions The two together.
Register Balance as of … The cleared balance plus the uncleared transactions: the account's balance in the books on the statement date.
Ending Balance The same figure, closing the report.

Detail

The same structure, with every transaction listed under its heading:

Column What it means
Type The kind of transaction.
Date Its date.
Num Its number.
Name The payee or customer.
Clr X for a cleared transaction. For an uncleared one, * means it has been changed since the reconciliation was completed.
Amount The amount.
Balance The running balance.

"Uncleared" means as it stood on the statement date: a cheque that cleared on a later statement was still outstanding then, so it is listed here.

Changed since

The cleared transactions that have been changed since this reconciliation was completed. See Reconciliation Discrepancy. When nothing has changed it says Nothing cleared in this reconciliation has been changed since.

Double-click any transaction in the Detail or Changed since view to open it. PDF produces the Reconciliation Detail as a printable page.

Undo a reconciliation

Undo when a statement was signed off against the wrong ending balance, the wrong date, or with the wrong transactions ticked.

Only the last reconciliation for an account can be undone. Undo appears only on the latest signed-off row. If you try to undo an earlier one, Aantar Books refuses: "Undo the reconciliation to (date) first: only the last one can be undone."

  1. Open the account's reconciliation history.
  2. Choose Undo on the latest reconciliation.
  3. Aantar Books asks Undo the reconciliation to (date)? and explains that every transaction it cleared goes back to uncleared, and the account is open for that period again. The reconciliation is marked undone, with your reason; it leaves the list, and can be seen again with Show undone, or deleted from there.
  4. Type Why (required; for example "Signed off against the wrong statement").
  5. Choose Undo it (or Cancel).

After undoing:

  • Every register line that reconciliation cleared is released, so it shows as uncleared again. The lines are still ticked, so when you reconcile that statement again you start where you left off rather than from nothing.
  • The account's last reconciled date and balance step back to the previous reconciliation, so the next Beginning Balance is right.
  • Any service charge or interest that was posted when it was completed stays posted.

If you need to undo several months, undo the latest first and work backwards — each undo makes the one before it the latest — then reconcile them again in date order.

Delete an undone reconciliation

An undone reconciliation is kept, with the reason given, until you delete it. To remove one from the history:

  1. Click Show undone (N) at the top of the history.
  2. Choose Delete on the undone reconciliation.
  3. Aantar Books asks Delete the undone reconciliation to (date)? — "It is removed from the history. Nothing in the books changes: it was already undone, and anything it still held is released."
  4. Choose Delete (or Cancel).

A signed-off reconciliation cannot be deleted. Undo it first, then delete it.

Permissions

Viewing the history and reports needs access to the Banking screens. Undoing a reconciliation, and deleting an undone one, needs Undo a Reconciliation, which the standard Bookkeeper role does not have.

Messages you may see

Message What to do
No bank or credit card accounts are set up yet. Add an account on the Bank Feeds screen.
Nothing has been reconciled yet. This account has no completed reconciliations.
A reason is required — it stays on the record. Type why you are undoing it.
Undo the reconciliation to (date) first: only the last one can be undone. Undo the later reconciliation named first, then this one.

Related articles

Something unclear or out of date? Write to support@aantar.com and name this page.