Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
  #4  
Old 05-28-2005, 01:29 AM
Dick Watson
Guest
 
Posts: n/a
Default Re: Auto Valuation Update and Trade-in

Cool. Glad I could help. Thanks for the feedback.

"Robert Sharon" <rcsharon[at]att.net> wrote in message
news:LlPle.258095$cg1.167781[at]bgtnsc04-news.ops.worldnet.att.net...
- quote -

> Thank you for your comments on this issue. I used your personal
> preference
> method for recording the purchase of my Chevy Venture and trade-in of the
> Olds Ciera. It seems to have worked out as an acceptable solution.



  #3  
Old 05-28-2005, 12:57 AM
Robert Sharon
Guest
 
Posts: n/a
Default Re: Auto Valuation Update and Trade-in

Thank you for your comments on this issue. I used your personal preference
method for recording the purchase of my Chevy Venture and trade-in of the
Olds Ciera. It seems to have worked out as an acceptable solution.

Thanks again.


"Dick Watson" <littlegreengecko[at]mind-enufalready-spring.com> wrote in
message news:%23KT1OnlYFHA.1092[at]tk2msftngp13.phx.gbl...
- quote -

> See below. Hopefully this will help. You know how to find me if it
doesn't.
> "Robert Sharon" <rcsharon[at]att.net> wrote in message
> news:uQrle.835875$w62.692226[at]bgtnsc05-news.ops.worldnet.att.net...
> > I am running Money Standard 2004.
> > > My statement about Money's transfer method is as follows:

> > When entering a transaction in the old auto account to reduce the value
> > (or
> > recognize the trade-in write-off), Money will not allow you to assign

the
> > "category" as a transfer to the same account (instead of something like
> > Miscellaneous). This reduces the value of the asset to zero.

> Let's say I have an asset account for old auto (the '97 Plymouth Wombat)
> with a balance (value) of $8,500. I trade it in for $4,800 off a $30,000 +
> $1,000 tax 2005 Honda Accord.
> My new car purchase would look something like:
> 5/25/2005 Payee: Hondas R Us Category: (split) Amount: ($2,500) Memo: buy
> the 2005 Accord
> splits:
> Automobile:Payments ($30,000) (or maybe this is Transfer To:2005 Accord
> Asset)
> Taxes:Sales ($1,000)
> Transfer From:97 Wombat Asset $4,800 Memo: trade-in value for the '97

Wombat
> Transfer From:Savings $23,700
> (A loan payoff and a new loan and so forth would be more complicated, but
> you get the general idea.)
> In the Old Auto Asset account, I'd enter a new EXPENSE TRANSACTION (this

is
> no transfer or anything else) like:
> 5/25/05 Payee: (asset value adjustment) Category: Automobile:Payments
> Amount: ($3,700) Memo: the final insult--the '97 Plymouth Wombat was worth

a
> whole lot less at trade in than I thought it was; here goes that money int

o
> the cost of actually owning the car
> > I do understand your comment regarding a transaction in the old asset

auto
> > account to zero out the remaining balance to a special category.

However,
> > it seems entering the transaction into the new auto asset account as a
> > transfer from the old auto account (trade-in value) will only increase

the
> > value of the new auto account. How do you enter a "negative" number

into
> > the new asset auto account without increasing the old auto asset auto
> > account with a positive number value (as in a transfer)?

> My personal preference is to setup the asset accounts by hand--as opposed

to
> loan wizard--with initial balances of $0 and put the money in them

following
> the cash flow. If you wanted to, you could have done this thus:
> 5/25/2005 Payee: Hondas R Us Category: (split) Amount: ($2,500) Memo: buy
> the 2005 Accord
> splits:
> Transfer To:2005 Accord Asset ($25,200)
> Taxes:Sales ($1,000)
> Transfer:Savings $23,700
> 5/25/05 Payee: (asset value adjustment) (split) ($8,500)
> splits:
> Automobile:Payments Amount: ($3,700) Memo: the final insult--the '97
> Plymouth Wombat was worth a whole lot less at trade in than I thought it
> was; here goes that money into the cost of actually owning the car
> Transfer:2005 Accord Asset ($4,800) Memo: roll this over to the new asset
> End result: 2005 Accord Asset is now at $30,000, 97 Wombat Asset is now at
> $0. Checking is $2,500 poorer, Savings is $23,700 poorer.
> (Disclaimers: I've never actually tried an asset account to asset account
> transfer. I'm betting it works. YMMV. There is no "one right way."
> Personally, I don't track autos as assets. Too much pain. Too theoretical
> the gain. etc.)



  #2  
Old 05-27-2005, 01:17 AM
Dick Watson
Guest
 
Posts: n/a
Default Re: Auto Valuation Update and Trade-in

See below. Hopefully this will help. You know how to find me if it doesn't.

"Robert Sharon" <rcsharon[at]att.net> wrote in message
news:uQrle.835875$w62.692226[at]bgtnsc05-news.ops.worldnet.att.net...
- quote -

> I am running Money Standard 2004.
> My statement about Money's transfer method is as follows:
> When entering a transaction in the old auto account to reduce the value
> (or
> recognize the trade-in write-off), Money will not allow you to assign the
> "category" as a transfer to the same account (instead of something like
> Miscellaneous). This reduces the value of the asset to zero.


Let's say I have an asset account for old auto (the '97 Plymouth Wombat)
with a balance (value) of $8,500. I trade it in for $4,800 off a $30,000 +
$1,000 tax 2005 Honda Accord.

My new car purchase would look something like:

5/25/2005 Payee: Hondas R Us Category: (split) Amount: ($2,500) Memo: buy
the 2005 Accord
splits:
Automobile:Payments ($30,000) (or maybe this is Transfer To:2005 Accord
Asset)
Taxes:Sales ($1,000)
Transfer From:97 Wombat Asset $4,800 Memo: trade-in value for the '97 Wombat
Transfer From:Savings $23,700

(A loan payoff and a new loan and so forth would be more complicated, but
you get the general idea.)

In the Old Auto Asset account, I'd enter a new EXPENSE TRANSACTION (this is
no transfer or anything else) like:

5/25/05 Payee: (asset value adjustment) Category: Automobile:Payments
Amount: ($3,700) Memo: the final insult--the '97 Plymouth Wombat was worth a
whole lot less at trade in than I thought it was; here goes that money into
the cost of actually owning the car

- quote -

> I do understand your comment regarding a transaction in the old asset auto
> account to zero out the remaining balance to a special category. However,
> it seems entering the transaction into the new auto asset account as a
> transfer from the old auto account (trade-in value) will only increase the
> value of the new auto account. How do you enter a "negative" number into
> the new asset auto account without increasing the old auto asset auto
> account with a positive number value (as in a transfer)?


My personal preference is to setup the asset accounts by hand--as opposed to
loan wizard--with initial balances of $0 and put the money in them following
the cash flow. If you wanted to, you could have done this thus:

5/25/2005 Payee: Hondas R Us Category: (split) Amount: ($2,500) Memo: buy
the 2005 Accord
splits:
Transfer To:2005 Accord Asset ($25,200)
Taxes:Sales ($1,000)
Transfer:Savings $23,700

5/25/05 Payee: (asset value adjustment) (split) ($8,500)
splits:
Automobile:Payments Amount: ($3,700) Memo: the final insult--the '97
Plymouth Wombat was worth a whole lot less at trade in than I thought it
was; here goes that money into the cost of actually owning the car
Transfer:2005 Accord Asset ($4,800) Memo: roll this over to the new asset

End result: 2005 Accord Asset is now at $30,000, 97 Wombat Asset is now at
$0. Checking is $2,500 poorer, Savings is $23,700 poorer.

(Disclaimers: I've never actually tried an asset account to asset account
transfer. I'm betting it works. YMMV. There is no "one right way."
Personally, I don't track autos as assets. Too much pain. Too theoretical
the gain. etc.)


  #1  
Old 05-26-2005, 10:11 PM
Robert Sharon
Guest
 
Posts: n/a
Default Re: Auto Valuation Update and Trade-in

I am running Money Standard 2004.

My statement about Money's transfer method is as follows:
When entering a transaction in the old auto account to reduce the value (or
recognize the trade-in write-off), Money will not allow you to assign the
"category" as a transfer to the same account (instead of something like
Miscellaneous). This reduces the value of the asset to zero.

I do understand your comment regarding a transaction in the old asset auto
account to zero out the remaining balance to a special category. However,
it seems entering the transaction into the new auto asset account as a
transfer from the old auto account (trade-in value) will only increase the
value of the new auto account. How do you enter a "negative" number into
the new asset auto account without increasing the old auto asset auto
account with a positive number value (as in a transfer)?






"Dick Watson" <littlegreengecko[at]mind-enufalready-spring.com> wrote in
message news:u08riIhYFHA.2664[at]TK2MSFTNGP15.phx.gbl...
- quote -

> I'm not sure what you mean by "Money does not allow you to use a the same
> Asset account transfer method". I'm also assuming that you are talking

about
> updating a value of the old auto in an asset account for the old auto.
> I'd setup the new auto purchase transaction(s) to Transfer in any trade-in
> value from the old auto asset account as a negative number. This will

reduce
> the value of the old auto asset to the difference between what the asset
> account thinks it's worth and what you were able to get as a trade-in. See
> the refi question in the UFAQ for some insight into how to make complex
> transactions like this.
> Then I'd enter a transaction in the old auto asset account in the amount

of
> the balance against some category like "Automobile:Payments." This asset
> value lost was an expense related to owning that old automobile.
> "Robert Sharon" <rcsharon[at]att.net> wrote in message
> news:wNmle.253466$cg1.238456[at]bgtnsc04-news.ops.worldnet.att.net...
> > How do you treat an auto valuation decrease balance adjustment and
> > subsequent "trade-in" write-off for "category" assignment? I have

> assigned
> > them to Miscellaneous but it does not seem appropriate. Money does not
> > allow you to use a the same Asset account transfer method.
> > > Another auto was purchased and recorded at the net price.



 
Old 05-26-2005, 04:44 PM
Dick Watson
Guest
 
Posts: n/a
Default Re: Auto Valuation Update and Trade-in

I'm not sure what you mean by "Money does not allow you to use a the same
Asset account transfer method". I'm also assuming that you are talking about
updating a value of the old auto in an asset account for the old auto.

I'd setup the new auto purchase transaction(s) to Transfer in any trade-in
value from the old auto asset account as a negative number. This will reduce
the value of the old auto asset to the difference between what the asset
account thinks it's worth and what you were able to get as a trade-in. See
the refi question in the UFAQ for some insight into how to make complex
transactions like this.

Then I'd enter a transaction in the old auto asset account in the amount of
the balance against some category like "Automobile:Payments." This asset
value lost was an expense related to owning that old automobile.

"Robert Sharon" <rcsharon[at]att.net> wrote in message
news:wNmle.253466$cg1.238456[at]bgtnsc04-news.ops.worldnet.att.net...
- quote -

> How do you treat an auto valuation decrease balance adjustment and
> subsequent "trade-in" write-off for "category" assignment? I have

assigned
> them to Miscellaneous but it does not seem appropriate. Money does not
> allow you to use a the same Asset account transfer method.
> Another auto was purchased and recorded at the net price.



  #-1  
Old 05-26-2005, 04:27 PM
Robert Sharon
Guest
 
Posts: n/a
Default Auto Valuation Update and Trade-in

How do you treat an auto valuation decrease balance adjustment and
subsequent "trade-in" write-off for "category" assignment? I have assigned
them to Miscellaneous but it does not seem appropriate. Money does not
allow you to use a the same Asset account transfer method.

Another auto was purchased and recorded at the net price.

Please advise.


 

Tags
auto, tradein, update, valuation
Similar Threads
Thread Forum Replies Last Post
Auto Update with Bank of America
Drew Zerdecki: Does anyone have this setup with MS Money? Some of my other accounts automatically download new account info when I open Money. Can I get BoA to...
Microsoft Money 23 01-05-2005 12:21 AM
Can no longer update my E*Trade Accounts
Rob: Money 2005 is no longer updating by E*Trade account information. I had no problem then all of sudden it says there is an error. What that error is I...
Microsoft Money 3 12-01-2004 01:08 PM
Home Update Valuation of Asset
Robert Sharon: In Money 2004, after you originally set up your home purchase price and date, how can you assign a category for the valuation increase when only...
Microsoft Money 8 11-24-2004 10:15 PM
Auto Valuation
: When tracking your Automobile asset value in Money, which value do you use: Kelly Trade-In, Kelly Retail, or something else?
Microsoft Money 1 02-07-2004 05:31 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 11:29 AM.