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.
SusanHopes
Level 1

Added new account, it re-imported txns, invoice matching a mess

I converted from sole proprietor to LLC on January 1 and had to set up new bank accounts to go with it. Fine. Accounts opened two weeks before LLC came into being, old accounts closed a few days into the year.

 

Added the new accounts to my Quickbooks. I said sure, import everything from last year thinking it would be just the setup transactions for the new accounts. Surprise! It brought in what should be duplicates of all of last year's transactions. In addition, the old categorized and reconciled transactions from the old account, including payments matched to invoices, were gone! Only some transactions from a few vendors remained. 

 

Can anyone help me understand what happened and how I can get this fixed without having to review a whole year of transactions plus the now-missing prior year, as well?

 

Thank you! 

Solved
Best answer January 05, 2024

Best Answers
KayePe
QuickBooks Team

Added new account, it re-imported txns, invoice matching a mess

Let us help you understand why duplicates happen in your account and help you resolve this, @SusanHopes

 

With bank transactions, it's essential to note that there's often a default day when the transactions will sync. The transaction history you access varies from bank to bank. Some banks allow you to download up to 90 days of transactions, while others may go back 24 months. With this, you may see duplicate transactions in your account if you've already added them to an old account of yours, such as a sole proprietorship account. For a fix, exclude the duplicate transactions. 

 

 Let me show you how:

 

  1. Go to Transactions, then select Bank Transactions.
  2. Choose the For Review tab.
  3. Click the checkbox of the transactions to exclude.
  4. Select Exclude.

 

Regarding your missing categorized and reconciled transactions from your old account, checking your audit log is recommended. If you don't see them there, it's worth checking your new account. However, please note that categorized and reconciled transactions won't carry over to your new account since they are already associated with the old one.

 

On the other hand, I recommend scanning these articles as your reference in adding transactions in QBO:

 

 

Comment below for more queries about fixing your concern. We're always here to assist. Have a good one!

View solution in original post

1 Comment 1
KayePe
QuickBooks Team

Added new account, it re-imported txns, invoice matching a mess

Let us help you understand why duplicates happen in your account and help you resolve this, @SusanHopes

 

With bank transactions, it's essential to note that there's often a default day when the transactions will sync. The transaction history you access varies from bank to bank. Some banks allow you to download up to 90 days of transactions, while others may go back 24 months. With this, you may see duplicate transactions in your account if you've already added them to an old account of yours, such as a sole proprietorship account. For a fix, exclude the duplicate transactions. 

 

 Let me show you how:

 

  1. Go to Transactions, then select Bank Transactions.
  2. Choose the For Review tab.
  3. Click the checkbox of the transactions to exclude.
  4. Select Exclude.

 

Regarding your missing categorized and reconciled transactions from your old account, checking your audit log is recommended. If you don't see them there, it's worth checking your new account. However, please note that categorized and reconciled transactions won't carry over to your new account since they are already associated with the old one.

 

On the other hand, I recommend scanning these articles as your reference in adding transactions in QBO:

 

 

Comment below for more queries about fixing your concern. We're always here to assist. Have a good one!

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

Need to get in touch?

Contact us