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

How do I select a Date range for download banking transactions

Is there a way to select a date range to download banking transactions?
1 Comment 1
Carneil_C
QuickBooks Team

How do I select a Date range for download banking transactions

Hi there, userjmproductdesign.

 

I'll help you select a date range before downloading your bank transactions into QuickBooks Online.

 

If you're connecting the bank for the first time, you'll be able to choose a date range for the transactions that you're about to download. You can refer to this screenshot below for your visual reference:

image.png

 

Otherwise, when you're about to enter those transactions, you need to know the date of the oldest existing transaction present in the account first to avoid duplicates. I'll show you how:

 

  1. Go to the Bookkeeping menu, then select Chart of Accounts.
  2. Choose the bank or credit card account you want to upload the transactions.
  3. Click View register.
  4. Find and write down the date of the oldest transaction. The oldest transaction is usually the opening balance.

 

Then, you can obtain transactions from your bank and check the date range before uploading it. 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. Every financial institution has different steps.
  3. Verify 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 them somewhere you can easily find them, like your computer's desktop.

 

For the next detailed step-by-step process, you can check Steps 3 to 6 in this article: Manually upload transactions into QuickBooks Online.

 

On top of that, these handy resources can help you organize your transactions flawlessly in the future:

 

 

I’m always ready to assist you if you have more questions or concerns about managing your bank transactions. Take care always.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us