Pleasure to have you here in the Community space, charisseann. Let me share some information on connecting bank transactions in QuickBooks Online (QBO). Once you link your bank account with QuickBooks, it will automatically download all transactions from most banks up to 90 days, or even older, depending on the financial institution, since they're the ones who allow third-party applications to access older transactions. To enter older transactions, you can do so by downloading a CSV file format from your bank and then uploading it manually in QuickBooks. However, let's ensure that the CSV file you're trying to upload is formatted correctly to meet QBO's requirements. Double-check the file format if it adheres to the guidelines and can be uploaded successfully. Additionally, I've attached these articles that explain the required format for uploading a CSV file: Format CSV files in Excel to get bank transactions into QuickBooks.Common errors for importing bank transactions using CSV in QuickBooks Online Moreover, you can follow the steps below on how to manually upload in QBO: Go to the Transactions tab and select Bank transactions.Choose the tile for the specific bank account to upload the transactions into.Click on the Link account dropdown and select Upload from file.Select Drag and drop or select files and choose the file you've downloaded from your bank. Then, click Continue.Continue the on-screen instructions to match the columns in the file with the correct fields in QuickBooks. Choose the transactions you wish to import. Then click Continue to proceed.Select Yes and click on Done. You can refer to this guide for the step-by-step instructions: Manually upload transactions into QuickBooks Online. Furthermore, you can check out this article to learn how to reconcile your accounts so they always match your bank and credit card statements in the future: Reconcile an account in QuickBooks Online. I'll be here if you've got additional questions regarding banking in QBO. We're always here to help. Take care.

Question

How to connect bank transaction automatically from last year. Accidentally only did to the first of this year and I need all of last years for P&L

Forum|Forum|2 years ago
February 17, 2024
2 replies
18 views

No text available

QuickBooks Online

C

Carl

Moderator

Pleasure to have you here in the Community space, charisseann. Let me share some information on connecting bank transactions in QuickBooks Online (QBO).

Once you link your bank account with QuickBooks, it will automatically download all transactions from most banks up to 90 days, or even older, depending on the financial institution, since they're the ones who allow third-party applications to access older transactions.

To enter older transactions, you can do so by downloading a CSV file format from your bank and then uploading it manually in QuickBooks. However, let's ensure that the CSV file you're trying to upload is formatted correctly to meet QBO's requirements. Double-check the file format if it adheres to the guidelines and can be uploaded successfully.

Additionally, I've attached these articles that explain the required format for uploading a CSV file:

Moreover, you can follow the steps below on how to manually upload in QBO:

Go to the Transactions tab and select Bank transactions.
Choose the tile for the specific bank account to upload the transactions into.
Click on the Link account dropdown and select Upload from file.
Select Drag and drop or select files and choose the file you've downloaded from your bank. Then, click Continue.
Continue the on-screen instructions to match the columns in the file with the correct fields in QuickBooks.
Choose the transactions you wish to import. Then click Continue to proceed.
Select Yes and click on Done.

You can refer to this guide for the step-by-step instructions: Manually upload transactions into QuickBooks Online.

Furthermore, you can check out this article to learn how to reconcile your accounts so they always match your bank and credit card statements in the future: Reconcile an account in QuickBooks Online.

I'll be here if you've got additional questions regarding banking in QBO. We're always here to help. Take care.

4

4Gal

Level 5

@charisseann08-ho

You can use MT Online or one of the converter tools (e.g csv2qbo @ $60 one time license) as a workaround.

https://www.moneythumb.com/?ref=110