Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
matildajones1930
Level 1

How do I import a previous year's bank transactions?

I just purchased Quickbooks and imported my bank transactions for this year just to begin. Now I would like to import last year's bank transactions. But I don't see how to do this.
2 Comments 2
4Gal
Level 11

How do I import a previous year's bank transactions?

You can use MT Online or one of the converter tools (e.g csv2qbo @ $60 one time license) as a workaround.

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

 

RCV
QuickBooks Team
QuickBooks Team

How do I import a previous year's bank transactions?

Let me guide you on how to import last year's bank transactions in QuickBooks Online (QBO), Matilda.

 

We can get transactions from your bank or credit cards and manually import them into the program. To avoid entering duplicates, you need to know the date of the oldest existing transaction currently in the account:

 

  1. Go to the Gear icon on the top menu. 
  2. Select Chart of accounts (Take me there).
  3. You can also select Chart of accounts from the Transactions tab in the MENU ▼.
  4. Find the bank or credit card account you want to upload the transactions into.
  5. Click View register.
  6. Find and write down the date of the oldest transaction. Usually, the oldest transaction is the opening balance.

 

Once done, get the transactions form your financial institution. Let me guide you how: 

 

  1. Sign in to your bank or credit card's website.
  2. Follow your bank's instructions for how to download 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. Save the file somewhere you can easily find it, like your computer's desktop.

 

Your bank may offer a few file formats and you can pick the QuickBooks Online data (QBO) format. These are formatted specifically for QBO and you can also upload transactions from a CSV or Quicken (QFX) file. Once done, proceed to Step 3: Review the file format and size section in this article to finish the process: Manually upload transactions into QuickBooks Online.

 

In case you need steps on how you can review bank and credit card transactions to avoid double entries, you can refer to this article: Categorize online bank transactions in QuickBooks Online. Moreover, I'm adding this article that tackles reconciliation to ensure your account is balanced and accurate: Reconcile an account in QuickBooks Online.

 

If you need more help managing your bank transactions, please don't hesitate to reach out to me again. I'm here to ensure that your pending tasks are carried out seamlessly. Have a great day!

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us