Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
  #4  
Old 02-26-2005, 04:36 PM
Dick Watson
Guest
 
Posts: n/a
Default Re: how to move mortgage from checking account into mortgage, escrow acct

Most municipalities and insurance companies send copies of the bills to you
saying that the mortgage company is set to pay them. You can enter them then
and when you get the annual statement from the mortgage company, it should
tell you stuff you already recorded.

"jmoeller18" <jmoeller18[at]gmail.com> wrote in message
news:1109438458.784221.147730[at]z14g2000cwz.googlegroups.com...
- quote -

> > Then when you see
> > an insurance bill or a tax bill, enter the payment in the escrow

> account as
> > your bank will.

> ok, like from the annual escrow account disclosure statement. i will
> hand enter the from escrow transactions so i understand what this
> account is doing



  #3  
Old 02-26-2005, 04:20 PM
jmoeller18
Guest
 
Posts: n/a
Default Re: how to move mortgage from checking account into mortgage, escrow acct

- quote -

> I recommend setting up a Cash account for the escrow and managing the

> expense it pays.


thanks for your ideas

- quote -

> As with many similar things in Money, if this choice really does
> exist but is not offered int he pull downs, type it out.


aha!

- quote -

> Then when you see
> an insurance bill or a tax bill, enter the payment in the escrow

account as
> your bank will.


ok, like from the annual escrow account disclosure statement. i will
hand enter the from escrow transactions so i understand what this
account is doing

- quote -

> Asset account is the best bet.

thanks for your ideas

- quote -

> But understand what an Asset account is for: it's just a way to
> track the value of your home to offset the liability of the mortgage

to give
> good net worth calculation. A side benefit is that they can be used

to track
> cost basis.


I'll leave this for another time

  #2  
Old 02-26-2005, 03:21 PM
Dick Watson
Guest
 
Posts: n/a
Default Re: how to move mortgage from checking account into mortgage, escrow acct

Comments inline.
"jmoeller18" <jmoeller18[at]gmail.com> wrote in message
news:1109432858.830834.222370[at]g14g2000cwa.googlegroups.com...
- quote -

> after starting over by deleting the current mortgage loan and any
> related scheduled transactions:
> I created a new loan account for a mortgage, that is paid from my
> checking account via a scheduled transaction
> which is split into
> principal payment (calculated)
> interest expense (calculated)
> principal payment (additional)
> and a new expense category called "escrow transfer"
> i believe you are suggesting the escrow transfer is an actual transfer
> not a new expense category but this isn't available to me.
> is there a way to set this up?


I recommend setting up a Cash account for the escrow and managing the
expense it pays. You setup the cash account and then you add a line to the
details of the scheduled loan payments for Transfer:[name of the account you
setup]. As with many similar things in Money, if this choice really does
exist but is not offered int he pull downs, type it out. Then when you see
an insurance bill or a tax bill, enter the payment in the escrow account as
your bank will. This way you track what they should be doing. You can also
just expense the escrow portion, but then you will have no place to record
the expense it actually covers.

- quote -

> notes on cleanup - going backward:
> going forward i will match the scheduled transaction to the imported
> bank statement so there is only one checking account transaction
> listed. I will have to manually add registry entries in the scheduled
> transaction for the previous loan payments and like i did for my
> doubled paycheck transactions, i will void or delete the imported
> transaction in favor of the registry entry. and now i am guessing i can
> just delete the transactions that i asked for within the mortgage
> statement


That sound more or less right.

- quote -

> note on creating mortgage loan account:
> in M05, when i create an account of the "other" category, i can choose
> loan (mortgage etc.) or i can choose mortgage. I am assuming it is
> setup this way for maximum flexibility and it doesn't matter if i
> choose loan or mortgage type of other, i get the same thing in the end.


I suspect you are correct. Haven't tried it in M05.

- quote -

> note on asset:
> during the loan account setup i was given the option of adding an
> "asset" or a "home account". i choose asset because it was the first
> choice. upon reviewing the "other" account category. i see there is a
> home account that looks like it is a better fit for a home account.
> also there is a "home equity line of credit".


I'm not really sure what a "home account" is, but I suspect this is just
another case of Money offering lots of terminology for essentially the exact
same kind of thing because Most Users Prefer(tm) them calling these things
by names they recognize even if the reality is simpler. Asset account is the
best bet. But understand what an Asset account is for: it's just a way to
track the value of your home to offset the liability of the mortgage to give
good net worth calculation. A side benefit is that they can be used to track
cost basis.


  #1  
