Balance keeps changing
I've been using MD for about a year. I started out with MD and checkbook the same balances. I entered all my entries for the 1st of September. My checkbook balance ended up $370.00 less then MD. I deleted all the entries and reentered again and now I'm 905.82 off. Without question I've checked all entries and all is OK. This has happened in previous months and I thought it might be me but I can't find anything wrong with my addition and subtraction unless it is my adding machine. I've added/subtracted the error amount to make everything balance but there seems to be something wrong somewhere and has happened a number of times. Any suggestions where the problem is?
Comments are currently closed for this discussion. You can start a new one.
Keyboard shortcuts
Generic
| ? | Show this help |
|---|---|
| ESC | Blurs the current field |
Comment Form
| r | Focus the comment reply box |
|---|---|
| ^ + ↩ | Submit the comment |
You can use Command ⌘ instead of Control ^ on Mac
1 Posted by Ben Spencer on 13 Sep, 2009 04:35 PM
Hi Richard
I am sorry I haven't gotten back to you sooner. I am something of a loss as to what to suggest. I have a very high level of confidence that moneydance is not making an error when summing the transactions in your account. The algorithm foe calculating the balance of an account is simple and we would be recieving a great many complaints if this were not functioning correctly. One thought is that the initial balance for your account in Moneydane is not set correctly. Go intot he transaction register for the account in question and Select "Edit Account" from the Acounts menu. Please make use that the "initial balance" value is set to the correct balance for the date that you started using Moneydance.
Sincerely
Ben Spencer
2 Posted by Archie Ferrier on 01 Nov, 2009 05:25 PM
I have been using MD since 2004 with no problems but a couple of months ago, when doing a reconciliation, the balance showed as being about £500 out. I have checked back to January 2008 and the error is from prior to this date. This is impossible because, as I said, it was functioning correctly until September this year. I am totally at a loss but don't want to have to input all my statements again from 2004 to present in order to correct this. It has had the same effect on all of the accounts that my wife and I are tracking in MD although I have only checked back in one account to try to find the cause.
Any assistance would be appreciated.
3 Posted by Frank Hampel on 02 Nov, 2009 03:43 AM
Archie, is it possible that you mis-entered the date of a recent transaction?
4 Posted by Ben Spencer on 02 Nov, 2009 02:12 PM
Archie
The most likely cause is that you have inadvertently added deleted or edited a transaction with a prior data. If you have a backup file you could check against that and see if you can determine when the unwanted change occured.
I am not sure what you mean by "It has had the same effect on all of the accounts that my wife and I are tracking in MD although I have only checked back in one account to try to find the cause." Are you saying that all accounts are $500 off?
Ben Spencer
5 Posted by Archie Ferrier on 06 Nov, 2009 06:14 PM
Hi Ben
Thanks for your response. I don't think this problem could have been caused by entering data incorrectly as it has affected three savings accounts and two credit card accounts. The amounts that the final balance is out by differs from one account to another and the error goes back more than a month despite the account having been previously reconciled. In the case of my current (checking) account I have traced back a couple of years and the error exists then. It is not possible that the error could have been made this far back as I have always been able to reconcile this account. When I restore from a back-up the error still exists.
Archie
6 Posted by Ben Spencer on 29 Nov, 2009 04:07 PM
Hi Archie
One possibility is that you might have deleted an account that you were no longer using. Doing so would have deleted all transactions that were assiocated with that account and would change the balance on other accounts even if they were reconciled.
How old is the backup file your restored from. If you try an older one is the problem still present?
Sincerely
Ben Spencer
7 Posted by R Levski on 29 Nov, 2009 04:26 PM
I think you are right! I did have trouble about two months ago and I
thought I started over but apparently not.
Thanks for the quick answer. I hope if I have any problems starting over
that I can contact you.
Name hear is Dick Levandowski
8 Posted by Archie Ferrier on 10 Dec, 2009 09:13 PM
Hi Ben
I have not deleted any accounts since I started using MD several years ago. This appears to be something that occurred totally spontaneously.
Regards
Archie
Angie Rauscher closed this discussion on 17 Dec, 2009 03:28 AM.