Despite claims to the contrary, it does not appear possible to import invoice data from ANY spreadsheet (via csv) to Zoho invoice owing to the incompatibility of date formats.  Spreadsheets insist on exporting date format as "mm/dd/yyyy" (Excel) whereas zoho invoice insists on the mysql format yyyy-mm-dd.

This drove me nuts until I worked out the logic.

Solution?

Use sed, the Unix stream editor.  If you have a Mac, you already have it.  For Windows?  Can be obtained by installing the Cygwin project .. http://www.cygwin.com/

This is where I started to get my solution working ..
http://tinobox.com/wordpress/coding/fun-with-sed/


Export your data from Spreadsheet, process it with sed, import into invoice.

hth

Rgds.

ps ...
a rudimentary start to a bash script to work with the default data given in zoho invoice. As far as I can see, the logic should work with any data as it looks for dates.  I think it will work till the end of 2099.

It trims the quotes in the field, changes the / separator to - and moves yyyy from the end to the front of the field.  Corrections welcome.

#--------------------------------------------------------------------------------------------------------------------------------
#!/usr/bin/bash

sed -e 's:\("\)\([0-9]\+\)/\([0-9]\+\)/\(20[0-9][0-9]\)\("\):\4-\2-\3:g' $1 > $2


Useage:    thisscipt.sh inputfile outputfile