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
imported amounts wrong
- Angeman
- Administrateur
- Posts: 2369
- Joined: 28 December 2008, 21:28
- Location: Toulouse, France
- Contact:
Re: imported amounts wrong
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.
Anyway you'll be able to choose the decimal separator in V5.
Re: imported amounts wrong
So there's no work around for now? I have to wait till V5? When will that be released?
- Angeman
- Administrateur
- Posts: 2369
- Joined: 28 December 2008, 21:28
- Location: Toulouse, France
- Contact:
Re: imported amounts wrong
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:So there's no work around for now?
viewtopic.php?f=2&t=795jmckible wrote:When will that be released?
Re: imported amounts wrong
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.