cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
PBG
Super Explorer *

Reconciliation discrepancy

Hi, I had a reconciliation discrepancy which as I saw in the report was because I deleted a transaction that was already reconciled. It had to be deleted as it was incorrect. since this was a sales receipt issued to the wrong client and to the wrong account, it was after that corrected and I had Now, I followed the instructions by QBO to recreate it again but

Solved
Best answer 07-04-2019

Accepted Solutions
QuickBooks Team

Re: Reconciliation discrepancy

We appreciate you performing some steps to reconcile your account, PBG.

 

Let's try checking if the reconcile status of the created transaction is marked as R (Reconciled).

 

Here's how:

 

  1. Click Accounting on the left menu.
  2. Choose Chart of Accounts.
  3. Find the row of the account you'd like to view, then click View Register.
  4. Go to the reconcile status column (indicated by a check mark), and make sure the sales receipt is marked as R. If not, then manually change it.
  5. Click Save.

If the same thing happens, it possible there's another deleted transactions for that period. You can use the audit log to locate them. Just follow the steps and details in this article: How to use the audit long to re-enter deleted transaction.

 

Then, manually recreate the transaction and reconcile it in the register. This amends the opening balance of the current reconciliation.

 

You can always reply to this thread if you need anything else with reconciling your account.

5 Comments
Content Leader

Re: Reconciliation discrepancy

Thanks for posting in the Community, @PBG. I can lend a hand with your reconcile. 

 

Just to clarify, have you marked the corrected transaction as reconciled in your register? If not, the transaction will not be included in the reconcile balance to replace the deleted one and result in a discrepancy. Here's how you can change the reconcile status of the sales receipt. 

 

  1. Click the Gear icon.
  2. Select Chat of Accounts.
  3. Click View register for the account. 
  4. In the Reconcile Status column, select the square to change it to an R.

 

I've included a screenshot to serve as an example:

 

 

For further insight into changing a transaction's reconcile status, such as the meaning of the different codes, please see the following article: How to unreconcile a transaction or undo a reconciliation. Additionally, I recommend the following resource as it contains articles to help with every step of the reconcile process: Reconcile Hub.

 

If I can be of further assistance with your reconcile, please let me know. Have a good one. 

PBG
Super Explorer *

Re: Reconciliation discrepancy

Hi David, Yes, I did that, I marked it in the register with R
Established Community Backer ***

Re: Reconciliation discrepancy

For future reference. There was no need to delete anything - only change the customer name and details in the receipt. 

 

One thing I have found myself doing wrong occasionally is recreating or entering a transaction with a wrong date. Even when marked C or R a future dated transaction is not included if you hide transactions after the statement date.

 

You can rerun a reconciliation for same most recent statement date and your ending balance entered would be same as beginning balance

PBG
Super Explorer *

Re: Reconciliation discrepancy

Thank you for your answers but I still cannot solve my problem. Any other suggestions?
QuickBooks Team

Re: Reconciliation discrepancy

We appreciate you performing some steps to reconcile your account, PBG.

 

Let's try checking if the reconcile status of the created transaction is marked as R (Reconciled).

 

Here's how:

 

  1. Click Accounting on the left menu.
  2. Choose Chart of Accounts.
  3. Find the row of the account you'd like to view, then click View Register.
  4. Go to the reconcile status column (indicated by a check mark), and make sure the sales receipt is marked as R. If not, then manually change it.
  5. Click Save.

If the same thing happens, it possible there's another deleted transactions for that period. You can use the audit log to locate them. Just follow the steps and details in this article: How to use the audit long to re-enter deleted transaction.

 

Then, manually recreate the transaction and reconcile it in the register. This amends the opening balance of the current reconciliation.

 

You can always reply to this thread if you need anything else with reconciling your account.

Need to get in touch?

Contact us