Skip to main content
February 8, 2022
Solved

Can new Account Detail Type be added in COA? e.g., COGS does not allow distinction between Purchases and Materials/Supplies as Sched C does.

  • February 8, 2022
  • 1 reply
  • 0 views
I think it's odd that there are so many other options for COGS Detail Type, but not Purchases.
Best answer by Rainflurry

The only thing that keeps me hung up on the Account Details is the question of why they're even included when they have no (apparent) use?  If that field is going to even be there, I think there ought to be some function.  For instance, when I look at my Accounts, I'd like to see something useful, like even "Account Description", which I can't see unless I edit an account.

 

As far as Purchases, I've read any support article I can find, and it does seem that it's preferably an Asset account for the periodic inventory method.  However, data seems to be moved (via something like a journal entry) into a COGS account only once an inventory is done - so if I do an annual inventory, it would seem that any COGS data would remain blank through that interval on my P&Ls.  Or am I missing something?

 

As far as I can see, if my inventory stays the same every year (which doesn't quite happen, of course), my COGS would be accurate simply by entering Purchases into COGS accounts - which would give me up-to-date (though, admittedly, not exact) information on my P&L through the entire year.  Simultaneously, I could have my total inventory value in an Asset account, and create annual journal entries at time of inventory to adjust both the Inventory Asset account and the COGS accounts.  Again, I may well be missing something.

 

You're certainly correct as far as freight costs.  I suppose I've taken another step away from what's probably accepted accounting practice and just lump the freight in with item cost, so have no use for it.  As an example, one box supplier I've used sells boxes at amazingly low prices, but charges FAR MORE than the box cost for the freight - while another charges more for each box, but provides free shipping.  There's no way I can determine a "best price" without considering both - or calculate a retail price (and I have yet to find a POS system that factors freight as well as pure cost of a good into retail price calculation).


@oceanbeachesglass 

 

IMO, the "Detail Type" is a pointless field.  It may be there just to assist users in naming the account.  The field doesn't even exist in QB Desktop and that is a far superior product IMO. 

 

You are exactly right that if your beginning inventory and ending inventory are the same, then your purchases account will equal your COGS for the period (month/year).  And, any freight you have allocated to purchases will be fully expensed.  However, a 'Purchases' account should always be a temporary asset account - not an expense or COGS account.  You would create a journal entry to reduce (credit) purchases and increase (debit) COGS at period-end by the same amount if there is no change in inventory level.  When using periodic inventory, you needn't take a physical inventory, you can estimate COGS via the gross profit method but that's a topic beyond the scope of this post probably.

 

 

1 reply

JessT
February 8, 2022

Hi oceanbeachesglass!

 

Welcome and thank you for getting help with setting up your COGS account.

 

Adding an account Detail Type is currently not a feature in QuickBooks Online. We can only select from the available options. I suggest consulting your accountant to know which among the choices is best for the kind of purchases you have.

 

I also suggest sending feedback about this from your QBO company, so our engineers will be aware that you need a separate detail type for purchases. Just click on the Gear icon and choose Feedback.

 

Feel free to go back to this thread if you need anything else. Take care and have a good one!

February 10, 2022

Well, my accountant cannot help with this one.  Based on what's on the Schedule C, the options simply don't reflect what's there. 

 

On Schedule C, in the COGS section, line 36 is "Purchases", line 37 is "Labor", line 38 is "Materials and Supplies", and line 39 is "other".

 

What QBO offers for Account Detail types for COGS is, in order, "Cost of Labor", "Equipment Rental", "Other Costs", "Shipping", and "Supplies and Materials".

 

You can see there's a good match with Labor, Materials and Supplies, and Other (personally, I don't see why Equpment Rental and Shipping wouldn't be lumped in with Other, but that's beside the point). 

 

My point is that there is no option for Purchases.  Purchases, by definition, is what any raw materials go under, as well as any item purchased for sale (i.e., Inventory) goes under.  For an inventory-based business - at least for a Sole Proprietorship - it's going to be the primary type of Cost of Goods Sold.  

 

But then again, I think I remember the significance of the Account Detail Type from years ago when I used QB Desktop, and it was the criterion for which account would be linked in Turbotax during the QB-TT export.  But I just discovered yesterday that there is no QBO-TT export, so I guess the whole issue becomes moot - it looks like Account Detail Type has no relevance, as far as I can tell.