Home Page link  

New Car / Old car

 

Quicken Personal Finance Discussions - Quicken - personal finance software discussions

 Post an article  get this group's latest topics as an RSS feed add this group's latest topics to your My MSN content add this group's latest topics to your My Yahoo content  add this group's latest topics to your Google content  YahooMyWeb Yahoo!  Google Google  Windows Live Favorites Windows Live  del.icio.us del.icio.us  digg digg  Add to Netscape Netscape
Subject Author Date
New Car / Old car bill 09-19-2007
Posted by bill on September 19, 2007, 8:40 pm
Please log in for more thread options
Just got a new car, with trade in of old. Dont want this to show up as
any type of income when i zero out old car. Have old car setup as a
property asset and a property liability because of the loan. If i
lower the asset account to match the amount left on the loan and do a
transfer, would that do it?? Need to also setup new loan account for
new car ==should i also setup a asset account for it??

Anybody done this?? Whats the best way??


Posted by Fred Smith on September 19, 2007, 11:31 pm
Please log in for more thread options
Personally, I would use the same account. You can zero out the old balance with
a transaction which posts to the same account (you'll get a warning, but say
Yes). Or do a balance adjustment. You won't see any income or expense with this
entry.

--
Regards,
Fred


> Just got a new car, with trade in of old. Dont want this to show up as
> any type of income when i zero out old car. Have old car setup as a
> property asset and a property liability because of the loan. If i
> lower the asset account to match the amount left on the loan and do a
> transfer, would that do it?? Need to also setup new loan account for
> new car ==should i also setup a asset account for it??
>
> Anybody done this?? Whats the best way??
>



Posted by slb on September 20, 2007, 10:52 pm
Please log in for more thread options
I do something similar to Fred but a little more complicated. Take it for what
it's
worth. As Fred did, I post all the transactions to the same account and click Yes
on the warning.

I set up 2 asset accounts for each car. The first is called 99 Car Name with an
initial Increase entry for the total amount paid, say $20k. I also set up a 99
Car
Name Deprec account. Each Jan 1 I calculate the remaining car value and
depreciation from Edmunds or Kelly and enter a Decrease amount in Deprec as the
prior year depreciation. On my net worth statement I have the original amount
minus
the accumulated depreciation leaving the "net" value of the car.

I traded the car in this year and made a 2nd entry in the Car Name account as a
decrease for the trade-in, $2k. Net cost $18k for 8 years. I also made a
corresponding Decrease entry in Deprec, in this scenario $1,800 to "balance" so
the
sum of the two accounts is now zero. In this case I traded the car for $200 more
than it's calculated "value."

You could potentially put the yearly depreciation charge in the original asset
account but I like to see the values separate on my net worth reports. To be even
more OCD, I make a 0 amount entry in the Car Name asset account each Jan 1 called
mileage and put the current odometer reading as a memo item. I have a spreadsheet
that goes back 12 years with cost per mile numbers for each of our many cars. Not
extremely useful but fascinating trivia.

This time though it showed me the cost per mile increasing as I started to incur
some repair costs over the past 2 years. Made the decision to trade a year
earlier
than normal as I ignored this warning in the past and got burned on 2 cars.

Hope this helps.

sb


Fred Smith wrote:

> Personally, I would use the same account. You can zero out the old balance with
> a transaction which posts to the same account (you'll get a warning, but say
> Yes). Or do a balance adjustment. You won't see any income or expense with this
> entry.
>
> --
> Regards,
> Fred
>
> > Just got a new car, with trade in of old. Dont want this to show up as
> > any type of income when i zero out old car. Have old car setup as a
> > property asset and a property liability because of the loan. If i
> > lower the asset account to match the amount left on the loan and do a
> > transfer, would that do it?? Need to also setup new loan account for
> > new car ==should i also setup a asset account for it??
> >
> > Anybody done this?? Whats the best way??
> >


Posted by sharx35 on September 20, 2007, 11:48 pm
Please log in for more thread options

>I do something similar to Fred but a little more complicated. Take it for what
it's
> worth. As Fred did, I post all the transactions to the same account and click
Yes
> on the warning.
>
> I set up 2 asset accounts for each car. The first is called 99 Car Name with an

You only need to have ONE account per asset, i.e. ONE account per vehicle. Start
off with cost price, as
you did in your first account, and simply insert depreciation, on an annual
basis in that ONE asset
account. That way, your net worth is always accurate with only ONE account
needed per depreciable asset.




