![]() ![]() You have to click 'Change +/-' to reverse that. There is an important thing, that for some Credit Cards they supply expenses as positive numbers and the deposits of payments to Credit Card is negative numbers. This CSV file is simple, it has one Amount column with amounts as positive and negative numbers, so the converter understands it. Then you can map the Record Type column and use also Map Amount column. If your CSV file has a separate column with words like Debit or Credit, you can also Map it as the Record Type and say: the Amount is always positive, but there is the column, that says: Debit or Credit. Like if your file has Debit and Credit columns instead of one Amount column, then you would say: "Do not use" and assign the Debit and Credit columns. You can click 'Review Mapping' and reassign columns here if needed. Some users may find QFX useful, some users find QIF useful. There is a difference between QFX and QIF formats. There is another article with step-by-step details for CSV to QIF conversion, that shows how to convert to QIF file and import into Quicken 2017 (please visit: ). You may also use the CSV2QIF converter with Quicken 2017, which imports QIF files fine. And QFX file originally downloaded from your bank. Because categories are something, that you defined, not your Bank defines when it provides a QFX file. There isn't for that, because QFX format by its history or by its definition does not the categories. The QFX format does not have categories here, so Quicken offers the Renaming rules or categorization feature during QFX import. All these columns the converter understands and uses them for specific fields on a QFX file or to Map your CSV file. It's great, if your CSV file has the first line, as column names, like Date, Amount, Payee, Memo, Check number, Type. We don't use any manual Mapping here, the converter understands the file itself. The converter knows many other formats, but this is more the simplest format, that you can follow. You can use this file as an example to try the product or to get an idea: how a CSV file should look like, so the converter processed it without problems. We will use a sample CSV file, you can find it on the product page. IMPORTANT : CSV2QFX is now replaced with the Transactions app, which converts from more formats and converts to more formats. This tutorial shows how to convert CSV/Excel files to QFX (Web Connect) format and import into Quicken 2017. Solution home Transactions app Legacy Products CSV2QFX: Convert CSV to QFX (Web Connect) and import into Quicken 2017 ![]()
0 Comments
Leave a Reply. |