Read this full article if you want to learn 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. The article consists of the procedure with examples that are the best way to understand things. Still, having an issue related to it contact our QuickBooks Proadvisor through toll-free no: +1-844-405-0904
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 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-844-405-0904 for more information.