I'm glad you made it here, aaron39.
You'll have to run two reports to achieve this. To see the list of transactions that have been paid, you can run the Invoices and Received Payments report. This shows all the payments you’ve received and the invoices that go with them.
Here's how:
- Go to Reports.
- Enter Invoices and Received Payments in the search field.
- Customize the necessary filters.
- Click Run report.
Here's an article made handy about modifying columns on the report: Customise and modify columns on reports.
For the unreconciled transactions, you can customize an Account QuickReport. This helps you filter the status. Here's how to accomplish this:
- Go to Account and choose Chart of Accounts.
- Locate the bank and click on the Account history drop down.
- Choose Run report.
- Click on Customise.
- Set the date under Report period.
- Go to Filter.
- Mark to select Cleared box and choose Uncleared.
- Select Run report.
Then, you can export the report into a worksheet to get the sorting you need. I'll show you how to do it:
- Open the report.
- Click the Export icon.
- Select Export to Excel.
To give you more information about exporting reports in QuickBooks Online (QBO), here's an article that you can refer to: Export your reports to Excel from QuickBooks Online.
I'm also adding this resource to help you with the future task and tips when using QBO: Help Articles.
Let me know if you have any follow-ups or other questions. I'm always here to help. Wishing you a good one.