How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask PDtax Your Own Question
PDtax
PDtax, CPA firm owner
Category: Financial Software
Satisfied Customers: 4097
Experience:  Have used almost every software package available.
64119565
Type Your Financial Software Question Here...
PDtax is online now
A new question is answered every 9 seconds

Question on QuickBooks. I am real estate broker. The average

This answer was rated:

Question on QuickBooks. I am real estate broker. The average split of my agents is 90% to their favor. When I get the commission checks I categorized them as Commission Income in the income category. When I pay the realtors I categorized it as CommissionsPaid in the expense category. My reports show a huge income "commission Income", that gets offset by an almost equal "commissionsPaid" expense. I'd like to set a system where the commission income and commissionsPaid would wash each other and would not show in the reports. I'd like the report to only show the 10% I am keeping.

PDtax :

Welcome to the site. I will be helping you today.

PDtax :

a simple way to accomplish what you want is to change the classification of commissions Paid from an expense to a reduction of the commissions income. That way, both line items will be available for tax time, but net commissions will show on your profit and loss statement.

PDtax :

You can then customize the report to not report the detail, but only net commissions, and only the retained 10% would be reported as income.

PDtax :

Thanks for asking at Just Answer/PDtax. Ask any follow up you may have, or please leave positive feedback to let management know your opinion of the service today.

Customer:

THank you. So let's say, I get 1000 coming in. I classify it as commission income. Then I have 900 going out, also classified as commission income, which leaves a $100 remainder. How do I customize the report? What do you mean by "detail"? Please explain because I don't see how to show in the report only the 10% without seen the rest

PDtax :

You could set a main category as "Commissions", and tell QuickBooks to print just the commissions net amount, without the detail of Commissions Income and Commissions Paid. Then, save the formatting of the report and you will always have a report that shows only (net) commissions as the income line.

PDtax :

Try that and let me know if you need assistance customizing, but it's pretty straight forward.

Customer:

I know there is a way to change one category into something else at once. Can you tell me that?

PDtax :

Set up a new income category, call it "Real estate commissions" or something to make it different from the Commission Income and Commissions Earned. Then, bring Commissions Earned and Commissions Paid under that category. Change their categories. Then, set up your reports to only report "Real estate commissions".

PDtax and 2 other Financial Software Specialists are ready to help you

Related Financial Software Questions