QuickBooks Previous Reconciliation Report ( Run, View, Print & Use Old QB Reconcile)

To ensure that all business transactions are accurate, it is essential for organizations to frequently compare their accounting. Reconciliation reports […]

Voiced by Amazon Polly

To ensure that all business transactions are accurate, it is essential for organizations to frequently compare their accounting. Reconciliation reports aid businesses in understanding and efficiently tracking their expenses. With only a few clicks, QuickBooks enables businesses to easily produce precise QuickBooks Reconciliation Reports.

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

This post will educate you about QuickBooks Reconciliation Reports. Additionally, you will obtain a thorough understanding of QuickBooks, including its salient features, benefits, QuickBooks Reconciliation Reports, and the procedures needed to view and export QuickBooks Reconciliation Reports. To learn more about QuickBooks Reconciliation Reports, continue reading.

How To Run A Previous Reconciliation Report In QuickBooks?

  • Head over to the Reports menu. Choose Previous Reconciliation by hovering over Banking.
  • Choose the reconciled account from the Account drop-down list.
  • The reconciliation period you want to review should be chosen in the Statement Ending Date box.
  • In case of report type, you can choose Detailed or Both. If you’re utilizing the report to make reconciliation corrections, we suggest Detailed.
  • Which transactions should appear on the report, select it from two option:
  • Cleared transactions at the time of reconciliation: This provides you with a snapshot. It only displays activities that occurred in the account at the time of reconciliation.
  • Transactions that have cleared plus any modifications: This displays account activity at the time of reconciliation. Additionally, it displays where they are right now in your accounts.
  • Select Display to run the report when you’re ready.

How To Use The Old Reconcile Reports To Customize Reports In QuickBooks Desktop?

Using preconfigured customer, job, and sales reports in QuickBooks Desktop, you can effortlessly keep track of your sales and expenses.

Reports can also be altered to highlight the data that is most important to your company. Most reports in QuickBooks Desktop can be modified.

Select Reports Centre from the menu under Reports.

  • On the List, Locate and Open a Report.
  • Choosing Customize Report.
  • To customize your report, make use of the filters and other options. As soon as you’ve found the parameters you prefer, choose Memorize to save the report so you may use it again later.

How to View QuickBooks Previous Reconciliation Report

How To View The Last Month’s Bank Reconciliation Reports In QuickBooks Pro?

Only the most recent reconciliation report created is accessible in QuickBooks. You have a number of alternatives for keeping a copy of other reports in your file or on your hard drive:

  • For future use, you might want to commit the reports to memory. To prevent your reports from being overwritten each month, give the reconciliation report for each month a distinct name.

Note: Please take note that the data used to construct these reports comes from the file at the moment the request is made. They are not records of the earlier action. The reports will reflect any modifications made to reconciled transactions, so they might not match the printed reports you retain on file.

  • You can transmit the report to Excel if you are using a version of QuickBooks Pro or higher. With the help of this function, you can keep a different worksheet for each month in a single workbook.
  • The list of past reconciliations is accessible when you open the QuickBooks Pro file in QuickBooks Premier or a later version.

How To View Previous Reconciled Reports In QuickBooks Premier Or Advanced

You can view the 120 most recent reconciliation reports.

  • Banking >Previous Reconciliation can be found under the QuickBooks Reports menu.
  • Choose the relevant choices from the Select Previous Reconciliation Report window.
  • Select the transaction categories you want to include in your report:
    • At the time of reconciliation, transactions had cleared.
      • You may see what was reconciled in this report, which is a snapshot of your last reconciliation.
      • The report will automatically load in PDF document formate.
      • The Print icon can be found at the top of the PDF window, or you can right-click the report and choose Print from the menu that appears.
    • Transactions that have been cleared along with any modifications.
      • This report displays the current status of each transaction that was cleared during the last time you reconciled this account.
      • Transactions that have been removed or moved to another account won’t be shown anymore.
      • This report will launch in the QuickBooks report format. Following that, you can print, edit, or export the data in this report for use in other applications like Microsoft Excel.
  • Select Display.

How do I Edit Previous Reconciliations Report in QuickBooks?

