Why CSV imports changed my dashboard totals and how I debugged it

This came up during a weekly operations dashboard fed by CSV exports from two vendor portals. The problem was not dramatic at first: the same revenue total changed every time a replacement CSV was imported, even when the visible rows looked identical. I suspected a chart aggregation bug, especially because it happened when finance uploaded a file exported from Excel instead of the vendor portal…