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

I only have bank statements, not the CSV files. I need to capture statement entries all the way back to September 2023. How do I do this?

To clarify, I only have the monthly bank statements as pdf. No CSV and my bank auto sync is only back to April. I am missing 7 months of synced transactions.
2 Comments 2
Eman_E
QuickBooks Team

I only have bank statements, not the CSV files. I need to capture statement entries all the way back to September 2023. How do I do this?

Welcome to the Community, Werner. Let me help you capture the bank statement that is missing from your QuickBooks Online (QBO) account.

 

Depending on the financial institution, some banks allow customers to download their transaction history for up to 90 days, while others offer access to as far as 24 months of past transactions. To obtain the CSV file containing this data, simply reach out to your bank for assistance.

 

When the file is formatted correctly, you can manually upload the transactions. Here's how:

 

  1. Sign in to your QuickBooks Online account.
  2. Hover your mouse to Transactions, then click on Bank Transactions.
  3. In the Link account drop-down, select Upload from file.
  4. Select the Drag and drop or select files button and then choose the file you downloaded from your bank. Then hit on Continue.
  5. In the QuickBooks account dropdown, select the account you want to upload the transactions into. Then click on Continue.
  6. Follow the onscreen steps to match the columns on the file with the correct fields in QuickBooks, then click on Continue.
  7. Choose the transactions you want to import.
  8. Hit on Yes.
  9. Once okay, click on Done.

 

For more information, you can visit this article: Manually upload transactions into QuickBooks Online.

 

Once everything's set, make sure to check out these articles for future reference that'll walk you through the steps to categorize your transactions and reconcile your account seamlessly:

 

 

I'm all ears if you have other queries about importing transactions in QuickBooks Online. Don't hesitate to reach out. Stay safe always.

On Beta
Level 4

I only have bank statements, not the CSV files. I need to capture statement entries all the way back to September 2023. How do I do this?

@werner-mementotr 

You can use pdf2qbo converter tool

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