I understand that you need assistance in running reports for account transaction statements that include unpaid invoices, @nhopper.
To achieve this, I recommend running two separate reports and then exporting them to an Excel file. After that, you can combine the two transactions to get the desired result. To ensure that the unpaid invoices show up on the reports, you just need to follow the steps below:
- Go to the Report tab, and find the Invoice and Received payment in the Search bar.
- Sort the dates and other details.
- Press the Customize button in the upper left to change the column.
- Then, navigate to the Rows/Columns dropdown and put a checkmark on the Customer checkbox and A/R Paid to show the unpaid invoices.
- Hit Run Report once done.
For future reference, here's an article on how to reconcile in QuickBooks Online: How to reconcile your accounts.
I would love to hear from you! Feel free to leave a comment below if you have any questions about running your reports. Have a fantastic day!
