leelee1035
Level 1

manual upload of bank statements

i am in mexico

I uploaded my bank statement manually

the bank statement has date written with words...ie. 17 ENE 2025

Therefore the program cannot recognize the dates therefore i cannot import the bank transactions I want.. 

How do I get around that

 

Chrea
Level 8

About QB Community

Explore the converter tool. e.g csv2qbo

You can edit the data before importing it.

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

 

Ivan_G
QuickBooks Team

About QB Community

I've got a way to successfully upload your transactions manually into QuickBooks, Lee.
 
To import your bank statement into QuickBooks, you'll have to modify the date format of your CSV file to numeric first. You can open the CSV copy of your statement to Excel and edit the format from there.
 
For this, it's advisable to use the Date/Month/Year format (DD/MM/YYYY): 17/01/2025. You can also check the image I've added below as your guidance:
 

 

It's also essential to map your data accurately to upload your transactions seamlessly. See this sample for reference:
 

 

For more details about the manual importing process, review this link: Upload bank transactions into QuickBooks Online.

 

I've also included these resources that can help you classify your data and reconcile your accounts accordingly:

 

 

You can always add another post here in the Community if you have more questions about the importing procedure in QuickBooks. Our team is committed to helping you promptly.