Quickbooks Destop Reconciliation

There should not have been any differences between Dec and Jan.  Bank Reconciliation *should* be month to month and have nothing to do with Year End.  Is there any common theme to the discrepancies between Dec and January. 

Some of the common issue are:

- Something that had be Reconciled was modified and it is now UN-Reconciled

- Someone got mixed up between 2021 and 2022 and entered something in 01/21 by mistake

- Someone moved something into Dec to make it look like a 2021 transaction

- Bank Feed items was  not correctly matched to an entries but "Added" as a duplicate

First check would be to take the Dec Statement and start the Reconcile process.  Put in the Dec Closing Date and the Closing Bank Balance.  Check to see what, if anything, is NOT Reconciled and also confirm you have a $0 Balance and if so, Dec/2021 is still correct. 

If things don't match up, start with those items and see if you can figure out what happened.

Luckily you are using the Desktop version, so you have the option to Undo the months you've already Reconciled.  So go undo back through Dec (even Nov if you want) and then move forward again to get things back in line.

Hello there, ab12.

In addition to @Pete_Mc  answer, let’s run the Reconciliation Discrepancy report to look for transactions that were changed, added, or removed. I’ll help show the steps on how to open it.  

Here’s how:

1. In your QuickBooks, head to the Reports at the top menu bar to choose Banking and select Reconciliation Discrepancy.
2. Click the Specify Account drop-down and choose the account you’re working on.
3. Tap the OK button to open the report.
4. Press the Dates drop-down to set the correct period and click Refresh to view the changes.
5. Review the report and look for any discrepancies.

Once identified, talk with the person who made the change. Then check the reason why they modified the entry and edit it as needed.

Aside from building the statement mentioned above, you can open the Missing Checks or Transaction Detail reports to determine the discrepancy.

If none of these suggestions work, I recommend you continue performing the troubleshooting steps in this article: Fix issues when you're reconciling in QuickBooks Desktop. Proceed directly to Step 3 for detailed instructions.

For additional resources, the links below cover all the details on how to resolve when reconciled entry showed up as unreconciled. You’ll also learn about reconciling the account as well as running a mini-reconciliation.

• Reconcile previously deleted and re-entered checking or credit card transactions
• Reconcile an account in QuickBooks Desktop

Reach out to me again if you have other concerns about reconciling an account. I’ll be more than happy to assist further. Have a great rest of the day.