Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Connect with and learn from others in the QuickBooks Community.
Join nowI 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?
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.
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.
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!
There is no customization, its just the "sales by customer summary report". For the current year.
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:
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!
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.