cancel
Showing results for 
Search instead for 
Did you mean: 
catalyst81
Level 1

Setting up quickbooks and adjusting opening equity balance and assets

My wife has an online clothing business (S Corp) for a few years and I'm finally getting her set up in Quickbooks.  She has previously managed everything in excel.  We have a lot of inventory but will not be using QB to manage it.  I've connected all our business accounts as of January 1st 2019, but I need to know the best way to add existing inventory into QB as assets (purchased prior to that date).

 

She has a negative opening balance equity (I believe its the credit card balance) due to the previous purchase of inventory.  After adding the value of the existing inventory (as of Jan. 1st) in inventory assets, should I adjust (credit?) that equity balance by the amount added (debited?) to assets?   If so, how do I do that?

2 Comments 2
Rustler
Level 15

Setting up quickbooks and adjusting opening equity balance and assets

equity is total assets less total liabilities, so if there are more liabilities than assets, it would be normal to have negative equity in that case.

If you are not going to use the QB inventory system then you need to use periodic inventory

create an asset account for inventory, best not to use inventory asset in case you change your mind down the road, make an opening entry for the full cost the items on hand, and use OBE as the offsetting account

There are two ways to do periodic inventory, choose one and stick with it, you can not mix and match

1. (my preference) Create an asset account called purchases and post all purchases of item for resale to that account.  Periodically, weekly, monthly, etc value the inventory on hand, subtract that value from the amount shown in the purchases account and do a journal entry for the answer to the subtraction
debit COGS for that value
credit purchases for that value

OR

2.  Post all purchases to COGS.  Periodically, but at least at the end of the year, you value the inventory on hand and do a journal entry.
debit the asset purchases account for that value
credit COGS for that value

Print the P&L
then reverse the journal entry
debit COGS for that same value
credit the asset purchases account for that value

This last journal entry, moves the value of what was on hand at the end of year back to COGS so the cost will be counted against the new year sales.

catalyst81
Level 1

Setting up quickbooks and adjusting opening equity balance and assets

Thank you.  I have an asset account created already for purchases under other assets.  To clarify (new to accounting/bookkeeping), would that opening entry on the asset account be made through a journal entry?  Basically, add the wholesale value of the inventory on hand as of Jan 1st to the inventory account and then offset the OBE by that amount?  

Need to get in touch?

Contact us