nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Problems with decimal points when I export a Report

alino

I moved from the US to Europe and I set my 2023 M2 Mac Mini, running Sequoia, Language and Region system setting to the European setting, change all my quickens accounts to “Euro” currency and the Number format in settings as “1 234 567,89”

All functions in Quicken operate properly, but exporting causes an unexpected issue.

If i export from the menu file → export → register to CSV) everything works fine

When exporting from a report (anyone), all numbers after the decimal symbol are lost. For instance, 1 609.03 becomes 1 603.

Can anyone help me?

Find more posts tagged with

Comments

jacobs

Just a wild shot at a workaround: when you go to export the report, instead of selecting "Export to CSV file", see what happens if you select "Copy to Clipboard", open a blank spreadsheet, and Paste. Are the cents still lost?

Have you tried an alternate spreadsheet program (Numbers, Google Sheets, Excel) to see if the results are the same?

Or, probably the best place to start would be to open the .CSV file in TextEdit and look at the value to see if the cents are present or missing. If they're missing, it's clearly a Quicken bug.

UKR

"CSV" stands for Comma-separated values.
Looks to me like the comma in the amount acts as a field separator.
AFAIK, the numeric field would have to be enclosed in "quotes" or prepared in a pure numeric format with decimal point and without thousand separators and commas.
Or, try exporting the file as tab-delimited file.

Somebody, maybe a Quicken programmer with more experience in properly formatting CSV values, would have to see what needs to be done when the computer is not using standard US/English numeric formats.

Jon

It's Quicken. All I had to do to reproduce the problem was change the number formatting in System Settings > General > Language & Region over to the European style being used by @alino ("1 234 567,89") and the exported report rounded off the fractional part of the number to the nearest integer.

A line from the exported report with European style numbers:

Total,,"-152"

The same line with US style numbers:

Total,,"-151.52"

Jon

There are four number formats in System Settings, and the one that uses spaces for the thousands separator and a common for the decimal point ("1 234 567,89") is the only one that Quicken rounds off when the report is exported. The other three numeric formats export the fractional part of the number.

alino

https://community.quicken.com/discussion/comment/20456810#Comment_20456810

If I select the "copy to clipboard" is the same, unfortunately

Number Sheets, Excel, Everything works in the same (bad) way

alino

https://community.quicken.com/discussion/comment/20456839#Comment_20456839

thanks, bug exporting as tab-delimited is not a option (at least for my quicken version)

alino

Exactly as you mention, it's quicken after all, sometime strange things happens….

jacobs

You can use Report a Problem to report this issue to Quicken; at best, it might be something they fix, but it's not likely to be quick. So…

• Can you live with exported reports which are rounded to the nearest Euro? (Most financial analysis doesn't really require seeing cents.)

• Can you live with changing your Mac to be of the other number formats which export reports properly?

• Can you live with printed reports, or printing to a PDF or opening in Preview?

alino

https://community.quicken.com/discussion/comment/20456855#Comment_20456855

Exactly as you mention, it's quicken after all, sometime strange things happens….

alino

https://community.quicken.com/discussion/comment/20456855#Comment_20456855

Thanks for your great help

It works!!!