mcc-codes

A public repository of Merchant Category Codes (MCC) in formats easier to read than most places (i.e. not a PDF).

The same data is available in several formats:

csv
small json - no whitespace characters
formatted json - indented for legibility
ods (LibreOffice and OpenOffice.org compatible)
xls (Microsoft Office & useful with many other systems that can read xls)

Fields

Derived MCC - mcc
edited_description - manually edited, modern text
combined_description - uses either USDA or IRS
usda_description - Description from the USDA
irs_description - Description from IRS
irs_reportable - Reportable under 6041/6041A and Authority for Exception

Future plans and workflow

I hope that folks will create pull requests to make this information easier to read and use. Specifically, the "Edited Description" field is a place where we can collaboratively go through and fix things like upper case vs. title case.

Preferences for the "Edited Description":

Shorter is better
Use descriptions that make the most sense to someone in 2014
Use title case

If the pull request is against the CSV I'll gladly update the binary formats. Or see below for how to update everything in one shot.

Credits

I'm building this to benefit the operations and users of https://www.card.com

We may add more data to this at some point and will share updates. Others (e.g. Expensify) are contributing fixes too. Thanks!

Updating the files

Start with a csv file that is in a good state.
Open it with LibreOffice using only commas as field separators.
"Save as" to ods.
"Save as" to xls.
php -f csv-to-json.php mcc_codes.csv mcc_codes.small.json
cat mcc_codes.small.json | json > mcc_codes.json

Step 5 assumes a working php-cli. Step 6 assumes a working node.js & "json"

License

Csinclair0/mcc-codes

ErrorLooks like something went wrong!

About

Resources

License

Uh oh!

Stars

Watchers

Forks

Releases

Packages 0

Languages

Error
Looks like something went wrong!

Packages