It is required to at least set the columns for the "Date", "Credit Amount" and "Debit Amount" values.
If a particular value is not listed in the CSV file, then set that value to "NA" (not available). If the Action column is not set for investment transactions it will use the Type column choice for the action. If there's a single amount column set that column for both the "Credit Amount" and "Debit Amount".įor investment transactions, make sure to also match both the "General Info Columns" and the "Security Info Columns". Next, specify what value each column represents in the CSV file such as "Column 1" having the "Date" values and "Column 4" having the "Category" values.Make sure the "Decimal Separator" option is set correctly for the transactions shown in the file (a period or a comma).
Set the "End Row" to be the row of the last transaction you want to import or just leave as a large number to import if the last row of the CSV file is the last transaction to import and there's not other information the bottom of the file.Set the "Start Row" to be the row of the first transaction you want to import.Not all programs export security prices to OFX files. Our file importing feature is widely regarded as one of the best there is, but it can only as good as the information available in the OFX file. Not all programs export security prices to QFX files. Our file importing feature is widely regarded as one of the best there is, but it can only as good as the information available in the QFX file. Not all programs export security prices to QMTF files and the QMTF file format is limited with regard to tracking investments. Our file importing feature is widely regarded as one of the best there is, but it can only as good as the information available in the QMTF file. If you realize the import didn't include all of your information, such as the date range or accounts to export was not set correctly during the export, then it would be best to start over and redo the export and import it into a new file. If desired, security prices can be set manually to match the exact prices in the other personal finance app or website you have been using for the comparison between the two. Not all programs export security prices to QIF files and the QIF file format is limited with regard to tracking investments. If there are any discrepancies, we recommend to check the more complex items such as investment accounts first. Our file importing feature is widely regarded as one of the best there is, but it can only as good as the information available in the QIF file.Īlthough we try to accommodate for as many of the errors in the exports of other programs as we can, many of them simply export information incorrectly or incompletely. Review the imported information for accuracy when compared to the other personal finance app or website you have been using.
0 kommentar(er)
