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

Sales by customer summary report includes all revenue.

I don't really understand this report. My profit and loss has things nicely broken down by category. But this sales by customer summary seems to include all revenue coming into the business, including grants, transfers, etc. It also doesn't correspond with the profit and loss very well. Is there a way to prevent non-sales revenue (like grants) from showing up in this report? 

5 Comments 5
Rasa-LilaM
QuickBooks Team

Sales by customer summary report includes all revenue.

Welcome to the Community, arobint.


The report mentioned above will show the total sales for each customer. In regard to your concern, I need some information on what you’re currently experiencing. This way, I can provide the best solution.


May I know If you set up your grants and transfers as products or services? Did you customize the report and filter it to a specific item? I appreciate it if you can send a screenshot of the report. This will also give a clearer view of the issue.


I’m looking forward to your reply. Thank you in advance.

arobint
Level 2

Sales by customer summary report includes all revenue.

Grants are in an "other income" account, and are brought in through cheque deposits or bank transfers. No where in the grant account does it indicate sales. On the sales by customer summary report, it divides this money between the entities we received it from, and if we didn't indicate the source, it puts it into "not specified". It also puts loan proceeds into "not specified" which makes no sense at all. However, we do have some portion of income that is received in December but is accorded to the next financial year, and that journal entry is NOT reflected in the sales, even though it is transferred from a sales account to a sales account. Super weird. 

 

 

JonpriL
Moderator

Sales by customer summary report includes all revenue.

Thank you for the screenshot, @arobint!

 

Before we can accomplish your goal for today, can you tell me more about your report? Saying you've indicated a source, how did you generate your report?

 

A screenshot of the customization you made would be much appreciated. Hope to hear again from you. Take care and stay safe!

arobint
Level 2

Sales by customer summary report includes all revenue.

There is no customization, its just the "sales by customer summary report". For the current year. 

JonpriL
Moderator

Sales by customer summary report includes all revenue.

I appreciate the clarification you provided, @arobint! I want to ensure you're able to pull up your report correctly.

 

The Sales by Customer Summary report allows you to view the total sales made for the specified period. Sales transactions namely invoices, sales receipts, and credit memos.

 

Comparing this report to your Profit and Loss does not show any specific category use. Instead, it'll report the income account of the product or services used as the line item transaction detail of the sales entry.

 

Since, you've already confirmed certain transactions, not related to your sales, shown on the said report, I'd recommend contacting our Customer Care Support. One of our specialists has the tool to further investigate why your report is not generating the proper data.

 

You can do so by following the steps below:

 

  1. Go to Help.
  2. Select Search.
  3. Click Contact Us.
  4. Enter a few words describing how your report is generating your data incorrectly in the What can we help you with? field.
  5. Select Continue.
  6. Click Chat, Callback, or Phone number.

 

Also, the following articles added below give you the overview of how a certain report is generated:

 

 

It'll always be my pleasure to help if you got questions other than generating your report. I'll surely be around ready to help. Take care always!

Need to get in touch?

Contact us