Skip to main content
January 7, 2024
Question

Do I delete the R or the C with duplicate transactions in my register?

  • January 7, 2024
  • 1 reply
  • 0 views
Original commenter did not share additional details

1 reply

January 7, 2024

Welcome to the Community. I can clarify your concern about deleting the R or the C with duplicate transactions in your register in QuickBooks Online.

 

In QuickBooks Online, the "R" and "C" markings are used to indicate the status of transactions about the bank reconciliation process. - "R" stands for "Reconciled": Transactions marked with an "R" have been reconciled. If verified that the transactions are real duplicates, undo first (do make sure that the R and C fields are blank) 

 

Moreover, "C" stands for "Cleared" when confirmed that's it's a real duplicate, undo them first then you can delete them. Understanding these markings is crucial for reconciling your accounts accurately. When encountering duplicate transactions, it's generally safe to review and confirm if its real duplicates before deleting them. 

 

To ensure the accuracy of your transactions, it is advisable to seek professional guidance from an experienced Accountant. 

 

If you encounter duplicate transactions in QuickBooks Online (QBO), you have two options to resolve them. You can either exclude them or delete them. Excluding a transaction will remove it from the bank feeds and prevent it from reappearing. On the other hand, if you delete it, QBO will detect it as missing and download it again. To avoid any reconciliation issues, I recommend excluding any duplicate transactions. 

 

Let me guide you on how to do it:

 

  1. Go to Bookkeeping, then select Transactions.
  2. In the Bank transactions tab, open the For Review tab.
  3. Tick the checkbox of the transactions you want to remove.
  4. Click Exclude.

 

After excluding a transaction, it will be relocated to the Excluded tab. If you want to undo this action, simply proceed to the Excluded tab, choose the transaction you wish to restore by selecting the checkbox, and click the Undo button. Once done, the transaction will be moved back to the For Review tab.

 

Additionally, if you accidentally deleted a transaction, you could recreate it from the discrepancy report. Here's how:

 

  1. Click the +New button.
  2. Choose the correct form (invoice, sales receipt, expense, etc.).
  3. Complete the form and select Save and Close.
  4. Go to Bookkeeping, then open Chart of Accounts.
  5. Look for the account you put the transaction into, then choose View Register.
  6. Locate the transaction and then click on it to expand the view.

 

To proceed to the following steps, refer to the "Deleted" dropdown in the "Step 4: Review any discrepancy reports" section of this article: Fix issues for accounts you've reconciled in the past in QuickBooks Online.

 

You can also check this article to learn what to do if QuickBooks Online doesn't match your bank statement at the end of a reconciliation: Fix issues at the end of a reconciliation in QuickBooks Online.

 

Please let me know if you encounter any other issues when deleting the R or the C with duplicate transactions in your register. I want to make sure everything is taken care of for you. Have a great day!