Any change other than the amount and account on a given transaction will not affect its reconciliation status. Changing the category of a reconciled transaction is as simple as editing it directly. Here’s how:

  • Chart of Accounts can be chosen by clicking Accounting in the left menu.
  • Choose the desired bank account from the list, then select View register.
View Register
  • Click Edit after finding and selecting the transaction you want to change.
Finding and Selecting the Transaction
  • Make a change to the category or description, then Click Save.
  • To accept the changes, click Yes.
  • To edit the remaining transactions, repeat these procedures.

Printing Prior Bank Reconciliation Reports in QuickBooks Desktop

We will first obtain a report preview before ordering the reconciliation report to be produced. It’s as easy as it sounds to do this. Print your report by following the instructions.

  • Select the settings tab from your QuickBooks company file in the top right corner of your screen.
  • Go to the drop-down menu and select “Reconcile”
  • The list of all the accounts will now appear in a new window.
  • The account you want to work with is up for selection.
  • The list of all reconciled entries can be found by selecting the reconcile reports tab.
  • Your file will be printed if you choose the print option at the bottom of the screen after scrolling there.

Resolve Common Issues on the QuickBooks Previous Reconciliation Report

Here is a summary of the typical problems you could run into when running the Previous Reconciliation report, along with suggested fixes to get you back to work right away.

Important: Back up the QuickBooks company file before you proceed with the recommended solution for each of the issues.

Reports are not Available

Scenario: The report options and types are greyed out in the scenario where you are unable to read earlier reconciliation reports. This can be the result of a broken or faulty QuickBooks PDF converter from when the previous reconciliation was performed.

Solution 1: Keep your QuickBooks Version up-to-date.

Solution 2: View prior reconciliation reports without having them appear as PDF files.

  • Choose Banking from the Reports menu, then choose Previous Reconciliation.
  • Choose the option button next to the section “In this report, include” and then click on “Transactions cleared plus any changes to those transactions since the reconciliation.

Solution 3: Third-party PDF Converter Repair. Cisit learn more, go visit QuickBooks Desktop: Troubleshoot PDF and Print Issues.

Blank Reports

Scenario: Although you can generate Previous Reconciliation PDF reports, some of the columns are blank or missing.

Solution 1: Edit Adobe Acrobat Reader’s Internet Preferences as a first step.

  • Get Adobe Reader open.
  • Activate the Edit menu.
  • From the Preference list, Pick Internet under the Preference option.
  • Display PDF in Browser is the first check box; uncheck it, or check it if it’s already checked.
  • Reconciliation report from the past, open.

Solution 2: The second option is to update, Fix, or Reinstall Adobe Acrobat Reader.

Solution 3: the prior reconciliation report again. The particular earlier reconciliation report that was chosen might be harmed. Try launching reports for the same account from earlier in time. Indicating that the desired report needs to be recreated if one of the other reports opens.

  • Until the broken reconciliation, undo all previous reconciliations.
    • Reconcile can be chosen from the Banking menu.
    • Select the appropriate account, then click Undo Last Reconciliation in the Begin Reconciliation window.
    • Before reversing a prior reconciliation, a warning is provided to backup the company file. Select Continue if a backup has already been made.
    • When it says “Undo Previous Reconciliation has completed,” click OK. Keep in mind that the date that was last reconciled has changed to the prior day.
  • Reconcile again.

Clear Transaction is Appearing Unclear

Scenario: Uncleared transactions are shown for reconciled/cleared transactions. In the Begin Reconciliation window’s Statement Date field, if a future date is entered, this happens.

  • Solution 1: First, undo the prior reconciliation, then re-reconcile the transactions with the right date.
    • Reconcile can be chosen from the Banking menu.
    • Select the appropriate account, then click Undo Last Reconciliation in the Begin Reconciliation window.
    • Before reversing a prior reconciliation, a warning is provided to back up the company file. Select Continue if a backup has already been made.
    • When it says “Undo Previous Reconciliation has completed,” click OK. Keep in mind that the date that was last reconciled has changed to the prior day.
    • Once more reconcile the transactions.
  • Solution 2: Just leave the reconciliation alone. When the statement date arrives, the transactions will show up as cleared on the report.

