cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Do you have a report for invoices paid during a specific period by rep to calculate commissions based on amount client paid & not invoiced no matter age invoice is?

I need a sales report to generate monthly/qrtly commissions which will show me all invoices paid during a specific period (with option to filter by rep) in order to calculate commissions due.  I only want the report to show the invoice # once and the amount, if there is more than 1 item on the invoice it shows each amount and the invoice number. I want rep-amount the invoice was and amount the we received by the client, no matter the date the invoice was issued. 

We only pay commission to reps when an invoice has been paid. Some invoices get paid partially or within a 30-90 day term or longer  I want to be able to see which invoices were paid or partially paid during a specific time period no matter how old the invoice is.

Solved
Best answer 10-19-2018

Accepted Solutions
Established Community Backer ***

Since QBO does not have a Rep field for sales, usually yo...

Since QBO does not have a Rep field for sales, usually you create a class or location to use for this kind of thing

class allows you to tag each item line in a transaction
location allows you to tag the entire transaction

From what you say, location would be the best to use

then you can run a P&L by location, set the P&L report to cash basis and it will only show paid invoices, or run a location report and see what you can do in report customization


10 Comments
Established Community Backer ***

Since QBO does not have a Rep field for sales, usually yo...

Since QBO does not have a Rep field for sales, usually you create a class or location to use for this kind of thing

class allows you to tag each item line in a transaction
location allows you to tag the entire transaction

From what you say, location would be the best to use

then you can run a P&L by location, set the P&L report to cash basis and it will only show paid invoices, or run a location report and see what you can do in report customization


Active Member

For what it’s worth, I added a custom field to my invoice...

For what it’s worth, I added a custom field to my invoices for Account Rep.  I can pull invoice reports for a certain time period and add the A/R field and Account Rep as filters.  The problem is, I cannot pull a report that has invoices from any date paid within a certain time period without using the Payment report.  Unfortunately, the payment report will not show the Account Rep as that info is tied to the invoice and not the payment.
Active Member

For what it’s worth, I added a custom field to my invoice...

For what it’s worth, I added a custom field to my invoices for Account Rep.  I can pull invoice reports for a certain time period and add the A/R field and Account Rep as filters.  The problem is, I cannot pull a report that has invoices from any date paid within a certain time period without using the Payment report.  Unfortunately, the payment report will not show the Account Rep as that info is tied to the invoice and not the payment.
Experienced Member

It is absolutely frustrating that QB Online has taken suc...

It is absolutely frustrating that QB Online has taken such a huge step backwards regarding this whole sales rep reporting issue.  Had I known this before hand, I would never have switched.  It is time to go back to desktop.
Established Community Backer ***

there is more functionality lost than just that, a non pa...

there is more functionality lost than just that, a non partisan comparison of QBO vs QB desktop
<a rel="nofollow" target="_blank" href="http://onsale-apparel.com/Rustler/qbo-or-qbdt">http://onsale-apparel.com/Rustler/qbo-or-qbdt</a>
(cost comparisons are at the end of the article)
Community Backer ***

Hi You can use Sales By Customer Detail Report. From Left...

Hi You can use Sales By Customer Detail Report.

From Left Navigation Bar select Reports - All ReportsSales By Customer Detail Report - Select the period you need and Select Cash Basis Accounting Method ( i.e Sales based on cash basis ) - From Top Right select Customize & / OR select Top Gear Icon for Settings- Select your preferences such as Crew # etc.

Also you have the option to Save your Customized Report for future use. 

Note. If you entered Credit Memo for Sales Return, Refunds, etc this will be included in your Report assuming you have selected Transaction Type - All under Customization.

Attached screen shot for sample report.

If you need more details comment back.

Not applicable

the problem is i can only see invoices that were created...

the problem is i can only see invoices that were created in that time frame, i need to see if an invoice was paid in June but was created in Decemeber i need the payment to show up and the invoice and rep on the June report how can i do that
Community Backer ***

Other option is to create SALES BY CUSTOMER DETAIL Report...

Other option is to create SALES BY CUSTOMER DETAIL Report ( Select to Customize / Settings to show Invoice No, Amount ) - Accrual basis export to Excel and  Combine with the Previous Cash basis report I suggested after Exporting to Excel.
Frequent Explorer *

Re: the problem is i can only see invoices that were created...

I need to do this exact same thing for commissions.  Did you ever find a solution?

QuickBooks Team

Re: the problem is i can only see invoices that were created...

Our AllStar @Rustler has a great suggestion for this, mtestoni1.

 

Let me share his answer below:

 

Since QBO does not have a Rep field for sales, usually you create a class or location to use for this kind of thing

class allows you to tag each item line in a transaction
location allows you to tag the entire transaction

From what you say, location would be the best to use

then you can run a P&L by location, set the P&L report to cash basis and it will only show paid invoices, or run a location report and see what you can do in report customization


 

In addition, we have a Help article that can help you track Sales Commissions in QuickBooks Online.

 

Let me know how this works for you. Have a good day!