cancel
Showing results for 
Search instead for 
Did you mean: 
DCrain
Level 2

Sales Report that shows sales orders each individual rep has written for a fiscal year

Hello,

      Is there a way to run a sales report that shows how many sales orders each individual rep has written for a fiscal year?  Not the total amount but the actual number of tickets written.  Our sales staff is wanting to know how many tickets they have each written but we can't figure out how to acomplish this.  Could you please give me a set of instructions on how to acomplish this task?

 

Thanks In Advance

 

(Title has been edited by moderator for clarity)

Solved
Best answer August 02, 2017

Best Answers
Anonymous
Not applicable

Sales Report that shows sales orders each individual rep has written for a fiscal year

Hi DCrain, 

 

What version of QuickBooks are you running?  In my sample file on QuickBooks Desktop, I run a similar report by creating a Sales By Rep Detail report and then I change the filtering to show Non Posting transactions. 

 

Customizing the report to show non-posting transactions is important because QuickBooks will only show transactions that have affected the balance and P&L accounts by default. 

 

To create the report:

  • Go to the Reports menu at the top of the screen then choose Sales and then Sales Rep By Detail
  • Click Customize Report
  • Choose the Filters tab
  • In the Choose Filter area, choose Posting Status
  • Set the Posting Status to Non-Posting

Then press OK to display the report.  

 

*If your reps are also on Estimates, they will be displayed as well. If this is the case, you may want to set the Transaction Type filter to show only sales orders. 

 

Here are some screenshots that could show you what to expect:

 

2017-08-02_13-37-46.jpg2017-08-02_13-38-39.jpg2017-08-02_13-38-50.jpg

View solution in original post

22 Comments 22
Anonymous
Not applicable

Sales Report that shows sales orders each individual rep has written for a fiscal year

Hi DCrain, 

 

What version of QuickBooks are you running?  In my sample file on QuickBooks Desktop, I run a similar report by creating a Sales By Rep Detail report and then I change the filtering to show Non Posting transactions. 

 

Customizing the report to show non-posting transactions is important because QuickBooks will only show transactions that have affected the balance and P&L accounts by default. 

 

To create the report:

  • Go to the Reports menu at the top of the screen then choose Sales and then Sales Rep By Detail
  • Click Customize Report
  • Choose the Filters tab
  • In the Choose Filter area, choose Posting Status
  • Set the Posting Status to Non-Posting

Then press OK to display the report.  

 

*If your reps are also on Estimates, they will be displayed as well. If this is the case, you may want to set the Transaction Type filter to show only sales orders. 

 

Here are some screenshots that could show you what to expect:

 

2017-08-02_13-37-46.jpg2017-08-02_13-38-39.jpg2017-08-02_13-38-50.jpg

DCrain
Level 2

Sales Report that shows sales orders each individual rep has written for a fiscal year

We use QuickBooks Enterprise 15 - R14_19.  Thank you for the help.  It doesn't appear that it will give you a count for the total number of sales orders written per rep.  It appears you would have to manually count them after setting the filters up correctly.  It gives you the total amount sold and total qty but it doesn't appear to show the total number of sales orders written. 

 

Our business is strange in that we have both hard bid and retail sales and there seems to be a bit of a dispute between the retail counter sales staff and the hard bid sales staff so they were wanting to see how many tickets had been written by each rep as in the total amount of sales orders that had been typed up so that they could compare. 

 

The dispute arises because within the same company we have to operate on two completely different business models.  The retail side has to use high profit margin / low volume and the hard bid side has to use low profit margin / high volume.  The sales staff is having trouble grasping this concept so I am trying to explain to them how the two are differet but equal. 

 

The hard bid staff in theory should only be writing a small number of sales orders because they only bid projects while on the other hand the retail sales side should be writing a higher number of sales orders at lower quantities.  I just need a way to total the number of sales orders written by each rep to settle the dispute.  I can always export to excel and run a sum formula I guess unless you know of a way that QuickBooks will total the number of sales orders written.

 

Thanks

Anonymous
Not applicable

Sales Report that shows sales orders each individual rep has written for a fiscal year

Thanks for the clarification DCrain, 

 

Honestly, to keep things as simple as possible, I would export to excel and have it count the sales orders too. There may be another option if you have access to the Advanced Reporting feature.  I haven't used it much myself, but you may find it interesting: http://qbar.intuit.com/

