Skip to main content
M
michael-state48m
January 26, 2024
Question

Merge duplicate transactions in the register

  • January 26, 2024
  • 1 reply
  • 0 views

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.  

1 reply

S
SirielJeaB
January 26, 2024

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.

M
michael-state48mAuthor
January 27, 2024

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.  

    C
    ChristineJoieR
    January 27, 2024

    I understand that the transaction was under the bank register, @Michael11_2. 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 R 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 C (for Cleared) to R (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.

    Terms & ConditionsAccessibility statement