Bank reconciliation troubleshooting
Missing transactions
If any transactions are missing:
-
Go to Bank and select View / Add Transactions for the required bank.
-
Ensure that the transactions you are expecting to see on your reconciliation are listed here. If they aren't, you'll need to recreate them. Use the audit trail report to identify anything that may have been inadvertently deleted.
-
If your transactions are listed here then move on to the next step.
Restart the Reconciliation
The main cause of a transaction not showing is if the transaction has been modified (such as amount, date, etc.) whilst a reconciliation is in progress.
-
Go to Bank > Reconcile > Resume the current reconciliation > Abandon. This will abandon the current reconciliation that is in progress.
-
After this reconciliation has been abandoned, restart it by going to Bank > Reconcile, your transactions should now display. If not, then your transactions will likely be currently reconciled via another bank reconciliation method.
Old Bank Reconciliation
If your transactions are still not showing it’s likely they are reconciled via the old bank reconciliation method. Check this by going to Settings > Advanced Settings > Untick the box for Split Screen Bank Rec > Update.
When this is done go to Bank > Reconcile >and enter in the statement start date as the start date of the bank account and any balance > Reconcile, any transactions ticked here will not be displayed on the split screen bank rec. To continue you will need to either untick all transactions or view our guidance on switching from old bank rec to new bank rec.
Start date incorrect
Your reconciliation start date is based upon one of the following;
Your last reconciliation– if you’ve reconciled before then the start date will be the day after your last reconciliation.
Bank account start date – the start date is set in Bank > Edit Details > Advanced Options > Start Date field. This should be set to a date before the first transaction.
Reconciliation date – if you’ve just moved over to IRIS Elements Cashbook and have been using previous accountancy software then you’ve most likely reconciled before; you can set the date to which you have previously reconciled up to by going to Bank > Edit Details > Advanced Options > and set the Reconciliation Date to the date that you previously reconciled up to, the start date will be the day after this.
Start Date doesn’t match your previous reconciliation end date
If you’ve found that your reconciliation start date doesn’t match the end date of your previous reconciliation that it’s likely one of the details above have been edited.
Follow the steps below to correct this.
Modify your reconciliation date to be the same as the end date of your last reconciliation.
-
Select Bank > Reconcile > Previous Reconciliations and take note of the last reconciliation end date.
-
Go to Bank > Edit Details > Advanced Options and check the start date is before the reconcile date, then change the reconcile date to be the same as your previous reconciliation end date.
-
Select Save Changes.
The bank account start date must be before your first bank transaction in IRIS Elements Cashbook.
Start or reconcile date changed
If you get an error on a bank reconciliation advising that your start or reconcile date has changed, this means that the start / reconcile date in the bank account settings has been changed. Use the guidance below to correct this.
Step 1 – Take Notes
Start by finding out the date of your very first reconciliation.
-
Go to Bank > Reconcile. Below are your previous reconciliations.
-
Make sure you’re on page 1 of your previous reconciliations, if not select the Oldest link.
-
On this screen, the reconciliation at the very top of the list will be your oldest reconciliation. The starting date of that is the key piece of information you’re looking for. Write that down.
Starting balance does not match closing balance of previous reconciliation
The starting balance for a reconciled period should always match the closing balance of the previous reconciliation. If it doesn’t, then it is likely there has been a change in the data that has caused the current balance to different.
Example of error:
Troubleshooting the cause of the problem.
Checking the opening balance of first reconciliation.
Firstly, check that the very first opening balance amount is correct. The opening balance is calculated based of the information entered in the Bank > View / Add screen prior to the start date of the account, and if there is any opening balance amount entered in the edit bank details screen.
-
Make a note of the start date and balance on the very first reconciliation.
2. Go to Bank screen and click on the pencil icon in the top-right corner of the bank.
3. Ensure that the Reconcile Date is one day before the start of your reconciliation:
4. Also, check if there is a balance in the Start Balance box. We would recommend leaving this blank and enter an opening via a journal entry (for more information visit this knowledge base article):
5. Go to Bank > View / Add and put in the date range of any historical day up to the start date of your first reconciliation. As you can see from the example before, there has been an opening balance journal entered in December 2019 and has set the running balance as £14,800 which matches that of the reconciliation.
If this is correct, then you will need to move onto the next section for further troubleshooting.
Possible errors
Reconcile Date in Edit Bank details is incorrect – ensure to set it back to the day before the start of the first reconciliation.
If the opening balance journal is missing – you would need to enter this.
If there are other bank transactions entered before the start date – these should be removed before you can carry on ensuring that the opening balances match.
Checking previous reconciliation that might be showing in 'Error' or 'Incomplete'.
-
Go back to Bank > Reconcile and check all previous pages of bank reconciliations to see if any are showing in Error or Incomplete.
Error – usually an item has been changed or deleted.
Incomplete – a bank reconciliation has been edited but not saved again.
-
If more than one reconciled period is showing in error, you will need to start from the first one and then work through them in order.
In the below example, the first and second reconciliation is showing in error. This will mean we will need to correct the first reconciliation starting from 1st January 2020 to 31st January 2020 first.
-
Click into the reconciliation and you should be presented with an error to which will help explain what the issue is.
How to correct a reconciliation showing in error
Using the above view, gain a copy of the original bank statement for this period and go through each transaction and check that everything matches, or if there is anything missing.
According to the bank statement, every transaction is correct except for one item:
In this case, one of the entries has got a transposed number, it is entered as £42.00 when it should be £24.00.
-
Go to Bank > View / Add and find the transaction and edit it so that shows correctly.
-
Go to Reconcile Statement at the top of the screen and you should now see that the bank reconciliation is now showing as Complete.
If you are not able to edit the transaction because it has been included on a VAT return, then you will need to create a new transaction coded and date, in the same way, to account for the difference.
When you go back to the reconciliation screen you will need to open that reconciled period and click Edit Reconciliation at the top and put a tick to reconcile that adjustment. Once this has been ticked it should allow you to click Save and Reconcile.
Step 1:
Step 2:
Step 3:
Step 4:
-
Once the reconciliation has been completed, move onto the next reconciliation in error and follow the same process by checking against the bank statement for any changed or deleted items.
In this example, it looks as though an item has been deleted.
We can check this by looking at the Audit Trail from the Reports menu.
-
If this is the case, you will need to re-add the transaction by going to Bank > View / Add.
-
Select Reconcile Statement at the top of the screen and click into that errored reconciliation and select Edit reconciliation.
-
Tick the box for that transaction:
-
Select Save & Reconcile at the top of the screen.
-
This should now show your previous reconciliation as Complete.
-
As the amendments to the previous reconciliation have now been completed, the latest Incomplete reconciliation will need to be deleted as it is still showing the wrong starting balance.
-
When you go back to the Reconciliation screen, you will see that the start balance is now matching the closing balance of the previous reconciliation.
If you have followed the steps above and you are still struggling to find why the starting balance doesn’t match the closing balance of the previous reconciliation, please contact support by emailing support@kashflow.com and include as much information as you can. If you can also enable the support access from the Help menu we will be able to look at this straight away for you.
Transactions have been edited, added or deleted
If you get an error on a bank reconciliation advising that you that transactions have been edited, added or deleted since your reconciliation was completed then this will unbalance previously completed reconciliations due to the data entered no longer being applicable.
Use the steps below to diagnose and correct this;
Step 1 – Take notes
Go to Bank > Reconcile > Previous Reconciliations and take a note of your latest reconciliation dates, starting balances and ending balances.
Step 2 – Compare to the View / Add Transactions screen
Go to Bank > View / Add and compare the balances that are on your previous reconciliation screen to the ones listed here. Start with the latest and work backwards until you find one that matches.
The point where they match is the last correct reconciliation. From that point onwards something has changed. This could be that a transaction date has changed, a transaction has been edited, added or deleted.
You will need to abandon all reconciliations from this point onwards and re-reconcile. You can then identify the transaction that has been modified, correct it and then re-reconcile again.
The Audit Trail
You may be able to identify what transaction has been modified and when by using the audit trail.
-
Go to Reports > General Reports > Audit Trail.
-
Set the start date to the date that you did your last reconciliation successfully and the end date to today.
-
Set it to Transactions created or edited between:and enter the dates.
-
Select Include deleted items and set the report to Include Invoice Payments, Purchase Payments and Bank Transactions only.
-
Select Run Report.
