How to Do A Bank Reconciliation – 3 Steps With Pictures
When you run a small business, it is very likely that you are going to have to deal with your business bank statements. But don't worry. Learning how to do it isn't hard. Here's How to Do a Bank Reconciliation. You need to have three things to start: your bank statement, the cash book and a calculator.
Start by gathering all the necessary documents
To carry out your bank reconciliation, you should have the following documents at hand:
- The account statements for the period in question;
- The relevant general ledger or 512 account statement;
- The latest bank reconciliation statement;
- Proof of cash movements (cheque remittances, cash remittances).
Get started by balancing the bank statement to the cash book
The first step in doing a bank reconciliation is balancing the bank statement to the cash book. This means that you will need to compare each transaction on your cash book with its corresponding transaction on your bank statement. This means adding up all deposits made into your account since the last time you reconciled it and subtracting any withdrawals from that total amount.
The goal here is to make sure that every single transaction matches up. If there are any discrepancies between these two records, then it is time for some detective work!
Now find the difference between the cash book and bank statement.
If there are any differences between these two sources of information, then it is time for some detective work! You will want to investigate where these differences are coming from so that you can make corrections accordingly in order to ensure that everything balances out correctly:
- Establish the starting balances: bank account balance and accounting account balance.
- Cross-reference the transactions between the bank account and the accounting account 512 :
- Establish the final match and show the reconciled balances.
Save the time you spend tracking customer invoices by automating your payment reminders and collection plans.Book a demo
Update your cash book according to what is on your bank statement
Once you have updated your cash book according to what is on your bank statement, it's time to compare the two documents together so that you can see if there are any differences between them. The easiest way of doing this is by using Excel or another spreadsheet program because this allows you to easily add up all of the figures together and check for discrepancies between them; however, if you don't want to use one of these programs then simply add up all of the figures manually using pen and paper instead.
If there are any discrepancies between what you have and what's on the bank statement, this is where you'll need to add or remove transactions from the cash book to make them match up again.
Make a note of any differences in your reconciliation journal (or use a spreadsheet). Once you've made sure everything matches up, make a note of any outstanding items and how much they are so that you can get them paid off as soon as possible.
How to set up the perfect bank reconciliation process using Libeo?
Reconciling your business' bank account is an easy task that can be mastered with Libeo.
From your Libeo user space, find all the invoices for which a payment on your bank account has been detected. You will be able to perform your bank reconciliation from the "Get paid" page. Libeo payments will be reconciled automatically:
- Select an account from the drop-down list on the left, or create a new account..
- Enter your bank statement into Libeo and match it against the deposits in your current file.
- When you are done entering all transactions, click "To reconcile" to generate a report containing any missing transactions and/or debits/credits that need to be corrected.
The financial and accounting management of your company is time-consuming and suffers from a paradox: if it is not efficient, the company is in danger; when the company is efficient, it is never thanks to its accounting management. Indeed, the time freed up by the automation of administrative tasks allows you to concentrate on the raison d'être of your company: its growth.
FIRESIDE CHAT : THE FUTURE OF ACCOUNTING
Watch our replay webinar, get an overview of what challenges SMBs currently face and how technology can help to tackle them.Access the replay