Service addresses in a billing system
A meter belongs to a house, and the bill goes to an address. When the system holds two spellings of one house or a number that is not on the street, the reading and the bill go wrong.
Find the addresses that do not exist
gridpin batch spain.bin accounts.csv accounts_checked.csv --with exists,verdict
exists says whether the house is in the sheet; verdict says what happened to each field (the number replaced by a neighbour's, the postcode corrected).
Duplicates and a page for the team
gridpin-pro dedupe groups the rows that name one house however they are written, and audit writes one page about the base. These are in the Pro tools.