Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
SUMMER SAVINGS 90% OFF QuickBooks for 3 months* Ends June 27
Buy nowWhen I try to run an Income by Customer report, then filter by payment type , the report is empty. Why?
This happens because the payment method is not saved on the accounting rows that use income accounts. It's saved on the payment that pays the invoices or on the 'source' row of a sales receipt.
Hello there, AjaLincoln.
I'm joining this thread to provide additional information on how you get the data based on your desired date.
BigRedConsulting is right. QuickBooks uses source and target when applying the information to the report. It's the reason why the Income by Customer report shows empty when adding the payment method in the Filter section. You can use this article for more details: Understand reports.
We can pull up the Payment Methods quick report to generate all customer payment with different payment method.
The other way around is exporting the report in Excel. Doing this help you filter and consolidate the data you want. Open the report. Then, select Excel drop-down arrow and select Update Existing Worksheet.
Here are some articles for more tips and details about handling sales transactions and reports:
Please let me know if you have more concerns about QuickBooks reports. I'll be around to help. Take care and stay safe.
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.
For more information visit our Security Center or to report suspicious websites you can contact us here