American Express Expense Report to QIF Converter 1.0

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.
Main features:
- 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