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.
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.
Need QuickBooks guidance?
Log in to access expert advice and community support instantly.