Level 7

Solved

Journal entry to increase inventory

Forum|Forum|7 years ago
December 11, 2018
7 replies
42 views

We are a dealership. I need to increase the cost of a vehicle so the balance sheet inventory is correct. We receive the vehicle at our cost, but in order to put it on the lot we need to detail it, add parts, etc To increase the cost of the car I want to do a journal entry , so I would debit inventory used or new cars and credit what type of account for parts and labor? an expense account? or an Income account?

QuickBooks Desktop

Best answer by Raywhite28

You would have to make an inventory adjustment to change the cost on a vehicle. A journal entry will not affect an inventory item.

Raywhite28Answer

Level 6

You would have to make an inventory adjustment to change the cost on a vehicle. A journal entry will not affect an inventory item.

Rustler

Level 15

@ lily

Labor for detailing the car, unless you pay an independent contractor, is already an expense, it is part of payroll if you have an employee do it.

If you are using inventory type items for the car, as stated never ever use inventory asset in any transaction.

In desktop this is fairly easy to do
create a current asset account called car set up or something

When you use parts from inventory to get the car ready to sell, use inventory adjust, set the adjusting account to the car set up account and lower the qty of parts used. If you do pay an outside contractor to detail the car, use this account as the expense for his payment.

When the car is ready for sale, use inventory adjust, set the adjusting account to the car set up account, and set the adjustment TYPE to value. Increase the car item value by the total amount in the car set up account and save

the car item now has an updated cost, the car set up account is zero balance an can be reused for the next set up

qbteachmt

Level 11

"except why Rustler was waiting until the vehicle was sold to add it to inventory."

That's not what he explained. He has the item already in stock, then he explains how to adjust it and relieve your own Parts in stock, as well as how to adjust it and Bring in WIP values:

"create a current asset account called car set up or something

When you use parts from inventory to get the car ready to sell, use inventory adjust, set the adjusting account to the car set up account and lower the qty of parts used. If you do pay an outside contractor to detail the car, use this account as the expense for his payment.

When the car is ready for sale, use inventory adjust, set the adjusting account to the car set up account, and set the adjustment TYPE to value. Increase the car item value by the total amount in the car set up account and save

the car item now has an updated cost, the car set up account is zero balance an can be reused for the next set up"

"I personally disagree somewhat with Rustler as far as needing a WIP."

Well, if you have no outside expense to add to that inventory item, you don't need to accumulate that anywhere so that the Adjustment function can be used. The point of this topic is that a JE cannot be used for managing QB inventory item Type transactions.

"There was a New Car Sales Journal, Used Car Sales Journal, Cash Disbursements Journal, Cash Receipts Journal, etc. Then in the 80's we came out with a new system which is the basic platform that is still used today. It still uses separate journals for each type of transaction. There is a new façade but the bones are still the same. The GM Manual uses journal entries, but they are not all General Journal Entries."

Open any transaction in QB, such as the Inventory Adjustment, and use Ctl Y to see the debits and credits are right there. The change since the 1980s is that we let computer programs, which have interfaces = tools and functions, do the raw accounting for us.

L

lindak1119Author

Level 7

Agreed.

qbteachmt

Level 11

"In the dealership world we technically consider this "specific inventory" and the parts inventory is "perpetual inventory". "

Using QB-ese, means that if you are using an Inventory Item Name for managing this, you are by definition doing Perpetual inventory. Whether you then buy more, sell them, restock etc, is up to how you manage this inventory item.

Periodic inventory can be done in QB, easily, as well. That would be, for example, leaving WIP in WIP until a Spec Home is sold, and not bothering to try to manage that by reference to an Inventory Item.

So, "Specific" inventory in QB = One Uniquely named Inventory Type item that will never be used for anything, again, such as By VIN. But that also still is part of Perpetual Inventory management, because it is By Item Name, with Quantity Cost and Price available.

"WIP is debited from payroll and credited when the repair order is complete and the work is charged to the vehicle inventory."

Yes, you can use QB payroll and accounting like this, just fine. For instance, a Construction spec home builder would "job track" the time and costs, and the Payroll data flow is whatever you need, but now, for QB payroll, the Payroll Item is linked to WIP or COGS or whatever matches your accounting needs, as would be done in a production environment.

"The WIP account used in this person's example is really just an inventory clearing account."

Of course it is. That's what any Asset account performs for you. You accumulate something, you get rid of that something. Values move in and out. But that isn't Inventory Clearing. It's WIP = value Clearing. It doesn't define that the end result is Inventory. You might be using it as that, for your needs.

"it is unfortunate that the workaround for this specific inventory is so cumbersome on QB."

All of this is yours to set up and use to meet your needs. It isn't cumbersome, unless you set up a Cumbersome process.

