United States United Kingdom Australia Canada India Mexico Singapore South Africa Global
cancel
Turn on suggestions
Showing results for 
Search instead for 
Did you mean: 
Highlighted
clearview872
clearview872
Not applicable
posted
‎10-15-2018 05:37 PM
last updated ‎November 08, 2018 1:52 PM

How do i run a report showing gross sales by month for a 12 month period

 
Solved
0 Cheers
Cheer
Reply
Best answer 10-15-2018
Solved

Accepted Solutions
GarlynGay
Moderator
Moderator
‎10-15-2018 05:37 PM

Hello clearview872, Let me help you with this. QuickBooks...

Hello clearview872,

Let me help you with this. QuickBooks Online doesn't have a report that shows gross sales per month. However, you can pull up the Sales by Product/Service Summary report and change the date range per month. Then, export the report in Excel.  I'd encourage you to request that this option be added. You can send a product suggestion by clicking the Gear icon and selecting Feedback. We'd really appreciate your suggestion since many of our updates come from customer recommendations.

Thanks for posting!

Reply
7 Comments
GarlynGay
Moderator
Moderator
‎10-15-2018 05:37 PM

Hello clearview872, Let me help you with this. QuickBooks...

Hello clearview872,

Let me help you with this. QuickBooks Online doesn't have a report that shows gross sales per month. However, you can pull up the Sales by Product/Service Summary report and change the date range per month. Then, export the report in Excel.  I'd encourage you to request that this option be added. You can send a product suggestion by clicking the Gear icon and selecting Feedback. We'd really appreciate your suggestion since many of our updates come from customer recommendations.

Thanks for posting!

Reply
mightygrow
mightygrow
Community Contributor *
‎10-15-2018 05:37 PM

That report has too much info that can't be removed/custo...

That report has too much info that can't be removed/customized in QBO, like % of sales, qty, avg price. What if you just need to simple total by month?
0 Cheers
Cheer
Reply
mightygrow
mightygrow
Community Contributor *
‎10-15-2018 05:37 PM

I ran "sales by customer summary" (instead of by product/...

I ran "sales by customer summary" (instead of by product/service) and it allows me to turn on or off those unwanted details. Seems like both reports should have that ability.
0 Cheers
Cheer
Reply
GarlynGay
Moderator
Moderator
‎10-15-2018 05:37 PM

Hi MightyGrow, Thanks for posting here. You try clicking...

Hi MightyGrow,
Thanks for posting here.
You try clicking on the Customize button on the report page to filter the unnecessary columns. Then, let me know if it helps.
0 Cheers
Cheer
Reply
Deanna5
Deanna5
Not applicable
‎10-15-2018 05:37 PM

To show gross sales by month for 12 month period (or any...

To show gross sales by month for 12 month period (or any custom date) on one report: 

Reports / Company & Financial / Profit & Loss Standard. 

Click: Customize Report; In the center where it says Display columns by________ across the top. Click the down arrow and choose Month. Click OK

Set the dates on you want the report for; refresh.

You should have your gross sales by month.

Deanna

Reply
Greg100
Greg100
Not applicable
‎11-07-2018 02:06 AM

Re: Hello clearview872, Let me help you with this. QuickBooks...

I find it staggering QBO doesn't allow a management tool as simple and fundamental to business operation as sales by month.

 

 

Reply
lomike98
lomike98
Not applicable
‎11-12-2018 09:02 AM

Re: To show gross sales by month for 12 month period (or any...

This is exactly the report I was looking for.  Thanks for the easy instructions

0 Cheers
Cheer
Reply
Top

Need to get in touch?

Contact us