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.

Product's homepage

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