Suggestions and Ideas
Here is some space for your ideas.
I will try my best to implement this tool on my spare time but I cannot guarantee weather/when it will be done. Please note that this is a Free tool and I cannot provide support.




Average 4.00 Votes: 1Here is some space for your ideas.
I will try my best to implement this tool on my spare time but I cannot guarantee weather/when it will be done. Please note that this is a Free tool and I cannot provide support.
It would be nice to submit one big csv file that feeds into multiple QIFs. I could use an account field in my CSV file to drive the decision of what QIF file to put the transaction into. Today, I have to filter my csv file and submit multiple times.
I am delighted to announce that there is a new feature on CSV to QIF Converter
Now you can use the Splitter type to split your CSV into separate QIF files. When you use this option, you will receive a ZIP file with all the QIF files nested. Just unzip and import into the appropriate accounts.
To use it, map a field like “Account Number” or “Account Name” as Splitter.
You can even split by Date or any other field from your CSV file.
In Spain we use the comma “,” as a decimal separator and the CSV files don’t use the comma as column separator but the semicolon “;”.
Would it be possible to add an option to use the semicolon?
Can you pls send a sample of your CSV file to webmaster@gginternational.net
After reading you site, Your site is very useful for me .I bookmarked your site!
My csv file
09/04/10,BACS Credit,49758252 COMBINED,SL-STREAMLINE-0604,564.20,,2620.04,60788198090348/,
12/04/10,BACS Credit,49758252 COMBINED,SL-STREAMLINE-0704,228.00,,2848.04,60788198090348/,
12/04/10,Own Account Credit,,,648.00,,3496.04,,
gets converted to the qif file
!Type:Bank
D09-04-2010
T564.2
PSL-STREAMLINE-0604
^
D12-04-2010
T228
PSL-STREAMLINE-0704
^
D12-04-2010
T648
P
^
The problem is that the value is before the payeee and not the other way around. Money cannot import the value. Can this be changed? Also the negative value is preceded by ,,.
i am happy to find it thanks for sharing it here. Nice work.
Was an interesting article, thank you..
Can you add support for investment fields such as:
Y – Security Name
I – Price
Q – Quantity of Shares
O – Commission Cost
U – Investment Amount (Pretty much similar to T – Value)
N – Investment Action (Buy, Sell)
I am now getting some results! I have removed the headers from the banks CSV file. I can import into Money but I have to leave the ‘Debit’ field as ‘Ignore’.
In summary I am able to import dates, payees, memos and positive values but cannot do the same for negative values.
So a big improvement.
Thank you for the idea.
We are making some improvements on the tool and will implement it soon.
Thank you for the tool. I only have one suggestion. The date field needs a 4 digit format option. I was trying to use it with GNUCash and the date field from my bank is MM/DD/YYYY and GNUCash gives an error – “cannot import date older than 1970″ when I use the MM/DD/YY field on your application.
Hi.
Love your webpage, saves me a lot of time entering transactions into GNU Cash.
However there is a (for me)minor bug: I loose the values for debit transactions when importing the file into Gnu Cash.
I would like to use this site, but I am still finding it my out of date copy of EzyTrans more useful. I cannot fully convert this:-
05/11/2010,Commission,000028,COMMISSION,,4.20,,564.83
05/11/2010,Commission,000028,SERVICE CHARGE,,3.00,,561.83
05/11/2010,BACS Credit,49758252 COMBINED,SL-STREAMLINE-0211,218.00,,60788198090348,79.83
08/11/2010,BACS Credit,49758252 COMBINED,SL-STREAMLINE-0311,164.00,,60788198090348,93.83
into a QIF file.
Would it be possible to support the QIF field for Reconciled. According to the QIF Wikipedia entry this would be:
C Cleared status: Values are blank (not cleared), “*” or “c” (cleared) and “X” or “R” for (reconciled).
when loading a csv file and converting, it strips the very first transaction. So, if you had 100 transactions, your .qif file would have 99, and in the place of the missing entry is just the “^” symbol. (without the quotation marks)
I tried this by uploading one single transaction on a .csv file, and all that was converted was the header (!Type:Bank), and no transaction.
Here’s exactly what was uploaded in csv format:
02/22/2011 -15 * (blank column) VENDOR NAME
for each item, I mapped the following:
02/22/2011 mm/dd/yyyy
-15 amount
* ignore
(blank col) ignore
vendor name payee
When you map this, all you get in return is:
!Type:Bank
^
….weird…..
this is an awesome tool, but for me, I have to be careful to always input manually that last transaction. Is this a bug, or do you think I’m doing this incorrectly?




(2.60 out of 5)



(4.25 out of 5)



(5.00 out of 5)



(3.00 out of 5)



(1.40 out of 5)



(2.25 out of 5)



(2.50 out of 5)



(1.50 out of 5)



(4.00 out of 5)
Comments
Leave a comment Trackback