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.
Cmccourt
Level 2

Help with separating funds

Hi there, Quick Books Online user here.

 

So the owner of the company I work for was asking me if there is a way for us to separate out our job income (the funds we collect from the customer for each job). He wants to be able to separate out the gross profit , overhead and eventually sales commissions into 1 or 3 separate accounts every time we sell a job and collect payment. 

from what I gather, this is the best way I can describe how it would work. 

job sells for $10,000

COGS is $7000

Gross profit is $3000

 

I really have no idea where to start and appreciate and ideas or advice. 

 

2 Comments 2
DivinaMercy_N
Moderator

Help with separating funds

I'm here to ensure you can achieve your desired data, @Cmccourt

 

You can specify the income and expense accounts assigned to the products or jobs you sell. Once they are assigned to a transaction, the income or expense amounts will go directly to the specific accounts linked to them. Let me guide you how:

 

  1. Sign in to your QuickBooks Online (QBO) account.
  2. Then, select the Sales tab.
  3. Choose Products and services.
  4. Locate the product or job you want to update and select Edit.
  5. From the Income account drop-down choose the sales account you want. Select also the specific account under the Expense account field.

 

If you want to create a new account for categorizing your sales and expenses, see this article for the detailed guide: Add an account to your chart of accounts in QuickBooks Online.

 

Then, to monitor the profitability of your business over a specific period, you can run the Profit and Loss report. Here's how:

 

  1. Select the Reports menu.
  2. Then, scroll down to the Business overview section.
  3. Click Profit and Loss.

 

Also, QBO has a compilation of how-to videos that will further guide you in optimizing your navigation. It includes tutorials from setting up a company to running payroll for your employees.

 

Stay in touch if you need additional assistance in separating your funds in QBO. Please leave your response below. Have a good one. 

Cmccourt
Level 2

Help with separating funds

Thanks for the reply.

 

Ah okay. I think I see what you mean. We currently just have a “Job Income” income account. And then of course the expense side which is Cost of Goods Sold.

 

I see that I can create either a parent income account  or sub account to the job income account and just call it “commissions , Profit, OH etc. or whatever he wants to track. Then it’s just a matter of assigning them. 

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us