Manufacturing - Expenses & COGS

industrialcontrols12 · ‎April 18, 2019

How do we merge our COGS account with the COGS account Quickbooks creates on it's own. We have merged, deleted, renamed, etc.

The integrator we paid a crapton of money to, set up the COA with a COGS account (50000), and quickbooks comes behind it, and indexes to the next COA number (50001) for its "*COGS" account.

Can we renumber this (to 50000) or is it too late?

Anonymous · ‎April 18, 2019

If QB is creating accounts it is because you have created items and not defined a COG account for it (in item setup details) - then QB posts to a default location that it created.
Open the transactions that may appear in that default account - then backtrack the transactions to the items involved and correct the settings for those items.

Remember that in QB 'items' link to accounts - not the other way. and items 'must' link to accounts so if the account is missing (or invalid) then QB puts an account in for you.

Renaming or renumber that account wont change anything - the problem is in the ITEMS

industrialcontrols12 · ‎May 06, 2019

There are NO items and no transactions that use 50001. When the integrator (The Wren Group, that we paid WAY too much money to set up our QB file) set it up, they didn't let QB create a default COGS account for the items.

So now, when we set up a new item, it defaults to 50001, which is what QB created as COGS, and we have to select 50000 for EVERY ITEM WE CREATE, EVERY TIME.

At some point, we will fail to change it to 50000, and it will hurt us.

industrialcontrols12 · ‎May 06, 2019

No transactions on the GL as 50001

Anonymous · ‎May 06, 2019

Yes I think your right ...
A possible fix might be to try to merger your 5000 account into QBs 5001 account (not the other way) then rename the 5001 to your old name

Topics

Training

Community

Resources

Manufacturing - Expenses & COGS