Skip to main content
C
CBMedia
September 11, 2022
Question

Bank Register Not Downloading Old Trasnsactions

  • September 11, 2022
  • 2 replies
  • 0 views

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!

2 replies

J
JamaicaA
September 11, 2022

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.

    C
    CBMediaAuthor
    September 11, 2022

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

    Fiat Lux - ASIA
    Fiat Lux - ASIA
    September 11, 2022

    @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

     

    Terms & ConditionsAccessibility statement