Basic Feature Issue - Import of Statement DO NOT works as intended.

Basic Feature Issue - Import of Statement DO NOT works as intended.

Hello Team,

Importing Bank Statement feature is Not working as Intended. Facing few issues. Specially regarding the Date format.
I tried to contact CS via phone and email, but still unresolved.                              

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 verifying the format by simply right clicking 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-yyyy, 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

    • 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 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.