I have attachments for how easy it is to do for Spec projects or Flipping.

"The dealership systems are very costly and would be overkill for my client's tiny used car lot. I am open to other software options but I am mostly familiar with the big 3 auto systems which again would not work here."

I don't understand: are you QB users about Not using QB?

We are cheap, too, or would not be using QB.

In 2006, for QB 2007, Intuit changed the database from flat tables to a true relational database, because they bought into the SyBase database engine. When I worked for a Capital Equipment manufacturer (now part of Applied Materials), we used that tool; that is why, along with my programming background, I know how powerful the functions of QB are. It just takes a bit of setup.

Everything you asked so far is actually pretty easy to do in QB.

L

lindak1119Author

Level 7

I have not actually asked anything except why Rustler was waiting until the vehicle was sold to add it to inventory. As an instructor, trainer and consultant with an MBS in Accounting I feel this is a cumbersome process to teach a lay person and inconsistent with automotive accounting procedures. I'm not sure why you are going through all of this detail with me. My only question was to Rustler "was I missing something"?

qbteachmt

Level 11

"Someone suggested a WIP account as a work around"

Yes, because that is an Asset with Multiple inputs = accumulating the total invested. This is done for any process that improves the asset, or the asset cost comes from multiple inputs such as Purchase Cost, Import Duties, Broker Fees, improvement labor and materials, etc.

"leaving all of the costs in the WIP until the unit is sold."

No, you don't have to Leave it there. If you want to manage this as a unique inventory item, you them "buy from WIP" by using a Vendor name of WIP, and listing the WIP account on the Expenses tab with the negative total; put the real item on the items tab with the total Basis. Hit re-calc. This is a $0 Bill. Now your product is On Hand in inventory and fully costed.

"I toyed around with adding the unit into inventory immediately and adding the additional costs to the WIP account. Then turning right around and adjusting the inventory value by doing and inventory adjustment using the WIP account."

Yes, that works, too. The real issue is Dates Matter. Pay attention to the Date reporting.

"That cleared the WIP account and keeps the inventory value for all of the units correct. I worked in the auto industry for over 30 years and find it hard to believe that QB can't get perpetual inventory right."

This isn't Perpetual Inventory. This is specific Items Names as "in progress." This is Production, really.

WIP = Work in Progress

CIP = Construction in Progress

Law firm = Advanced Costs

Lots of Industries use Other Asset tracking for expenditures for operational requirements.

Heck, I set up a Corrections Facility that is all Liability accounting, of three liability types.

L

lindak1119Author

Level 7

WIP in the dealership world is increased when a technician performs labor to a vehicle but has not yet completed it at the end of the pay week.  WIP is debited from payroll and credited when the repair order is complete and the work is charged to the vehicle inventory.  The WIP account used in this person's example is really just an inventory clearing account...a way to get the work that is done to the vehicle (likely from an outside source) into the vehicle's inventory.  It really is a temporary holding spot and not a true WIP account.

In the dealership world we technically consider this "specific inventory" and the parts inventory is "perpetual inventory".

Again, it is unfortunate that the workaround for this specific inventory is so cumbersome on QB.  The dealership systems are very costly and would be overkill for my client's tiny used car lot.  I am open to other software options but I am mostly familiar with the big 3 auto systems which again would not work here.

john-pero

Level 12

If you post the vehicle as an inventory item you have to post addition costs to same item. If you posted cost to a general inventory account you would post additional costs to same. However throwing all units into one overall account demands keeping a separate inventory and cost log - all GM approved, so it certainly passes muster.

I suggest this http://gm.acctmanual.com/Misc/gm_acct_manual%20v2-2-1-1.pdf as required reading as it will give you definitive answers on where and how to post costs in any accounting system.

L

lindak1119Author

Level 7

It would be nice if QB would work the way that auto dealership accounting was designed, but it doesn't. Someone suggested a WIP account as a work around, leaving all of the costs in the WIP until the unit is sold. I toyed around with adding the unit into inventory immediately and adding the additional costs to the WIP account. Then turning right around and adjusting the inventory value by doing and inventory adjustment using the WIP account. That cleared the WIP account and keeps the inventory value for all of the units correct. I worked in the auto industry for over 30 years and find it hard to believe that QB can't get perpetual inventory right.

P

PeterPS

I started a new company in May 2020. At first we drop shipped product from our manufacturer to businesses. We then realized we needed to build inventory because products were selling too fast and the manufacturer was not keeping inventory for us. In the transition, I never adjusted the products from non-inventory to inventory. Do you I need to make a journal entry to correct my inventory levels? What is the best way for me to move forward?

Sign up

Login with SSO

Let's get you signed in

Login with SSO

Scanning file for viruses.

This file cannot be downloaded