Question

Missing bank feed transactions

Forum|Forum|4 years ago
January 4, 2022
7 replies
0 views

Hi.

For the last two months or so my bank feed is missing random transactions, several each month. They are not all in batches but dotted throughout the month here and there.

What might be causing this, please?

QuickBooks Online

A

Ashleigh1

Hello AB74,

Welcome to the Community page, is there any error codes or messages showing up at all on your account? What bank is it and what account type is it as well?

A

AB74Author

No error messages.

It's a Sterling business current account.

AlcaeusF

Hi @AB74,

I appreciate you for adding more information about your bank. I can share some details about how the Banking feature works in QuickBooks.

When you link a bank account in QuickBooks, your transactions download automatically. The data that is imported into our system will depend on the information your bank shares with us.

If there are missing transactions, I recommend checking your bank's website. It may be possible that they aren't showing yet in your account.

If it's already reflected on the website, I suggest refreshing the account. You can use the Update button to refresh the connection with your bank.

Here's how:

On the left navigation bar, click Banking.
Select the account.
Press Update.

I've also attached an article you can use to import a CSV file manually from your bank into QuickBooks: Manually upload transactions into QuickBooks Online.

Fill me in if you have additional questions about bank feeds or downloading bank data. I'm always here to help. Take care always.

A

ACII

Had the same issue with RBC visa feeds. Read through entire thread and nothing QBO suggested solved problem. had to manually add the transactions through a Journal entry.

T

Trish_T

Hi ACII,

Thanks for reaching out here. QuickBooks Online provides the option to upload transactions manually in cases such as this. Whether you're unable to automatically update or have missing transactions for a previous period. I'll be happy to provide more information so you can complete your banking goals!

When you manually upload your transactions in csv. format, you'll select the desired date range on your bank's website. When you login to your bank and review the transaction history, you can select a specific date range. Once you've reviewed the items in the list, you'll download it in csv. format and save it to your computer. It's important to make note of the last transaction in QuickBooks to prevent duplicate entries. Continue by following these steps;

1. From Settings ⚙ in the top right of your dashboard, select Chart of Accounts

2. Locate the account in your list and select Account History to the far right

3. Write down the Date of the last transaction

Next, you'll login to your bank's website and download your transactions in csv format. Select the date range based on the last transaction in QuickBooks Online. Open the file and format it prior to uploading it into your bank feed. I recommend the 4-column format to keep the debits and credits separate. Save the file when finished.

Here's how to upload the transactions:

1. Login to QuickBooks Online, open Transactions from the left menu, select the Banking tab

2. Click the blue tile for the account you're uploading the transactions into

3. Select the ▼ dropdown arrow beside Link account and then Upload from file

4. Hit Browse and select the csv. file you downloaded from your bank, then click Next

5. From the Account ▼ dropdown, choose your account and hit Next

6. Follow the onscreen steps to match the columns on the file with the correct fields in QuickBooks and hit Next

7. Select the transactions to import and continue through the prompts

8. Choose Yes

9. Hit Let's go

Here's how to remove duplicate entries;

1. From the Review tab, checkmark the box beside all duplicated entries

2. Select Exclude from the tab that appears

Note: You can permanently delete the transactions from the Excluded tab by selecting all items and then hit Delete. This process is irreversible and any transactions deleted in error will need to be recreated manually.

If you'd like assistance with this process, please don't hesitate to contact us. It would be our pleasure to work with you directly and ensure you're back to business as soon as possible.

Feel free to let us know if this has been solved. Your success is important and we're always pleased to help!

A

ACII

For readers don't bother with QBO recommendations. if you are missing sporadic transactions from bank feeds, just create an entry (expense, deposit, JE) to fix. this is easiest solution. QBO does not seem to understand the issue or they would suggest the same thing.

J

Jon557

Same issue here, can't trust the dodgy bank connection feature at all. It randomly misses off income lines and my figures are all wrong, how can they sell a service so flaky! I need my accounts penny perfect.

K

KMA2020

Sorry to reactivate an older feed, but I have spotted the same issue with Starling accounts and QuickBooks. If someone from QuickBooks is listening, this issue really needs to be sorted. It is ridiculous I have to go through bank statements every VAT quarter to identify missing transactions.

A

Ashleigh1

Hello KMA2020, thanks for posting on this thread and leaving that feedback we will be sure to pass it on to get looked into.

C

Chr2

Did this ever resolve for you? I have had the same issue repeatedly with QBO, to the point where I am pretty done with the platform. Support tells me the same thing every time to update/refresh and that should do it... but dotted transactions are still missing everywhere making it incredibly frustrating to recon.

E

Ethel_A12

Hello there, @Chr2.

I appreciate your jumping into this thread and let us know you had the same concern. I'll help you in recovering those missing bank transactions,

Have you recently changed anything on the bank's website, such as your account number, login, or password? The reason for missing transactions could be due to this.

I can see you already tried updating your bank accounts and still having the same issue.

I recommend checking your uncategorized accounts. The missing transaction may be there.

Here's how:

Go to the Accounting menu.
Select the Chart of Accounts tab.
Look for the Uncategorized Income or Uncategorized Expenses account.
Select Run report.
Look for your missing transaction on the report.

If you still can't locate them, you can manually download and import the missing bank transactions into QuickBooks from your bank's website. Download CSV files of your transactions after logging into your bank's website. Below are the articles I've provided for more insights:

Once everything is back in order, you can begin categorizing 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.

E

emmam6

Hello Community Users, We just wanted to add onto this thread regarding missing transactions. If you have missing transactions and they are for a recent period like the past 24-48 hours it could be that bank has not updated which is when we would recommend using the update or accessing Quickbooks via a private window on the browser and loading the banking screen.

If you get an error refer to this guide on banking errors

If it is a longer period and it looks like the connection has stopped updating it is worth doing a complete disconnection of the banking connection( chart of accounts>edit under the drop down next to account history on the account>disconnect account on save>save and close) Then reconnecting via the banking page.

If the missing transactions are not recent and are sporadic. Report them here on this thread and we'll raise this with our senior technicians . We'd advice manually uploading the missing transactions via a CSV

Any questions or to report an issue please feel free to add them here

M

markus-wa

having the same issue with 3 missing transactions from about 2 weeks ago

this is pretty unacceptable as it keeps happening randomly throughout the year and messes up my reconciliation. tracking the missing transactions down manually is really tricky ...

please look into this again

A

Ashleigh1

Hello Markus-wa, thanks for posting on this thread, we have passed this on so it can be looked into more.

S

Sarah Wittridge

We have been experiencing random sporadic missing transactions for Starling across mulitple clients for months now.

It's not acceptable. It's making our data and reports unreliable.
Having to manually upload the missing transactions is time consuming as have to manually go through physical bank statements to identify which transactions are missing before we can upload.
Clients are also getting frustrated that we have to ask them to download statements each month for them - they say "why do we need to download statements when there is automatic bank feed" and we have to tell them it's not working properly which they then get anxious about.

Honestly thinking of moving all Starling clients across to Xero!
I spoke to someone at QBs support today about this and they said that QBs wasnt aware of any Starling issues and that it may be Starling not sending the transactions to QBs. We can't call Starling on clients behalf as they wont speak to us which means we would potentially need to ask the client to call which they won't want to do!
Please get this sorted QBs!!!!

A

Ashleigh1

Hello Sarah, thanks for posting on this thread and bringing this to our attention we have passed this on to the higher team to look into more.

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded