Showing results for 
Search instead for 
Did you mean: 
Everything you need to know about banking in QuickBooks Online - Discover more
Level 2

Reconciliation reports

As QBO doesn't produce meaningful reconciliation reports (most of the 'Payee' column is not populated i.e. from Transfers and Journals), please give us the option of downloading the reports into Excel so we can manually add a column and write some description. 

At the moment, only PDF is offered, hence not helpful at all.

These reports are useless the way there are now, as cannot be used for any checking. 

Thanks, Lucia 

QuickBooks Team
QuickBooks Team

Reconciliation reports

We always strive to give you the best experience possible when exporting your reports to Excel, l-brusati.


Currently, the Reconciliation report in QuickBooks Online is one of the few reports that can't be directly exported to Excel. We view consumer feedback as an opportunity to enhance our products' many features. I'd suggest submitting feedback directly to our engineers. They may look into this suggestion and consider adding this option in future updates. Here's how:


  1. Go to the Gear icon.
  2. Hit Feedback.
  3. Type in your recommendation in the Share your feedback field.
  4. Click Next.
  5. Follow the on-screen instructions to complete the process.


I've attached screenshots below for your reference:




On top of that, you can visit his page to keep updated with the latest software improvements and enhancements with QBO: Customer Feedback for QuickBooks Online. Alternatively, by doing the procedures below, we can manually export the reconciliation data to Excel:


  1. Highlight the information on the report.
  2. Right-click and copy the information.
  3. Open Excel and right-click and paste the information.
  4. Adjust the column widths for the format of the Excel report to show all the information.
  5. Press Save.


Here's an article you can refer to for more details about viewing, printing, or exporting a reconciliation report. Feel free to visit our Reports page for more insights about setting up reports to customise, run, and share.


Keep me posted by leaving a comment below if you need anything else with reconciling your bank accounts. I'm always here to help. Take care always.

Need to get in touch?

Contact us