forums.lyricapps.com

Hi- I'm evaluating the trial version of iCompta and I've run into a basic problem. When trying to import .QIF files from my bank the amounts shown are incorrect. I'm importing the QIF's in the 4 digit format (MM/dd/yyyy) and the dates are fine, but any balance amount over 5 digits get's whacked down. For example a debit of -573.38 is fine, but a debit of -5000.00 becomes one of -5.00. And a credit of 396.78 is fine, but one of 1500.00 becomes 1.00 and 2000.00 becomes 2.00, etc. I'd really like to give this software a try but I can't get past this.
Thanks

That's probably because those amounts don't have a decimal separator in the QIF file and iCompta thinks the thousands separator is the decimal separator.
Anyway you'll be able to choose the decimal separator in V5.

So there's no work around for now? I have to wait till V5? When will that be released?

jmckible wrote:So there's no work around for now?

The workaround is to modify the QIF file with a text editor and add .00 at the end of the amounts without a decimal separator.

jmckible wrote:When will that be released?

viewtopic.php?f=2&t=795

Actually I figured this out. The culprit was a coma in the QIF file. I just opened it in Text Editor and did a find and replace and took out all the comas. The file imported just fine then.