cancel
Showing results for 
Search instead for 
Did you mean: 
hartmannroofing
Level 1

Is it possible to upload/import bank transactions for previous year? Example 2019?

I’m In May 2020 now
4 Comments 4
KathyS296
Level 4

Is it possible to upload/import bank transactions for previous year? Example 2019?

Yes, if you are able to get the file from your banking institution. Use Web Connect.

Candice C
QuickBooks Team

Is it possible to upload/import bank transactions for previous year? Example 2019?

Good Morning, @hartmannroofing

 

Helping out with importing transactions is my specialty. Yes, you can import bank transactions from the previous year. If you go to your bank's website, you'll be able to download transactions from there into an Excel CSV file. Note: Some financial institutions only allow you to go back so far to download them. Example: 90 days, one year, etc. 

 

Once you've downloaded the transactions into a CSV file, you can follow the steps below on how to import. 

 

  1. Go to the Banking tab on the left-hand side of the screen. 
  2. Select the Banking section. 
  3. Press File upload on the banking page. 
  4. Pick Browse and choose the file you download from your bank. 

 

Here's an article that can give additional details on your question: 

 

 

If there's anything else I can help you with, just let me know. Have a wonderful day!

WaqasNasir
Level 1

Is it possible to upload/import bank transactions for previous year? Example 2019?

Hi, 

I upload bank transactions for year 2020 manually. Afterwards, my client connect bank with qbo in the current year 2021. And give it another name.

E.g EDI busn checking. 2021.

Wells Fargo checking 2020 is the one which was already entered.

 

 

In this scenario, is this thing alright?

Rasa-LilaM
QuickBooks Team

Is it possible to upload/import bank transactions for previous year? Example 2019?

Thanks for joining this thread, WaqasNasir.


Let me help and guide you on the right path on how to input your bank accounts in QuickBooks Online (QBO).

 

We’ll have to merge these accounts to ensure your records are in order. Please know that this process is permanent.


To begin, unlink your EDI business checking 2021. This way, you can consolidate it smoothly.


Here’s how:

 

  1. In QBO, go to the Transactions menu on the left panel and select Banking.
  2. This action will take you to the Transactions page.
  3. Click the Blue tile action and pick EDI business checking 2021.
  4. Tap the Pencil icon and then press the Edit account info link.disco olb.pngdisco olb1.png
  5. In the Account window, navigate to the Connected to section and tick the box for Disconnect this account on save.disco olb1.pngdisco olb1.pngdisco olb.png
  6. Press the Save and Close button.

This reference provides in-depth information on how to disconnect or delete accounts connected to online banking. Now that we’ve already disconnected it, you can now combine your EDI business checking 2021 with Wells Fargo checking 2020. Since the former is the one linked to the bank feeds, make sure to keep it.


For the step-by-step process, check the following resource: Merge duplicate accounts, customers, and vendors in QuickBooks Online. Once done, connect your EDI business checking 2021 to the bank feeds to start fetching new transactions.


For future reference, this write-up will guide you on how to classify downloaded entries to the correct category: Categorize and match online bank transactions in QuickBooks Online. You’ll also learn about excluding personal or duplicate transactions.


Don’t hesitate to visit the Community again if you have other banking concerns. I’ll get back to make sure you’re taken care of. Have a great rest of the day.

Need to get in touch?

Contact us