Transactions missing from Quickbooks

I’m dropping by to share with you some details regarding the transactions that did not sync to your bank feeds in QuickBooks Online (QBO), billy.

One of the reasons that particular transactions did not go through could be that they weren’t cleared by the bank. In that case, you’ll want to manually upload this to keep your account balanced.

Concerning checking your transactions from the bank to your company file. The only option available is to manually work on that. QuickBooks Online will only depend on what your financial institution forwards to the application. Thus, verifying them will require you to base it on the bank statement manually.

Once you’re done checking your transactions. You can start categorising your transactions and reconciling them to avoid any discrepancies at the end of every period.

Feel free to add any other concerns you may have here. I’ll ensure you get the assistance you need. Have a good one!

@billygreenway 

Explore csv2qbo converter tool as a workaround. 

https://www.moneythumb.com/?ref=110

As an additional option, use a backup restore app to lower any risks.

https://partnerwithus.rewind.com/quickbooks

Thanks Rose,  what do you mean by the transactions “weren’t cleared by the bank”?  What other reasons might a transaction not sync?

the particular payment in mind definitely was cleared and took place over a month ago.

Thanks @Fiat Lux - ASIA, would the csv to pdf tool be able to tell what has been input to QuickBooks already?

for the second option, how would this work if the transaction was never synched with QuickBooks?

thanks

Welcome back billygreenway. I'm here to help you bring the missing transaction in no time.

Other causes of missing transfers include connection problems and bank changes. To see if there is a notification that needs to be handled, you may log in to your bank's website. 

You can directly enter that one transaction into the system that didn't sync to your account. If there are more transactions, you can consider getting a CSV file from your bank and uploading it into QuickBooks Online.

To know more about the process, check these articles:

• Manually upload transactions into QuickBooks Online
• Import bank transactions using Excel CSV files

If you need additional assistance with your QuickBooks Online tasks, please post your questions in the comment section. I'll be happy to assist.

Thanks for your answer.

The problem that I’m having is that I don’t know which transactions are missing and need to be added, and it would be too time consuming to go through every transaction that my company has done (there are thousands) to check if it needs manually importing.

How can I work out which transactions haven’t synched correctly and need importing?

thanks

Thanks for coming back to us, @billygreenway.

I understand that it's quite time-consuming to manually check and add the missing transactions in QuickBooks Online (QBO). The only way to enter them into QuickBooks is to compare the bank statements.

We can also check your uncategorised accounts. There's a possibility that the missing transactions are there.

Here's how:

1. Go to the Accounting menu, and then select Chart of accounts.
2. Look for the Uncategorised Income or Uncategorised Expenses account.
3. Hit Run report.
4. Look for your missing transaction on the report.

I've added these articles about downloading transactions using CSV files:

•  Manually upload transactions into QuickBooks Online
• Format CSV files in Excel to get bank transactions into QuickBooks

Once everything is back in order, you can begin categorising and matching your online bank transactions to post them into the appropriate accounts.

Stay in touch if you need further assistance finding those missing transactions. We're always here to help.

I have had the same issue over the past 3 years. It's not frequent, but once in a while there's a duplicated transaction or a missing one. It's a nightmare, and it means I have to check one by one against the bank statement. 

This month I have found 19 duplicated transactions and one missing. Their support line is just condescending and useless. It seems like a simple bug and it blows my mind they have raised their fees without resolving the root source of this issue.

I was actually wondering if anyone ever got a straight answer from QB besides the usual "Apologies, we do not know why this is happening"? 

This has happened to me.  Google Ads monthly charge appears to get eaten, along with that of FloDesk.  No explanation, no errors, just not present.  Were you ever able to get to the bottom of it?  this is an existential concern for my use of QBO, am strongly considering going elsewhere!

Welcome to the QuickBooks Community, stevew3. Please know that we aim to deliver customer satisfaction at all times and fix an issue as soon as possible. With this, may I ask for additional information on which particular bank account are you using to connect to QuickBooks? Also, any extra information about Google Ads charges? I appreciate any further details so I can present accurate information.

Don't hesitate to click the Reply button below and add extra details about your concern, stevew3. I'm always around to help.

Hi there, 

no unfortunately this happened for over an year. I spent days trying to find out which transactions were duplicated and which ones were not... tried to contact quickbooks countless times. At first QB assumed it was a bug in their system, but then, after not being able to resolve it, they started to blame everything and everyone else, tried to gaslight me by telling me maybe the transactions existed and it was my mistake, were extremely rude, etc... anyway, after one year and weeks trying trying to resolve this, we gave up on Quickbooks as I was wasting more time chasing duplicated transactions than the time I was saving. 

Good luck! Hope you find a solution as it's an authentic nightmare to use a tool you cannot trust...

Also... I was first told it was a known bug. 

Then afterwards, was told they never faced this issued before and I was the only person ever to encounter this (despite the countless forums I found complaining about the same).

Well, that's a complete lie. 

One year and you never resolved this issue. 

They have lost two whole tax years of confirmed transactions and invoices for me, you’re right about not being able to trust them. May I please ask who you now use as I will not continue to use them. I have no evidence now for either tax year :face_screaming_in_fear: