Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
  #4  
Old 03-18-2007, 10:52 PM
Dick Watson
Guest
 
Posts: n/a
Default Re: Car Trade-In & New Purchase

Thanks for the note and welcome to the newsgroup.

I don't do the * Business versions, but here's the answer from my
(non-Business versions) perspective. Money does double entry accounting with
one account and one category. So, to change the value of an asset account,
enter a transaction in the asset account register that is categorized as
either income ("Investment Income : Real Estate Gains") or Expense
("Automobile : Depreciation"). In the accounting equation sense (Assets =
Liabilities + Shareholders equity) it seems this is either an increase or
decrease in shareholders equity.

Can't say how you enter than in the Business versions. Sadly, very few
Business version users help others here. Perhaps they are too busy running
their own businesses.

"NoCouth" <NoCouth[at]discussions.microsoft.com> wrote in message
news:47A036C3-8910-4141-AE0C-2D10E567CB4B[at]microsoft.com...
- quote -

> Regarding adjusting the value of ASSET accounts, I have been trying to
> figure out what the "opposite" account should be for these adjustments.
> In
> real accounting, it would be an owner equity account -- but in Money (I
> happen to be using 07 Hm & Biz) I'm struggling with this since there is no
> place to do General Journal entries, and it appears as though one can set
> up
> or post to an owner equity account as a BUSINESS account, but this would
> technically be a personal account.
> You post is comically and sadly correct! Autos and other toys with
> engines
> are typically "depreciating assets," so an occasional 5-20% reduction in
> the
> value of these "Assets" would be appropriate... regarding real estate and
> homes, which are "appreciating" assets (hopefully, at least), an
> occasional
> INCREASE in value is likewise appropriate... but where does the opposite
> side
> of the transaction go?



  #3  
Old 03-18-2007, 09:01 PM
NoCouth
Guest
 
Posts: n/a
Default Re: Car Trade-In & New Purchase

Hi Dick,

I've appreciated your posts over the past year, and I'm finally taking the
plunge and "signing up" to reply and ask questions.

Regarding adjusting the value of ASSET accounts, I have been trying to
figure out what the "opposite" account should be for these adjustments. In
real accounting, it would be an owner equity account -- but in Money (I
happen to be using 07 Hm & Biz) I'm struggling with this since there is no
place to do General Journal entries, and it appears as though one can set up
or post to an owner equity account as a BUSINESS account, but this would
technically be a personal account.

You post is comically and sadly correct! Autos and other toys with engines
are typically "depreciating assets," so an occasional 5-20% reduction in the
value of these "Assets" would be appropriate... regarding real estate and
homes, which are "appreciating" assets (hopefully, at least), an occasional
INCREASE in value is likewise appropriate... but where does the opposite side
of the transaction go?

Thanks.

"Dick Watson" wrote:

- quote -

> I should add, if you are using an Asset account for the new vehicle,
> 8) As soon as you've driven the new car 200 miles, enter a transaction in
> the NewVehicleAssetAcct that reduces the asset value of the new car by 20%.
> Compare this value to the outstanding loan balance (which includes the taxes
> and the residual from the old car you financed again) in the new loan
> account. Cry for a few minutes. Have a good stiff drink and try to forget
> about it.
> "Dick Watson" <littlegreengecko[at]mind-enufalready-spring.com> wrote in
> message news:uNgAqBtRHHA.4832[at]TK2MSFTNGP03.phx.gbl...
> > 7) The sum of txn #2 and txn #4 should reflect how much new cash you put
> > into the deal from that account. There will be an intermediate balance
> > that is not "real world" but the net of the two transactions should be.

  #2  
Old 03-18-2007, 08:50 PM
NoCouth
Guest
 
Posts: n/a
Default Re: Car Trade-In & New Purchase



"Dick Watson" wrote:

- quote -

> I should add, if you are using an Asset account for the new vehicle,
> 8) As soon as you've driven the new car 200 miles, enter a transaction in
> the NewVehicleAssetAcct that reduces the asset value of the new car by 20%.
> Compare this value to the outstanding loan balance (which includes the taxes
> and the residual from the old car you financed again) in the new loan
> account. Cry for a few minutes. Have a good stiff drink and try to forget
> about it.
> "Dick Watson" <littlegreengecko[at]mind-enufalready-spring.com> wrote in
> message news:uNgAqBtRHHA.4832[at]TK2MSFTNGP03.phx.gbl...
> > 7) The sum of txn #2 and txn #4 should reflect how much new cash you put
> > into the deal from that account. There will be an intermediate balance
> > that is not "real world" but the net of the two transactions should be.

  #1  
Old 02-02-2007, 02:09 PM
Dick Watson
Guest
 
Posts: n/a
Default Re: Car Trade-In & New Purchase

I should add, if you are using an Asset account for the new vehicle,

8) As soon as you've driven the new car 200 miles, enter a transaction in
the NewVehicleAssetAcct that reduces the asset value of the new car by 20%.
Compare this value to the outstanding loan balance (which includes the taxes
and the residual from the old car you financed again) in the new loan
account. Cry for a few minutes. Have a good stiff drink and try to forget
about it.

"Dick Watson" <littlegreengecko[at]mind-enufalready-spring.com> wrote in
message news:uNgAqBtRHHA.4832[at]TK2MSFTNGP03.phx.gbl...
- quote -

