Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
michael-state48m
Level 1

Merge duplicate transactions in the register

For whatever reason I have a ton of transactions in my bank register that have not been merged.  One transaction that I manually created and attached a receipt and the transaction downloaded by the bank.  I can't seem to figure out how to match them when they are in the register or how to get them back into the bank feed page.  The transactions are not reconciled.  

3 Comments 3
SirielJeaB
Moderator

Merge duplicate transactions in the register

Hello there! I'll guide you on managing your transactions in your bank register, Michael.

 

QuickBooks matched the downloaded transaction with one you already entered, like an invoice, a bill, a receipt, or a payment. This links them together so you don't get duplicates. 

 

Here's how to match with an existing transaction:

 

  1. Select Bank transactions from the Transactions tab.
  2. Find and select the downloaded record to expand the view.
  3. Review the Matching records found in QuickBooks for the possible matching transaction already entered in QuickBooks.
  4. Verify if your receipt and the downloaded transaction have the same details.
  5. If the details match, close the open record and select Match.

 

For more details, refer to this article: Match online bank transactions in QuickBooks Online.

 

Furthermore, it's important to reconcile your accounts monthly to ensure they match your bank statements to guarantee accuracy and balance.

 

Drop by in the Community space anytime whenever you have additional questions about matching transactions in QBO. We're available 24/7 to provide you with our utmost assistance. Keep safe.

michael-state48m
Level 1

Merge duplicate transactions in the register

The response given does not address my issue.  In my case the transactions are not in "Bank transactions" in the "For review" section.  They are already in the bank register.  

ChristineJoieR
QuickBooks Team

Merge duplicate transactions in the register

I understand that the transaction was under the bank register, @Michael. If you need assistance in undoing the reconciliation monthly date in QuickBooks Online, you've come to the correct place.

 

Please know that the transaction under the bank register cannot be merged. However, we can manually remove transactions at a time, by clicking the status. This way, all the transactions are removed from the reconciliation page. Once done, you need to reconcile your account again.

 

Follow the steps below:

 

  1. Go to the Gear menu and click Chart Of Accounts.
  2. Choose the bank account you want to un-reconcile and click the blue View Register hyperlink on that row.
  3. Find and select the transaction you need to unreconciled.
  4. Look in the column just to the right of the Deposit column. This column is the Reconciliation Status column.
  5. To undo the reconciliation of this transaction, click the R (for reconciled) until the field is blank.
  6. Click the green Save button.
  7. Now find and select the transaction.
  8. Click the blank or (for Cleared) to (Reconcile).
  9. Click the green Save button.

 

Moreover, you will need an easy way to undo the reconciliation and change the year date if you have already concluded the process, only QuickBooks Online Accountant has the Undo feature. I would advise bringing your accountant in to undo the whole reconciliation period.

 

Here's how:

 

  1. Click the Gear icon in the upper right corner, and select Manage Users.
  2. Go to the Accounting Firms tab, enter the accountant's email, and click the Invite button.
  3. Hit Save.
  4. Once invited, have your accountant undo the whole reconciliation.

 

If you run into any mistakes when reconciling your accounts, the article will show you how to repair them: Fix issues at the end of a reconciliation in QuickBooks Online.

 

If you need any additional help with reconciliation, ping me over. I'll always be available to assist.

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us