Skip to main content
A
AlamoRyde
October 6, 2020
Solved

5 weeks bank transactions missing from bank feed

  • October 6, 2020
  • 1 reply
  • 0 views

All transactions between 28/03/20 and 04/05/20 are missing from my bank feed.  This was during the period where the bank feed changed to the new system and bank transactions couldn't be downloaded automatically.  I have been trying to sort this out for months without success.  My bank (Barclays) won't let me download transactions older than one month.  Any help gladly received.

Thanks

 

Best answer by jamespaul

Hello, AlamoRyde.
 

I appreciate the efforts trying to sort the missing transactions out. Look no further because I'm here to help you get them into QuickBooks Online. 

 

You'll want to manually import those missing transactions from Barclays. Simply get a CSV file (for transactions between 28/03/20 and 04/05/20) from your bank account, then upload it into QuickBooks Online.

 

After getting the file, here's how you can import it to your QBO account: 

 

  1. Go to Transactions, then click the Banking tab.
  2. Click the arrow icon beside Update under your Barclays account.
  3. Choose Upload from file.
  4. Browse for the file you've downloaded, then hit Next.
  5. Follow the prompts to map and import your file successfully. 

 

 

If you'd like to know more about the process, you can check these articles: 

 

After importing the missing transactions, you can start categorising and matching them. 

 

When you're ready, reconcile your bank to ensure your books are accurate and all accounted for. If you need help with the process, visit this article: Reconcile an account in QuickBooks Online.

 

Happy to help you out again if you have other concerns with your QuickBooks Online tasks. Just add your questions in this thread and I'll be there. 

1 reply

J
jamespaulAnswer
October 6, 2020

Hello, AlamoRyde.
 

I appreciate the efforts trying to sort the missing transactions out. Look no further because I'm here to help you get them into QuickBooks Online. 

 

You'll want to manually import those missing transactions from Barclays. Simply get a CSV file (for transactions between 28/03/20 and 04/05/20) from your bank account, then upload it into QuickBooks Online.

 

After getting the file, here's how you can import it to your QBO account: 

 

  1. Go to Transactions, then click the Banking tab.
  2. Click the arrow icon beside Update under your Barclays account.
  3. Choose Upload from file.
  4. Browse for the file you've downloaded, then hit Next.
  5. Follow the prompts to map and import your file successfully. 

 

 

If you'd like to know more about the process, you can check these articles: 

 

After importing the missing transactions, you can start categorising and matching them. 

 

When you're ready, reconcile your bank to ensure your books are accurate and all accounted for. If you need help with the process, visit this article: Reconcile an account in QuickBooks Online.

 

Happy to help you out again if you have other concerns with your QuickBooks Online tasks. Just add your questions in this thread and I'll be there. 

A
AlamoRydeAuthor
October 7, 2020

Thanks for you reply.  I have now found how to download older transactions with Barclays.  Thanks for your help.

G
GeorgiaC
October 7, 2020

Hi AlamoRyde, 

 

There would be no way to recover these now through the live bank connection, you would need to refer to your bank statements and enter these manually or contact your bank to see if there is a way to export this data. 

 

Thanks 🙂

Terms & ConditionsAccessibility statement