|
#2
| |||
| |||
| Thanks for the suggestion. Unfortunately I think even at the date of your reply it was way too late to go back to any backups I had since none of them would have predated the problem surfacing. Several years ago there was an issue when I skipped balancing for a couple months and DID accept an incorrect (different from paper statement) opening balance. In the end I had to make an adjustment in order to get it to reconcile (unlike now, when it reconciles by using statement start/end amounts. In a subsequent month it had an error of the same amount and opposite sign, and I think there was a 3rd adjustment made. After that....no problems for several years. Maybe this has just come back to haunt me now for some reason. Problem continues as of 12/31 statement and I will note if (as I assume) the error is the same amount each month. On Mon, 17 Dec 2007 08:28:01 -0800, Bill Becker <BillBecker[at]discussions.microsoft.com> wrote: - quote - > When your bank statement opening balance differs from your MSMoney opening > balance it's a sign that there is a difference between MSMoney and the bank > in a previous month. As soon a this happens, look to see if you have > inadvertently changed or deleted a transaction in an earlier month. This can > be hard to find! > One technique for locating the problem is to open a backup made before the > problem started and export the account transactions to Excel. Then export > the transactions from the current file and use Excel to compare the lists. > Once you find the problem transaction you can correct it in the current file. |
|
#1
| |||
| |||
| When your bank statement opening balance differs from your MSMoney opening balance it's a sign that there is a difference between MSMoney and the bank in a previous month. As soon a this happens, look to see if you have inadvertently changed or deleted a transaction in an earlier month. This can be hard to find! One technique for locating the problem is to open a backup made before the problem started and export the account transactions to Excel. Then export the transactions from the current file and use Excel to compare the lists. Once you find the problem transaction you can correct it in the current file. -- Bill Becker "Cal Learner-- MVP" wrote: - quote - > In microsoft.public.money, kaplan3jiim[at]example.com wrote: > > When I go to reconcile my credit union checking statement each of the > > last several months with my money account, the starting balance is not > > what I entered the previous month from my paper statement. When I > > change it to what the paper statement says, I get a warning. I ignore > > the warning, enter the statement ending balance, and the account > > always reconciles to 0 discrepancy. But then next month, the previous > > ending balance gets changed when I go to reconcile the new month and I > > again have to correct. > > > This started a few months ago. Never had a problem before and I don't > > think I changed any settings to trigger the problem. I believe it did > > start before I upgraded from M05 to M+. . I can go on doing this > > indefinitely, but would prefer to find a way for it to stop nagging me > > for something that is not wrong. > Bonnie Synhorst said: > |Balancing can be frustrating. .. My rule of thumb is to avoid > |changing the starting statement balance that it asks for. If you > |do this, it will try to make an adjustment that you may not have > |needed to make (if you were balancing months out of order, for > |instance). I recommend balancing month by month starting from the > |earliest date after you are sure that nothing is marked with an R. > | > |Just remember, the opening balance it asks for is a calculation of > |the opening account balance plus or minus any reconciled > |transactions. |
| | |||
| |||
| In microsoft.public.money, kaplan3jiim[at]example.com wrote: - quote - > When I go to reconcile my credit union checking statement each of the
Bonnie Synhorst said:> last several months with my money account, the starting balance is not > what I entered the previous month from my paper statement. When I > change it to what the paper statement says, I get a warning. I ignore > the warning, enter the statement ending balance, and the account > always reconciles to 0 discrepancy. But then next month, the previous > ending balance gets changed when I go to reconcile the new month and I > again have to correct. > This started a few months ago. Never had a problem before and I don't > think I changed any settings to trigger the problem. I believe it did > start before I upgraded from M05 to M+. . I can go on doing this > indefinitely, but would prefer to find a way for it to stop nagging me > for something that is not wrong. |Balancing can be frustrating. .. My rule of thumb is to avoid |changing the starting statement balance that it asks for. If you |do this, it will try to make an adjustment that you may not have |needed to make (if you were balancing months out of order, for |instance). I recommend balancing month by month starting from the |earliest date after you are sure that nothing is marked with an R. | |Just remember, the opening balance it asks for is a calculation of |the opening account balance plus or minus any reconciled |transactions. |
|
#-1
| |||
| |||
| When I go to reconcile my credit union checking statement each of the last several months with my money account, the starting balance is not what I entered the previous month from my paper statement. When I change it to what the paper statement says, I get a warning. I ignore the warning, enter the statement ending balance, and the account always reconciles to 0 discrepancy. But then next month, the previous ending balance gets changed when I go to reconcile the new month and I again have to correct. This started a few months ago. Never had a problem before and I don't think I changed any settings to trigger the problem. I believe it did start before I upgraded from M05 to M+. . I can go on doing this indefinitely, but would prefer to find a way for it to stop nagging me for something that is not wrong. TIA |
Similar Threads | ||||
| Thread | Forum | Replies | Last Post | |
| Clear "Bank Balance" and "Last Updated" columns? Rick Shafer: Money 2007 ... in the Account list, is there a way to clear (eliminate) the values shown under the "Bank Balance" and "Last Updated" columns for an... | Microsoft Money | 4 | 06-24-2007 12:53 PM | |
| balance on home page disagrees with balance of account Stimpy Stimperson: I'm still using Money 2004 (waiting for wildcard support in payee rules before upgrading) and WinXP Pro SP2, fully updated. In case the subject... | Microsoft Money | 3 | 02-14-2007 09:47 PM | |
| Statement balance disagrees with Money Mike Schatz: Greetings... I've been using Money for years and have always successfully balanced my account with my banks, but recently the ending balance my... | Microsoft Money | 2 | 02-05-2006 04:25 AM | |
| "bank balance" vs "local balance" Mister Shed: In Money 2004, how do I get the account list to show the correct bank balance, rather than some silly "local balance", whatever that is? Thanks ... | Microsoft Money | 2 | 07-02-2005 02:18 PM | |
| Thread Tools | |
| Display Modes | |
| |