search

aniav / ynab-csv

Tool for making your CSV files ready to import into YNAB
https://aniav.github.io/ynab-csv/
MIT License
164 stars 84 forks source link

Allow to import files with a separate column impacting the transaction being inflow/outflow. #79

Open k0sm0sas opened 1 month ago

k0sm0sas commented 1 month ago

Hello. Importing transactions from .CSV file it does not recognize whether it + or -. My transactions marked in a separete column with D or K letters meaning Kredit and Debit. Using CSV Converter don't help. Example of my original file, 1 raw: " | " - this is a column separator. " | D |" represents "-" sign for the amount of 13.44 EUR 8888 2222 3333 7777 | 20 | 2024-01-01 | PayeeNAME| PIRKINYS 516793******6564 2023.12.30 13.44 EUR (842326) PayeeNAME | 13.44 | EUR | D | 2024010100525747 | K |   | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | `--`

Thats what I get scr

aniav commented 1 month ago

Hey, thank you for the report. I don't think there is an easy way to achieve what you need with how the tool is built right now. Until now there was no other report of bank statements with a configuration similar to yours so it doesn't seem like a popular case. I have marked the issue with "help wanted" so that someone can contribute to a change like that.

k0sm0sas commented 1 month ago

Hello and thank you for reacting. It took some time, but I managed to rebuilt my statement using Excel data extraction into suitable format for your converter. Of course will be great if someone contributes and will be possible just to import for people like me. Thank you Best regards, Pavel S.

пн, 28 окт. 2024 г., 17:27 Ania Warzecha @.***>:

Hey, thank you for the report. I don't think there is an easy way to achieve what you need with how the tool is built right now. Until now there was no other report of bank statements with a configuration similar to yours so it doesn't seem like a popular case. I have marked the issue with "help wanted" so that someone can contribute to a change like that.

— Reply to this email directly, view it on GitHub https://github.com/aniav/ynab-csv/issues/79#issuecomment-2441908148, or unsubscribe https://github.com/notifications/unsubscribe-auth/AIURYRTEVUQJUPUQ5LY27NDZ5ZCUHAVCNFSM6AAAAABQE4OWGWVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDINBRHEYDQMJUHA . You are receiving this because you authored the thread.Message ID: @.***>