- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
About QB Community
Explore the converter tool. e.g csv2qbo
You can edit the data before importing it.
https://www.moneythumb.com/?ref=110
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
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.