Onboarding & Credit

Customer Master Data Checklist

Getting the customer record right the first time — the fields to capture, how to avoid duplicates and why clean master data is the foundation of getting paid.

What this checklist covers

  • Capture the correct legal entity and contact details
  • Set billing, tax and payment fields accurately
  • Prevent duplicate and conflicting customer records
  • Keep the record current as the customer changes

6 min

Before you start

Dirty master data quietly costs you payments — invoices to the wrong name, reminders to the wrong inbox, duplicates that hide arrears. Decide your field standard before you create the record.

  • The verified legal entity name and ABN, not just the trading name.
  • A naming convention so records are consistent and searchable.
  • The agreed terms, credit limit and billing email confirmed in writing.
  • Access to search existing records so you do not create a duplicate.

Step 1 — Identity and core fields

  1. Enter the exact legal name as it appears on ABN Lookup or ASIC.
  2. Record the ABN, ACN and business structure.
  3. Capture the registered address and the delivery address separately.
  4. Add the trading name as an alias so staff can still find the account.
  5. Tag the account type — credit or prepaid — so the right rules apply.

Step 2 — Billing, tax and contacts

  1. Set the dedicated billing email — an accounts inbox, not a salesperson's personal address.
  2. Record the accounts-payable contact name and phone for follow-up.
  3. Set the payment terms, due-date rule and credit limit exactly as agreed.
  4. Configure GST and any tax settings to match the customer's status.
  5. Add a purchase-order requirement flag if the customer needs a PO on every invoice.

Step 3 — Deduplicate and maintain

  1. Search by ABN, legal name and trading name before saving to catch existing records.
  2. Merge any duplicates so payment history and arrears sit in one place.
  3. Lock or restrict who can edit key fields like terms and limit.
  4. Set a review prompt to confirm details periodically, especially the billing email.
  5. Update the record promptly when the customer changes name, address or contact.

Common mistakes

  • Using the trading name as the customer name so invoices name the wrong entity.
  • Sending invoices to a salesperson rather than an accounts inbox.
  • Creating a second record because nobody searched first, splitting the history.
  • Letting terms and limits be edited by anyone without control.
  • Never updating the record, so reminders bounce and payments stall.

Clean data is unglamorous but it is where reliable cash flow begins. The Merion tools help you keep records consistent. This is general guidance, not legal advice — make sure the billed entity is the one legally liable.

Key takeaways

  • Always store the legal entity, with the trading name as an alias
  • Bill an accounts inbox, never a personal sales address
  • Search before saving to stop duplicate records forming
  • Keep the record current so reminders actually reach the customer

Frequently asked questions

Why does the legal entity name matter so much?

Because you can only recover a debt from the entity that is legally liable. If your invoice and record name a trading name or the wrong company, you can lose time and leverage proving who actually owes you.

How do I stop duplicate customer records?

Search by ABN and legal name before creating any record, set the ABN as a unique field where your system allows, and run a periodic duplicate check. Merge duplicates so all history and arrears live in one account.

Who should be able to edit customer terms?

Restrict it to credit or finance staff, not sales. Terms and credit limits are risk controls; if anyone can change them, your controls are only as strong as the most optimistic person with access.

Free invoicing tools

Work the checklist, then get paid

Use the free Invoice Generator, then let Merion recover anything that goes unpaid — commission-only.