cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
jvandendool7
Level 1

My bank rec wont print what to do

 
1 Comment 1
JamesM
QuickBooks Team

My bank rec wont print what to do

Hi there, 

 

Being able to print your reconciliation allows you to have the flexibility to view it offline. I'll be happy to assist you with showing your how to view the report and print it. 

 

Each time you finish reconciling, QuickBooks Online automatically generates a reconciliation report for that session. The reconciliation report is useful if you have trouble reconciling the following month and when you meet with your accountant.

 

The reconciliation report summarizes the following:

  • Beginning and ending balances.
  • Lists which transactions were cleared and which were left uncleared when you reconciled.

Note: QuickBooks Online automatically generates a new reconciliation report even if you reconcile the account for the same month.

 

How to view a reconciliation report

  1. Go to Reports.
  2. Type Reconciliation Report in the Find report by name search bar.
  3. Select Reconciliation Reports.
  4. Select the Account for the reconciliation report you want to view.
  5. From the Report perioddrop-down arrow, choose the reconcile period.
  6. Select View Report.

How to print a reconciliation report

 

To print, select the Print icon in the upper right of the report.

 

How to export a reconciliation report to Excel

 

The Reconciliation report in QuickBooks Online is one of the few reports that can't be directly exported to Excel. To manually export this data, do the following:

  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. Select Save.

Things to know about reconciliation reports

  • This is a static report. If information within your company has changed, that change will not reflect on this report, but will affect all others within QuickBooks Online.
  • The balance on this report is the balance of all the reconciled transactions, while all other reports show account balance based on posted transactions (Note: Transactions are reported as posted the moment you save them within QuickBooks Online).
  • Reconciled transactions are those with the status R listed within the bank or credit card register.

You now know how to view, print, and export reconciliation reports. In case you have other questions, feel free to contact our support team using this link here.

Need to get in touch?

Contact us