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

Sales Report Doesn't show Sub-Account sales

When I run any "sales" report, it doesn't show any sales made and categorized as any sales sub-account. In other words, I created 5 sub-accounts to Sales (ie. Sales-Web Design, Sales-PPC Management, Sales-SEO management, etc.) but none of those sub-account sales show when I run a sales report.

accounts.jpg

 

So my question is, how do I either (1) get them to show in the sales report? Or (2) create a custom sales report that includes sub-accounts?

Solved
Best answer December 12, 2018

Best Answers
Malcolm Ziman
Level 10

Sales Report Doesn't show Sub-Account sales

I don't believe sub-accounts is the problem.  You have to use either an Invoice (for sales on credit) or a Sales Receipt (for cash sales) if you want to see the income on the P&L, dashboard or in sales reports. If you create income with a Bank Deposit, then it will show in a P&L only,  but not on the dashboard or in sales reports

View solution in original post

11 Comments 11
Charies_M
Moderator

Sales Report Doesn't show Sub-Account sales

Thank you for taking to time seek out our help, scottmckellam.

 

Let me help you run a report that will show your sales sub-accounts in QuickBooks Online (QBO).

 

If you wish to show sales sub-accounts, we can run Transaction Detail by Account and make sure to select All as your Filter for the Account. Please know that these sub-accounts will only show if there are transactions attached to it.

 

I'll show you how run the report by following the steps below:

  1. Go to Reports.
  2. Search for Transaction Detail by Account Report.
  3. Click Customize.
  4. Click Filter.
  5. From the Account, select All.
  6. Click Run report.

You can check out this article to learn more about customizing reports in QBO: How to customize reports.

 

There you have it. If I can assist you with anything else or about QuickBooks Sales reports, feel free to leave me a reply. Have a great day.

scottmckellam
Level 2

Sales Report Doesn't show Sub-Account sales

Thank you Charies! I appreciate you taking the time to respond. 

 

I suppose I could also run the "Income by Client Summary"...but it's a little offputting to see only $35k of the actual $64k of sales in the sales reports...or especially on the dashboard. 

 

I guess it's just sort of pointless to have the "Sales" graph in the Dashboard then...if it doesn't (or can't) include the Sales sub-accounts. 

Income by client.jpgDashboard.jpg

FritzF
Moderator

Sales Report Doesn't show Sub-Account sales

Hi there, @scottmckellam.

 

I appreciate the screenshots that you've provided. I'm here to explain the difference between the amount that shows on the Dashboard's Sales graph and on the Income by Client Summary report.

 

The most likely reason why the amounts are different is that on the Income by Client Summary report all the transactions connected with an income account will show on the report. While the amount on the dashboard's sales graph is the total amount of all the transactions with an item that is being sold to your customers.

 

You may want to check the Sales by Customer detail report to match the dashboard sales graph. Here's how:

 

1. Go to Reports menu at the left panel.
2. Type Sales by Client Detail in the search bar.
3. On the Report period drop-down, select This Year-to-date.
4. Click Run report.

 

 

 

You can also take note of the article provided by my colleague @Charies_M to know more about customizing reports in QBO for future reference. 

 

That should answer your concern for today. Please let me know how it goes or if you're referring to something else by leaving a comment below. I'll be here to help. Take care always!

scottmckellam
Level 2

Sales Report Doesn't show Sub-Account sales

Thanks @FritzF, that was actually my point. When I run that report, it's not showing all the sales!  It's only showing $35k.  Where are all the other sales I've made all year?

 

I'm guessing I just need to spend more time troubleshooting this myself. I'm sure there is some technical difference between what is showing as income and what is showing as "sales"....but in my mind, it's all the same. There is no difference. Even if it coming in through difference channels (QB invoice...PayPal...manual deposit)...shouldn't it all count as sales? Especially if I code it that way?

FritzF
Moderator

Sales Report Doesn't show Sub-Account sales

Hi again, @scottmckellam.

 

Thanks for getting back to me.

 

I can see how this built-in feature and functionality for sales report would be helpful for you and your business. Since this isn't currently an option in QBO, I'm going to send feedback directly to our product developers team for consideration in future updates.

 

I also encourage you to submit feedback as well. This can be done directly through your QBO account by clicking the Gear icon in the top right corner and selecting Feedback or by going to the following link: QuickBooks Online Feature Requests.

 

 

Should you have any follow-up questions or concerns, don't hesitate to post again or leave a comment below. I'm always here to help. Enjoy the rest of the day!

Malcolm Ziman
Level 10

Sales Report Doesn't show Sub-Account sales

I don't believe sub-accounts is the problem.  You have to use either an Invoice (for sales on credit) or a Sales Receipt (for cash sales) if you want to see the income on the P&L, dashboard or in sales reports. If you create income with a Bank Deposit, then it will show in a P&L only,  but not on the dashboard or in sales reports

scottmckellam
Level 2

Sales Report Doesn't show Sub-Account sales

As a follow up to anyone reading this...it turns out this is my error. I was confusing "sales" and "income."  Thanks to everyone who helped me get smarter today!!! :smileyvery-happy:

MiracleStrategies
Level 1

Sales Report Doesn't show Sub-Account sales

Malcolm, thank you for your expertise. I set up Quick Books two days ago and I'm a one-person consultant. Based on your reply to this question, I believe I have made a critical mistake up front. You wrote: "You have to use either an Invoice (for sales on credit) or a Sales Receipt (for cash sales) if you want to see the income on the P&L, dashboard or in sales reports. If you create income with a Bank Deposit, then it will show in a P&L only, but not on the dashboard or in sales reports."

 

Unfortunately, I added all my YTD Sales to QB through banking transactions. Now my Customer Sales Summary shoes $0. Is there any way to get them to show up without re-entering 2.3  months of data? - Thank you in advance.

Alessandra_B
QuickBooks Team

Sales Report Doesn't show Sub-Account sales

Hi @MiracleStrategies,

 

The Customer Sales Summary report only shows transactions with product/service items. Let me give you another report which shows all your transactions.

 

As what @Malcolm Ziman mentioned above, bank deposits only show on your Profit and Loss report. If you want to see all transactions in one report, you can pull up your Transaction List by Customer report.

 

The Transaction List by Customer report shows all customer transactions. Such transactions include invoices, sales receipts, and even bank deposits.

 

Here’s how you can pull up the report:

  1. On the left panel, click on Reports.
  2. Look for Transaction List by Customer from the search box.
  3. Adjust the Report period to show a specific period on the report.
  4. Click on Run Report.

Also, you have the options to show more columns on the report by clicking on Customize. Once done, you can then click on Save Customization to save your report in your Custom Reports tab.

 

Don’t hesitate to leave a comment below if you have other concerns by clicking on the Reply button. I’ll be here in the Community to provide assistance. Have a good one!

CPY_NJ
Level 2

Sales Report Doesn't show Sub-Account sales

I have the opposite problem. My sales showup in both sales and then in the sub-account. So, if I make $50K sales, it is showing $100k

 

what am I doing wrong in setting up my accounts?

 

katherinejoyceO
QuickBooks Team

Sales Report Doesn't show Sub-Account sales

Welcome to this conversation, @CPY_NJ.

 

I've tried to replicate the info in my sample account, but it only shows the right amount. 

 

To make sure we're on the same page, can you please tell me how you record your sales? Any additional information you can provide will help me provide you with the right resolutions to your concern. 

 

Here's the screenshot of my sample account: Capture101.JPGCapture102.JPG

 

I'll be looking forward to your response. Have a great day ahead. 

Need to get in touch?

Contact us