Let's get your reconciliation report exported to Excel, @timberfocus.
In QuickBooks Online (QBO), you're unable to export the reconciliation report directly to an Excel file. As an alternative, you'll have to copy the information on the report and manually paste it into Excel. Here's how:
- Click Reports from the left menu.
- Search for the Reconciliation report.
- Choose the appropriate bank account and select the statement ending date.
- Highlight the information on the report, then right-click and choose Copy.
- Open an Excel file and paste the information manually.
- Adjust the column widths for the format of the Excel report to show all the information.
- Click Save once finished.
I'm adding this article for more guidance: How do I view, print, or export a reconciliation report?
You might experience balance issues when reconciling accounts in the future. This article will guide you on how to fix it: Fixing a reconciliation.
It’s nice working with you. Feel free to leave a comment below if you need further assistance running the reconciliation report in QBO. I'll be sure to get back to you.