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

Duplicate transactions - Balance Sheet out of balance

Good morning.  I have the strangest problem in QuickBooks.  I am ready to pull my hair out.

 

I had a number of reconciled accounts that suddenly went out of balance this week.  There are multiple credit card transactions that we had deleted that reappeared.  We undid all of the 2020 reconciliations, voided the duplicated and re-reconciled.  By the time we did this, the transactions were showing up again in the bank feed.  Only this time, there balance reduced cash by $30K.  But it did not reflect as a change in the bank rec, so now the cash rec is $30K different from the balance sheet.

 

I spent an hour and half on the phone with QuickBooks Tuesday night.  They told me it was a known issue and that tech support would reach out to me via email with a fix.  They did not give me a case number.

 

I called today and they have no record of the case or "the known issue" and I am back at square one.  I have used QuickBooks online since it first came out and always had good luck with tech support.  This year hold times have been crazy and I can't find a knowledgeable tech to fix or understand the problems.  Any assistance you could offer would be very helpful.

 

I asked if we could do a rebuild like QuickBooks desktop. They said that tool doesn't exist for online.  One option is to backup and covert the file to Desktop to see if it fixes it.  But I know from experience that the conversion will delete all of the bank recs and they will have to be done over.  Help??!!

 

I am of course under deadline to finish the 2020 info for the return.  I can't provide the "broken" Quickbooks file to the tax accoutant. 

9 Comments 9
AlexV
QuickBooks Team

Duplicate transactions - Balance Sheet out of balance

Hi corsettia!

 

Thanks for reaching out to us. Let me assist you with your transactions.

 

It's because of the newly added transactions why your reconciled accounts went out of balance. If the same transactions are showing again on the Banking, simply exclude and don't add them into your books.

  1. Go to the Banking or Transactions menu, then select the Banking tab.
  2. From the For Review tab, select the checkbox of the duplicate transactions to exclude.
  3. Select Exclude.

 

I've added this link on how to handle duplicate transactions: Exclude a bank transaction you downloaded into QuickBooks Online.

 

Also, I suggest reaching out to our Support Team again regarding the transactions that keep on downloading. Since you already reported this, they can check if there's any update about it.

  1. Click the (?) Help icon and enter Talk to a human (then type it again when prompted).
  2. When asked by the bot, enter "Banking".
  3. Select I still need a human, then proceed with Contact us or Get help from a human.
  4. Choose either Chat or Callback.

 

When running the balance sheet report, make sure to set the correct dates as well as the accounting method. Please check these articles on how to handle balance sheet and reconciliation issues:

 

In addition, the rebuild tool is unavailable in QuickBooks Online. If you need to back up and restore, you can upgrade to QuickBooks Online Advanced. 

 

Leave a comment below if you need anything else. I'll be here!

corsettia
Level 2

Duplicate transactions - Balance Sheet out of balance

This is not the same issue as you are mentioning.  The transactions keep coming in by themselves over and over again.  We are not adding them to the bank rec and they keep populating back again and again.

 

Support told me on Tuesday night after and hour and a half call that it was a known issue.  The balance sheet is now out of balance for 32K for transactions in the bank that are not on the rec.

 

Now they can't find they case.  I am trying to get this completed for 2020 return to be filed.  I can't send out of balance transactions to the tax accountant.  

 

I asked today for a supervisor to call me and haven't heard anything back.

Test2Go
Level 5

Duplicate transactions - Balance Sheet out of balance

Always refer to your bank statement when reconciling an account. If a transaction is missing in the register, create it. If one is there but is not supposed to be there, delete it.

 

corsettia
Level 2

Duplicate transactions - Balance Sheet out of balance

This is not the same issue that I am having.

 

Transactions are posting themselves (not through the feed) over and over again that have been deleted. My balance sheet is out of balance by 30K from the bank rec.  

 

Support said on Tuesday that it was a known issue and they were working on a fix.  Today they have no record of the call or the outstanding issue. I am way beyond frustrated.

 

I have let my client know that this QuickBooks issue is going to prevent us from supplying the tax accountant with the financials.  Please help!

corsettia
Level 2

Duplicate transactions - Balance Sheet out of balance

I have deleted the additional transactions 5 or 6 times.  You can see all of the deleted transactions but it keeps reposting the same transaction over and over again without going to the feed.

 

Tuesday they said existing issue and upper level tech working on it.  Today no one has ever heard of it...

 

KlentB
Moderator

Duplicate transactions - Balance Sheet out of balance

I know that this hasn't been easy for you, corsettia.

 

Let me route you the best support so this will be taken care of as soon as possible.

 

To follow up on your case, I'd recommend getting in touch Customer Care Team. One of our representatives will pull up your account details and check the status of your case and the performed investigation. Here's how to connect with us:

 

  1. Go to the Help icon.
  2. Select Talk to a human.
  3. Enter "Talk to a human" again in the search bar.
  4. Choose I still need a human, then click Contact us.
  5. Select Get a callback or Send a message to start a conversation.

I'm also adding these articles to help fix common issues and errors in the Balance Sheet:
 

If I can be of any additional assistance, please don't hesitate to leave a comment below. I'll always have your back.

corsettia
Level 2

Duplicate transactions - Balance Sheet out of balance

I have done this twice.  It did not work.  My issue is not resolved and I can't talk to a human who knows what they are doing.

 

I want you to understand that 99% of people will reach out to a CPA for an opinion on Software.  I will be telling my clients Quickbooks online can no longer support the platform.

Jen_D
Moderator

Duplicate transactions - Balance Sheet out of balance

Thanks for posting here again and sharing with us your feedback and experience, @corsettia,

 

I know how it can be frustrating to be held up like this when you just want to get this reporting issue sorted out.


We want to ensure you're able to get in touch with our Support Team so they can look into this and provide a fix. To speak with a live rep, follow the steps below:

 

  1. Go to the Help menu in QuickBooks, then choose the Search tab.
  2. At the bottom click on Contact us.
  3. Enter the keyword Account Management and Billing in the What can we help you with? box.
  4. On the next screen, scroll down to How would you like to connect with us section.
  5. Choose Chat with us to initiate a discussion with a live agent.
  6. Enter you account contact information then press Get a chat.
  7. When using this option, make sure to enable pop-up windows. The chat box will appear at the bottom right section of your monitor, and an agent will be with you shortly after. See this:

 

When you're connected, provide all the information about your concern or request a viewing session with out representative.

 

Post here again after contacting our support. I want to make sure you get the answers you need with the Balance Sheet problem and I'll be right here if you need further help. Have a nice day!

corsettia
Level 2

Duplicate transactions - Balance Sheet out of balance

I have contacted support repeatedly.  The last time they said it is a known QuickBooks issue under case [removed] and that I will be contacted when it is resolved.

Need to get in touch?

Contact us