Hi Angeman,
Hope you are well.
I'm trying to import into Icompta statements from my Wise account in CSV format.
It seems like Icompta's internal browser can't handle it, so I'm importing it externally.
The problem is that the amount column doesn't have a sign on the figures showing what's Credit or Debit.
There is another column named "DIRECTION" which marks each transaction as IN or OUT.
So I have mapped the import process accordingly as seen on the screenshot attached.
The problem is that it doesn't work properly.
Amounts seem to have been marked as Credit or Debit randomly.
How can I fix that, please?
Thanks
Wise CSV Import settings
-
- Posts: 72
- Joined: 07 August 2014, 20:23
Wise CSV Import settings
- Attachments
-
- Screenshot 2023-07-28 at 10.56.18.png (62.78 KiB) Viewed 186383 times
- Angeman
- Administrateur
- Posts: 2303
- Joined: 28 December 2008, 21:28
- Location: Toulouse, France
- Contact:
Re: Wise CSV Import settings
In your case you should only map "Amount" and "Amount sign" fields in the fields mapping screen (the one before your screenshot), not "Credit" and "Debit".
-
- Posts: 72
- Joined: 07 August 2014, 20:23
Re: Wise CSV Import settings
Yes, that's what I'm doing.
I'm not mapping Credit or Debit fields.
I'm not mapping Credit or Debit fields.
- Attachments
-
- Screenshot 2023-07-28 at 12.43.28.png (259.04 KiB) Viewed 186374 times
-
- Screenshot 2023-07-28 at 12.45.04.png (101.92 KiB) Viewed 186374 times
-
- Posts: 72
- Joined: 07 August 2014, 20:23
Re: Wise CSV Import settings
Could the dates coming with TIME create some inconsistencies on import??
- Attachments
-
- Screenshot 2023-07-28 at 12.51.13.png (90.16 KiB) Viewed 186373 times
-
- Posts: 72
- Joined: 07 August 2014, 20:23
Re: Wise CSV Import settings
I'm mapping dates as yyyy-MM-dd simply ignoring the TIME.
It seems to be importing dates correctly this way.
It seems to be importing dates correctly this way.