{"id":7205,"date":"2021-07-17T00:23:47","date_gmt":"2021-07-17T04:23:47","guid":{"rendered":"https:\/\/www.sage.com\/en-ca\/blog\/?p=7205"},"modified":"2026-01-15T12:02:33","modified_gmt":"2026-01-15T17:02:33","slug":"bank-reconciliation-save-time","status":"publish","type":"post","link":"https:\/\/www.sage.com\/en-ca\/blog\/bank-reconciliation-save-time\/","title":{"rendered":"Bank reconciliation: This is how to save time on this vital task"},"content":{"rendered":"
\n\t
\n\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t
\n\t\t\t\t\t\t\tMoney Matters<\/a>\t\t\t\t\t\t<\/div>\n\t\t\t\t\n\t\t\t\t
\n\t\t\t\t\t

\n\t\t\t\t\t\tBank reconciliation: This is how to save time on this vital task\t\t\t\t\t<\/h1>\n\t\t\t\t<\/div>\n\n\t\t\t\t\t\t\t\t\t

\n\t\t\t\t\t\t\t\t\t\t\t<\/p>\n\t\t\t\t\n\t\t\t\t\n\t\t\t\t\n\t\t\t<\/div>\n\n\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t<\/div>\n\t\t

\n\t\t
\n\t\t\t
\n\t
\n\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\n\t\t
\n\t\t\t\n\t\t\t\t\"Keir\t\t\t\tKeir Thomas-Bryant<\/span>\n\t\t\t<\/a>\n\n\t\t\t\t\t<\/div>\n\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t<\/div>\n<\/div>\n\n\n\n\n\n

There\u2019s no getting away from the fact that running or managing a business requires the need to tackle regular administration tasks. One such requirement is bank reconciliation.<\/p>\n\n\n\n

Although the term might make you groan, technological progress has made it a simpler and faster procedure than it once was.<\/p>\n\n\n\n

With the right accounting software, it can take as little as a few minutes once you start to keep on top of it \u2013 potentially turning it into a quick daily task that significantly boosts your visibility of your business finances.<\/p>\n\n\n\n

The result is greater flexibility and agility, and smarter decision-making for your business.<\/p>\n\n\n\n

What is bank reconciliation?<\/h2>\n\n\n\n

Bank reconciliation is a process where you match what your bank says is the case with your finances against what your accounting software\u2019s ledger says.<\/p>\n\n\n\n

If the two balances match, you\u2019ve successfully reconciled.<\/p>\n\n\n\n

Incoming and outgoing payments are considered in reconciliation, as are charges such as bank fees that might not appear in your accounting software (but will have to be added).<\/p>\n\n\n\n

Everything should always match up. If it doesn\u2019t, that\u2019s a clue that something has gone wrong and needs to be fixed.<\/p>\n\n\n\n

If you create an invoice for a large customer order in your accounting software, for example, this will need to be reconciled against the payment when it\u2019s received. Until the received payment is reconciled, a false impression is created.<\/p>\n\n\n\n

You may avoid making purchases, for instance, because you believe your bank balance is lower than it really is.<\/p>\n\n\n\n

Of course, if the invoice shows as not being reconciled \u2013 even after you\u2019ve reconciled everything properly \u2013 this indicates the payment should be chased, assuming the agreed payment terms have expired.<\/p>\n\n\n\n

 <\/p>\n\n\n\n

The three methods of bank reconciliation<\/h2>\n\n\n\n

Depending on the software you use, and which bank you\u2019re signed up with, there are three options for reconciliation.<\/p>\n\n\n\n

1. Manually reconcile<\/h3>\n\n\n\n

Perhaps the oldest method is to manually reconcile against the printed bank statement you receive or a PDF version of this on your computer.<\/p>\n\n\n\n

You might even have your online banking open in a browser window, alongside your accounting software in order to match and reconcile transactions.<\/p>\n\n\n\n

It\u2019s clear how labour-intensive this task is. This can mean people simply put it off \u2013 which means their accounting isn\u2019t providing the insight they need.<\/p>\n\n\n\n

2. Download and import<\/h3>\n\n\n\n

So, technology has provided a solution. In the first instance, it\u2019s sometimes possible to download the statement from your bank and import it into your accounting software.<\/p>\n\n\n\n

This means reconciliation becomes a task where you match entries in one on-screen table against another.<\/p>\n\n\n\n

3. Connect your bank feed<\/h3>\n\n\n\n

However, the gold standard for ease of use is connecting the bank feed directly to your accounting software, so the transactions are imported automatically and near-instantly in the background.<\/p>\n\n\n\n

This can speed up the process of reconciliation to the extent that it becomes something you spend a few minutes taking care of each day, thereby ensuring your accounting is always up to date.<\/p>\n\n\n\n

Building on top of bank feed functionality, some accounting software even includes features to automatically reconcile transactions.<\/p>\n\n\n\n

If you regularly receive a payment each month with the same reference, for example, you can configure the software to reconcile it immediately.<\/p>\n\n\n\n

Increasingly, artificial intelligence functionality is enhancing this so the accounting software can recognise new or irregular transactions, and reconcile them automatically without user input (although it\u2019s always wise to check).<\/p>\n\n\n\n

Why is bank reconciliation important?<\/h2>\n\n\n\n

Reconciliation is a vital business practice that helps you to be clear on what\u2019s happening with your cash flow<\/a>.<\/p>\n\n\n\n

If you don\u2019t undertake reconciliation regularly, your accounting software won\u2019t display how much money your business has \u2013 and how much you can spend or expect to receive.<\/p>\n\n\n\n

But more than this, if your business finances ever need to be examined \u2013 by your accountant at year-end, for example, or even by HMRC \u2013 regular and accurate bank reconciliation is vital.<\/p>\n\n\n\n

Accounting software is increasingly sophisticated, and often includes reporting and dashboard features. These aim to provide an up-to-the-minute, at-a-glance view of your business finances so managers are empowered to act immediately.<\/p>\n\n\n\n

Without correct bank reconciliation, it can\u2019t provide the incredible insights and power that it does.<\/p>\n\n\n\n

Managers might simply shrug at the thought of not having this level of insight. It\u2019s true that a business can operate successfully without it.<\/p>\n\n\n\n

But the use of reports and dashboards can provides the kind of competitive edge that could give you an advantage over your competitors, which leads to growth and new business.<\/p>\n\n\n\n

However, there\u2019s a more fundamental reason to undertake bank reconciliation.<\/p>\n\n\n\n

You can spot any errors introduced by the bank, such as erroneous debits, credits or charges. You should never assume your bank is correct.<\/p>\n\n\n\n

On a similar theme, regular bank reconciliation can be an invaluable way to spot any fraudulent activity from within the business.<\/p>\n\n\n\n

\n\t
\n\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t\t

10 Tips to Transform Your Productivity<\/h2>\n\n\t\t\t\t\t\t\t\t\t
\n\t\t\t\t\t\t

Learn how changing your accounting administration habits can have a positive impact on your business.<\/p>\n\t\t\t\t\t<\/div>\n\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\tGet your guide on transforming your productivity<\/a>\n\t\t\t\t\t\t\t<\/div>\n\n\t\t\t\t\t<\/div>\n\n\t\t\t\t\t\"Woman\t\t\t<\/div>\n<\/div>\n\n\n\n

How to do bank reconciliation<\/h2>\n\n\n\n

Let\u2019s run through some general steps required to undertake bank reconciliation. Here we assume you\u2019ve just received a bank statement.<\/p>\n\n\n\n

Step 1: Check your entries<\/h3>\n\n\n\n

Before you even start, ensure you\u2019ve entered all recent transactions within your accounting software up until the end date of the bank statement that you\u2019re using to reconcile.<\/p>\n\n\n\n

For example, if your business means people create invoices or purchase orders outside of the accounting software, you should ensure these details have been correctly inputted.<\/p>\n\n\n\n

Step 2: Select the bank account<\/h3>\n\n\n\n

In many accounting packages, the first step for bank reconciliation is to select the bank account that\u2019s provided the statement. There should then be an option to reconcile transactions.<\/p>\n\n\n\n

Step 3: Provide summary information<\/h3>\n\n\n\n

Your next step will probably be to provide summary information.<\/p>\n\n\n\n

This is to tell the accounting software the date the statement runs up to, inputting the statement\u2019s final balance, and providing a reference for your own purposes so you can view this reconciliation in future (typically some combination of the date is sufficient).<\/p>\n\n\n\n

Step 4: Start reconciling<\/h3>\n\n\n\n

Now begins the work of reconciling.<\/p>\n\n\n\n

Check what appears in the list against the bank statement you have. To reconcile the entry in the accounting software you may have to tick a box.<\/p>\n\n\n\n

Alternatively, your accounting software may show two separate lists of unreconciled and reconciled entries. Therefore you will have to click to move entries from the former to the latter.<\/p>\n\n\n\n

Step 5: Check the list<\/h3>\n\n\n\n

Rather than reconcile each and every entry, you can visually check the list quickly and, if you\u2019re sure everything is correct, select an option to reconcile all entries in one fell swoop.<\/p>\n\n\n\n

It\u2019s worth remembering that you can unreconcile transactions later, should you make an error.<\/p>\n\n\n\n

Step 6: Look for amount increases and decreases<\/h3>\n\n\n\n

As you work to reconcile entries, you should see amounts increase or decrease in the receivables and paid boxes beneath the transactions list.<\/p>\n\n\n\n

This should guide you as to whether you\u2019re completing the reconciliation process correctly.<\/p>\n\n\n\n

Step 7: Enter bank fees and charges<\/h3>\n\n\n\n

Bank fees, charges or earned interest that appear on the statement won\u2019t exist in your accounting software\u2019s reconciliation list. Therefore, you\u2019ll need to enter these manually as you reconcile.<\/p>\n\n\n\n

There should be an option to do this in the software, and you\u2019ll be invited to input the date, plus the charge or interest earned.<\/p>\n\n\n\n

Step 8: Review the balance<\/h3>\n\n\n\n

Once you\u2019ve completed the reconciliation, the balance listed below the reconciled transaction list should equal the target balance, which is what you entered from your statement when you started.<\/p>\n\n\n\n

If the two don\u2019t match then something is wrong and must be fixed before you can continue.<\/p>\n\n\n\n

You might have missed an entry in the transaction list, for example. Perhaps you have an outstanding invoice or purchase order that you haven\u2019t entered into your system.<\/p>\n\n\n\n

Or you may have incorrectly entered the statement end amount when beginning the reconciliation process, or the incorrect end date (the latter of which means the accounting software won\u2019t display transactions that should be included in the reconciliation list).<\/p>\n\n\n\n

Step 9: Split the task if necessary<\/h3>\n\n\n\n

There\u2019s no need to complete the entire reconciliation process at one sitting. You may find it necessary or easier to split the task across several or more attempts.<\/p>\n\n\n\n

In most accounting software, you can simply click to save the reconciliation list. This will save it as a draft within your accounting software but without applying the reconciliations to the ledger.<\/p>\n\n\n\n

Step 10: Add the reconciliations to the ledger<\/h3>\n\n\n\n

Once you\u2019ve finished, you can click to write the reconciliations to the ledger. You may find at this point that you\u2019re offered the option to print or save a PDF copy of the reconciliation for future reference.<\/p>\n\n\n\n

This can be filed separately to your main accounting.<\/p>\n\n\n\n

Conclusion on bank reconciliation<\/h2>\n\n\n\n

There\u2019s no getting away from undertaking bank reconciliation if you\u2019re serious about your business or your role within it. Therefore, become the master of the task and make full use of modern technology so you can reap the rewards of having a closer connection to your business finances.<\/p>\n\n\n\n

If your business embraces bank reconciliation rather than considers it a chore, you\u2019ll have a competitive edge over your competitors \u2013 and that can make all the difference.<\/p>\n\n\n\n

 <\/p>\n\n\n

\n\t
\n\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t\t

Subscribe to the Sage Advice Newsletter<\/h2>\n\n\t\t\t\t\t\t\t\t\t
\n\t\t\t\t\t\t

Get a roundup of our best business advice in your inbox every month.<\/p>\n\t\t\t\t\t<\/div>\n\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\tSubscribe<\/a>\n\t\t\t\t\t\t\t<\/div>\n\n\t\t\t\t\t<\/div>\n\n\t\t\t\t\t\"\"\t\t\t<\/div>\n<\/div>\n\n

\n\t
\n\t\t
\n\t\t\t
\n\t\t\t\t

Browse more topics from this article<\/h3>\n\t\t\t<\/div>\n\t\t\t
\n\t\t\t\t