cancel
Showing results for 
Search instead for 
Did you mean: 
finance139
Level 2

Transaction never reconciled

When we (a church) released our paid bookkeeper three months ago, the register for our bank account was found to be reconciled; that is, the closing balance of her last reconciliation matched the starting balance of the next bank statement that we received. We have now discovered, however, that before then the bookkeeper had been doing some “creative” work and there was one check, which cleared the bank four months ago, that was omitted entirely from her final reconciliation three months ago. Is there some simple, quick way to correct for that, without having to try and figure out how she managed to reconcile while at the same time omitting a check from the process?

Solved
Best answer February 05, 2021

Best Answers
JamesDuanT
Moderator

Transaction never reconciled

Let's see what happened here, finance139.

 

There's a possibility that your bookkeeper created an adjusting entry while reconciling the affected month. Hence, you still got the correct starting balance on the next bank statement.

 

There are different ways to correct this without affecting the following month's reconciliation. Before that, I'd recommend reviewing the affected month's reconciliation report.

  1. Click Accounting on the left menu and go to the Reconcile tab.
  2. Click Summary in the upper-right corner and select reconciliation report of the affected period.
  3. In the reconciliation report, look for Adjustment and make sure the amount is the same with the omitted check that you mentioned.

If the amounts of  the Adjustment in the reconciliation report and the omitted check are the same, we can proceed to these steps:

  1. Go back to the reconciliation report and click the amount associated to the Adjustment.
  2. This will open a transaction window. Click More at the bottom.
  3. Select Delete and click Yes to confirm the action.

After that, we can go to the account register and reconcile the check manually.

  1. Click Accounting on the left menu and go to the Chart of Accounts tab.
  2. Look for the affected account and click View register.
  3. Look for the check and change the transaction status from blank or Cleared (C) to Reconciled (R).
  4. Click Save and select Yes to confirm the action.

If the amounts of the omitted check and the Adjustment are not the same, you might need to undo the reconciliation of the affected period. You'll have to do this one transaction at a time. You can use this link for reference: Undo or remove transactions from reconciliations in QuickBooks Online.

 

You can also invite your accountant  to make it easier. They have an option to undo the period at once. From there, the can reconcile the period again and include the check you mentioned.

 

Note that we are always here to further assist you in managing your data in QuickBooks Online. Have a great day!

View solution in original post

3 Comments 3
JamesDuanT
Moderator

Transaction never reconciled

Let's see what happened here, finance139.

 

There's a possibility that your bookkeeper created an adjusting entry while reconciling the affected month. Hence, you still got the correct starting balance on the next bank statement.

 

There are different ways to correct this without affecting the following month's reconciliation. Before that, I'd recommend reviewing the affected month's reconciliation report.

  1. Click Accounting on the left menu and go to the Reconcile tab.
  2. Click Summary in the upper-right corner and select reconciliation report of the affected period.
  3. In the reconciliation report, look for Adjustment and make sure the amount is the same with the omitted check that you mentioned.

If the amounts of  the Adjustment in the reconciliation report and the omitted check are the same, we can proceed to these steps:

  1. Go back to the reconciliation report and click the amount associated to the Adjustment.
  2. This will open a transaction window. Click More at the bottom.
  3. Select Delete and click Yes to confirm the action.

After that, we can go to the account register and reconcile the check manually.

  1. Click Accounting on the left menu and go to the Chart of Accounts tab.
  2. Look for the affected account and click View register.
  3. Look for the check and change the transaction status from blank or Cleared (C) to Reconciled (R).
  4. Click Save and select Yes to confirm the action.

If the amounts of the omitted check and the Adjustment are not the same, you might need to undo the reconciliation of the affected period. You'll have to do this one transaction at a time. You can use this link for reference: Undo or remove transactions from reconciliations in QuickBooks Online.

 

You can also invite your accountant  to make it easier. They have an option to undo the period at once. From there, the can reconcile the period again and include the check you mentioned.

 

Note that we are always here to further assist you in managing your data in QuickBooks Online. Have a great day!

Boone Bookkeeping
Level 1

Transaction never reconciled

Tagging onto this conversation here... I have a new client I am keeping books for. The last time their accounts were reconciled were 4-8 months ago depending on the account from what I can tell. However, each account has several outstanding transactions from years ago. How do I handle this? I would like to clear them out to keep everything neat and clean but just deleting them does not seem like the right solution.

Kevin_C
QuickBooks Team

Transaction never reconciled

Hi there, Boone. I'll chime in to share some insights on how you can clear out your client's outstanding transactions in QuickBooks Online.

 

Reconciling the transactions is the best way to clear the outstanding transactions of your client's books for past years. That said, you can collect their bank statement for each specific period of the accounts that need to be reconciled. Then, you can reconcile each period to ensure you can clear all your transactions neat and clean.

 

You can also manually reconcile the outstanding transactions if these are included in the bank statement for the previous years. Here's how:

 

  1. Go to the Gear icon, then choose Chart of accounts.
  2. Locate the account that you put the transaction into and select View register.
  3. Find the transaction and select it to expand the view.
  4. Select the box in the checkmark column until you see an R. This manually reconciles the transaction.
  5. Once done, tap Save.

 

Otherwise, you can generate a journal entry for another option to clear out the outstanding transactions.

 

Additionally, you can check out this article to view various guidelines to assist you in your online transactions' reconciliation process: Learn the reconciliation workflow in QuickBooks.

 

If you have additional questions about reconciliation, feel free to click the Reply button below. I'm always here to help. Stay safe!

Need to get in touch?

Contact us