Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Simplify payday and set payroll to run automatically on QuickBooks. Explore QuickBooks Payroll
phxuser
Level 1

Duplicate transfer transactions when importing bank data

Hi.

 

I imported a year's worth of bank data for three accounts, reconciled the accounts and had a lot of transfer transactions "left over" in each account. All these transactions are duplicates of other transfers in the same account... the memo of the reconciled transfer will say "transfer to acct xxxx" (xxxx being a different account) and the memo of the duplicate of that transaction will say "transfer from acct yyyy" (yyyy being the account being reconciled).

 

Presumably what's happening is that when I import a transfer transaction in one account, QBO makes a corresponding transaction in the other, to/from account. How do I deal with this when importing files which will show the transfer already in both accounts? (I have a lot more importing to do.)

 

Also, is there a way to batch delete the duplicates?

Thank you!

 

phxuser

 

 

1 Comment 1
DivinaMercy_N
Moderator

Duplicate transfer transactions when importing bank data

Hi there, @phxuser. I'm here to provide information on how you can import your transfer transactions in QuickBooks Online (QBO) to prevent duplicates.

 

In QBO, handling transfers is a bit different. For instance, if there are transfers between two accounts, and you set up bank feeds for those accounts, you'll have a transaction downloaded for money leaving one account as well as money entering the other. That said, you'll need to perform some processes to record it correctly in the system. 

 

To begin, add the transfer from one account. However, in the other account (which is the other half of the transfer) instead of adding that bank feed transaction, match it to the transfer in the system.  It can be a tricky process, so I recommend reaching out to the Customer Care team support for additional assistance. 

 

Then, to batch exclude the duplicate transactions, below are the steps you can perform:

 

  1. In your QBO account, select the Banking menu and choose Banking.
  2. Next, select the account where the transactions are located.
  3. Then, go to the For Review tab.
  4. From there, check the box of the transactions you want to Exclude.
  5. After that, click the Exclude button.

 

For reference, feel free to visit this article: Exclude a bank transaction you downloaded into QuickBooks Online.

 

I'd love to know how this process goes. I'd appreciate any details that you can add. If you have further questions about managing your transfer transactions in QBO, feel free to get back in this thread. I'm always ready to lend a hand. Keep safe and take care. 

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

Need to get in touch?

Contact us