American Express Expense Report to QIF Converter 1.0 review
DownloadAmerican Express Expense Report to QIF Converter project is a utility that converts American Express expense reports into QIF. The
|
|
American Express Expense Report to QIF Converter project is a utility that converts American Express expense reports into QIF.
There are three main reasons:
1. American Express only offers QIF files for the last 6 months of activity whereas the expense reports go back 2 years. You can also run a report with a custom 1- to 12-month time period within 24 months of the current calendar month.
2. American Express QIF files have limited to no "categorization" whereas the expense report categorizes each transaction with a "Merchant Category" and "Subcategory".
3. American Express QIF files do not indicate which credit card in a multi-card account performed the transaction.
Here are some key features of "American Express Expense Report to QIF Converter":
Inserts card owner and last 5 digits of the credit card in the memo field
Reads config file for user defined rules so transactions can be automatically mapped to different accounts in your accounting software. Mapping can be based on:
Credit card owner
Vendor name
AMEX "Merchant Category" and "Subcategory"
Any combination of the above
Sanitizes and cleans up vendor names
Has the ability to add a prefix to all vendor names
American Express Expense Report to QIF Converter 1.0 keywords