At the end of every month, the routine is the same for many business owners and accountants. You open your bank statement, log in to QuickBooks Online, and carefully match each transaction until everything is balanced. When the numbers finally align, it feels like closing a chapter; your books are accurate, your records are clean, and you move on to the next task. But a few weeks later, a familiar situation arises.
Your accountant asks for the reconciliation details for last month. Or an internal review requires proof that your accounts were properly reconciled. Maybe you simply want to double-check a discrepancy in a previous statement. Suddenly, you’re not just looking for confirmation that reconciliation happened, you need the actual report that documents it. That’s when many users start searching for ways to print a reconciliation report in QuickBooks Online.
The reconciliation report is more than just a summary. It captures the entire story of that reconciliation period; the beginning balance, the ending balance, and every cleared transaction in between. It serves as a record that proves your books matched your bank statement at a specific point in time. For accountants, auditors, and business owners, this report often becomes an important piece of financial documentation.
Fortunately, QuickBooks Online keeps these reports easily accessible. Whether you want to review them on screen, export them for digital records, or simply print a reconciliation report in QuickBooks Online for documentation, the process is straightforward once you know where to look.
In this blog, we’ll walk through how to view, export, and print reconciliation reports in QuickBooks Online, so you can quickly access the records you need whenever questions about past reconciliations come up. So, let’s begin with it.
Things to Know About Reconciliation Reports in QuickBooks Online
Reconciliation reports provide a snapshot of your account at the time the reconciliation was completed. When you find, view, and print a reconciliation report in QuickBooks Online, it’s important to understand how the data in the report works and how it may differ from other financial reports. The following points highlight a few key things to keep in mind when reviewing reconciliation reports.
1. Reconciliation Reports Are Static
A reconciliation report captures account details exactly as they were when the reconciliation was completed. If changes are later made to transactions in your company’s file, those updates will not appear in the previously generated reconciliation report. However, those changes may affect other reports within QuickBooks Online.
2. Balance Reflects Only Reconciled Transactions
The balance shown in a reconciliation report is calculated based only on transactions that were reconciled during that session. This differs from many other reports, which display account balances based on all posted transactions. When you find, view, and print a reconciliation report in QuickBooks Online, the balance you see represents only the reconciled entries for that period.
3. Posted Transactions Affect Other Reports
Transactions are considered posted as soon as they are saved in QuickBooks Online. Once posted, they are reflected in most financial reports immediately. However, reconciliation reports remain unchanged because they capture a fixed record of the reconciliation at that specific time.
4. Reconciled Transactions Are Marked with “R”
Within the bank or credit card register, transactions that have been reconciled are identified with the status “R.” This label indicates that the transaction was included in a completed reconciliation and is reflected in the corresponding reconciliation report.
Steps to Find, View, and Print a Reconciliation Report in QuickBooks Online
Reconciling your accounts helps ensure your financial records are accurate, but sometimes you may need to revisit those reconciliations later. Knowing how to view and print a reconciliation report in QuickBooks Online allows you to quickly access reconciliation details, review cleared transactions, and keep a documented record when needed.
The reconciliation report provides a summary of the following details:
- Beginning and Ending Balances: Displays the starting balance at the beginning of the reconciliation period and the final balance after reconciliation is completed.
- Cleared and Uncleared Transactions: Shows which transactions were marked as cleared during the reconciliation process and which ones remained uncleared.
Note: Each time you complete a reconciliation, QuickBooks Online automatically generates a reconciliation report for that session. This report can be especially helpful if you encounter issues during the next reconciliation period or need to review the details with your accountant.
The steps below will guide you through the process of locating, viewing, and printing a reconciliation report for your accounts.
A. How to Find and View a Reconciliation Report in QuickBooks Online?
- Open QuickBooks Online and navigate to Reports.
- From the left-hand menu, click the Reports icon and go to the Standard Reports section.
- In the Find report by name search bar, type Reconciliation Report.
- Choose Reconciliation Reports from the search results to proceed.
- Next, select the specific account for which you want to view the reconciliation report.
- Use the Report period drop-down menu to pick the reconciliation period you want to review.
- Finally, click View Report to display the reconciliation details for the selected account and period.
B. How to Print a Reconciliation Report in QuickBooks Online?
Once you complete the steps above, printing a reconciliation report in QuickBooks Online becomes quick and straightforward, allowing you to easily keep a record of your reconciled transactions.
Once the report opens, click on the Print icon located in the upper-right corner to print the reconciliation report.
C. How to Export a Reconciliation Report to Excel in QuickBooks Online?
Exporting reports to Excel is a common way to analyze, store, or share financial data. However, in QuickBooks Online, the Reconciliation Report cannot be exported directly to Excel like many other reports. If you need the data in a spreadsheet format, you can manually copy the report and paste it into Excel.
Follow these steps to export the reconciliation report data:
- Open the reconciliation report.
- Select the information displayed in the report using your cursor.
- Right-click on the highlighted data and choose Copy.
- Open Microsoft Excel, right-click on a blank worksheet, and select Paste to insert the copied information.
- Resize the column widths and adjust formatting as needed so that all report details are clearly visible.
- Once the formatting is complete, save the file to keep the reconciliation report in spreadsheet format.
This method allows you to work with reconciliation of report data in Excel even though the report itself does not include a built-in export option.
Why Printing a Reconciliation Report in QuickBooks Online Can Be Important?
Reconciliation helps ensure that your books match your bank’s statements, but the process doesn’t end once the accounts balance. In many situations, businesses need a documented record of that reconciliation. That’s why the ability to view and print a reconciliation report in QuickBooks Online becomes important for maintaining clear and reliable financial records.
1. Share Reports with Accountants or Auditors
Accountants and auditors often request reconciliation reports to verify that accounts have been properly balanced. Instead of explaining each step of the reconciliation process, you can simply access the report and provide a detailed record of the cleared transactions, beginning balance, and ending balance for the reconciliation period.
2. Maintain Organized Financial Documentation
Businesses frequently keep reconciliation reports as part of their monthly or quarterly financial documentation. These reports create a clear record that shows when the reconciliation was completed and how the balances were verified, making it easier to maintain well-organized accounting records over time.
3. Review Past Reconciliations When Issues Arise
Financial discrepancies can sometimes appear weeks or months after reconciliation. In such cases, revisiting an earlier reconciliation report helps you review cleared transactions and identify whether any adjustments were made during the process.
Also Read: How to Undo a Reconciliation in QuickBooks Online?
4. Keep Printed Records for Compliance
Some businesses prefer maintaining physical records for internal audits or regulatory compliance. Keeping printed reconciliation reports ensures there is a documented trail that supports financial transparency and accountability.
5. Track Account Activity Over Time
Reconciliation reports can also help businesses understand how account activity changes over different periods. By reviewing reports from previous months, you can analyze transaction patterns, confirm balance consistency, and ensure that financial records remain accurate as your business grows.
In short, reconciliation reports serve as more than just confirmation that your accounts match. They provide a reliable record that supports financial reviews, documentation, and long-term tracking of account activity. This is why knowing how to view and print a reconciliation report in QuickBooks Online can be essential for maintaining accurate and well-documented financial records.
Conclusion
Reconciling your accounts is a key part of maintaining accurate financial records, but being able to access and document those reconciliations is just as important. When you find, view, and print a reconciliation report in QuickBooks Online, you create a reliable record that confirms your bank or credit card accounts are properly balanced for a specific period. These reports provide valuable insights, including beginning and ending balances, as well as details about which transactions were cleared during reconciliation.
Understanding how these reports work also helps you interpret them correctly, especially when comparing them with other financial reports within QuickBooks Online. By regularly reviewing and maintaining reconciliation reports, businesses can strengthen their financial recordkeeping and ensure greater transparency in their accounting processes.
Ultimately, knowing how to find, view, and print a reconciliation report in QuickBooks Online makes it easier to keep your financial records organized, accurate, and ready whenever you need them.
Frequently Asked Questions
If you want to keep a record of your reconciled accounts, it’s helpful to know how to print a reconciliation summary in QuickBooks. The software allows you to print reports for both the current reconciliation and previously completed ones.
A. Print the Current Reconciliation Report
1. Go to Transactions and select Bank.
2. Click Reconcile Bank Statement.
3. After completing the reconciliation, select Save & Print.
4. The Reconciliation Detail report will open, which you can print for your records.
B. Print a Previous Reconciliation Report
1. Navigate to Transactions > Bank > Reconcile Bank Statement.
2. Select History on the reconciliation page.
3. The Reconciliation History report will appear.
4. Choose the required statement and print the report as needed.
Following these steps makes it easy to print a reconciliation summary in QuickBooks whenever you need documentation of completed reconciliations.
Yes, QuickBooks creates a reconciliation report once you complete the reconciliation process. This report shows the starting and ending balances and includes a list of transactions that were cleared as well as those that remained uncleared during the reconciliation.
In QuickBooks Online, the reconciliation report cannot be exported directly to Excel. If you need the data in Excel, you must export it manually by selecting the information on the report, right-clicking, and copying it before pasting it into an Excel sheet.
If you’re unable to see previous reconciliation reports and the report options appear grayed out, it could be due to issues with the PDF converter used when the reconciliation was completed. This may prevent the reports from displaying properly. Possible causes include:
1. The QuickBooks PDF converter used during the reconciliation may be corrupted or damaged.
2. Because of this issue, the system may not be able to generate or display the reconciliation reports.
3. As a result, the report options and report types may appear grayed out or unavailable.
4. Resolving or repairing the PDF converter can often restore access to the previous reconciliation reports.
In QuickBooks, the letters shown in the register indicate the reconciliation status of a transaction.
1. C (Cleared): The transaction has cleared the bank but has not yet been fully reconciled in QuickBooks. It appears with a “C” in the register.
2. R (Reconciled): The transaction has been matched and verified during the reconciliation process. Once confirmed, it is marked with an “R” in the register.
To unreconcile all transactions for a specific month in QuickBooks Online, follow these steps:
1. Open the Reconciliation Report for the month you want to undo.
2. Navigate to the Actions drop-down menu located in the top-right corner of the report.
3. Select “Unreconcile All Transactions from This Report.”
This will remove the reconciliation status from all transactions included in that report.
