SUMMER SAVINGS 90% OFF QuickBooks for 3 months* Ends June 27

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
AjaLincoln
Level 1

A report that shows all customers that paid by check/visa/...etc during a certain time frame.

When I try to run an Income by Customer report, then filter by payment type , the report is empty. Why?

2 Comments 2
BigRedConsulting
Community Champion

A report that shows all customers that paid by check/visa/...etc during a certain time frame.

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.

SarahannC
Moderator

A report that shows all customers that paid by check/visa/...etc during a certain time frame.

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.

 

  1. Go to the Lists menu.
  2. Customer & Vendor Profile Lists.
  3. Select Payment Method.
  4. Choose the payment method you want to pull up.
  5. Click Report drop-down arrow. 
  6. Select Quickreport or press Ctrl+Q.

 

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.

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us