xl2qif Excel macro


Frequently Asked Questions (FAQ)

XL2QIF | CALC2QIF | Links | Download | FAQ | Français 



New

References


Links



Usage

  • The macro runs without any error message but not QIF ouput file is generated:
    Check if the macro execution is allowed by your antivirus software (this issue has been reported with the Kaspersky Office antivirus).

  • The decimal separator is lost during the conversion (an amount of 100,00 becomes 10000):
    This issue has been reported with some versions of Money 2000 who don't recognize the point "." as the standard decimal separator in the QIF file.
    As a workaround for this issue the revision 0.9 of xl2qif includes a special processing to replace in the QIF output file the point "." by the comma "," as the decimal separator.

  • When I import from QIF to Money, Money does not include the categories:
    This a Money issue, I've observed that to import categories from a QIF file, you have to choose under Money the command File>Import... import as a new account.
    Otherwise, with the default import settings the categories are not imported even if they are present in the QIF file.

Error messages

  • I get the error message "Invalid values in Date column":
    This occurs when one of the selected cells in the Date column as defined by the fields order has a value which is not recognized as a valid date by Excel.
    This error can be due to:

    • an error in the definition of the fields order for the data to convert
    • an error in the selection of the data to convert: for example the selection of the title of the columns (see Excel data organisation)

  • I get the error message "Invalid values in Amount column":
    This occurs when one of the selected cells in the Amount column as defined by the fields order has a value which is not recognized as a valid number by Excel.
    This error can be due to:

    • an error in the definition of the fields order for the data to convert
    • a difference between the decimal separator in the cell and the local settings of the PC: for example a value of 100,00 in the cell with the point "." selected as the decimal separator in the local settings.




XL2QIF | CALC2QIF | Links | Download | FAQ | Français 


© 2002-2004 Last updated: Monday July 5th, 2004