Wise CSV Import settings

Discussions about iCompta on macOS
Post Reply
AlecFasani
Posts: 72
Joined: 07 August 2014, 20:23

Wise CSV Import settings

Post by AlecFasani »

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
Attachments
Screenshot 2023-07-28 at 10.56.18.png
Screenshot 2023-07-28 at 10.56.18.png (62.78 KiB) Viewed 184876 times
User avatar
Angeman
Administrateur
Posts: 2303
Joined: 28 December 2008, 21:28
Location: Toulouse, France
Contact:

Re: Wise CSV Import settings

Post by Angeman »

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".
AlecFasani
Posts: 72
Joined: 07 August 2014, 20:23

Re: Wise CSV Import settings

Post by AlecFasani »

Yes, that's what I'm doing.
I'm not mapping Credit or Debit fields.
Attachments
Screenshot 2023-07-28 at 12.43.28.png
Screenshot 2023-07-28 at 12.43.28.png (259.04 KiB) Viewed 184867 times
Screenshot 2023-07-28 at 12.45.04.png
Screenshot 2023-07-28 at 12.45.04.png (101.92 KiB) Viewed 184867 times
AlecFasani
Posts: 72
Joined: 07 August 2014, 20:23

Re: Wise CSV Import settings

Post by AlecFasani »

Could the dates coming with TIME create some inconsistencies on import??
Attachments
Screenshot 2023-07-28 at 12.51.13.png
Screenshot 2023-07-28 at 12.51.13.png (90.16 KiB) Viewed 184866 times
AlecFasani
Posts: 72
Joined: 07 August 2014, 20:23

Re: Wise CSV Import settings

Post by AlecFasani »

I'm mapping dates as yyyy-MM-dd simply ignoring the TIME.
It seems to be importing dates correctly this way.
Post Reply