Bank Statement difference

I have been working through some bank statements and came across a receipt which hadn’t been logged in the system. At the time (20/6/14) I created an invoice (dated 27/5/13) and logged the payment against it (dated 28/5/13), and carried on checking and everything balanced up to the end of Oct 13, when I stopped for the day. I then logged on to do some more on the 11/7/14 and added transactions for Nov 13 but the balance was £56 out. I checked back for numerous months and every one I checked was also out by £56, I couldn’t understand as we would not have continued forwards if any month did not balance. I then checked back to the beginning of my records on Quickfile and even Sept 11 is now out by £56! I have subsequently deleted and re-entered the May 13 invoice and payment for £56 which I had created on the 20/6/14, in case this was the issue, but to no avail. As things stand at the moment I have deleted the invoice and payment for £56 from May 13 again and as such the bank statement for May and QF records should be out by £56, but they match, as all balances from Sep 11 to May 13 are overstated by £56. Not sure what is going on? Please help!

Check your opening balance is correct.

Yes it is correct and has been since I set it all up.
Thanks.

Have you used the reconcile tool at all? Does that throw up anything that may be missing / added extra?

I noticed a few credits for £56 so I would assume there’s a duplication somewhere. As @Parker1090 suggests I would use the reconcile tool to establish at what point the balance goes out.

Finally found the issue!! All sorted now.

2 Likes

This topic was automatically closed after 24 hours. New replies are no longer allowed.