cancel
Showing results for 
Search instead for 
Did you mean: 
MCWW
Level 2

Dumplicate transactions belong to account that doesn't exist

Hello, I have recently solved a problem where my bank changed online systems which caused me to have duplicate accounts.  That problem is fixed, however I am left with a new one.

 

There are duplicate transactions showing payments from a checking account *that no longer exists in my chart of accounts*

 

I cannot zero out these transactions or remove them because they are associated with an account that QBO says is inactive.  However, even with "Show Inactive Accounts" selected in options, the account is not listed in the chart of accounts.  Therefore I am left with the following scenario (at least 20 instances of this):

 

1.  A payment from the correct "Business Checking" account to the "Business Amex Card" account

2.  A duplicate payment from a now nonexistant "SMALL BUS CKG 0010-4-1" account that is not listed in the Chart of Accounts despite having the "Show Inactive Accounts" flag turned on.

 

Please help me either find this missing account or guide me to delete the duplicate transactions regardless of the fact that the original account they are tied to no longer exists.

 

Thank you!

Solved
Best answer November 21, 2023

Best Answers
SarahannC
Moderator

Dumplicate transactions belong to account that doesn't exist

I appreciate you getting back to us and providing screenshots for additional reference, MCWW.
 

Yes, you're right that the transactions you encircled are the ones that were automatically downloaded from the bank. Any deleted accounts that are not showing up, even after including the inactive accounts, need to be fixed, and I'm here to help you with that.

 

To isolate this, you can log in to your account using a private browser or an incognito window. This will help us determine if the issue is related to your browsing data or extensions.
 

  • For Chrome: Ctrl Shift N
  • For Firefox: Ctrl Shift P
  • For Safari: Command Shift N

 

Another way is to use compatible browsers when accessing QuickBooks Online. It optimizes and minimizes potential compatibility issues. 

Moving forward, you can access the Categorized tab and undo any duplicate transactions that aren't part of your reconciliation.  Here's how:

 

  1. Go to the Transactions menu.
  2. In the Bank transactions, go to the Categorized tab.
  3. Find the duplicate transaction and select Undo.

 

If you suspect that someone has made changes to your work in your books, you can use the Audit log feature to view the activity history. 

 

Additionally, you can utilize these articles when reviewing and reconciling your accounts:

 

 

If you have further concerns about addressing unexpected issues with accounts and transactions, please let me know by commenting below.

View solution in original post

5 Comments 5
Angelyn_T
Moderator

Dumplicate transactions belong to account that doesn't exist

Hi, MCWW.

 

It's my top priority to assist you in finding your missing account and deleting the identical transactions from your record. To do that, can you tell me more about these duplicate transactions? Are they downloaded from online banking or just manually recorded?

 

Could you also provide a screenshot of your chart of accounts and the screen where you receive the error message? This way, I'll be able to verify the details more closely.

 

Your reply is much appreciated. Stay safe!

MCWW
Level 2

Dumplicate transactions belong to account that doesn't exist

Screenshot of duplicate transactions shown from the reconciliation screen.  Several examples are circled in red.  There are more.  These examples in particular were automatically downloaded.

Duplicates.png

 

I edit the transaction from the reconciliation screen.  When I try to zero the dollar amount and save it, I get the error message. 

 

 

TryingToZero.png

 

Chart of accounts looks like this - there is no matching account for the one that shows as (deleted) on the reconcile page.  Note this is just a few, but shows all of the "Bank" accounts - note that there is not one matching the first screenshot.

 

 

ChartofAccounts.png

 

 

 

 

 

 

SarahannC
Moderator

Dumplicate transactions belong to account that doesn't exist

I appreciate you getting back to us and providing screenshots for additional reference, MCWW.
 

Yes, you're right that the transactions you encircled are the ones that were automatically downloaded from the bank. Any deleted accounts that are not showing up, even after including the inactive accounts, need to be fixed, and I'm here to help you with that.

 

To isolate this, you can log in to your account using a private browser or an incognito window. This will help us determine if the issue is related to your browsing data or extensions.
 

  • For Chrome: Ctrl Shift N
  • For Firefox: Ctrl Shift P
  • For Safari: Command Shift N

 

Another way is to use compatible browsers when accessing QuickBooks Online. It optimizes and minimizes potential compatibility issues. 

Moving forward, you can access the Categorized tab and undo any duplicate transactions that aren't part of your reconciliation.  Here's how:

 

  1. Go to the Transactions menu.
  2. In the Bank transactions, go to the Categorized tab.
  3. Find the duplicate transaction and select Undo.

 

If you suspect that someone has made changes to your work in your books, you can use the Audit log feature to view the activity history. 

 

Additionally, you can utilize these articles when reviewing and reconciling your accounts:

 

 

If you have further concerns about addressing unexpected issues with accounts and transactions, please let me know by commenting below.

MCWW
Level 2

Dumplicate transactions belong to account that doesn't exist

Hello - thank you for the help.  As you can see below, I cannot "Undo" the categorization for the two items shown because they are associated with the deleted account.  Please advise.

 

MoreErrors.png

MCWW
Level 2

Dumplicate transactions belong to account that doesn't exist

Please ignore the above post - I have found the transactions and was able to "unclear" them and zero them out.  Thank you.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us