|
#12
| |||
| |||
| Re: Thanks for the tip Ken... image should be attached... You're Welcome, and yes, I see the image. The problem is a lot of news servers delete attachments to post or even delete the whole post. For those reading this thread via one of those news servers will never see your image or your post for that matter. Ken "bunkerbob" <no[at]email.net> wrote in message news:%23j2DUNqPJHA.4756[at]TK2MSFTNGP02.phx.gbl... | Thanks for the tip Ken... image should be attached... | "Ken" <PleaseReply[at]NewsGroup.Thanks> wrote in message | news:%23ljV%23UpPJHA.4224[at]TK2MSFTNGP03.phx.gbl... | > Re: I saved a screen shot of the critical dialogue box; wish I could post | > it | > here. | | > Hi, | | > You can attach up to 100 KB images (.jpg) if you access this newsgroup | > with | > your Outlook Express News Reader via a microsoft news server. | | | | |
|
#11
| |||
| |||
| Re: I saved a screen shot of the critical dialogue box; wish I could post it here. Hi, You can attach up to 100 KB images (.jpg) if you access this newsgroup with your Outlook Express News Reader via a microsoft news server. If you use the link below it should set up Outlook Express to this newsgroup. Be sure you have Outlook Express open before using the link. If the link is not clickable, copy and paste it into your browser news://news.microsoft.com/microsoft.public.money Ken "bunkerbob" <bunkerbob[at]discussions.microsoft.com> wrote in message news:A80EEDD7-98A5-43D1-9F96-375BE82445F3[at]microsoft.com... | Glad that worked out for you guys. I did a little celebration myself a few | minutes ago when I downloaded my latest bank statement, which included a new | mortgage payment, and Money handled the P&I split without any manual | intervention! One small step for man... | | btw... I saved a screen shot of the critical dialogue box; wish I could post | it here. But for anyone else who stumbles across this thread, (...like maybe | the MS Money 2010 team!), the dialogue box is titled "Update Default Loan | Payments", and the option that solved the problem is "Change this loan and | any recurring bill I have set up for it." There really needs to be an | obvious way in the software to open that dialogue for any loan. | | > That worked. Thank-you very much for sharing your findings. | | |
|
#10
| |||
| |||
| Glad that worked out for you guys. I did a little celebration myself a few minutes ago when I downloaded my latest bank statement, which included a new mortgage payment, and Money handled the P&I split without any manual intervention! One small step for man... btw... I saved a screen shot of the critical dialogue box; wish I could post it here. But for anyone else who stumbles across this thread, (...like maybe the MS Money 2010 team!), the dialogue box is titled "Update Default Loan Payments", and the option that solved the problem is "Change this loan and any recurring bill I have set up for it." There really needs to be an obvious way in the software to open that dialogue for any loan. - quote - > That worked. Thank-you very much for sharing your findings. |
|
#9
| |||
| |||
| Pure Genius! That worked. Thank-you very much for sharing your findings. I guess the developers of Money could not bring themselves to create a single, consitent, usable, and *correct* mechanism for maintaining a loan/bill association. Instead, they created three; got two of them to work equally wrong, but somehow missed the third which works correctly. I expect they will 'plug' the abhorance (the one working correctly) in the next release to make sure all is consistent (-ly broken). However, my woes are temporarily fixed and I will *never* archive my data again. I truly appreciate your help. Cheers, -dave |
|
#8
| |||
| |||
| Thanks bunkerbob...the well documented steps detailed in you post corrected this issue for me. "bunkerbob" wrote: - quote - > Dave, I just spent about 2 hours wrestling with what I think was exactly the > same problem, and finally got it fixed, like this: > 1. deleted bill that wasn't working properly > 2. manually adjusted the previous bill payment in my bank account register > to the correct principle/interest split. > 3. right-clicked on that last payment, and chose "Make recurring...." > 4. clicked on OK, which brought up a dialogue box saying that my payment > matched an existing loan payment and giving me several options about changing > the loan and/or existing payment. The first time I tried this I told it NOT > to change the loan, but that didn't work. The second time I told it to > change the loadn and the existing bill (that was the first option), and > finally the new payment that was created had the right split for principle > and interest. I tested entering a few month's worth of transactions, and > they correctly recalculated the P&I each time, even though the word > "calculated" didn't appear in the payment setup screen. > Hope this helps. > Bob. > "Dave Cattley" wrote: > > However, when I create the bill and (or) when I try to enter the bill, the > > error "sum of splits does not match total transaction" occurs (as others > > report). |
|
#7
| |||
| |||
| Dave, I just spent about 2 hours wrestling with what I think was exactly the same problem, and finally got it fixed, like this: 1. deleted bill that wasn't working properly 2. manually adjusted the previous bill payment in my bank account register to the correct principle/interest split. 3. right-clicked on that last payment, and chose "Make recurring...." 4. clicked on OK, which brought up a dialogue box saying that my payment matched an existing loan payment and giving me several options about changing the loan and/or existing payment. The first time I tried this I told it NOT to change the loan, but that didn't work. The second time I told it to change the loadn and the existing bill (that was the first option), and finally the new payment that was created had the right split for principle and interest. I tested entering a few month's worth of transactions, and they correctly recalculated the P&I each time, even though the word "calculated" didn't appear in the payment setup screen. Hope this helps. Bob. "Dave Cattley" wrote: - quote - > However, when I create the bill and (or) when I try to enter the bill, the > error "sum of splits does not match total transaction" occurs (as others > report). |
|
#6
| |||
| |||
| Thank you all for your time and suggestions. -dave |
|
#5
| |||
| |||
| I note that you say that you archived your data at some point. I don't know if that is the cause of your problem, but I think that you will find that all of the experienced users here believe that archiving is a major mistake. As such, none of the experts here archives their data, so they do not any experience to relate your problem to. This further suggests that you will probably do better with a support case with MS than with help from your peers in this group. -- Peace, BobJ "Cal Learner-- MVP" <via_newsgroup[at]please.tnx> wrote in message news:1la3d4h0aetqbnuabllpdrs0o47tc3hj85[at]4ax.com... - quote - > In microsoft.public.money, Dave Cattley wrote: > > > Again, thanks for your suggestion. I did try that approach with no net > > effect. After deleting the bill data, the same issue persists when the > > mortgage bill is re-created. The principal value is too high such that > > P+I+Escrow exceeds the correct payment sum. > Are you defining this as a loan? If so, I suggest you not enter the > interest rate. Instead leave that blank, and enter the other > information. Let Money compute the interest rate. |
|
#4
| |||
| |||
| In microsoft.public.money, Dave Cattley wrote: - quote - > Again, thanks for your suggestion. I did try that approach with no net
Are you defining this as a loan? If so, I suggest you not enter the> effect. After deleting the bill data, the same issue persists when the > mortgage bill is re-created. The principal value is too high such that > P+I+Escrow exceeds the correct payment sum. interest rate. Instead leave that blank, and enter the other information. Let Money compute the interest rate. |
|
#3
| |||
| |||
| Mr. Watson, Again, thanks for your suggestion. I did try that approach with no net effect. After deleting the bill data, the same issue persists when the mortgage bill is re-created. The principal value is too high such that P+I+Escrow exceeds the correct payment sum. Regards, -dave |
|
#2
| |||
| |||
| I wasn't suggesting your problem wasn't a problem or hadn't been reported here. Only that it isn't reported often enough to have risen to a level where there is a community understanding of the root cause and how to fix it. That's one reason I suggested that a support case with Microsoft might be in order. My addled brain is having touble coning in on v17 but I think this is M+. If so, then one more thing I might try is this: in a COPY of the file, I'd "Nuke The Bills". (File|Repair|Remove bills data or something like that.) Then I'd re-create the scheduled Loan Payment and enter one to see what happens. Good luck. |
|
#1
| |||
| |||
| Mr. Watson, Thank you for your suggestions. - quote - > I'm not sure exactly what's going on here, but I don't think there are a
I too have been using MNY since 1.0 and have not experienced this problem> vast number of reports of this or that most or even very many users see this > situation. I've never seen it in about fifteen years of using Money and Loan > Accounts and Scheduled Bills to pay them. until now (well, it started on its own some months ago without much explanation). Without a doubt if there 'vast' accounts of this symptom, it would probably have gotten lots of attention from PSS. None the less, a simple NG or Google search (even a FAQ entry by some MNY MVPs) shows that related symptoms (busted mortage bills) are experienced by more than just me. - quote - > It's very hard to guess what could be causing this. Are the bills being paid > on schedule? [YES] - quote - > Do you have the correct term and payment frequency defined? [YES] - quote - > Is there some reason Money might think that you are behind schedule on
into the debt planner as suggested by the MVP FAQ that MNY said that a number> Principal? [Good question, how would I know? I did not that when I moved the mortage of payments were missing and gave me the option to say 'they had been paid'. When I look into the register for the load, it shows payments from payment #28 to #60 (the most current). Now, I did not ever delete #1..#27 but they seem to have been removed by data archiving in 2006 (these are the payments for 2005 and prior). However, this issue did not occur until recently so this 'data' had been removed for two versions of the program and over two years. Moreover, the balance, term, remaining payments, and amortization schedule report are *correct* so how is it that MNY would not be able to figure the payment for the bill when it perfectly figures the payment for the report.] - quote - > Are you using Debt Reduction Planner? (Not sure it could cause
the loan into and then out of DRP but keeping the bill to 'rebuild' the bill.> this, but if I saw this and were using it, it's a vector I'd investigate.) [NO. I simply used the technique on a MVP FAQ of deleting the bill, moving This turns out to do nothing more than what can be done by just adding the bill back. I suspect the FAQ was written for a prior version where the ability to add a bill for an amortized loan was not as simple as it is in the present version.] - quote - > Is there something odd about the loan terms like a balloon payment or
basic stuff.]> something that isn't or is incorrectly entered in the loan setup? [NO. Conventional 25-yr fixed rate US mortgage with no baloon. Pretty Thanks again for you time. -dave |
| | |||
| |||
| I'm not sure exactly what's going on here, but I don't think there are a vast number of reports of this or that most or even very many users see this situation. I've never seen it in about fifteen years of using Money and Loan Accounts and Scheduled Bills to pay them. It's very hard to guess what could be causing this. Are the bills being paid on schedule? Do you have the correct term and payment frequency defined? Is there some reason Money might think that you are behind schedule on Principal? Are you using Debt Reduction Planner? (Not sure it could cause this, but if I saw this and were using it, it's a vector I'd investigate.) Is there something odd about the loan terms like a balloon payment or something that isn't or is incorrectly entered in the loan setup? Those are just some of the things that come to mind as avenues I'd explore. But there is not a general problem effecting lots of users with a known fix that I'm aware of. And I read a lot of posts here. Good luck. This may be a good candidate for a support case opened directly with Microsoft. "Dave Cattley" <DaveCattley[at]discussions.microsoft.com> wrote in message news EA5C10F-63C6-4445-AC34-C07A2A4038DB[at]microsoft.com...- quote - > However, when I create the bill and (or) when I try to enter the bill, the > error "sum of splits does not match total transaction" occurs (as others > report). As others have reported, the value of the principal is off by > quite > a while the interest calculation seems to be correct. |
|
#-1
| |||
| |||
| Ok, I have read many other posts with this symptom and tried to 'fix' my bill for my mortgage using the recommended remedies including deleting the bill and re-creating it, moving the mortage in & out of debt planner to create the bill, etc. When I create the bill I *do* get the "Calculated" values for P & I and the value for the escrow (transfer) is correct based on the loan data. However, when I create the bill and (or) when I try to enter the bill, the error "sum of splits does not match total transaction" occurs (as others report). As others have reported, the value of the principal is off by quite a while the interest calculation seems to be correct. Every time I enter the bill instance, I have to manually edit the principal amount 'down' by the unassigned amount to get it all to balance up correctly. The amortization report seems correct (within the margin of error for MSMoney vs. my bank - apparently one or the other has a different notion of how math works as they cannot ever agree to the penny). Running the "update loan" wizard does not fix anything. Recreating the bill does not fix anything. Running salvage does not fix anything (ever, as far as I can tell). Failures like this are annoying and destructive of confidence in a product that one uses to manage finances. If someone has yet another remedy to try, please let me know what might fix this gremlin once and for all. -dave |
| Tags |
| bill, incorrect, mny17, mortgage, splits, sum |
Similar Threads | ||||
| Thread | Forum | Replies | Last Post | |
| Mortgage and bill payment duskycub: Ok i got the Mortgage setup 5 months ago but my payment changed. So i setup the amount in the Loan setting but i can not get my bill Summary to... | Microsoft Money | 3 | 09-23-2005 11:07 PM | |
| newbie--mortgage splits insurance Anne S: Thanks for the unofficial FAQ! I couldn't find my problem, though the recent escrow difficulties are similar. Today I thought I'd properly... | Microsoft Money | 1 | 07-14-2004 01:02 AM | |
| Mortgage Bill Set-Up Shooter71: I have created a mortgage account in Money which included all required load information, and I wanted to set up an automatic bill entry. I have... | Microsoft Money | 1 | 04-18-2004 09:16 PM | |
| Thread Tools | |
| Display Modes | |
| |