Skip to main content
B
BJLAY1959
December 6, 2023
Solved

Errors in the register

  • December 6, 2023
  • 1 reply
  • 0 views

Hello,

I have an account that has been reconciled but when I go to the register it shows duplicate - sometimes three entries for the same transaction and all of the transactions have the little R for reconciled. If I change to the C or leave it blank, I get a discrepancy inn  my reconciliation.

Also, these double/triple entries are causing my reports to be incorrect.

Thanks in advance for any help.

Brenda

Best answer by Bryan_M

Welcome to the Community space, @BJLAY1959.

 

I'm here to help you narrow down things we'll need to perform to remove your duplicate transactions that are reconciled in your register.

 

To start, we'll need to undo the reconciliation of the affected period, and then delete the duplicates. 

 

Here's how:

 

  1. From the Transactions tab, select Chart of Accounts.
  2. Look for the account where the duplicated transactions are registered and reconciled.
  3. From the Bank Register, let's undo the reconciliation by clicking the column that has the "R" until no sign shows.
  4. Do this to all the affected transactions of that period. 
  5. Then, look for the duplicated transactions. Click it and choose Delete to remove the transactions on the register permanently.

Once done, redo the reconciliation together with your accountant for additional guidance.

 

If you want to learn what to do if QuickBooks Online (QBO) doesn't match your bank statement at the end of a reconciliation, you can refer to this article: Fix issues at the end of a reconciliation in QuickBooks Online.

 

For more queries about managing duplicated transactions in your register, never hesitate to reply to this post. I'll be willing to lend a hand. Have a good day.

1 reply

Bryan_M
Bryan_MAnswer
December 6, 2023

Welcome to the Community space, @BJLAY1959.

 

I'm here to help you narrow down things we'll need to perform to remove your duplicate transactions that are reconciled in your register.

 

To start, we'll need to undo the reconciliation of the affected period, and then delete the duplicates. 

 

Here's how:

 

  1. From the Transactions tab, select Chart of Accounts.
  2. Look for the account where the duplicated transactions are registered and reconciled.
  3. From the Bank Register, let's undo the reconciliation by clicking the column that has the "R" until no sign shows.
  4. Do this to all the affected transactions of that period. 
  5. Then, look for the duplicated transactions. Click it and choose Delete to remove the transactions on the register permanently.

Once done, redo the reconciliation together with your accountant for additional guidance.

 

If you want to learn what to do if QuickBooks Online (QBO) doesn't match your bank statement at the end of a reconciliation, you can refer to this article: Fix issues at the end of a reconciliation in QuickBooks Online.

 

For more queries about managing duplicated transactions in your register, never hesitate to reply to this post. I'll be willing to lend a hand. Have a good day.

B
BJLAY1959Author
December 8, 2023

Thank you. Is there something else I need to do to Unreconcile a specific month? Should I start at the beginning of the time that the duplicates started? I took over this account and the issue was already going on.

The account was reconciled to 0.00 each month. 

TIA

AldritchM
AldritchM
December 8, 2023

You're most welcome, @BJLAY1959.

 

It's good to hear the instructions that were provided by my colleague is helpful.

 

I'd suggest reconciling from the beginning of when the duplicates started. This way, the beginning balance for each month is accurate.

 

Additionally, I'll also share this article which can serve as your reference to learn to unreconcile an individual transaction from a completed reconciliation: Undo or remove transactions from reconciliations in QuickBooks Online.

 

If you encounter any troubles with reconciling, don't hesitate to reply. I'm always around to help!

Terms & ConditionsAccessibility statement