imported amounts wrong

Discussions about iCompta on macOS
Post Reply
jmckible
Posts: 3
Joined: 08 May 2012, 18:39

imported amounts wrong

Post by jmckible »

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
User avatar
Angeman
Administrateur
Posts: 2369
Joined: 28 December 2008, 21:28
Location: Toulouse, France
Contact:

Re: imported amounts wrong

Post by Angeman »

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.
jmckible
Posts: 3
Joined: 08 May 2012, 18:39

Re: imported amounts wrong

Post by jmckible »

So there's no work around for now? I have to wait till V5? When will that be released?
User avatar
Angeman
Administrateur
Posts: 2369
Joined: 28 December 2008, 21:28
Location: Toulouse, France
Contact:

Re: imported amounts wrong

Post by Angeman »

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
jmckible
Posts: 3
Joined: 08 May 2012, 18:39

Re: imported amounts wrong

Post by jmckible »

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.
Post Reply