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.
taz-tuesday-app
Level 1

How do i backdate to import transaction through online bank connection

 
2 Comments 2
4Gal
Level 11

How do i backdate to import transaction through online bank connection

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

 

jenop2
QuickBooks Team

How do i backdate to import transaction through online bank connection

Maintaining accurate banking records is crucial for effective financial management and decision-making, taz-tuesday-app. I am here to guide you on how to bring older or backdated transactions.

 

Most of the banks let you download the last 90 days of transactions when syncing your account in QBO. Others can go back as far as 24 months.

 

For transactions that are beyond this period, you can ask for or download a CSV copy from your bank's website. Then, import it in QBO to get them into your account. 

 

Follow these steps on how to do it:

 

  1. Go to the Transactions menu and select Bank transactions.
  2. Select the blue tile for the account you want to upload the transactions into.
  3. Click the drop-down list for Link account, then select  Upload from file.
  4. Select Drag and drop or select files and select the file you downloaded from your bank. Then click Continue.
  5. In the QuickBooks account ▼ dropdown, select the account you want to upload the transactions into. Then select Continue.
  6. Follow the onscreen steps to match the columns on the file with the correct fields in QuickBooks. Then click Continue.
  7. Select the transactions you would like to import and select Continue.
  8. Click Yes.
  9. When you accept your transactions, select Done.

 

Let me also share these articles for additional information and guidance when importing your transactions:

 

 

For additional banking-related guidance and references, I'll share these resources as well:

 

 

Please know we're here for any questions that come up along the way while importing bank transactions, taz-tuesday-app. Whether it's guidance on troubleshooting any download issues, clarification on import settings, or anything else related to pulling your transaction data into QuickBooks - our team has the expertise to help. 

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

Need to get in touch?

Contact us