Import of Bank Statement DO NOT work - Date Mapping issue - Basic Feature Issue Becoming Serious Pain

Import of Bank Statement DO NOT work - Date Mapping issue - Basic Feature Issue Becoming Serious Pain

Hello,

Yes, This is True.
Importing Bank Statement feature is Not working as Intended. Facing few issues. Specially regarding the Mapping of Date field format. No matter how many times, we create a Case with Support team, they are NOT supporting in proper way. Infact not even trying to resolve it.
Rather than that we realized that few CS people even tried to Blame MS Excel Software. What a Fun.

Let me try to explain-
I have a Bank Statement that I have downloaded directly from Bank's official site in Excel format. The date format of which is dd-MM-yyyy
Whenever I try to import the statement in Zoho Books using the same Date format, it throws error, stating that the Date format do NOT matches.
I tried verifyhing the format by simply right clcking any Cell (that has date), and check the format, that again shows the same one, that is dd-MM-yyyy
Still it didn't worked.

Surprisingly, that same excel file (having dd-mm-yyyy), worked if I choose UnMatched Date format from within the Zoho books, that dd/mm/yyyy.
Now, this is seriously a problem or a bug. They should accept it and resolve it, without any further delay

This also shows, that Zoho Books Do NOT accepts the format dd-mm-yyy, but is just sits there for formality purposes, and will never work.

2. Another Proof-
I tried to download the Sample file from within the Banking module of Zoho books. Then I view it by confirming the Date format first (so as to use and Map the fields accordingly and correctly).
I found that this Sample file also has the Date format dd-mm-yyyy

To my utter surprise, when I try to upload that Sample Excel file (as it is), and Map the Date fields accordingly (dd-mm-yyyy), even that throws the same error of Date format not matching.

This clearly indicates there is something wrong with the Import of Statements and Unmatching of Date fields.
Selected Date format is NOT matching at all, specially for dd-mm-yyyy date format.

You are requested to check and verify this at your end, by simply downloading the Excel Sample file in CSV format having dd-mm-yyyy format and try to match and Map the fields with the same format. And then try to upload the Sample statement file (as it is).

Also, for your reference, I can share the Statement file with you (having dd-mm-yyyy) if required. You can suggest me, if there is anything wrong with our own statement excel file.
Please let me know, how to share the privately. Or shall I attach here directly

Please resolve
                                                                  
Regards

    • Sticky Posts

    • Features, Feedback and Votes

      We’re launching the Feedback Forum for our customers. This is 'THE' place where you can add everything  you’d like to see in Zoho Books. If you don't find the specific feature you need, simply add it so others can also vote for it. While we cannot promise a ‘release date’ for each of your feature  request s, we definitely want to know what would help you run your business better.  We will update feature requests that we're working on and by participating in the forums, you'll remain updated on every
    • Zoho Books (UK edition) in the post-Brexit era

      Dear users,   As you may know already, the transition period for Brexit is ending on 31 December 2020 and Britain is exiting the EU. In this post, we will look into its implications on VAT treatments and the changes in Zoho Books.   VAT Treatments   Pre-Brexit,
    • Zoho Books is now integrated with Slack messenger

      Hello,   Zoho Books is glad to announce its latest integration with Slack, a messaging app for teams. If you are a Slack user, and you seldom log into your Zoho Books account, then we have got the perfect news for you. With our latest integration, you can monitor your customer's Client Portal activities over Slack. The notifications that are triggered based on your customers’ actions in the Client Portal gets simultaneously pushed into your preferred Slack channel (#general, #random, etc.) The integration
    • Webinar: Introduction to the Client Portal

      Business owners know there is never enough time in the day. Not only do you have to beat the competition and make the sale, you then have to make sure you get paid. In fact, the sales process starts way before the sale, and never really ends. Preparing and getting estimates approved, collecting payments, and fielding customer requests for information related to past transactions are all part of the day in the life of a business owner. Well, Zoho Books can offer some relief to weary business owners.
    • Join us at Zoholics - Finance & HR User Conference

      Hello, I have some special news to share with you.  We are organizing  our very first  Zoholics  for Finance and HR applications at Zoho headquarters on 06-07th November in  Pleasanton , CA.   The agenda is simple: help you master Zoho Books and get the most out of it for your business. I also have some exciting news to share with you regarding the new products that we’re building.   To know more, here's the agenda :  https :// www .zoho.com/ zoholics /finance-hr. html   In the past 6 years, we've


          Zoho TeamInbox Resources

            Zoho DataPrep Resources


                Zoho CRM Plus Resources

                  Zoho Books Resources


                    Zoho Subscriptions Resources

                      Zoho Desk Resources

                        Zoho Projects Resources


                          Zoho Sprints Resources


                            Zoho Orchestly Resources


                              Zoho Creator Resources


                                Zoho WorkDrive Resources




                                    Zoho Campaigns Resources

                                      Zoho CRM Resources

                                                    Design. Discuss. Deliver.

                                                    Create visually engaging stories with Zoho Show.

                                                    Get Started Now


                                                      Zoho Show Resources


                                                        Zoho Writer Writer

                                                        Get Started. Write Away!

                                                        Writer is a powerful online word processor, designed for collaborative work.

                                                                  有料プランをご利用の方