Bank Reconciliation Question 1
Jee asks: Since the bank reconciliation statement should be done on a monthly basis, say if a company has a lot of banks, is it possible to out-source the bank reconciliation to the bank itself and what are the disadvantages?
In my experience it is not possible to outsource reconciliations to banks because they do not usually offer this service.
It is however possible to outsource the task to a bookkeeper or accountant.
order for a bank reconciliation to be done, access to the business cash
book/s is required. A business with many bank accounts should have a
separate cash book for each account.
I know of a lawyer who has
five separate bank accounts. Bank reconciliations are performed twice a
month for each using bookkeeping software.
There is bookkeeping
software available, such as Xero, that has the capacity to link directly
to the bank account. Every night the software automatically downloads
the bank transactions into the cash book, which saves the bookkeeper a
lot of time because they do not have to manually enter each transaction.
many banks provide a special file that can be downloaded directly into
the bank reconciliation section of the bookkeeping software so that the
cash book can be automatically updated... another time saver.
bank reconciliation Question 2
Maryam asks: If the beginning balance on the bank statement is not the same amount as the beginning balance in the cash book, for preparing the reconciliation how can we adjust the difference in the beginning balances?
How to fix the problem depends on whether you are using book-keeping software or keeping a manual cash book. Below are suggestions for both, but first, you need to find out what caused the problem in the first place. If you have already found the problem you can skip this part.
To find the problem, you need to go through the previous month's cash book and bank statement.
(Remember that the actual bank statement will always have the right closing balance so any issues or adjustments will be found and made in the cash book or reconciliation.)
Finding the Problem
- Go back through the reconciliation/cash book for the previous month and check them against the bank statement.
- Highlight any transactions on the statement that are missing from the cashbook, or
- Highlight any transactions in the cash book that are not on the bank statement.
- Check if the transactions from point 3 above have been included in the final part of the reconciliation for the previous month (i.e. the part that has ‘’add: outstanding withdrawals, less outstanding deposits’ – check the example on my bank reconciliation statements page (This will only apply to manual bookkeeping because most bookkeeping software automatically include these entries)
- If the previous month has nothing wrong you may need to check further back to older months.
- Once you know exactly what has caused the opening balances to differ, you can move on to making the adjustments.
If you are using specialized bookkeeping software (like Quickbooks, MYOB, Sage etc.) the best thing to do is call their support line and ask them to guide you through fixing the problem or search through their on-line guide for an answer. If for some reason you cannot do this, try the following:-
Step 1 :
Undo the completed reconciliation for last month, enter in the missing transactions, redo the reconciliation but please note:-
- Only undo the reconciliation if you know that any adjustments made are not going to mess up sales tax calculations that may have already been made and paid to the revenue department (such as GST or VAT etc.). If you don’t know what this means then chances are you don’t have to process this kind of tax in your country so don’t worry about it! But check with your local tax department to be sure.
- Some bookkeeping software will lock a month that has been reconciled and so will not allow you to undo the reconciliation or make any adjustments in the previous month. In this case, do Step 2 below.
Step 2 :
Enter the missing transactions from last month’s cash book into the current month of the cash book (use the date of the opening balance) and include them in your bank reconciliation for the current month. Even though these items are not on the current month’s bank statement you can still bring them in so that the closing balance of the reconciliation matches the bank statement. The disadvantages of this are:-
- Your profit and loss reports and balance sheet will not be 100% accurate for the current month or the previous month, however, the adjustments will balance out and make accurate the overall reports at the end of the financial year.
- The closing balance of last month and the opening balance of the current month being reconciled will still be wrong, but the closing balance of the current reconciliation month will be right, which is what you want. You should write out a note explaining what occurred and attach it to the back of the bank reconciliation so that if you have to look back at it later in the year you will be reminded of how it happened and what you did to fix it.
If you are using a manual bookkeeping system i.e. a handwritten cashbook, or excel spreadsheet, you should easily be able to go back through the previous month and do the necessary adjustments to ensure the closing balance matches the bank statement. Just remember however, if you have sales tax or VAT that has already been declared for last month, then simply follow Step 2 above.
What do to if this problem occurs at the end of the financial year
- If the wrong closing balance of last month happens to be the last day of the financial year and you are unable to undo the reconciliation or unlock last month to fix it, do any of the following:-
- Process the current reconciliation as per Step 2 above under “Bookkeeping Software” so that this month’s closing balance matches the bank statement, but make a special note to tell the accountant who processes your end of year accounts and tax. The accountant will be able to journal these transactions back into the correct financial year in his/her system for tax purposes, or
- Contact your bookkeeping software support line to find out what to do, or
- Contact your tax accountant and ask him/her what they want you to do.
Note: One of the first things an accountant does at the end of the year is to check your cash book closing balance and reconciliations against the bank statement for the final day of the end of the financial year. If there are differences on that final day, he will want to know why, so you may as well let him know up front instead of waiting for him to contact you.