Reconciliation Difference

Let me help you with your reconciliation concern, Sarah.

When reconciling, only the transactions that were cleared from your bank account appear on the Reconciliation page. In your case, it seems that the October transaction cleared in January, which is why it's showing up now. To verify this, you can cross-check the transactions on the QuickBooks Online (QBO) account with your bank statement to ensure they match.

Moreover, you can go through the following articles to help keep your accounts up-to-date:

• Learn the reconcile workflow in QuickBooks
• Fix issues for accounts you've reconciled in the past in QuickBooks Online
• Fix QuickBooks Payment deposits that don't match your bank statement

Once the reconciliation is complete, you can run a report to check if everything is in order. For detailed instructions on how to run a reconciliation report, please refer to this article: How do I view, print, or export a reconciliation report?

If you have any further questions related to balancing your accounts, feel free to visit the Community again. We're always here to assist you, Sarah.

Thank you for your assistance, I double checked the cleared deposits against my bank statement and the January ones match but none of the October transactions are on my bank statement for January. When I originally reconciled October I matched the cleared transactions at that time to the bank statement and had no issues. Is it possible that the October transactions showing up in January are duplicate? What do I do?

Thank you for your response, @Sarah_HM. I appreciate you sharing your additional concerns regarding your reconciliation. I know that timely reconciliation is crucial, and I'm here to help you achieve that and ensure accurate bookkeeping figures.

You mentioned that none of the transactions from October are listed on your January statement, and that you've reconciled your October with no issues. Therefore, let me assist you in making sure that these are not duplicate transactions. If they are, I will guide you on how to correct them.

First, let's review the transactions in the Reconciliation window and look for any that are in QuickBooks but not on your bank statement. Make a note of the transaction date and amount, and run a Past Reconciliation report for those dates.

If you find a transaction that was on a previous bank statement but wasn't on the past reconciliation report for those dates, follow these steps:

1. Go to Bookkeeping and select Chart of accounts.
2. Find the account you’re reconciling and click View register.
3. Locate the transaction and select it to expand the view.
4. If the box in the checkmark column is blank or has a C, make sure the transaction is accurate.
5. Click the box in the checkmark column until you see an R. If there's already an R in the checkmark column, leave it alone.
6. Once done, select Save.

If the transaction was on the past reconciliation report, let's look for duplicate transactions and delete them. Please note that you should only delete transactions if you're absolutely certain they're a duplicate or error.

Here's how:

1. Go to Bookkeeping and select Chart of accounts.
2. Find the account you’re reconciling and click View register.
3. Locate the transaction and select it to expand the view.
4. Select Delete and then Yes to confirm.

Furthermore, I recommend getting in touch with your accountant for extra advice on the next step to take and to keep your books in order.

Finally, you can learn the reconcile workflow in QuickBooks and view, print, or export a reconciliation report.

If you have any additional issues or need clarification regarding reconciliation, please let me know. I'm available 24/7 to help you out.

Thank you so much for your help. I reviewed my reconciliation for October and there was at one point transactions that were erroneously deleted and I had to manually re-enter them. Those transactions are the ones that appeared in my January reconciliation. They show at the top of the October report as deleted and then in the main part of the report. Does that mean they are showing up twice since they appear on the October report and in my January reconciliation?

I'm here to help you with your reconciliation, @Sarah_HM. Let me provide you with some information to ensure everything is correct.

Yes, it will show twice. However, it doesn't necessarily mean they're duplicates since it was marked as deleted in the October report. To avoid it appearing in the January reconciliation, you'll need to mark it as reconciled.

Here's how you can do it:

1. Go to the Transactions menu and select Chart of Accounts.
2. Look for the account you're reconciling and click View register.
3. Find the transaction that appeared in your January reconciliation and select it to expand.
4. Tick the box in the checkmark column until you see an R.
5. Once done, select Save.

I've attached a screenshot for visual reference.

I'll add these informative resources as a guide in reconciling your accounts and help fix issues you may encounter:

• Learn the reconciliation workflow.
• Fix Issues When Reconciling Accounts.
• Enter an adjusting entry for a reconciliation.

I can back you up again if you need further assistance with your reconciliation and transactions. Feel free to leave your response below. Best wishes! 

Hello,

I went into my chart of accounts and saw that the October transactions I had to hand enter did not have an "R" so I changed them. When I resumed reconciling my balance is still off by the same amount it was before. I reviewed the deposits and payments for the month I am reconciling (January) and they match the bank statement. So I am not sure why my balance is off still. What should I do?

Thanks for reviewing your transactions, @Sarah_HM. Allow me to provide you with an overview of why this discrepancy happened.

In your previous post, you identified a deleted transaction from October. The deleted and re-entered transaction from October would be the reason for the discrepancy in January's balance.

It's not advisable to remove a transaction from previous reconciled months. If a transaction has been deleted, make sure that the date of the manually entered transaction in January matches the date of the deleted transaction in October, so it won't count in the January reconciliation.

To sort this out, please follow my colleague @JorgetteG's steps above to undo the reconciliation back to October to correct the deleted transaction and the balance each month. You can also follow step 6 in this article: Fix issues at the end of a reconciliation.

If you're hesitant to do this on your own, I recommend contacting our Technical Support Team to assist you further in correcting your reconciliation in a secure environment.

Here's how:

1. Click the Help icon.
2. Select the Search tab. Then, Contact Us.
3. Choose a general topic where your concern falls. Or, click Ask about something else.
4. Explain your issue in words. Once done, tap Continue.
5. Pick how you want to connect with us: Chat or Callback.

Additionally, I'll add these articles to guide you in reconciling your accounts and to help you with any discrepancy.

• Learn the reconciliation workflow
• Enter an adjusting entry for a reconciliation

I value your urge to fix your books right away. Please let us know if you have other queries about correcting your reconciliation. We'll do our best to fix it promptly. Take care.