The article outlines the recommended troubleshooting steps for some of the common issues you may encounter when running a Previous Reconciliation report.
Always create a backup copy of the company file before you try any of the recommended solutions below.
What is happening: You are not able to view previous reconciliation reports and the report options and types are grayed out. This may be caused by a corrupted or damaged QuickBooks PDF converter when the previous reconciliation were done.
Solution 1: Update to the latest release for your version of QuickBooks Desktop.
Solution 2. View Previous Reconciliation Reports without displaying as a PDF file.
Solution 3. Repair PDF Converter.
What is happening: You are can generate Previous Reconciliation PDF reports but they are blank or missing certain columns.
Solution 1: Edit the Internet Preferences in Adobe Acrobat Reader
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.
What is happening: Reconciled/cleared transactions are showing as uncleared when you view Previous Reconciliation report. This issue can occur when a future date is entered in the Statement Date field of the Begin Reconciliation window. Note that 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 that this date does not occur in the future.
Option 1: Undo the previous reconciliation and then reconcile the transactions again using the correct date.
Option 2: Leave the reconciliation as it is. The transactions will appear as cleared on the report once the statement date has been reached.
If the report shows an incorrect beginning and ending balances, it may be caused by an incorrect statement date used on a reconciliation OR a later reconciliation entered in QuickBooks Desktop before the current one.
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. 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 - Checks 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:
If the statement date for the previous reconciliation is incorrect:
QuickBooks Desktop remembers the last calendar date entered on a reconciliation. If a future date was entered, the Reconcile window and the reconciliation reports will default to that future date until it has passed.
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.
When trying to view previous reconciliation reports in QuickBooks Desktop this error occurs:
The error occurs if the Adobe installation is corrupt. Please see this Adobe article to resolve this issue in QuickBooks Desktop.