cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Intuit

Resolve common issues on Previous Reconciliation report

Having trouble with previous bank reconciliation report showing as blank or worried about cleared transactions showing up as unclear? Here’s a list of the common issues you may encounter while running the Previous Reconciliation report along  with recommended solutions to get you back to business in no time.

IMPORTANT NOTE: Back up the QuickBooks company file before you proceed with the recommended solution for each of the issue.

Reports not available

SCENARIO: You are not able to view previous reconciliation reports and the report options and types are greyed out. This may be caused by a corrupted or damaged QuickBooks PDF converter when the previous reconciliation were done.

Solution 1: Ensure your version of QuickBooks is up to date.

Solution 2. View Previous Reconciliation Reports without displaying as a PDF file.

  1. From the Reports menu, click Banking > Previous Reconciliation.
  2. Under In this report, include section, click the Transactions cleared plus any changes made to those transactions since the reconciliation radio button.

Solution 3. Repair PDF Converter. For details see Troubleshoot PDF and Print problems with QuickBooks Desktop.

Blank reports

SCENARIO: You can generate Previous Reconciliation PDF reports but they are blank or missing certain columns.

Solution 1: Edit the Internet Preferences in Adobe Acrobat Reader.

  1. Open Adobe Reader.
  2. Select the Edit menu.
  3. Choose the Preference option and from the Preference list, click Internet.
  4. Uncheck the first checkbox labelled Display PDF in Browser or if the box is already unchecked, check the box instead.
  5. Open the Previous Reconciliation report.

Solution 2. Update, repair or reinstall Adobe Acrobat Reader.

Solution 3. Recreate the previous reconciliation report. The particular previous reconciliation report being selected may be damaged. Try opening up reports for the same account further back in history. If one of the other reports opens that would suggest that the desired report is broken and would need to be recreated.

  1. Undo each previous reconciliation up to and including the broken reconciliation.
    1. From the Banking menu, click Reconcile.
    2. In the Begin Reconciliation window, select the appropriate account then click Undo Last Reconciliation.
    3. A message to backup the company file before undoing a previous reconciliation is displayed. If you have already created a backup, click Continue.
    4. Click Ok when the message Undo Previous Reconciliation has completed displays. Note that the last reconciled on date has reverted to the previous date.
    5. Reconcile the transactions again.
  2. Reconcile the transactions again.

Cleared transactions appear as uncleared

SCENARIO: Reconciled/cleared transactions are showing as uncleared. This occur when a future date is entered in the Statement Date field of the Begin Reconciliation window.

IMPORTANT NOTE: QuickBooks Desktop assigns the Statement Date (future or otherwise) to each transaction as it is cleared. When you run a reconciliation report, cleared transactions with a future date assigned to them can appear in the Uncleared Transactions section.

To help prevent this issue in the future, check the date in the Statement Date field of the Begin Reconciliation window before continuing with the reconciliation. Make sure the date does not occur in the future.

Option 1: Undo the previous reconciliation and then reconcile the transactions again using the correct date.

  1. From the Banking menu, click Reconcile.
  2. In the Begin Reconciliation window, select the appropriate account then click Undo Last Reconciliation.
  3. A message to backup the company file before undoing a previous reconciliation is displayed. If you have already created a backup, click Continue.
  4. Click Ok when the message Undo Previous Reconciliation has completed displays. Note that the last reconciled on date has reverted to the previous date.
  5. Reconcile the transactions again.

Option 2. Leave the reconciliation as it is. The transactions will appear as cleared on the report once the statement date has been reached.

The beginning and ending balances on the report are incorrect

SCENARIO: When you generate the report, it gives an incorrect beginning and ending balances. This is caused by an incorrect statement date used on a reconciliation OR a later reconciliation entered in QuickBooks Desktop before the current one.

IMPORTANT NOTE: QuickBooks Desktop associates the statement date with each transaction you reconcile. At the end of the process when you print a reconciliation report, the beginning balance is the sum of all cleared transactions that have a statement date prior to the one used for the current reconciliation. So, if the statement date from a prior reconciliation was later than the statement date for the current reconciliation, the transactions associated with the later date are not included in the beginning balance.

For example, with a prior reconciliation statement date of 09/30/08, and a current statement date of 08/31/08, transactions associated with the 09/30/08 statement date will not be included in the beginning balance on the current 08/31/08 reconciliation report.

Whether the prior reconciliation had a future date, or the current reconciliation has a past date (for example, if you go back to reconcile a past bank statement after reconciling the most recent one), transactions assigned a date later than the statement date in the current reconciliation will not be included in the beginning balance on the report. And because the ending balance is derived from the beginning balance:

Beginning Balance + Deposits and Other Credits - Cheques and Payments = Ending Balance

If the beginning balance is incorrect, the ending balance will be incorrect as well.

If the statement date for the current reconciliation is incorrect:

  1. Undo the reconciliation.
    1. From the Banking menu, click Reconcile.
    2. In the Begin Reconciliation window, select the appropriate account then click Undo Last Reconciliation.
    3. A message to backup the company file before undoing a previous reconciliation is displayed. If you have already created a backup, click Continue.
    4. Click Ok  when the message Undo Previous Reconciliation has completed displays. Note that the last reconciled on date has reverted to the previous date.
  2. Delete all statement services charges, interest adjustments and balance adjustments from the register or journal.
  3. Reconcile again using the correct date.

If the statement date for the previous reconciliation is incorrect:

  1. Undo all the reconciliations back to and including the one that is incorrect.
    1. From the Banking menu, click Reconcile.
    2. In the Begin Reconciliation window, select the appropriate account then click Undo Last Reconciliation.
    3. A message to backup the company file before undoing a previous reconciliation is displayed. If you have already created a backup, click Continue.
    4. Click OK when the message Undo Previous Reconciliation has completed displays. Note that the last reconciled on date has reverted to the previous date.
  2. Delete all statement service charges, interest adjustments, and balance adjustments for each statement period from the register or journal.
  3. Reconcile each statement again separately and in sequential date order.

Report shows future statement date

SCENARIO:  When you generate the report, it shows future statement date. QuickBooks Desktop remembers the last calendar date entered on a reconciliation, so if a future date was entered, the Reconcile window and the reconciliation reports will default to that future date until it has passed.

IMPORTANT NOTE: You need to undo last reconciliation to reset the account register’s last reconciliation, last reconciled date and remove the Previous Reconciliation report for the corresponding date.

  1. From the Banking menu, click Reconcile.
  2. In the Begin Reconciliation window, select the appropriate account then click Undo Last Reconciliation.
  3. A message to backup the company file before undoing a previous reconciliation is displayed. If you have already created a backup, click Continue.
  4. Click Ok when the message Undo Previous Reconciliation has completed displays. Note that the last reconciled on date has reverted to the previous date.
  5. Reconcile the transactions again. Make sure the correct dates are entered.

PDF-related error/s

SCENARIO: When trying to view previous reconciliation reports in QuickBooks Desktop this error occurs:

The Adobe Acrobat/Reader that is running cannot be used to view PDF files in a web browser. Adobe Acrobat/Reader version 8 or 9 is required. Please exit and try again.

The error occurs if the Adobe installation is corrupt. Please see this Adobe support article to resolve this issue in QuickBooks Desktop.

Was this helpful?

You must sign in to vote, reply, or post