Listing customer check payments on report

Thanks for posting, @Susan607.

I have some information about QuickBooks reports. QuickBooks Desktop (QBDT) and QuickBooks for Mac (QBDT for Mac) works in two different operating systems (Windows and macOS). That said, some of the report filters and customization aren't available in QuickBooks for Mac.

To learn how to filter report data in QBDT for Mac, check out this guide: Customize reports in QuickBooks Desktop for Mac.

Here's how to view the available columns and filters in QBDT: Customize reports in QuickBooks Desktop.

I've also added this link in case you need help in exporting reports to Excel. You can open the Excel workbooks with Apple Numbers v3.5 or Microsoft Excel 2016 or later, including Mac Office 365.: Export a report in QuickBooks Desktop for Mac.

Please know that you're always welcome to swing by anytime if you still have questions or concerns with reports. I'm always here to help. Take care and have a nice day ahead.

Hi, SheellaGrace,

I've QB 2019 which does not have a create report function. I've checked the reports center and even if I create a report the only tools I can find are the filter and options icons at the top of report which are limited in what they can do.  i.e. add or remove columns, sort and limit customer lists and of course date ranges.  There is no customize report option that I can find.

I need to be able to list sales receipts for a customer in a date range along with check numbers.  I don't see anywhere I can find the check numbers on a report.  When I pull up a undeposited funds register to print the customers transactions to that account, it can not be exported as an excel file, only printed as a pdf which crops the fields and does not allow column adjustment.  Looks terrible.  See file uploaded. Any suggestions?  Even if just a list of checks with sales receipts would be helpful.  Thanks.

Thanks for coming back, Susan607.

If you are using QuickBooks Desktop for Windows, we can run the Transaction Detail report. Then, customize the report to Sales Receipts as the Transaction Type and select Check number in the Display Column. Here's how: 

1. From the QuickBooks Reports menu, select Custom Reports.
2. Choose Transaction Detail.
3. Enter the appropriate date range.
4. Select Check # in the Columns field.
5. Tap Filters.
6.  Enter Transaction Type and choose Sales Receipt.
7. Press OK. 

Then, click the Excel drop-down icon and choose Create New Worksheet to export the report to Excel.  If you need a report that shows all of the payments you received and deposits you made within the selected time period, with a subtotal for each customer, and a grand total at the bottom of the report, run the Cash Receipts Journal report. Here's an article you can refer to for more details on how to customize reports in QuickBooks Desktop. 

Feel free to seek self-help articles on our Help Articles page to help you get your QuickBooks task done in no time. 

Drop a comment below if you have follow-up questions or concerns about running financial reports in QuickBooks. I'm more than happy to assist you. Take care and have a wonderful day ahead.

Hello, RCV,

I was sending request for help to the Mac desktop community.  In your response you were speaking about Windows.  I do not have Windows.  The instructions you gave don't include the choices that I have available in QB desktop for Mac.

See attached files for screenshots of my dilemma.  I have found no where that a report will display check numbers.  There is no column choice in options to have the check numbers show up. Thank you.

Good morning, @Susan607. 

Thanks for reaching back out and letting us know. Allow me to point you in the right direction to get this resolved. 

Since none of the steps that my colleague provided have worked for you, I recommend contacting our Customer Support Team. They'll be able to take a closer look and give you some additional details. 

QuickBooks Desktop Mac

Please let me know how it goes. I want to ensure that you're taken care of today. Have a wonderful day!