Recovery playbooks · Prevention

Normalizing invoice numbers before you pay

Comparing invoice numbers after removing prefixes, punctuation, spaces and leading zeros catches duplicates an exact-match check misses.

In short

  • INV-01043, INV 1043 and 1043 all normalize to 1043.
  • Normalization belongs at entry and again before each payment run.
  • Normalized matches should still be compared on vendor and amount before they are called duplicates.
  • Suppliers that reuse numbers each year need the invoice date in the comparison.
  • A keying standard reduces variation at the source.

Figures on this page are calculated by ERPSav from the definitions shown. The explanatory text is drafted with AI from those figures and checked automatically before it is published. General information only, not legal, tax or financial advice.