Transaction amount not mapping from csv import (V5)
Posted: 02 March 2017, 13:58
Hi,
I'm sorry if I'm missing something really obvious but I'm having problems importing from a csv file. And I've given this the wrong title - I'm using V6, not V5!
I have a spreadsheet with columns called date, name, debit, credit and amount. The date and name data maps with my iCompta but the amount, debit and credit doesn't. The amount, debit and credit fields are formatted as number in the spreadsheet. The amount always shows up as zero when it has been imported to iCompta. Could somebody suggest where I might be going wrong?
These are the settings:
I'm sorry if I'm missing something really obvious but I'm having problems importing from a csv file. And I've given this the wrong title - I'm using V6, not V5!
I have a spreadsheet with columns called date, name, debit, credit and amount. The date and name data maps with my iCompta but the amount, debit and credit doesn't. The amount, debit and credit fields are formatted as number in the spreadsheet. The amount always shows up as zero when it has been imported to iCompta. Could somebody suggest where I might be going wrong?
These are the settings: