Good day, michealmorr.
Let me show you how to export customer balances.
The best report that I can suggest is the Customer Balance Detail. This shows how much each customer owes you and the individual invoices. You can follow these steps:
- Go to the Reports tab. Search and select Customer Balance Detail.
- Set the correct Report period and the Aging method. Click Run report.
- Click the Export button and choose either Export to Excel or Export to PDF.
From the Reports tab, you can also use and export the Customer Contact List. This is the best report that shows customer details.
If you need a detailed guide, here's how to customize and memorize reports in QuickBooks Online.
Keep on posting here if you need anything else. We'll respond as soon as we can.