Old 02-26-2005, 02:47 PM
jmoeller18
Guest
 
Posts: n/a
Default Re: how to move mortgage from checking account into mortgage, escrow acct

after starting over by deleting the current mortgage loan and any
related scheduled transactions:

I created a new loan account for a mortgage, that is paid from my
checking account via a scheduled transaction
which is split into
principal payment (calculated)
interest expense (calculated)
principal payment (additional)
and a new expense category called "escrow transfer"

i believe you are suggesting the escrow transfer is an actual transfer
not a new expense category but this isn't available to me.
is there a way to set this up?

notes on cleanup - going backward:
going forward i will match the scheduled transaction to the imported
bank statement so there is only one checking account transaction
listed. I will have to manually add registry entries in the scheduled
transaction for the previous loan payments and like i did for my
doubled paycheck transactions, i will void or delete the imported
transaction in favor of the registry entry. and now i am guessing i can
just delete the transactions that i asked for within the mortgage
statement

note on creating mortgage loan account:
in M05, when i create an account of the "other" category, i can choose
loan (mortgage etc.) or i can choose mortgage. I am assuming it is
setup this way for maximum flexibility and it doesn't matter if i
choose loan or mortgage type of other, i get the same thing in the end.

note on asset:
during the loan account setup i was given the option of adding an
"asset" or a "home account". i choose asset because it was the first
choice. upon reviewing the "other" account category. i see there is a
home account that looks like it is a better fit for a home account.
also there is a "home equity line of credit".

 
Old 02-26-2005, 12:49 PM
Dick Watson
Guest
 
Posts: n/a
Default Re: how to move mortgage from checking account into mortgage, escrow acct

For payments going forward, Loan Payment:[name of mortgage Loan Account] is
the transaction Special Category you want. (Loan Payment is another one of
these specific kinds of splits like Paycheck.) Loan Payment is a Special
Category that combines a Principal Transfer:[name of mortgage Loan Account]
with an interest expense in a split. Both are calculated based on the loan
account's specifics and balance. You can also add a Transfer:[name of escrow
cash account] to the Loan Payment:[name of mortgage Loan Account] splits.
This answers that part of the question.

e.g.,
scheduled payment will show Loan Payment:First Mortgage $810 with details:
<calculated> Principal Transfer:First Mortgage
<calculated> Interest Expense:Mortgage Interest
$90 Transfer:BigBank Escrow

for a mortgage that was defined with a $720 P+I payment and with interest
specified to be categorized as Interest Expense:Mortgage Interest

A Loan Payment has nothing in particular to do with an Asset Account. That's
not to say that you shouldn't have an Asset Account linked to the loan, just
that the payments have little to do with it.

You can't Transfer directly to a Loan Account. You must use the Loan
Payment. That's why the Loan Account is not shown as a target for your
Transfer. You can Transfer to the Asset Account. Circumstances where you
might want to do this are typically when you want to add an improvement to
your cost basis: Add a garage? Don't expense--e.g., Housing:Maintenance--
it, Transfer the cost to the Asset Account.

The reason the previous transactions are already entered is probably that
you created the loan account and it is a loan that got originated a long
time ago or it is a loan the you told Money had already had payments made.
Money didn't have a clue where the payments came from, so it just put them
in as having come from nowhere in particular.

Hope this helps. It assumes Advanced Register.

"jmoeller18" <jmoeller18[at]gmail.com> wrote in message
news:1109423447.591739.13420[at]g14g2000cwa.googlegroups.com...
- quote -

