Check a customer master list before a purchase order

A purchase order can look complete and still point to the wrong customer account, an old address, or a duplicate record. A quick check against your customer master list can catch those mismatches before the order moves forward.

Use the CSV Editor to open the list in your browser, find a customer, sort records, and look for duplicate rows. Then compare the matching record with the purchase order and your organization’s approval rules.

Check the purchase order against the customer list

1. Open the CSV Editor and load a copy of the customer master CSV. Keep the original file unchanged while you review it.
2. Find the customer using the account or customer ID shown on the purchase order. If the order has no ID, search by the customer’s legal name, then confirm the result with another field such as the billing ZIP code.
3. Compare the matching row with the purchase order. Check the legal business name, billing address, ship-to details when listed, account status, and any terms or contact details required by your process.
4. Sort the list by customer ID or name and look for repeated records or similar entries. Before removing anything, note the rows that need review and confirm whether they are genuine duplicates.

Use the same customer identifier throughout the check. A familiar company name is not enough by itself: two branches can share a name, and one company can have separate accounts for different locations.

What the result means

The ID and details match

The purchase order points to a record with matching customer details. This is a useful consistency check, but it does not confirm that the order is authorized, that the customer is credit-approved, or that the master list is current. Follow your normal approval steps before processing it.

The ID matches, but the name or address differs

The purchase order may use an old business name or address, or the master record may need an update. Do not edit the customer record just to make it match the order. Ask the person responsible for the account which information is authoritative, especially when the billing address or payment terms differ.

The ID is missing or returns more than one possible row

There may be a typing error, a duplicate account, or a purchase order that uses a location code instead of the customer ID. Search using the full legal name and compare another identifier, such as a tax reference or postal code if your approved process uses one. Do not choose a record based only on a similar name.

The record is present but key fields are blank

A blank address, status, or terms field may mean the record is incomplete, or that the information lives in another approved system. Treat the missing value as a question to resolve, not as permission to assume the purchase order is correct.

Several rows look alike

Repeated names do not always mean duplicate accounts. Separate locations, divisions, or billing entities can have similar details. Compare the customer IDs and the full record before deciding whether anything should be combined or removed.

Fix mismatches without damaging the list

1. Check the purchase order for a typing error. Compare the ID character by character, including any leading zeros. A CSV can contain IDs that look like numbers but must be treated as text. See why leading zeros disappear from CSV data if an ID looks shorter than expected.
2. Search by a second detail. Look for the legal name or another approved identifier, then compare the results with the purchase order. Similar names alone are not a safe basis for picking an account.
3. Review possible duplicates before removing them. Sort by ID or name to bring similar rows together. Two records with the same name can represent different customers or locations, so only remove a row after confirming it is an actual duplicate and you have a backup.
4. Correct the source record, not just the review copy. If the master list is wrong, send the discrepancy to the person or team that maintains it. Editing an exported CSV may fix your local copy without changing the authoritative customer record.
5. Get approval for unresolved differences. If the PO and customer record disagree on the billing entity, payment terms, status, or ship-to address, pause the check and ask the responsible team. Keep a note of the discrepancy and the decision for your audit trail.

Why the customer ID matters more than the name

Customer names can change, include punctuation differences, or appear in several forms, such as a brand name and a legal business name. An account ID is usually a more reliable way to locate the intended record, but it still needs a second check when a list contains duplicates or old accounts.

A CSV Editor can help you find and organize the rows you have, but it does not confirm that the file is the latest approved master list or automatically validate a purchase order against another system. Check the file date or source with your team when accuracy matters. The CSV Editor processes the file in your browser, and the file stays on your device.