> 7) The sum of txn #2 and txn #4 should reflect how much new cash you put
> into the deal from that account. There will be an intermediate balance
> that is not "real world" but the net of the two transactions should be.



 
Old 02-02-2007, 12:48 PM
Dick Watson
Guest
 
Posts: n/a
Default Re: Car Trade-In & New Purchase

General outline, no one right answer, I don't know all the details of the
transactions, etc:

1) create some kind of expense transaction (Automobile : Payments?) in the
asset account to adjust it down to the trade in value.

1.99) if you really want to continue tracking vehicles as Assets, create a
$0 asset account for the new vehicle now. This experience highlights why
some of us do not track vehicles as asset accounts.

2) create a transaction to buy the new car. It will have these components in
splits:
Automobile : Payments $value of new car (Alternately, Transfer :
NewVehicleAssetAcct)
Taxes $value of taxes on new car
Transfer : OldVehicleAssetAcct ($value of residual of trade-in)
Other Income : Loan Proceeds Received ($value of new loan)
===
total value of cash you put into the new car less old loan payoff value ($0
you said was down payment. In this case, you can put this transaction in
just about any account. Do you have a pocket change account? That's be a
good place.)

3) create a new loan account. Note in its details that the loan is for this
car and where (account/date) to find transaction #2. (If you are going the
asset route, watch what the wizard does re. the new asset account. You may
have to go change the instructions above or the way it changes your
already-created asset account after the fact.)

4) in the account where you put transaction #2, enter a transaction to
payoff the old car. It will be a Loan Payment with these components in the
split:
Interest Expense : (whatever you used for this loan) $residual interest in
the payoff
Principal Transfer : OldLoanAcct $principal balance
===
payoff amount

5) the old asset account should be $0. Close it.

6) the old loan account should be $0. Close it.

7) The sum of txn #2 and txn #4 should reflect how much new cash you put
into the deal from that account. There will be an intermediate balance that
is not "real world" but the net of the two transactions should be.

I wish there were neater ways for several aspects of this regarding the
transfers to/from loan accounts and the interim balance not matching what
happens in the real world account. The other ways are really ugly.

"User" <User[at]discussions.microsoft.com> wrote in message
news:678F50FA-4F36-4045-B94B-59D1AD5DBA57[at]microsoft.com...
- quote -

> I've got a car in Money as an asset, and an associated loan. I've never
> depreciated the value of the car. It's obviously worth a lot less at the
> time of trade in so I first need to adjust the depreciated value to
> reflect
> the trade-in price. The old loan had more on it than the trade-in value.
> The trade in was subtracted, and the old loan added to the financing of
> the
> new car. No down payment was made.
> So poor asset management aside, how do I get rid of the two accounts for
> the
> old car, and generate a new asset and loan account for the new car? If I
> set
> up the loan and asset accounts for the new car first at the actual price
> of
> the new car, Money will more than likely miscalculate repayments when I
> then
> transfer in the trade-in as payment to the new loan, and the old loan loan
> as
> an increase to the new loan. Also curious as to how I record the
> transactions (transfers, expenses, etc.)
> So in summary I'd like to...
> 1. Close two accounts associated with a traded-in car (remaining loan
> more
> than value of the car).
> 2. Create two accounts for the new car incorporating transfers into the
> new
> loan reflecting the difference between old car loan and old car value.
> Hope that all makes sense.



  #-1  
Old 02-02-2007, 02:00 AM
User
Guest
 
Posts: n/a
Default Car Trade-In & New Purchase

I've got a car in Money as an asset, and an associated loan. I've never
depreciated the value of the car. It's obviously worth a lot less at the
time of trade in so I first need to adjust the depreciated value to reflect
the trade-in price. The old loan had more on it than the trade-in value.
The trade in was subtracted, and the old loan added to the financing of the
new car. No down payment was made.

So poor asset management aside, how do I get rid of the two accounts for the
old car, and generate a new asset and loan account for the new car? If I set
up the loan and asset accounts for the new car first at the actual price of
the new car, Money will more than likely miscalculate repayments when I then
transfer in the trade-in as payment to the new loan, and the old loan loan as
an increase to the new loan. Also curious as to how I record the
transactions (transfers, expenses, etc.)

So in summary I'd like to...

1. Close two accounts associated with a traded-in car (remaining loan more
than value of the car).

2. Create two accounts for the new car incorporating transfers into the new
loan reflecting the difference between old car loan and old car value.

Hope that all makes sense.
 

Tags
car, purchase, tradein
Similar Threads
Thread Forum Replies Last Post
HarrisDirect is now e*trade...what to do
md: HarrisDirect has been taken over by e*trade. So how do I proceed. I had auto updating with HarrisDirect. With e*trade I already had an account that...
Microsoft Money 6 01-14-2006 01:40 PM
money 2006 and E-trade
capt601: I have been having a problem since I installed Money 2006. It seems as if it is trying to connect to my e-trade accounts and download the...
Microsoft Money 4 08-22-2005 03:57 PM
Anyone have luck with E*TRADE?
Max: I'm trying to get my accounts to download automatically: E*TRADE - I have 4 accounts. It's currently downloading 2 of the accounts. My new...
Microsoft Money 6 08-01-2005 10:46 PM
Importing Trade Transactions
Won Lee: I DLed an OFX file containing my trades. When I try to import it into Money 2005 Standard, I have several problems. 1) It wants me to OK every...
Microsoft Money 2 04-05-2005 07: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 08:21 PM.