We read the monthly bordereaux from each binder, map them to the carrier template, and flag the rows that do not reconcile.
Every month, bordereaux arrive from each binder in a different format. Someone maps each file to the carrier’s template, fills the gaps, and checks the totals before it can be reported. It is slow work, and errors are easy to miss.
We read each bordereaux, map the columns to the template, check the fields and totals, and flag the rows that do not reconcile.
A clean, mapped file each month, with the exceptions listed for the ops lead to clear. The reporting goes out on time, and the data behind it holds up to a review.