Learn How to Reconcile Accounts for FREE!
This page contains our free online reconciliation course. It will teach you the basics of reconciling accounts, including how to reconcile a bank account.
The Course Covers:
The basics of reconciliations
Bank reconciliations
Reconciliation examples
And more
Course Modules:
​
Lesson 1: Reconciliation Basics
Lesson 2: How to do a Basic Reconciliation
Lesson 3: How to do a Bank Reconciliation
To start my free reconciliation course, scroll down.
​
This course is FREE, and no registration is required!
​
Jump to:
FREE Reconciliation Course: Learn How to Reconcile Accounts
Part 1: Reconciliation Basics
Module overview:
​
-
Course Overview
-
What is reconciling in accounting
-
Why are reconciliations needed
-
Reconciliation basics
1.1 What is a reconciliation?
In accounting, a reconciliation compares an entity's accounting records against a financial document, such as a bank statement.
​
A reconciliation involves reviewing transactions, adding any missing transactions, and correcting accounting errors, such as duplicate entries.
1.2 Why are reconciliations needed?
Accounting reconciliations help ensure that the financial accounts are reliable and accurate. They are a safety net. Without reconciliations, financial accounts are more vulnerable to errors. Reconciliations must be done to produce accurate financial statements.
1.3 Which accounts can be reconciled?
If a statement can be obtained, an account can be reconciled. A statement usually includes opening and closing balances, payments, charges, and other items which impact balances. For example, a bank statement typically includes opening and closing balances for a specified period, as well as transactions showing money going in and out of the account. A statement from a supplier should detail an opening and closing balance, invoices, credit notes, payments to the account, and refunds.
​
The following accounts can be reconciled:
​
-
Bank accounts, including current, checking, and savings accounts
-
Credit and charge card accounts
-
Loan and mortgage accounts
-
Tax accounts, including corporation and sales tax accounts
-
Supplier accounts
Reconciliations are easier when you understand the basics of bookkeeping and accounting:
The ULTIMATE Accounting Course
​
​
Part 2: Reconciliation Example
Module overview:
​
-
How to reconcile an account
-
Reconciliation example
-
The basics of reconciling accounts
-
And more
2.1 Reconciliation Example
For this example, I will be reconciling a loan account.
We will compare the loan accounting records in the financial accounts against a loan statement. The loan statement shows the account activity for the last six months, so we'll compare the accounting records against the loan statement for the same period.
​
The loan statement shows the following for the period:
-
An opening balance
-
A closing balance
-
Loan repayments
-
Interest charged
We must compare the accounting records against all four to ensure that they are accurate. If there are mistakes, these must be corrected. Common errors highlighted by a reconciliation include missing transactions and duplicate entries.
Loan Statement Example
Accounting Records Example
2.2 Reconciliation Example Continued
Review the above statements.
The loan statement details the entire loan account activity for a six-month period (1 Jan 20XX to 30 Jun 20XX).
​
The statement from our accounting records displays what has been accounted for in the same period.
​
What do you notice? Are the accounting records complete? What is missing? Are there any errors?
​
You should notice the following on the accounting records:
​
-
The opening balances match. This is likely because a reconciliation was completed for the period prior, so the accounting records are up to date and accurate as of 31 Dec 20VV.
-
Repayment duplicate. The February repayment has been accounted for twice.
-
Repayment missing. The March repayment has not been accounted for.
-
Interest missing. The interest charge for quarter one has not been accounted for.
-
Repayment error. The May repayment amount is wrong.
-
The closing balance is not correct.
​
Once the discrepancies have been identified, they are corrected. For example, missing transactions can be accounted for, duplicate transactions can be removed or reversed, and incorrect amounts can be amended. Once the corrections are done, the closing balances should match. Closing balances that match are a sign that the accounting records are complete. The reconciliation is done.
Reconciliations are much easier with accounting software.​
​
Click here for an exclusive and special discount on Xero.
Part 3: Reconciling a Bank Account
Module overview:
​
-
How to reconcile a bank account
-
Bank reconciliation example
-
Bank reconciliation basics
-
And more
3.1 How to do a Bank Reconciliation
Completing a bank reconciliation is no different to completing any other reconciliation, such as the loan reconciliation above. However, current and checking accounts usually have more transactions than other accounts, such as loan, credit card, supplier, and tax accounts. Due to the larger volume of transactions, reconciling bank accounts can be more challenging and typically done more frequently than with other accounts.
​
You'll need access to the company's accounting records and bank statements to do a bank reconciliation. Once you have these, the process is:
​
-
Choose a period to reconcile. This is usually the period following the last reconciliation.
-
Compare the accounting records for the period against the bank statements for the same period.
-
Add missing transactions. These transactions are shown on the bank statements but not the accounting records.
-
Remove duplicate transactions. These are duplicate entries on the accounting records added by error.
-
Amend incorrect transactions. These are often transactions with incorrect dates or amounts.
-
Ensure the closing balances match. Once the process is complete, the closing balance on the accounting records should match the closing balance for the period on the statements.
3.2 Bank Reconciliation Examples
Watch an example of doing a bank reconciliation in my free How to do a Bank Reconciliation video.
​
Alternatively, watch me reconcile a bank account on accounting software:
​
3.3 How often should the Bank be Reconciled?
It depends on the number of transactions going through the bank account. However, the rule of thumb is, 'the more often, the better'. If you can reconcile the bank account every few days or once a week, this is best. Leaving a bank reconciliation to once a year can create a messy task.
3.4 Common Bank Reconciliation Problems - Troubleshooter
Problem: The closing balance doesn't match
Solution: You must re-check all transactions, including the opening balance, as well as the money in and out. Check for incorrect amounts, missing transactions, and duplicate entries.
​
Problem: The opening balance doesn't match
Solution: The previous period hasn't been reconciled, or an error has been made after previous periods' reconciliations. You will need to investigate.
​
Problem: Transactions are shown from previous periods
Solution: If all previous period reconciliations have been completed, then the transactions are likely errors. They were not used in prior reconciliations, so they were never reconciled; therefore, they were brought forward to the following reconciliation. You will need to investigate. ​​