cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Get unlimited expert tax help and powerful accounting in one place. Check out QuickBooks Online + Live Expert Tax.
CBMedia
Level 1

Bank Register Not Downloading Old Trasnsactions

Hi, there! 

I'm going back through years of old transactions to reconcile them and clean up our bookkeeping. About halfway through April 2019, all of the transactions that appear in my bank statements do not appear on the register and I cannot reconcile. 

Quickbooks says it is synced with my bank and the current amount in the account matches but it is clear that Quickbooks did not download many transactions over the last few years. 

What do I do? Do I need to manually enter every missing transaction? At this point, it makes me wonder why I even have Quickbooks because I feel like I could do all of this much easier with an Excel spreadsheet.

Thanks!

5 Comments 5
JamaicaA
QuickBooks Team

Bank Register Not Downloading Old Trasnsactions

Yes, you can manually add your older transactions in Quickbooks Online, @CBMedia. I’m here to walk you through the process and ensure you can reconcile them successfully.

 

When you connect your bank into QuickBooks, the system downloads up to the last 90 days of transactions. Since you need to fetch older items for your online banking, you have the option to upload them manually.

 

First, let's download the old transactions from your bank's website. Then, map the transactions in the following supported formats or file types. To guide you further, please follow these steps:

 

  1. Sign in to your bank's website.
  2. Follow the instruction provided on your bank to download your transactions.
  3. Then, save the file on your computer.

 

Once done, upload them to your QBO account. Here are things to follow:

 

  1. Go to Transactions or Banking on the left panel.
  2. Within the Banking page, click the Link account drop-down arrow.
  3. Select Upload file. Another window will appear.
  4. Click the Browser button. Then, select the file saved from your bank.
  5. Hit the Next button.

 

Here are the sample screenshots for additional reference:

https://lithium-response-prod.s3.us-west-2.amazonaws.com/intuit.response.lithium.com/RESPONSEIMAGE/9c370c67-f90c-4cde-a6d2-a283943bc2f7.default.PNG

https://lithium-response-prod.s3.us-west-2.amazonaws.com/intuit.response.lithium.com/RESPONSEIMAGE/5488b859-5671-494c-b0b4-5a58f4508da7.default.PNG

 

I've attached here an article to guide you with the process: How to upload more than 90 days of bank transactions?

 

I'd like to include these resources that provides more details on how to handle the imported transactions in QuickBooks Online:

 

 

Please let me know how it goes. I'll be here to help if you have other questions about your bank statements. Have a good one.

Fiat Lux - ASIA
Level 15

Bank Register Not Downloading Old Trasnsactions

@CBMedia 

Another option, utilize MT Online as a workaround. It is designed to import into any bank or credit card in QuickBooks Online, so there is no specific setting needed. 

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

 

CBMedia
Level 1

Bank Register Not Downloading Old Trasnsactions

Thank you, thank you! I'm going to try this in the morning.

CBMedia
Level 1

Bank Register Not Downloading Old Trasnsactions

I'm struggling with this a little bit because Quickbooks has been connected to my bank since before the missing transactions. So, there are some transactions from the period in question in Quickbooks but not ALL of them. I'm worried about ending up with duplicate transactions. Is there a way to avoid that if I manually upload? Thank you again!

Fiat Lux - ASIA
Level 15

Bank Register Not Downloading Old Trasnsactions

Utilize the trial version of a backup restore app to lower any risk.

https://rewindio.grsm.io/quickbooks

 

Then you should be able to filter what you are about to import to avoid duplication.

 

Get answers fast!
Log in and ask our experts your toughest QuickBooks questions today.

Need to get in touch?

Contact us