When exporting bank statements I noticed that the minus in a negative amount is changed to âˆ’ when I opened the TSV in Excel. Also, I’m missing the tracking codes in there. I have added a lot of tracking codes to different transactions and would like to filter on these in Excel (as I’m unable to …

I’m not able to reproduce issue with âˆ’, could you send sample what you have exported to bugs@manager.io? Regarding tracking codes, the issue is that bank transactions can be split into multiple lines and each line can have different tracking code. What are you trying to achieve by tracking codes …

[image] lubos: âˆ’ Thank you, I have sent a mail to bugs@manager.io . Regarding the tracking code. I have some excel sheets which I used before Manager to manage the financials but also draw some reports. This was done by adding each bank statement or transaction to a certain category. Like t…

To categorize bank transactions into income/expense categories, there is an Account field for it. I’m just not sure what you are using Tracking codes for. They have specific purpose and the purpose is to be able to generate Profit & Loss Statement per division, rental property, job or project etc… i…

I also have the same problem with negative numbers after exporting to csv ( they appear preceded by âˆ’ in both Excel and OpenOffice_org using both Windows and Mac). Unfortunatley I don’t know how to send you a sample. I notice the previous correspondent sent a bug report. Did anything come of it…

I don’t remember details anymore but I believe I fixed it. Are you using the latest version (14.12) ?

My apologies, the problem is fixed in the latest version, although negative numbers are left aligned whilst positive numbers are right aligned, but I can live with that. Many thanks for taking the time to respond. Great programme which I’m sure will be even better when the promised report gener…

Do you get the same alignment issue under Excel and OpenOffice? I think the issue with alignment is how your spreadsheet program is interpreting values in TSV since TSV format is just values, no styles.

I’ve checked and Excel aligns correctly. I’ll fiddle with OpenOffice to find a setting that works (as I don’t have a licensed copy of Excel). Thanks again.

Exporting bank transactions (tracking codes column)

Uncategorized

Topic		Replies	Views
Export to excel, negative numbers as text Uncategorized	6	1877	August 16, 2017
Negative numbers appear as text when converted from tsv to excel Uncategorized	11	1226	September 9, 2015
Importing Bank Statements with Reverse Values Uncategorized	12	581	May 1, 2023
Expenses not deducting when imported bank statements Uncategorized	6	1408	August 17, 2018
Export to .tsv Uncategorized	0	815	March 10, 2016

Exporting bank transactions (tracking codes column)

Related topics