Skip to main content
M
MCWW
November 21, 2023
Solved

Dumplicate transactions belong to account that doesn't exist

  • November 21, 2023
  • 1 reply
  • 0 views

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!

Best answer by SarahannC

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.

1 reply

Angelyn_T
Angelyn_T
November 21, 2023

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!

M
MCWWAuthor
November 21, 2023

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.

 

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

 

 

 

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.

 

 

 

 

 

 

 

 

S
SarahannCAnswer
November 22, 2023

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.

Terms & ConditionsAccessibility statement