Hi there, Ben621.
I'm here to share some insights about how QuickBooks populates the data on your reports.
The Filters option allows us to limit report data to selected criteria. This is particularly important if we need to personalize the report for your needs. QuickBooks looks at individual transaction lines when building a report. If a line matches the report set, then the line is added to the report.
Once we use the Class filter, the program will show the transactions (invoices) with assigned classes. Please know that we're unable to show the payments tied to those invoices since the payments don't have classes. We'll have to open each invoice by double-clicking it to view the payments (under the Recent Transaction section).
We can also export the report to an Excel file and manually sort it from there. I'll show you how:
- Select Reports from the top menu bar.
- Choose Customers & Receivables, then select Customer Balance Detail.
- Set the appropriate reporting period.
- Click the Excel button, then choose Create New Worksheet.
- Select Export, then manually customize it outside the program.
To learn more about how reports work in QuickBooks Desktop, you can read this guide.
In case you'll need to personalize and design your reports, you can utilize the Customize feature. Then, memorize them to save its current customization settings.
Do you have any other questions in mind? Feel free to leave them below and I'll get back to you as soon as I can. Stay safe and have a great rest of the weekend.
