Vendor rate sheets arrive in 10 different formats. How do you standardise them?

Every vendor has its own layout: different column names, date formats, notation for “increase/decrease,” and sometimes PDF or zipped files.

What works:

• Map each vendor format once and reuse the mapping
• Validate before import (missing prefixes, negative rates, odd jumps)
• Highlight changes against the current rates, not just the new list
• Keep an archive of every file received

More on the topic in this piece on rate sheet processing. Anyone fully automating the intake?