Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
muttsbefantastic
Level 1

How do I link last year's bank transactions so I can sort through my 2023 spending? It will not let me access before January 14th.

 
2 Comments 2
LollyNino_C
QuickBooks Team

How do I link last year's bank transactions so I can sort through my 2023 spending? It will not let me access before January 14th.

Greetings! @muttsbefantastic. Thank you for posting here in the Community. Let me share some information on linking your bank transactions in QuickBooks Online (QBO).

 

When you connect your bank account with QuickBooks Online, it will automatically download transactions from most banks for up to 90 days or more, depending on your financial institution. However, you can also manually upload transactions to QBO. To ensure that there are no duplications and to maintain accuracy, it is best to obtain a CSV file of the month(s) that are not yet in QBO by contacting your bank.

 

Log in to your bank's website. Then, download your transactions in a CSV file. Once that's completed, we can proceed with the following steps to manually upload them into QuickBooks. After that, here's how to manually upload the transactions:

 

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

 

For the detailed procedures, you can check out this article to further guide you: 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’m always ready to assist you with other questions or concerns about managing your bank transactions. Tag me in your reply, and I'll get back here as soon as possible to help you again. Have a great day ahead!

4Gal
Level 11

How do I link last year's bank transactions so I can sort through my 2023 spending? It will not let me access before January 14th.

@muttsbefantastic 

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

 

 

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us