tirsdag den 1. december 2009

The spreadsheet syntax - explained

There are 5 rows in the spreadsheet used for the import

  1. Account no.
  2. Text note
  3. From date *
  4. To date *
  5. Amount (rember income is negativ and expense is positive in accounting ) **

* Data needs to be in this format yyyy-mm-dd i.e. 2009-12-01, google sheet can format this for you and
** So far tested with danish number separators i.e. one thousand is 1.000,00, alternatively don't use thousand separators

Ingen kommentarer:

Send en kommentar