Skip to main content
February 10, 2023
Question

Can qbol upload only a few weeks of transactions when we connect with the bank? "Help" link said we would be able to stipulate how many months of transactions to upload?

  • February 10, 2023
  • 1 reply
  • 0 views
Original commenter did not share additional details

1 reply

February 10, 2023

Glad to see you here in the Community, @tess12. Let me provide you with some details about your clarification about the allotted time frame for the bank transactions to be sync QuickBooks Online (QBO).

 

When you connect your bank account in QuickBooks Online, the system will automatically download up to the last 90 days (3 months) worth of transactions. Although it also depends on the bank, other banks can go back as far as 24 months.

 

If you want to sync transactions that are more than the allocated time frame, you can manually upload those transactions in QBO. To do this, just get the bank data from your bank using the supported file types, download it to Excel, and then upload it into QBO.

 

Here are the file types you can use:

 

  • Comma-Separated Values (CSV)
  • Quicken (QFX)
  • QuickBooks Online (QBO)
  • Microsoft Money (OFX)

 

Once ready, you can now upload your transactions into QBO. Follow the steps below:

 

  1. Go to the Banking menu and select the Banking tab.
  2. Click the blue tile for the bank account you want to upload the transactions.
  3. Select the Link account dropdown and then Upload from the file.
  4. Then Browse for the file you downloaded from your bank.
  5. In the QuickBooks account dropdown, locate the account you want to upload the transactions.
  6. Follow the onscreen steps to match the columns on the file with the correct fields in QuickBooks.
  7. Choose those transactions you would like to import and select Continue.
  8. Hit Yes and then click Done.

 

I'll share some articles that you check out for more details on uploading bank transactions to QBO:

 

Once all your transactions are in QuickBooks, you'll want to ensure all entries are accounted for correctly, and with no duplicates, you can categorize and match them. Then, reconcile them to ensure the accuracy of your books and your bank statements.

 

Keep me posted if you need further assistance with managing your bank transactions or any other QuickBooks-related concerns. We'll be around to help you. Stay healthy!