> initial Increase entry for the total amount paid, say $20k. I also set up a 99
Car
> Name Deprec account. Each Jan 1 I calculate the remaining car value and
> depreciation from Edmunds or Kelly and enter a Decrease amount in Deprec as the
> prior year depreciation. On my net worth statement I have the original amount
minus
> the accumulated depreciation leaving the "net" value of the car.
>
> I traded the car in this year and made a 2nd entry in the Car Name account as a
> decrease for the trade-in, $2k. Net cost $18k for 8 years. I also made a
> corresponding Decrease entry in Deprec, in this scenario $1,800 to "balance"
so the
> sum of the two accounts is now zero. In this case I traded the car for $200
more
> than it's calculated "value."
>
> You could potentially put the yearly depreciation charge in the original asset
> account but I like to see the values separate on my net worth reports. To be
even
> more OCD, I make a 0 amount entry in the Car Name asset account each Jan 1
called
> mileage and put the current odometer reading as a memo item. I have a
spreadsheet
> that goes back 12 years with cost per mile numbers for each of our many cars.
Not
> extremely useful but fascinating trivia.
>
> This time though it showed me the cost per mile increasing as I started to
incur
> some repair costs over the past 2 years. Made the decision to trade a year
earlier
> than normal as I ignored this warning in the past and got burned on 2 cars.
>
> Hope this helps.
>
> sb
>
>
> Fred Smith wrote:
>
>> Personally, I would use the same account. You can zero out the old balance
with
>> a transaction which posts to the same account (you'll get a warning, but say
>> Yes). Or do a balance adjustment. You won't see any income or expense with
this
>> entry.
>>
>> --
>> Regards,
>> Fred
>>
>> > Just got a new car, with trade in of old. Dont want this to show up as
>> > any type of income when i zero out old car. Have old car setup as a
>> > property asset and a property liability because of the loan. If i
>> > lower the asset account to match the amount left on the loan and do a
>> > transfer, would that do it?? Need to also setup new loan account for
>> > new car ==should i also setup a asset account for it??
>> >
>> > Anybody done this?? Whats the best way??
>> >
>



Posted by slb on September 21, 2007, 12:58 am
Please log in for more thread options
I made that very statement (one account would work) in the 4th paragraph of my
response. I use 2 accounts
because of personal reporting preferences. There is no single correct answer for
a personal tracking
system.

I also do it this way because when I owned my company the corporate accounting
system tracked assets with
corresponding accumulated depreciation accounts and an offseting expense account
to track yearly business
depreciation tax writeoffs.

sb


sharx35 wrote:

> >I do something similar to Fred but a little more complicated. Take it for
what it's
> > worth. As Fred did, I post all the transactions to the same account and
click Yes
> > on the warning.
> >
> > I set up 2 asset accounts for each car. The first is called 99 Car Name with
an
>
> You only need to have ONE account per asset, i.e. ONE account per vehicle.
Start off with cost price, as
> you did in your first account, and simply insert depreciation, on an annual
basis in that ONE asset
> account. That way, your net worth is always accurate with only ONE account
needed per depreciable asset.
>
> > initial Increase entry for the total amount paid, say $20k. I also set up a
99 Car
> > Name Deprec account. Each Jan 1 I calculate the remaining car value and
> > depreciation from Edmunds or Kelly and enter a Decrease amount in Deprec as
the
> > prior year depreciation. On my net worth statement I have the original
amount minus
> > the accumulated depreciation leaving the "net" value of the car.
> >
> > I traded the car in this year and made a 2nd entry in the Car Name account
as a
> > decrease for the trade-in, $2k. Net cost $18k for 8 years. I also made a
> > corresponding Decrease entry in Deprec, in this scenario $1,800 to "balance"
so the
> > sum of the two accounts is now zero. In this case I traded the car for $200
more
> > than it's calculated "value."
> >
> > You could potentially put the yearly depreciation charge in the original
asset
> > account but I like to see the values separate on my net worth reports. To be
even
> > more OCD, I make a 0 amount entry in the Car Name asset account each Jan 1
called
> > mileage and put the current odometer reading as a memo item. I have a
spreadsheet
> > that goes back 12 years with cost per mile numbers for each of our many
cars. Not
> > extremely useful but fascinating trivia.
> >
> > This time though it showed me the cost per mile increasing as I started to
incur
> > some repair costs over the past 2 years. Made the decision to trade a year
earlier
> > than normal as I ignored this warning in the past and got burned on 2 cars.
> >
> > Hope this helps.
> >
> > sb
> >
> >
> > Fred Smith wrote:
> >
> >> Personally, I would use the same account. You can zero out the old balance
with
> >> a transaction which posts to the same account (you'll get a warning, but say
> >> Yes). Or do a balance adjustment. You won't see any income or expense with
this
> >> entry.
> >>
> >> --
> >> Regards,
> >> Fred
> >>
> >> > Just got a new car, with trade in of old. Dont want this to show up as
> >> > any type of income when i zero out old car. Have old car setup as a
> >> > property asset and a property liability because of the loan. If i
> >> > lower the asset account to match the amount left on the loan and do a
> >> > transfer, would that do it?? Need to also setup new loan account for
> >> > new car ==should i also setup a asset account for it??
> >> >
> >> > Anybody done this?? Whats the best way??
> >> >
> >



Contact Us | Privacy Policy
This site is not affiliated with Intuit - makers of Quickbooks and Quicken software
This site is not affiliated with Sage Software - makers of Peachtree accounting software
XML SitemapXML Sitemap