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

QB self .ex.I sold $100 of product,pd $20 in commis, was paid $80. Can anyone assist with entering of total sale, commission, and then my income so my deposit matches

I am finding that I cant manually enter a transaction and split it. I tried looking for uncollected funds but its not a choice and I am not seeing where I can add a new category in Quickbooks self employed
3 Comments 3
Michael K
Moderator

QB self .ex.I sold $100 of product,pd $20 in commis, was paid $80. Can anyone assist with entering of total sale, commission, and then my income so my deposit matches

Glad to see you in the Community, @wwrk2hrd.

 

Entering your invoice information in QuickBooks Self-Employed is super easy and takes only a few moments.

 

Here's how:

  1. Select Invoices on the left-hand menu.
  2. On the Invoices screen, click the Create invoice button.


     
  3. Fill out the Client details on your Invoice, then click Add work to add a line item to the invoice.
  4. In the example below, I've added a line item for the Product for $100.00 and another line item for Commission in the amount of -$20.00. This will bring the total to $80 so that you can match your bank transaction to the Invoice.

That's it! Please let me know if there's anything else I can do to be of assistance. Thank you for bringing us your questions.

wwrk2hrd
Level 1

QB self .ex.I sold $100 of product,pd $20 in commis, was paid $80. Can anyone assist with entering of total sale, commission, and then my income so my deposit matches

Thank you MichaeIK. I  considered that and made a dummy invoice. My concern is when I pull reports in QB self it won't categorize each line item of the invoice.  I created the dummy with 

sales $2.00

commission  -$1.00

sales tax .07

total 1.07

I marked it as paid and then pulled reports and none of the line items show in reports. This could cause me an issue at end of month/year. 

 

What i then tried was to create multiple transactions. 

My total collected on the below example was $763.12

I made one transaction for commission and one transaction for the exact same amount showing the money was initially collected as sales (income)

I did the same with the sales tax money, one for the amount of tax I paid and one showing that same money was collected

and then finally I made one for the amount that was actually deposited. 

sales tax collected on hospital sales

Cash

-$46.89
Business
   
 12/26/19
income hospital sales

Cash

$46.89
Business
   
 12/26/19
income hospital sales payroll deduct

Cash

$314.63
Business
   
 12/26/19
commission paid to hospital for sales

Cash

-$314.63
Business
26/19
ATM Deposit

Basic Business Checking

$401.59

 

My thought on this was because I have to show the entire amount I collect for my yearly reports and even though I paid commission I still did earn the income.

 

I am hoping I explained what I did well enough but this was the only way I could come up with to show everything....and I am still not sure if this is correct or the best method

AlexV
QuickBooks Team

QB self .ex.I sold $100 of product,pd $20 in commis, was paid $80. Can anyone assist with entering of total sale, commission, and then my income so my deposit matches

Let me share how invoice works in QuickBooks Self-Employed, wwrk2hrd.

 

The QuickBooks Self-Employed won't automatically categorize the invoices regardless if you marked it as paid or not. It is just for recording purposes and won't reflect to any reports.

 

You have to import and categorize the transactions from your bank. Then, we can split it when categorizing so it will reflect on your reports correctly. From your Transactions tab, locate the transaction and click Split. On the pop-up, separate the amounts for sales, commission, and sales tax, then select the correct Category.

 

If your bank isn't connected into your QuickBooks, you can manually enter them, just like what you did. Though, you only have to enter the total amount. Creating another deposit transaction will cause discrepancy since it's already a duplicate to the transactions you've entered.

 

It would also be better to consult to an accountant. This is to make sure to make sure all your expenses and income will be categorize properly.

 

You can always reach out to us here if you have other questions. Have a great day!

Need to get in touch?

Contact us