Incorrect Beginning and Ending Balances of Report

The beginning and ending balances are wrong when you generate the report. This is brought either by a later reconciliation entered in QuickBooks Desktop before the current one, or by using the wrong statement date on a reconciliation.

The beginning balance on the report will not include transactions assigned a date later than the statement date in the current reconciliation, regardless of whether the prior reconciliation had a future date or the current reconciliation has a past date (for instance, if you go back and reconcile a previous bank statement after reconciling the most recent one). As a result of the beginning balance being the source of the ending balance:

Beginning Balance + Deposits and Other Credits – Checks and Payments = Ending Balance

In the event that the beginning balance is incorrect, the ending balance will be incorrect as well.

If the Reconciliation’s Current Statement Date is Incorrect:

  • Undo the reconciliation.
    • Reconcile can be chosen from the Banking menu.
    • Select the appropriate account, then click Undo Last Reconciliation in the Begin Reconciliation window.
    • Before reversing a prior reconciliation, a warning is provided to back up the company file. Select Continue if a backup has already been made.
    • When it says “Undo Previous Reconciliation has completed,” click OK. Keep in mind that the date that was last reconciled has changed to the prior day.
  • From the register or journal, Delete all the statement services fees, interest adjustments, and balance changes.
  • Use the accurate date to reconcile once again.

Incorrect Statement Date for the Prior Reconciliation:

  • Undo all the reconciliations back to and including the one that is incorrect.
    • Reconcile can be chosen from the Banking menu.
    • Select the appropriate account, then click Undo Last Reconciliation in the Begin Reconciliation window.
    • Before reversing a prior reconciliation, a warning is provided to backup the company file. Select Continue if a backup has already been made.
    • When it says “Undo Previous Reconciliation has completed,” click OK. Keep in mind that the date that was last reconciled has changed to the prior day.
  • Delete from the register or journal each statement period’s service charges, interest adjustments, and balance adjustments.
  • Reconcile each statement once more, separately and according to their respective dates.

Report Showing Future Statement Date

Scenario: A future statement date is displayed when you generate the report. The Reconcile window and the reconciliation reports will default to the last calendar date entered on a reconciliation in QuickBooks Desktop if a future date was entered. This behavior will persist until the future date has passed.

  • Reconcile can be chosen from the Banking menu.
  • Select the appropriate account, then click Undo Last Reconciliation in the Begin Reconciliation window.
  • Before reversing a prior reconciliation, a warning is provided to back up the company file. Select Continue if a backup has already been made.
  • When it says “Undo Previous Reconciliation has completed,” click OK. Keep in mind that the date that was last reconciled has changed to the prior day.
  • Once more reconcile the transactions. Ensure that the right dates are input.

PDF-related errors

In QuickBooks Desktop, the following issue occurs while attempting to see earlier reconciliation reports:

It is not possible to view PDF files in a web browser while Adobe Acrobat/Reader is operating. It’s necessary to have Adobe Acrobat/Reader version 8 or 9. Please leave and attempt again.

For all businesses, reconciling business accounts is a recommended practice because it makes account management and tracking easier. When businesses use QuickBooks, the reconciliation procedure becomes easier. The company’s efforts required to produce reconciliation reports are significantly reduced by the accounting application. QuickBooks is a good option for businesses due to its straightforward report generation process and straightforward exporting capabilities.

In case you face any issue contact us we will help you in resolving that issue.

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

Is it Possible to Undo a Reconciliation in QuickBooks?

A balance in your accounts might be thrown off by even minor changes. Only one transaction at a time can be unreconciled in order to lessen the impact. Contact your accountant if you need to start from scratch. Reconciliations can be completely undone only by accountants.

Is it Possible to Resolve a Reconciliation Inconsistency in QuickBooks?

Locate the account that has a reconciliation difference. To expand as a report, click. following which you should go back and alter all of the transactions associated with that account. You should use caution if any of these are from a closed fiscal period.

What is a Report on Reconciliation?

A Reconciliation Report is a specific kind of document that details the differences between several payment kinds connected to a specific assignment. It is an accounting-related report that displays whether their accounts have the correct balances recorded.

Call Now+1-800-596-0806
Top