Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
January 26, 2025

manual upload of bank statements

  • January 26, 2025
  • 1 reply
  • 4 views

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

 

    1 reply

    Level 1
    January 26, 2025

    Explore the converter tool. e.g csv2qbo

    You can edit the data before importing it.

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

     

    Moderator
    January 26, 2025

    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.