Skip to main content
January 16, 2022
Question

How do i get bank to import complete list of transactions?

  • January 16, 2022
  • 1 reply
  • 0 views
Original commenter did not share additional details

1 reply

January 16, 2022

Hi, randy-schuh12.

 

I'm here to help you download the list of transactions in QuickBooks Online.

 

QuickBooks only downloads for the preceding 90 days when you connect your bank or credit card account for the first time. You can manually upload bank transactions in QuickBooks Online. Just download the remaining transactions directly from your bank website. Your bank may offer QuickBooks Online data (QBO) format or CSV files.

 

Get transaction from your bank:

 

  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. Save the file somewhere you can easily find it, like your computer's desktop.

 

Manually upload the transactions for accounts connected to online banking:

 

  1. Go to the Banking menu, then the Banking tab.
  2. Select the blue tile for the account you want to upload the transactions into.
  3. Click the Link account dropdown, then Upload from file.
  4. Hit Browse, then locate the file you download from your bank. Then Next.
  5. In the QuickBooks account dropdown, choose the account you want to upload the transactions to. Then Next.
  6. Follow the onscreen steps to match the columns on the file with the correct fields in QuickBooks. Then select Next.
  7. Checkmark all the transactions you would like to import. Then Next.
  8. Hit Yes, then Let's go.

 

For account not connected to online banking:

 

  1. Go to the Banking menu, then Upload transactions.
  2. Select Drag and drop or select files and then locate the file you downloaded from your bank.
  3. Click Continue.
  4. In the QuickBooks account dropdown, choose the account you want to upload the transaction into. Then Continue.
  5. Follow the onscreen steps to match the columns on the file with the correct fields in QuickBooks. Then select Continue.
  6. Checkmark all the transactions you would like to import. Then Continue.
  7. Hit Yes, then Done.

 

You can review this resource for the complete procedure: Manually upload transactions into QuickBooks Online.

 

Once your transactions are in QuickBooks, you may match and categorize them to make sure they go into the correct account.

 

Please don't hesitate to post if you have other questions in handling your bank transactions. I'm just here to help out.