The first line in the CSV file contains the column headers. You may choose not to include this header when you export or import the CSV file but the order of the columns must be maintained. Each CSV file can only contain transaction data for a single account.
There are a total of 6 columns:
1)PAYEE_ITEM_DESC
2)CATEGORY
3)AMOUNT
4)STATUS
5)TRAN_DATE
6)REMARKS
Column 1: PAYEE/ITEM DESCRIPTION
This is the payee/item field. This is a mandatory text field.
Like all CSV text fields, if the data string contains the field delimiter (eg. ',' (COMMAS)), it must be enclosed with '"' (DOUBLE QUOTES). Additionally, if a '"' (DOUBLE QUOTES) appear within the data string, it must be prefixed by another '"' (DOUBLE QUOTES).
Column 2: CATEGORY
This is a mandatory text field. If the category is not found in EasyMoney, it will be created automatically with category type = 'Expense' if the amount is negative and 'Income' otherwise.
Like all CSV text fields, if the data string contains the field delimiter (eg. ',' (COMMAS)), it must be enclosed with '"' (DOUBLE QUOTES). Additionally, if a '"' (DOUBLE QUOTES) appear within the data string, it must be prefixed by another '"' (DOUBLE QUOTES).
Column 3: AMOUNT
The amount must be a valid number. For negative numbers, a -(MINUS) sign must be placed in front of the number.
There should be no group separator and the only two acceptable decimal separators are the '.'(PERIOD) and the ','(COMMA). If you use COMMA as the decimal separator, you must enclose the amount field with '"' (DOUBLE QUOTES).
Column 4: STATUS
The status must be exactly one of the following: 'Cleared', 'Uncleared', 'Reconciled' and 'Void'. Note that this field is case-sensitive.
Column 5: TRANSACTION DATE
The data in this field must be a valid date string.
Accepted date formats : "2 Dec 2009", "12/2/09"
Column 6: REMARKS
This is an optional text field. Like all CSV text fields, if the data string contains the field delimiter (eg. ',' (COMMAS)), it must be enclosed with '"' (DOUBLE QUOTES). Additionally, if a '"' (DOUBLE QUOTES) appear within the data string, it must be prefixed by another '"' (DOUBLE QUOTES).
Sample CSV File
PAYEE_ITEM_DESC,CATEGORY,AMOUNT,STATUS,TRAN_DATE,REMARKS
"Newspaper","Self Improvement",-0.90,"Uncleared","4 NOV 2009",""
"Cab","Transportation",-18.00,"Cleared","5 Dec 2009",""
"Drinks","Food",-60.00,"Cleared","15 Dec 2009","Beer, wine and spirits."
"Groceries","Groceries",-170.15,"Cleared","25 Dec 2009","Lots of food for Joanne's birthday party"
"Lunch","Food",-9.20,"Uncleared","10/6/09",""