There may be times when transactions you already reconciled show up as unreconciled. There may be a few reasons for this:
- Someone undid the last reconciliation.
- Someone changed or deleted the reconciled transactions.
- Cleared transactions were unchecked (uncleared) in the account register.
- Funds were transferred from a previously reconciled bank account to a sub-account.
- Company file conversions can cause issues (from QuickBooks for Mac to Windows or QuickBooks Online to Desktop) (US only).
- The transactions were never reconciled in the company file. This might be because the file was restored from a backup, which can overwrite data and reconciliations.
You can do a special reconciliation, also sometimes called a "mini reconciliation," to fix these issues.
Do a special reconciliation
This "mini reconciliation" method uses an "off-cycle" reconciliation date to make a correction.
This assumes you know the ending balance from the most recent reconciliation. Get this information before you start.
Fix transactions in a bank account
- Go to the Banking menu and select Reconcile.
- Select the bank account with the transactions you need to reconcile.
- In the Date of Statement field, enter date for an "off-cycle reconciliation." This date can be any date between your last reconciliation and the next scheduled one.
Note: When you enter an "off-cycle" date, QuickBooks will remind you that you're doing a mini reconciliation. This puts previously unreconciled transactions back without affecting the "cycle" that they follow. - In the Ending Balance field, enter the balance of your last successful reconciliation. Then select Continue.
- In the Reconcile window, check off the transactions you are fixing and re-reconciling.
- Make sure the Difference field shows $0.00.
- When everything looks good, select Reconcile Now.
Fix transactions in a credit card account
- Go to the Banking menu and select Reconcile.
- Select the credit card account with the transactions you need to reconcile.
- In the Date of Statement field, enter date for an "off-cycle reconciliation." This date can be any date between your last reconciliation and the next scheduled one.
Note: When you enter an "off-cycle" date, QuickBooks will remind you that you're doing a mini reconciliation. This puts previously unreconciled transactions back without affecting the "cycle" that they follow. - In the Ending Balance field, enter the balance of your last successful reconciliation. Then select Continue.
- In the Reconcile window, check off the transactions you are fixing and re-reconciling.
- Make sure the Difference field shows $0.00.
- When everything looks good, select Reconcile Now.
After you select Reconcile Now, QuickBooks asks if you want to Create a Payment Check or Create a Bill to Pay Later.
- Select Create a Bill to Pay later.
- If you need to, print your Reconciliation Report for your records.
- After you print the report, a bill appears on the screen. The bill amount will be the balance you just reconciled.
- Select Clear. This removes all info from the bill.
- Close the bill
This balances the account. QuickBooks won't create a bill so your credit card balance isn't affected.