How to enter trade-ins

How does QB Pro 2006 handle trade-ins? I can't find anything in the help files on trade-ins, or Sales, Trades. The customer is paying for the new item with both cash and the old item. Additionally, his old item now becomes an inventory asset item. I could sell him the new one and then refund his money on the old one but then it complicates the sales tax and I'd have to list it as a returned item, and even then it would only work if I sold the item in the first place.

Bob

Reply to
RobertM
Loading thread data ...

Quite well, thank you.

I can't find anything in the help

Reply to
Allan Martin

Put the tradein on the same invoice as a minus qty

Greg

Reply to
Greg

I hope those that know me realize that I do know the answer. Bobby Boy will just think I don't want to "bother" answering the question in light of my previous response.

Reply to
Allan Martin

Wrong answer Grasshopper, try again.

Reply to
Allan Martin

OK, thanks.

Bob

Reply to
RobertM

I don't know the correct way to do this from an accounting standpoint. From a bookkeeping perspective on how to get the info on the books one way would be to create a customer credit using the trade-in as a line item (create a new one for inventory if its not already there) and the amount is whatever you deem the value of the trade-in. Now the customer has a credit. Create an invoice for the new item at its regular price. The difference is what's payable and in Receive Payments you can account for the credit and whatever method of payment is used for the balance.

Reply to
Tee

Can't do it this way because the sales tax will calculate on the entire amount when the invoice for the new item is created. The actual sales tax is figured only on the difference between the selling price of the new item and the trade-in, that is to say the final amount the customer pays is taxable, not the original selling price of the new item. It was suggested to simply enter the trade-in as a negative item. That'll give the necessary tax and invoice amounts.

Bob

Reply to
RobertM

Way to go Bobby Boy. MAke my day, use the above.

Reply to
Allan Martin

Oh my oh my. A tad complicated don't you think? Can you image having to deal with numerious trade-ins this way. I'm getting dizzy just reading this. There is a simple way, I left a clue in my previous post of where to look for the solution.

By the way your method will not account for the transation correctly to boot.

I could tell you but its for Bobby Boy and I don't want to "bother".

Reply to
Allan Martin

I would have thought you were supposed to tax the full sale price and treat the trade-in as a payment form.

Reply to
Tee

I'll double check it, but I think the value on the trade-in is taxed when the trade-in is subsequently sold. Otherwise, there would be a double tax on the same item.

Bob

Reply to
RobertM

In most states if the item traded-in will be used for resale in the normal course of business then taxable sales are reduced by the trade-in allowance.

There is an answer to the problem, and oh, by the way the method does take into account the proper way to handle sales tax.

Reply to
Allan Martin

I just checked the tax code online. The amount of the trade-in is excluded from the taxable selling price of the new item. I sell a new item for $800, customer trades in $300 item, taxable amount is $500 on this sale. When trade-in is sold, it will be taxed for $300 selling price. Trade-in must be noted on invoice with model and s/n where applicable.

Bob

Reply to
RobertM

I will award a QB Black Belt to anyone that gets the right answer to this problem.

Put on your thinking caps.

Are you a QB Guru?

Reply to
Allan Martin

Not a guru but my answer was the correct one.

Greg

Reply to
Greg

Yep, I appreciate the information.

Bob

Reply to
RobertM

Except for the fact that it did not take into consideration the distortion of sales, cost of goods sold and inventory valuation. Other than that, it was the correct answer.

Reply to
Allan Martin

Thats because you are an idiot.

Reply to
Allan Martin

In the real world it works, and did everything that was asked.

Greg

Reply to
Greg

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.