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

How to access transactions past a certain date

I just created my quickbooks account and am trying to sort my expenses and income. When connecting my bank account to qb, I clicked the custom date range option and selected 11/01/2020 as the beginning from when to pull transactions from, however in the quickbooks banking tab, It will only show transactions starting from 2/26/2021 to present. There are some major expenses I want to including in my books from before 2/26/2021, so this is frustrating to me. I tried to delete my bank account and re-connect it,  but this did not solve the isssue. 

2 Comments 2
MirriamM
Moderator

How to access transactions past a certain date

Welcome to the QuickBooks family, @rachelgrimes38.

 

I'm here to lend a hand with your bank transactions concern.

 

In QuickBooks Online (QBO), once you connect your bank account, it brings the last 90 days of your transactions by default or more depends on your bank. To get older transactions to show on your QBO account, you can download the file from your bank website and manually import the other transactions into the program. To do this, here's 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. 
  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, then save the file on your computer.

After that. review the format and size of your downloaded file. You can use this link as your guide: Format CSV files in Excel to get bank transactions into QuickBooks.

 

Once verified, you're now ready to upload the transactions into QuickBooks manually. And when the transactions are downloaded, start categorizing and matching them

 

If you need additional help with your banking transactions, let me know by adding a comment below. I'll be right here to provide additional assistance. Have a great day.

rachelgrimes38
Level 1

How to access transactions past a certain date

I was getting an error message when uploading the csv file, but I was able to connect qbo to my bank account again and the past transactions showed up that time. Thanks for your help.

Need to get in touch?

Contact us