> M05 Std
> how to move mortgage from checking account into mortgage, escrow acct?
> in order to categorize all of my checking account transactions, i am
> forced to learn about mortgages
> so i created a mortgage account along with the suggested asset account
> (the value of the house)
> going back to checking account, i took what used to be the incorrectly
> designated deposit into a payee named in the mortage banks honor, and
> changed it to a transfer account.
> the transfer "to" listing did not list my mortgage account, it only
> listed the asset account. this didn't makes sense to me and now money
> refused to let me change the transaction back to deposit. Not to
> mention that now a large payment is increasing the asset value. i'd
> like to understand this asset/house thing associated with the mortgage,
> but that is another story.
> so i deleted the asset account as it didn't make any sense to me and
> now i can change the transaction back to deposit.
> after reading the posts on mortgages, i created a cash account for my
> escrow account.
> i am assuming that i want to take that mortgage checking transaction
> and do a split transfer into both accounts much in the same way the
> paycheck concept works.
> however:
> A. i see that the mortgage account already has a transaction listed for
> each payment and i would need to sync this with the checking account
> transaction
> B. i see that the "to" listing on the checking account transfer does
> include the escrow account and it does NOT include the mortgage account
> C. i don't see that you can "split" transaction destinations from a
> checking account transaction categorized as a transfer
> ideas:
> to fix the mortgage and the escrow accounts, i could create a scheduled
> transaction as a transfer for the mortgage payment, the additional
> mortgage payment we make each month, and the escrow payment. however i
> still have a transaction moving out of the checking account and this
> would create a double "out" payment. Although the scheduled transaction
> transfer does allow me to see the mortgage account in the "to" listing.
> in the checking account i could organize the automatic mortgage payment
> as a split deposit so as to classify the transactions for the budget
> and the scheduled transaction would keep the other accounts even.
> Although i would still have that double "out" payment when the
> scheduled transaction would register the transfers in the checking
> acount.
> please advise:



  #-1  
Old 02-26-2005, 12:10 PM
jmoeller18
Guest
 
Posts: n/a
Default how to move mortgage from checking account into mortgage, escrow acct

M05 Std
how to move mortgage from checking account into mortgage, escrow acct?

in order to categorize all of my checking account transactions, i am
forced to learn about mortgages

so i created a mortgage account along with the suggested asset account
(the value of the house)

going back to checking account, i took what used to be the incorrectly
designated deposit into a payee named in the mortage banks honor, and
changed it to a transfer account.

the transfer "to" listing did not list my mortgage account, it only
listed the asset account. this didn't makes sense to me and now money
refused to let me change the transaction back to deposit. Not to
mention that now a large payment is increasing the asset value. i'd
like to understand this asset/house thing associated with the mortgage,
but that is another story.

so i deleted the asset account as it didn't make any sense to me and
now i can change the transaction back to deposit.

after reading the posts on mortgages, i created a cash account for my
escrow account.

i am assuming that i want to take that mortgage checking transaction
and do a split transfer into both accounts much in the same way the
paycheck concept works.

however:
A. i see that the mortgage account already has a transaction listed for
each payment and i would need to sync this with the checking account
transaction

B. i see that the "to" listing on the checking account transfer does
include the escrow account and it does NOT include the mortgage account

C. i don't see that you can "split" transaction destinations from a
checking account transaction categorized as a transfer


ideas:

to fix the mortgage and the escrow accounts, i could create a scheduled
transaction as a transfer for the mortgage payment, the additional
mortgage payment we make each month, and the escrow payment. however i
still have a transaction moving out of the checking account and this
would create a double "out" payment. Although the scheduled transaction
transfer does allow me to see the mortgage account in the "to" listing.

in the checking account i could organize the automatic mortgage payment
as a split deposit so as to classify the transactions for the budget
and the scheduled transaction would keep the other accounts even.
Although i would still have that double "out" payment when the
scheduled transaction would register the transfers in the checking
acount.

please advise:

 

Tags
account, acct, checking, escrow, mortgage, move
Similar Threads
Thread Forum Replies Last Post
Escrow account for home mortgage
Dave 1029: I have set up escrow category associated with my home mortgage. My bank has notified me they distributed funds and I am attempting to transfer funds...
Microsoft Money 14 07-07-2006 12:03 PM
Mortgage escrow account
Chris: I am having trouble tracking my home mortgage payment information so I can get both the principal to populate the loan account and to get the escrow...
Microsoft Money 1 02-19-2005 04:32 AM
Setup Mortgage Account with Escrow?
Fixedamage: I've tried to set up my mortgage account in Money2005, and it asks for Remaining Balance, Interest, Principal+ Interest, and Balloon Amount. I'm...
Microsoft Money 1 10-27-2004 05:52 PM
How can I can split escrow in mortgage pmt to Cash acct
Steve S.: I created an escrow account for Real Estate taxes paid by my mortgage company as a cash acct and now I would like to direct the portion of my...
Microsoft Money 2 06-12-2004 03:26 PM
Re: Mortgage Payment to escrow account
Dick Watson: A Loan Payment is a special split. In it, you can add the Transfer:Escrow Acct as another line amongst the Principal Transfer:Loan Acct and Interest...
Microsoft Money 8 10-24-2003 05:53 AM



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 07:50 AM.