AMEX Statement Import
The AMEX statement turned into a Business Central upload file with one drag and drop.
Problem
Every charge on the company AMEX had to be keyed into Business Central by hand. Each one needed the right vendor and the right expense account, and there are a lot of charges in a month.
Approach
Accounting drags the AMEX export onto a shortcut and gets back a file that’s ready to upload into Business Central.
Each charge is matched to a vendor in two passes. First it checks a list of known merchants the team edits in Excel. If that doesn’t find it, it falls back to matching on the vendor name. The hard part was making sure a close-but-wrong match never slipped through. An early version matched “SPS Commerce” to a state Department of Commerce vendor because both names had “Commerce” in them, so I rebuilt the matching to ignore filler words and to flag any tie instead of picking one.
Anything it isn’t sure about gets flagged for review, not guessed.
Result
- A month of AMEX charges turned into an upload file in one step
- Unknown merchants are flagged, never posted to the wrong vendor
- New vendors get added in Excel, with no code changes
- Accounting runs it on their own