cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
NEW Connect to DBS IDEAL direct bank feeds Click here
info852
Level 1

How long back can you link the bank account with quickbooks? Can you go as far back as 2017 and beyond?

 
1 Comment 1
Rea_M
Moderator

How long back can you link the bank account with quickbooks? Can you go as far back as 2017 and beyond?

Hello there, info852.

 

QuickBooks automatically downloads the last 90 days of your transactions after you connect your bank accounts. Since you want to go back as far as 2017 and beyond, you can manually upload them into your account. Let me guide you how.

 

To start, you need to make sure you don't import transactions you've already recorded. This will prevent duplicates. Here's how:

  1. Go to the Accounting menu.
  2. Select Chart of Accounts.
  3. Find the bank or credit card account you want to upload more transactions into.
  4. Choose Account history.
  5. Scroll to the bottom of the list.
  6. Write down the date of the oldest transaction. 

 

Next is to download your transactions from your bank. Follow your bank’s instructions on how to download them to your computer and save it somewhere you can easily find it.

 

Then, review the file format and its size. Please make sure to select either the Comma-Separated Values (CSV) or the QuickBooks Online (QBO) format. The maximum file size is 350 KB.

 

Once done, you can now upload your file to your QuickBooks Online account. Here's how:

  1. Go to the Banking menu.
  2. Choose the Banking tab.
  3. Select the blue tile for the account you want to upload the transactions into.
  4. Click the Update drop-down arrow, then select File upload.
  5. Select Browse, then select the file you downloaded from your bank.
  6. Click Next.
  7. Select the account from the QuickBooks account drop-down menu, then select Next.
  8. Follow the onscreen instructions.
  9. Click Let's go to add the transactions to your account.

 

After the process, you can go back to the Banking menu to categorise and add the transactions. You can refer to this article for the detailed steps: Match and categorise bank transactions in QuickBooks Online. It also contains information on how you can exclude your personal and duplicate transactions.

 

Moreover, I'd also recommend reconciling your account every month. This will ensure your books are accurate. To learn more, kindly check out this article: Reconcile an account.

 

Please let me know if you have other concerns. I'm just around to help.