How to View, Print, or Export a Reconciliation Report in QuickBooks Online




When you finish bank reconciliation in QuickBooks Online, it automatically generates a reconciliation report for you. You can use this reconciliation report for various uses like when you are facing any issue while reconciling next month’s transaction and more such occasions. So, read this full article if you want to learn how to view, print, or export a reconciliation report in QuickBooks Online.

A reconciliation report consists of the following information.

  • Beginning and ending balances when you were reconciling the transactions. This can be proven helpful if you have trouble reconciling the next month.
  • It also consists of a list of both cleared and uncleared transactions when you reconciled in the past.

Note: If you have reconciled the same account twice in a month then QuickBooks Online will automatically create two separate reconciliation reports.

How to view a reconciliation report

  • From the left side navigational panel, click on the Reports menu.
  • In the Find Report by Name field, you need to enter Reconciliation Report.
  • Then, select the Reconciliation Report option.
  • After that, you need to choose an Account for the reconciliation report you want to view.
  • Next, click on the Report Period drop-down menu and select the reconcile period you want to view.
  • Finally, click on the View Report option.

How to Print a reconciliation report

Here we are going to show you how to print a recent as well as prior month reconciliation report in QuickBooks Online.

For example, if you have just completed the January month bank reconciliation but for some reason, you want to print the last year’s December reconciliation report.

  • From the left side navigational panel, select the Reports option.
  • In the Find Report by Name field, you need to enter Reconciliation Report.
  • Then, select the Reconciliation Report option.
  • After that, you need to choose an Account for the reconciliation report you want to view.
  • Next, click on the Report Period drop-down menu and select the reconcile period you want to view.
  • Then, click on the View Report under the action column.
  • Here, choose the Statement Ending Date, it is important to choose the current ending date otherwise the statement that you are going to print will be of a different month.
  • Once you find the correct reconciliation report, from the upper right corner of the screen click on the Print icon.

How to export a reconciliation report to Excel

You can’t just directly export the reconciliation report to Excel from the QuickBooks Online. This is one of the few reports in QuickBooks that can’t be exported. Follow the instructions mentioned below to manually export the report.

  • First, you need to highlight the data that you want to transfer.
  • After that, right-click on the information and select the Copy option.
  • Then, open the Microsoft Excel or any other excel program and copy the information.
  • You may need to adjust the lengths and widths of the column on the Excel report so that all the information is visible.
  • Once all things are in the perfect place, click on the Save button.

Important Things to Know About Reconciliation Report

  • This is a type of Static Report i.e. If you have made changes in the company’s information then those changes will be not visible in the reconciliation report. But the changes you made will affect all others in the QuickBooks Online software.
  • The balance that you see in this report is the balance of all reconciled transactions on the other hand balances that shows in other reports are based on the recorded transactions. (NOTE: In QuickBooks Online, all the transactions are reported as soon as you post them into the software.)
  • In the Bank or Credit Card Register, all the transactions that have an R status are classified as the reconciled transactions.

The Bottom Line

Here, in this article, we have discussed how to view, print, or export a reconciliation report in QuickBooks Online. In addition to this, we have also described how you can print a prior month bank reconciliation report so that you can fix the preceding month reconciliation with ease. We hope that you found this article useful and valuable as well.

You don’t have to worry if you still have issues with the bank reconciliation in QuickBooks or any other related errors. You can have assistance from our team of Intuit Certified QuickBooks ProAdvisor. These professionals can fix any of your problems instantly. Call us at our 24/7 toll-free QuickBooks support number +1-855-441-4417 for more information.

Connect With QuickBooks ProAdvisor Experts


Author: Editor Team
Wizxpert Authors & Editor team is blessed with the most qualified and experienced experts that support you with one of the best solutions for your queries related to Accounting and Bookkeeping. We are here from last 3 years in the assistance of our customers. Our main goal is to happy and satisfied viewers with our service. We are a team of 10+ members. Every member research on the unique issue and try to fetch out the relevant solutions of that particular problem. Our team always tries to get the update with every new release of Accounting and Bookkeeping solution, and also try our level best to convey that information in the very moderate form to our viewers.



Content is protected !!
callnow

Live QB Support:

+1-855-441-4417
Call Now