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

Importing older bank transactions

I recently created a QBO account and am trying to import transactions from 1 Jan 2019 - 31 Dec 2019. Unfortunately, M&T only export transactions from the last 90 days which means I can only go as far back as 31 Oct.

 

I've spoken to M&T and they say it's a Quickbooks question. Has anyone else had this problem? If so, can you please tell me how you resolved


it?

 

Thanks in advance! 

1 Comment 1
RCV
QuickBooks Team
QuickBooks Team

Importing older bank transactions

Let me share some information about downloading bank transactions into your account, Cfaa004.

 

I've checked here on our end and there's no reported case about this one. When connecting to Online banking, QuickBooks Online (QBO) automatically downloads the bank transactions for the last 90 days (or more).

 

To upload the older transactions from your bank, just use the Web Connect feature to manually download them. Before doing this, let's get the date for the oldest transaction in your account to avoid duplicate.

 

Here's how:

 

  1. Click Accounting on the left menu.
  2. Select Chart of Accounts.
  3. Find the bank or credit card account you want to upload more transactions into.
  4. Then hit View register. 
  5. Scroll to the bottom of the list.
  6. Write down the date of the oldest transaction. In many cases, the oldest transaction is the opening balance.

 

Then, proceed to Step 2: Download transactions from your bank section in this article: Manually upload transactions into QuickBooks Online. Once done, continue to Step 7 to finish the importing process.

 

You can also import bank transactions into QBO using Excel CSV (comma-separated values) files. Just refer to this article for the steps and details: Import bank transactions using Excel CSV files.

 

Fill me in if you need a hand with categorizing your bank transactions or any QBO related. I'll be here to help.

Need to get in touch?

Contact us