DCrain
Level 2

Sales Report that shows sales orders each individual rep has written for a fiscal year

I think I like the K.I.S.S. method personally.  Usually time is the most valuable of all resources and seems as though expoting to excel will be faster than learning the advanaced reporting feature.  Thank you again for the help.  Much appreciated.

Anonymous
Not applicable

Sales Report that shows sales orders each individual rep has written for a fiscal year

I highly appreciate the info like this! I currently working on improving my email marketing and sales activity. I've started using this soft recently https://voiptimecloud.com/inside-sales-software/ . It works great, when it comes to sales order reports!

chinachin
Level 1

Sales Report that shows sales orders each individual rep has written for a fiscal year

Thanks for picking out the time to discuss this. It is extremely helpful for me. Thanks for such a valuable help again.word counter

sarok110
Level 1

Sales Report that shows sales orders each individual rep has written for a fiscal year

Amazing Tutu Thanks I check My  Sales Order Music.

semifa
Level 1

Sales Report that shows sales orders each individual rep has written for a fiscal year


@Anonymous wrote:

Hi DCrain, 

 

What version of QuickBooks are you running?  In my sample file on QuickBooks Desktop, I run a similar report by creating a Sales By Rep Detail report and then I change the filtering to show Non Posting transactions. 

 

Customizing the report to show non-posting transactions is important because QuickBooks will only show transactions that have affected the balance and P&L accounts by default. 

 

To create the report:

  • Go to the Reports menu at the top of the screen then choose Sales and then Sales Rep By Detail
  • Click Customize Report
  • Choose the Filters tab
  • In the Choose Filter area, choose Posting Status
  • Set the Posting Status to Non-Posting

Then press OK to display the report.  

 

*If your reps are also on Estimates, they will be displayed as well. If this is the case, you may want to set the Transaction Type filter to show only sales orders. 

 

Here are some screenshots that could show you what to expect:

 

2017-08-02_13-37-46.jpg2017-08-02_13-38-39.jpg2017-08-02_13-38-50.jpg


 

Thanks it's working for me. Perfectly.
peterjerry
Level 1

Sales Report that shows sales orders each individual rep has written for a fiscal year

thisis really helpful/

peterjerry
Level 1

Sales Report that shows sales orders each individual rep has written for a fiscal year

yes for me too,

peterjerry
Level 1

Sales Report that shows sales orders each individual rep has written for a fiscal year

Yes for sure.

peterjerry
Level 1

Sales Report that shows sales orders each individual rep has written for a fiscal year

Nice to have this ,

bhaimane
Level 1

Sales Report that shows sales orders each individual rep has written for a fiscal year

Thanks for the post. That is of much help.

bhaimane
Level 1

Sales Report that shows sales orders each individual rep has written for a fiscal year

Thanks for the post. That was of much help.

khan2556
Level 1

Sales Report that shows sales orders each individual rep has written for a fiscal year

 thank for help you your realy nice man amazeproduct

khan2556
Level 1

Sales Report that shows sales orders each individual rep has written for a fiscal year

thank for help you your realy nice man amazeproduct

aneebaali
Level 1

Sales Report that shows sales orders each individual rep has written for a fiscal year

I have used almost 7 to 8 different accounting software for my fesco bill online but QuickBooks is one of the best software I have ever seen. Thanks to the developer and team of QuickBooks.

aneebaali
Level 1

Sales Report that shows sales orders each individual rep has written for a fiscal year

thanks to you brother 

GregoryStellar
Level 1

Sales Report that shows sales orders each individual rep has written for a fiscal year

Quickbooks perfectly solves the problem of creating a financial report! In my free time I love to drawing  step by step drawing tutorials!

GregoryStellar
Level 1

Sales Report that shows sales orders each individual rep has written for a fiscal year

Quickbooks perfectly solves the problem of creating a financial report! In my free time I love to draw and create step by step drawing tutorials!

johnragan1998
Level 1

Sales Report that shows sales orders each individual rep has written for a fiscal year

Same Here. Thank you so much for such a detailed guidance. I have tried multiple accounting software but quickbooks is really the best.

 

Regards,

reverb

johnragan1998
Level 1

Sales Report that shows sales orders each individual rep has written for a fiscal year

Thank you for such a detailed guidance. Reverb

Need to get in touch?

Contact us