I have another way how you can show a report to a single-line item per customer,
For now, being able to show information in a single line is unavailable in QuickBooks. As a workaround, you can export a report to an Excel file so you can edit the information from there so it shows on a single line item only. To do so, follow the steps outlined below:
- Go to Reports, then Reports Center.
- Find and double-click the report you want to export.
- Select the Excel ▼dropdown, then Create New Worksheet or Update Existing Worksheet.
- If you see a message that says your report has too many columns, select Advanced, then uncheck the Space between columns checkbox. Select OK.
- When you’re ready to export, select OK.
To give you more details on exporting a report, go through this article for complete steps: Export Report As Excel WorkBooks In QuickBooks Desktop.
I've also added this article to make sure you're able to customize information and be able to get what your company needs most, I've got this for your reference: Customize Reports In QuickBooks Desktop.
Please touch base with us here if you have any other concerns about the average days to pay report or any reports in QuickBooks. We're here to help you and get you covered.
