Rentsera
Centre d’aide
Retour
Les articles du centre d’aide sont offerts en anglais seulement.

Reconcile a bank account

Reconcile a bank account to its statement: start it, check the Difference, finish and review it, undo it, and see why reconciled entries lock.

Reconcile a bank account to check that its transactions match the balance on the bank statement. A finished reconciliation locks the statement period.

Before you start

  • Your role needs Bank Reconciliations with Create access to start a reconciliation, Post access to finish one, and Void access to undo one. Without them, the page shows "You do not have permission to do this with bank reconciliations."
  • A reconciliation covers every property that posts to the bank account. You need access to every property, or the page shows "A bank reconciliation covers every property that posts to the bank account, so it requires access to all properties."
  • The bank account needs an opening balance. Its first reconciliation starts from that balance. Without one, the page shows "This bank account has no opening balance". Add the balance from the bank account's setup.
  • Have the bank statement ready. You need its Statement beginning balance, its Statement ending balance and its statement ending date.
  • A trust account also needs a responsible broker and a copy of the statement. See Understand trust accounting.

Reconciling is not importing

Reconciling compares your transactions with the statement. It does not bring transactions into Rentsera. The reconciliation marks the transactions the bank has cleared. Each transaction you tick is marked cleared on this statement.

Steps

  1. In the sidebar, open BANKING and select Bank Accounts. Select the Reconciliation tab.
  2. Select New bank reconciliation.
  3. Choose the bank account you want to reconcile.
  4. On the Statement step, type the Statement beginning balance and the Statement ending balance, then set the ending date.
  5. Select Next. On the Match transactions step, tick each transaction that appears on the statement. The steps for ticking, adding a bank fee or interest and attaching the statement copy are in Match bank transactions to your statement.
  6. Check the Difference in the footer. It must reach zero before you can finish.
  7. Select Finish reconciliation.

Tenant payments are not added in a reconciliation. Record a tenant payment with Receive Payment on the lease.

You can stop before you finish. The reconciliation then stays a draft, and you resume it from the list.

How the beginning balance and the Difference work

The beginning balance of a reconciliation is the ending balance of the last finished statement. For the first reconciliation of a bank account, it is the opening balance. The statement beginning date is the day after that statement, or the day after the opening balance.

Rentsera works out the Difference from the statement ending balance, the beginning balance, the cleared transactions and the bank errors on the statement. A zero Difference means the cleared transactions account for the statement.

If the beginning balance you type does not match the opening balance or the last finished statement, Rentsera shows a message that names the amount it expects. Check the statement. If the bank's figure is right and your opening balance is wrong, correct the opening balance first.

A transaction you do not tick stays uncleared. The reconciliation list shows the uncleared transactions of the bank that are dated on or before the statement ending date. A cheque the bank has not paid yet stays uncleared. It appears again on the next reconciliation until a statement clears it.

What happens when you finish

  • The bank account shows the statement as reconciled, and its statement is locked.
  • Nothing dated on or before the statement ending date can be posted to that bank. A correction posts on the next open date.
  • The list shows a finished reconciliation with the badge Reconciled. For a trust account, it shows Reconciled until the responsible broker signs the review. To find the reconciliations that still need review, set the Status filter to Reconciled (needs review). For another account, review is optional.
  • The reconciliation report keeps the figures saved when you finished. Changes made later are not included in it.

Locked transactions

When a finished reconciliation clears a transaction, you cannot change or delete that transaction. The transaction shows the notice "This transaction has already been reconciled. Some changes to this transaction will not be allowed." It also shows the statement date that locked it. To change it, undo that reconciliation first.

Undo a reconciliation

Undo a finished reconciliation when a statement was wrong or a transaction must change. You can then correct the entries and finish the reconciliation again.

  1. In the sidebar, open BANKING and select Bank Accounts. Select the Reconciliation tab.
  2. In the Actions menu of the row, select Undo reconciliation.
  3. Enter the Reason for the undo. It is required.
  4. Select Undo reconciliation.

Undo has these effects:

  • Only the newest finished reconciliation of a bank can be undone. Undo the later ones first.
  • Each cleared transaction becomes uncleared again.
  • Entries dated after the statement date can be posted, changed or voided again.
  • The report stays in the history, marked as undone, with your reason.
  • The redo starts with the same items already ticked. The redo needs a new review.
  • A month that is hard-closed blocks the undo. A hard close cannot be reopened.

Common problems

  • This bank account already has a reconciliation in progress. Resume it from Bank Reconciliations. Open the draft from the list instead of starting a second one.
  • The statement ending date must be after {date}, the statement beginning date. Enter an ending date after the beginning date.
  • The statement ending date must be on or before {date}, today. Enter a date that is not in the future.
  • The Difference must be zero before you finish the reconciliation. Tick the transactions on the statement, or correct the balances.
  • Some transactions must post or leave their queue before you finish this reconciliation. Finish waits until the list in Before you can finish is clear.
  • A trust account's reconciliation needs a copy of the bank statement to finish. Select Edit statement and attach the statement under Bank statement copy.
  • Set a responsible broker for this bank account before its reconciliation is reviewed. Choose the responsible broker on the bank account first.
  • Only the latest finished reconciliation of a bank account can be undone. Undo the later ones first. Undo the newer reconciliations in order.
  • A hard-closed month depends on this reconciliation, and a hard close can't be reopened, so it can't be undone. Record a correction dated in the open month instead.
  • This transaction has already been reconciled. Undo the reconciliation that cleared it, then change the transaction.
  • No uncleared transactions of this bank are dated on or before the statement ending date. Check the statement ending date. A transaction dated after it does not appear.

Related articles

  • Banking
  • Match bank transactions to your statement
  • View a bank account register
  • Understand trust accounting