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.
Zsmith1
Level 1

Importing linked bank transactions from a previous year

I’ve been using QuickBooks since 2019. Switching to online was the biggest mistake I’ve ever made. None of the features work 100%, I’ve tried to add my cc card today and every time I get to the page where it asks how far back would I like to add the transactions, the screen freezes. I tried on my iPhone 14 pro max, iPad (safari and Firefox). Then when I managed to add the acct on the mobile app. It only imported 2024 and I’m unable to import 2023. I work in the tech sector in development and it’s unreal what a dumpster fire this is. For as much money intuit charges for this, it should be fluid. I’m extremely motivated to do away with this software this year and will be sure to advise as many of my business owner friends to steer clear.

2 Comments 2
On Beta
Level 6

Importing linked bank transactions from a previous year

You can use MT Online or one of the converter tools with a one time license (e.g csv2qbo @ $60) for the time being.
https://www.moneythumb.com/?ref=110

 

Otherwise, consider switching back to QB Desktop to keep using the bank feed feature.

AdonL
QuickBooks Team

Importing linked bank transactions from a previous year

It is not the experience we want you to have, Zmith1. I see your point, and I appreciate your detailed description of the issue. I'd be glad to provide insights to help you import your bank transactions from the previous year into QuickBooks Online (QBO).

 

When you connect your credit card to QBO, the system will only download bank transactions within the last 90 days, depending on your financial institution. That is why you can't download the previous year's transactions on either one of your devices.

 

To address this, let's import the remaining bank transactions manually. This process will ensure your financial records are complete and accurate, reflecting all transactions from this year and the previous one.

 

Let's begin by downloading the transactions from your bank or credit card. You can refer to the steps below:

 

  1. Sign in to your bank or credit card's website.
  2. Follow your bank's instructions for downloading CSV files of your transactions to your computer. Every financial institution has different steps. Here are steps for Bank of AmericaChase, and Wells Fargo.
  3. Check the date range for the download. It should be at least one day before the date of your oldest transaction.
  4. Download your transactions and save the file somewhere you can easily find it, like your computer's desktop.

 

Your bank may offer a few file formats. Please review the correct format and size before uploading the file. Once you've verified the format and size, manually upload the transactions to QBO using these steps:

 

  1. Go to Transactions and select Bank Transactions.
  2. Choose the account you want to upload to.
  3. Select the Link account dropdown, then select Upload from File.
  4. Select files or drag and drop and choose the file you downloaded from your bank. Then, select Continue.
  5. In the QuickBooks account dropdown, select the account you want to upload the transactions. Then, click Continue.
  6. Follow the onscreen steps to match the columns on the file with the correct fields in QuickBooks. Then select Continue.
  7. Select the transactions you like to import. Then select Continue.
  8. Click Yes to confirm and Done to Complete.

 

If you need steps to review bank and credit card transactions to avoid double entries, please refer to this article: Categorizing online bank transactions.

 

Moreover, I'm adding this article that tackles reconciliation to ensure your account is balanced and accurate: Reconciling an account.

 

If you need more help importing your bank transactions, please don't hesitate to leave a comment below. We're always here to ensure your pending tasks in QBO are seamlessly carried out. Have a great day!

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

Need to get in touch?

Contact us