Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
  #12  
Old 11-04-2008, 08:03 PM
Ken
Guest
 
Posts: n/a
Default Re: MNY17 - Mortgage 'bill' has incorrect sum of splits

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  
Old 11-04-2008, 02:51 PM
Ken
Guest
 
Posts: n/a
Default Re: MNY17 - Mortgage 'bill' has incorrect sum of splits

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  
Old 11-04-2008, 02:20 AM
bunkerbob
Guest
 
Posts: n/a
Default RE: MNY17 - Mortgage 'bill' has incorrect sum of splits

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  
Old 11-02-2008, 03:12 PM
Dave Cattley
Guest
 
Posts: n/a
Default RE: MNY17 - Mortgage 'bill' has incorrect sum of splits

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  
Old 11-01-2008, 03:21 PM
delgados129
Guest
 
Posts: n/a
Default RE: MNY17 - Mortgage 'bill' has incorrect sum of splits

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  
Old 10-28-2008, 03:11 PM
bunkerbob
Guest
 
Posts: n/a
Default RE: MNY17 - Mortgage 'bill' has incorrect sum of splits

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  
Old 09-18-2008, 02:14 PM
Dave Cattley
Guest
 
Posts: n/a
Default Re: MNY17 - Mortgage 'bill' has incorrect sum of splits

Thank you all for your time and suggestions.
-dave
  #5  
Old 09-18-2008, 01:30 AM
Marilyn & Bob
Guest
 
Posts: n/a
Default Re: MNY17 - Mortgage 'bill' has incorrect sum of splits

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  
Old 09-18-2008, 01:12 AM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: MNY17 - Mortgage 'bill' has incorrect sum of splits

In microsoft.public.money, Dave Cattley wrote:

- quote -

> 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.

  #3  
Old 09-17-2008, 11:28 PM
Dave Cattley
Guest
 
Posts: n/a
Default Re: MNY17 - Mortgage 'bill' has incorrect sum of splits

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  
Old 09-17-2008, 06:07 PM
Dick Watson
Guest
 
Posts: n/a
Default Re: MNY17 - Mortgage 'bill' has incorrect sum of splits

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  
Old 09-17-2008, 11:48 AM
Dave Cattley
Guest
 
Posts: n/a
Default Re: MNY17 - Mortgage 'bill' has incorrect sum of splits

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
> 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.


I too have been using MNY since 1.0 and have not experienced this problem
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
> Principal?

[Good question, how would I know? I did not that when I moved the mortage
into the debt planner as suggested by the MVP FAQ that MNY said that a number
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
> 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
the loan into and then out of DRP but keeping the bill to 'rebuild' the bill.
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
> something that isn't or is incorrectly entered in the loan setup?

[NO. Conventional 25-yr fixed rate US mortgage with no baloon. Pretty
basic stuff.]

Thanks again for you time.
-dave
 
Old 09-17-2008, 04:36 AM
Dick Watson
Guest
 
Posts: n/a
Default Re: MNY17 - Mortgage 'bill' has incorrect sum of splits

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
newsEA5C10F-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  
Old 09-17-2008, 01:36 AM
Dave Cattley
Guest
 
Posts: n/a
Default MNY17 - Mortgage 'bill' has incorrect sum of splits

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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off

All times are GMT. The time now is 03:55 AM.