How to Print Reconciliation Summary in QuickBooks (2026 Guide)

Latest Date: February 27, 2026

Once you are done with finishing reconciling, QuickBooks generates an automatic reconciliation report for that particular session or the amount period. Know how to print reconciliation summaries in QuickBooks.

Save Time, Reduce Errors, and Improve Accuracy

Dancing Numbers helps small businesses, entrepreneurs, and CPAs to do smart transferring of data to and from QuickBooks Desktop. Utilize import, export, and delete services of Dancing Numbers software.

*No credit card required

There is absolutely no doubt in confirming that reconciliation reports are extremely useful and stand out as a great help when you face difficulties in reconciling for the upcoming month or you sit with your accountant for a sweating brainstorm.

This article will help you to understand about reconciliation summary and how to print it.

What is a Reconciliation Summary Report?

A typical reconciliation report is static and sums up the two most important data which are the opening and the ending balances. At its very core purpose, A reconciliation report helps you to view the complete List of Transactions that were cleared and the ones that are still pending to be cleared and need to be added at the time of reconciling.

There are a few things that you must keep in mind about reconciliation reports:

  • If there has been a modification to the information inside your company, that particular change will not be reflected in this particular report. However, It shall be affecting other components present within QuickBooks.
  • The balance that you find on this report is the balance that represents all the reconciled transactions whereas other reports generally show you the respective account balance that is fetched from posted transactions.
  • Reconciled Transactions are the ones that carry the status ‘R’ and are seen to be listed within the credit card register or bank.

Method 1: Printing in QuickBooks Online (History & Reports)

QuickBooks Online (QBO) stores your reports in a specific “History” vault rather than the standard reports list.

  1. Navigate to Transactions > Bank Transactions (or Bookkeeping).
  2. Select the Reconcile tab.
  3. Click on History by account in the upper right corner.
  4. Select the Account and Report Period you need to view.
  5. Find the specific reconciliation in the list and click View report under the Action column.
  6. Click the Print icon (or press Ctrl + P) to generate the PDF or physical copy.

The QBO ‘Static Report’ Alert: Why PDF Backups are Mandatory

Critical 2026 Update: QBO reconciliation reports are “Static.” This means they capture the state of your books at the exact moment you hit “Finish Now.” If you later delete or change a transaction from that period, the Report will not change, but your Opening Balance for next month will be off.

Pro Tip: Always save a PDF copy to a secure cloud drive (like Google Drive or OneDrive). This is your only proof of what the books looked like before an accidental change occurred.

Method 2: Printing in QuickBooks Desktop (Pro, Premier, Enterprise)

QuickBooks Desktop offers more granular control, allowing you to choose between “Summary,” “Detail,” or “Both.”

  1. Go to the Reports menu and select Banking.
  2. Choose Previous Reconciliation.
  3. Select the Account you just reconciled.
  4. Under “Type of Report,” choose Summary, Detail, or Both (Highly recommended for audits).
  5. Click Display or Print.

Locating Prior Reconciliations (The 120-Report Limit)

Be aware that QuickBooks Desktop Pro has a storage limit for reconciliation history. While Enterprise and Premier can store up to 120 previous reports, older versions may only show the most recent one.

Missing a report? If your report isn’t in the “Previous Reconciliation” list, you may need to look into your PDF/Print Archive folder if you have automated backups enabled in your 2026 settings.

Troubleshooting: What to do if the Print Button is Missing or Grayed Out

If the print button isn’t responding in 2026, it’s usually a communication error between QuickBooks and the Microsoft XPS Document Writer.

  • Check Windows 11 Features: Ensure “Optional Features” has “XPS Viewer” and “XPS Document Writer” enabled.
  • The QuickBooks Tool Hub: Open the Tool Hub, go to Program Problems, and select QuickBooks PDF & Print Repair Tool. This resets the internal print “spooler” that often hangs during large report generation.
  • Grayed Out? Ensure you have finished the reconciliation process. You cannot print a summary for a “work in progress” reconciliation.

Advanced: Exporting Reconciliation Summaries to Excel

Directly exporting a reconciliation report to Excel from QBO is not supported by a single button. Follow this 2026 “Clean-Copy” workaround:

  1. Open the View Report screen in QBO.
  2. Press Ctrl + A to select all text on the report page.
  3. Open a blank Excel workbook.
  4. Right-click and select Paste Special > Match Destination Formatting.
  5. Using Tools: For a faster, formatted export of thousands of transactions, use Dancing Numbers to pull the reconciled data directly from your company file into a structured Excel sheet.

FAQ: Common Reconciliation Report Questions

  • Can I print a report for a reconciliation I “Undid”?
    No. Once you “Undo” a reconciliation, the associated report is deleted from the history.
  • What is the difference between a Summary and a Detail report?
    The Summary shows totals (Cleared, Uncleared, Register Balance). The Detail lists every individual check and deposit.
  • How do I print a report for a specific date range?
    Reconciliation reports are tied to the “Statement End Date,” not a custom range. To see a range, you must use a Custom Transaction Detail Report filtered by “Cleared” status.

Thus, Printing your reconciliation reports is no big deal on QuickBooks. Go ahead, and take charge of all the transactions you need to.

Accounting Professionals, CPA, Enterprises, Owners
Accounting Professionals

Looking for a professional expert to get the right assistance for your problems? Here, we have a team of professional and experienced team members to fix your technical, functional, data transfer, installation, update, upgrade, or data migrations errors. We are here at Dancing Numbers available to assist you with all your queries. To fix these queries you can get in touch with us via a toll-free number
+1-800-596-0806 or chat with experts.


Frequently Asked Questions

Can I Export a Reconciliation Report to Excel directly?

No. The Reconciliation report in QuickBooks cannot be exported to Excel directly, and thus you need to execute the same manually.

To do this, make sure you align with the points below:

checked Start with highlighting the specified information on the report.
checked Make a right-click on the highlighted information and copy the same.
checked After opening the Excel, Past the information by making a right-click.
checked According to your preference, Adjust column widths for a better information view.
checked Choose Save.

How can I View a Reconciliation Report in QuickBooks?

To view the reconciliation report in QuickBooks, you need to follow the steps laid down below:

checked Visit Reports.
checked Locate the Reconciliation Report.
checked Choose Reconciliation Report.
checked Choose the account for which you wish to see the Reconciliation Report.
checked Select the respective reconcile period which is to be found under the report period drop-down.
checked Hit View Report.

What Kinds of Transactions Can I View on the Reconciliation Reports?

There are two kinds of transactions that I can view on the reconciliation reports:

Cleared Transactions: These transactions are the ones that are cleared at the time of reconciliation and show you a snapshot of them.

Modified Transactions: These types of transactions are the ones that have changed, yet, will still appear at the time of reconciliation and show where they are currently placed in your accounts.

close btn

Get Your Case Study

Call Now +1-800-596-0806
Top