The Closing Balance of Balance Sheet in Manager is 658.91
The Closing Balance of Bank Statement (actual bank account) is 801.03
801.03 is the amount entered as closing balance for 31/12/2015 while reconciling using reconciliation report in Manager.
If the Report shows successfully reconciled, then shouldn’t the Closing balance of Bank statement and Balance Sheet match?
Your question cannot be answered because the other person’s problem was never revealed, if there was even any follow-up. And if you won’t answer questions, no one can help. The original problem described in this thread was not reproducible so far as I know. So you are going to have to provide detailed information, screen shots, etc.
If Lubos requests my data I will send it through. In the meantime I will spend another few days trying to get my head around all of this. As I am ridiculously green at all this and it could be I am doing something silly at my end.
Yes I noticed that suggestion in the earlier replies. I discovered I did have three items in the suspense account when I ran the reconciliations which I have later corrected. There are still some other items in Suspense that shouldn’t be relevant to those months. But what I will do is work through the data removing any items in suspense and then I will jiggle my balance so that the data won’t reconcile and double check all the remaining data matches. Then I will run the reconciles again. This will take me a number of days though as I don’t get much time to myself to do this stuff.
One never knows. Manager puts things in Suspese for a variety of reasons, not all of which may be obvious. Since you say there is a constant 400 difference, the thing is to drill down on the account balance. Sort it by amount by clicking on the column heading. That will make it easy to find any 400 transaction.
Yes I probably should have upgraded to the latest before posting. Was muddle headed yesterday.
Have updated to 17.8.12.
I deleted the closing balance for the 28/10/2015 transaction then deleted the reconciliation report.
Then I recreated it and it still came up as reconciled with differing balances.
I think I will delete all balances and reports and re reconcile from the beginning again as a first step. Would you suggest I try that?
Then continue fixing the billions of errors that are likely in my data
Thanks for replying!
If you mean to generate a bunch of reconciliation reports going back to 2015, no, I wouldn’t recommend that. Reconcile as of the date of the most recent bank statement or online balance you can obtain. If you reconcile, you are reconciled. Having more interim reports doesn’t help anything. Manager will guide you through a process of narrowing down.
Understand that those reports you saved aren’t actually reports. They are definitions of parameters for reports. The actual reports are regenerated every time you look at them. So there is no harm or risk in deleting them.