Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
JonathonFS
Level 1

Tracking Item Profit/Margin as Service Revenue

Our business resells a lot of products that we markup. That markup pays for procurement, install, and setup labor. As I understand it, the labor is Service Revenue, and product costs are Product Revenue. My Objective: Split out our Service Revenue and Product Revenue, preferably in the Chart of Accounts (but I'm open to alternatives).

 

QBO Items can be configured with Price going into an Income account and/or Cost going into an Expense account. What happens if instead of setting an item's cost to go into an Expense account, we set it to an Income account for Product Revenue? Will it show up as a positive or negative amount within the income account? Is QBO smart enough to remove the cost from the amount going into the configured Price account, so we don't see inflated income revenue? Ultimately, we want an item's profit (price - cost) to go into a Service Revenue account, while the cost goes into a Product Revenue account.

 

P.S. Creating separate 'service' and 'product' items in QBO is not an option. We ingest thousands of products for various distributors into our PSA, which syncs with QBO. We would have to manually create and maintain all those duplicate items in our PSA, to sync with the separate QBO items. Not only would this be a huge time sink, but it would completely throw off our PSA quoting and contracting vehicles.

2 Comments 2
Teri
Level 9

Tracking Item Profit/Margin as Service Revenue

I suggest keep revenue and expense in separate accounts which is the more standard accounting practice. Profit or loss does not normally show in revenue accounts.  It shows at bottom on income statement (P&L).  

JonathonFS
Level 1

Tracking Item Profit/Margin as Service Revenue

Thanks for the reply Teri, although I'm not sure you understood the question I was trying to convey. I'm not trying to combine revenue and expenses. I was trying to re-purpose the Expense account feature (of a QBO Product/Service) to let me split income across two income accounts:

  • Revenue from a resold product (what we pay for a product we resell)
  • Revenue from markup/margin on the resold product  (this isn't pure profit for us, because we still have to subtract expenses like install labor, fuel, etc...)

As it turns out, our PSA doesn't even sync costs to QuickBooks, so I wasn't even able to test this theoretical mode of operation.

 

I still believe that splitting revenue in this way would most accurately represent the difference between Service and Product revenue for a product reseller business like ours. However, I haven't been able to find any examples of other businesses using it, and it's clearly not supported by our PSA and Quickbooks. Therefore, we decided to classify income as Service or Product revenue based on ownership and recurring payments. 

  • a recurring payment agreement exists (i.e. subscription, lease): Service revenue
  • the invoiced item is 100% labor: Service revenue
  • the product's ownership is transferred to a customer (i.e. sale): Product revenue
Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us