Why master data is an operational asset
In many Swiss SMEs, customers and suppliers live in multiple lists: a shared Excel sheet, CRM contacts, an email address book and records in accounting software. Every new order or invoice adds a row; rarely does anyone check whether that partner already exists under a different spelling or a slightly different address.
Duplicates and incomplete data do not stay confined to master data. They spread to orders, credit notes, VAT entries and payment reminders. A customer registered twice may receive duplicate invoices or, conversely, payments credited to the wrong account. A supplier without a UID number or with an incorrect VAT rate exposes the company to corrections on returns and discussions with the Federal Tax Administration (FTA).
This guide focuses on the quality of customer and supplier master data: how to spot typical problems, which fields are mandatory in the Swiss context, and how to set simple rules that accounting, sales and administration can apply every day — including using ERP software such as Accountex as a single source of truth.
Dirty data: effects on VAT, receivables and suppliers
Master data errors rarely show up alone on the balance sheet; they accumulate as small deviations until they become operational bottlenecks or tax risks:
| Master data issue | Operational consequence | Risk for the SME |
|---|---|---|
| Duplicate customer (same UID, different names) | Fragmented customer balance, reminders on items already paid | Delayed collections, damaged commercial relationship |
| Incorrect VAT code or exemption | Invoices with wrong rate, corrective credit notes | Periodic VAT corrections, interest and penalties in serious cases |
| Outdated billing address | Documents rejected, late payments due to “invoice not received” | High DSO, unpredictable cash flows |
| Supplier without verified IBAN | Failed transfers, duplicate payments after re-entry | Bank charges, penalties and manual work at month-end |
| Inconsistent payment terms | Due dates calculated differently from contract | Unauthorised concessions or excessive pressure on strategic customers |
| Foreign partner without country and VAT regime | Purchases/imports recorded generically | Errors on VAT returns and statistics where applicable |
Where duplicates come from (and how to find them)
Duplicates are not always two identical records. In Swiss SMEs they appear mainly in these situations:
Customers
- A new sales contact creates a customer while accounting already has one with an abbreviated company name.
- Branches or job sites registered as separate customers instead of as a delivery address for the same UID.
- Individuals and small businesses entered with first and last name only, without matching against UID/VAT number or email already in use.
- Acquisitions: the target company keeps its own master data parallel to the group’s.
Suppliers
- Same supplier with different trade brand and legal name (e.g. “XY SA” and “XY Shop”).
- Scanned paper invoices with OCR suggesting a new supplier for every small text variation.
- Occasional suppliers reactivated each year instead of being marked inactive.
- Subcontractors paid via the principal but registered as duplicate direct suppliers.
For systematic search, combine automated rules and human review: normalised name comparison (uppercase, punctuation, “SA/Sagl/AG”), billing email, UID number (business identifier) and, for VAT-registered Swiss B2B customers, the VAT number in the format CHE-xxx.xxx.xxx MWST. A report listing partners with the same UID or email but different internal codes is often enough for a first cleanup.
Essential fields in the Swiss context
You do not need an “encyclopaedic” master record, but some data is decisive for VAT compliance and payments. Defining which fields are mandatory before saving a new partner reduces errors upstream.
Customers (debtors)
- Company name and legal form — consistent with commercial register extract or previous invoice.
- Billing address — complete with postcode and canton; separate delivery address if different.
- UID and VAT number — for VAT-registered customers; verify on the UID register or the customer’s invoice.
- VAT code / default rate — aligned with type of supply (domestic, exempt with reason, export of services where applicable).
- Payment terms and currency — net days, cash discount, customer IBAN only if required for direct debit or set-off.
- Contact person and preferred channel — reduces reminders sent to a generic address.
Suppliers (creditors)
- Swiss IBAN or QR-IBAN — format validation; attention to invoices with QR reference.
- Supplier UID / VAT — required for input VAT deduction on taxable purchases and for cross-checks.
- Default cost centre or expense category — avoids postings to generic “miscellaneous” accounts.
- Withholding tax — flag and percentage only where the supplier falls under the obligation (e.g. certain foreign service providers or specific sectors, under current law).
- Currency and agreed terms — consistency with framework contracts and internal approvals.
Cantonal differences mainly affect addresses and local tax authorities, not federal VAT fields. Keeping “commercial partner” and “VAT entity” separate (when both are needed) helps companies with multiple sites or group relationships.
VAT errors linked to master data
Most recurring VAT discrepancies in SMEs do not come from complex legal interpretation, but from wrong defaults on the partner:
Default rate not updated
After a rate change or introduction of new categories (e.g. 2.6% reduced rate on certain goods), existing customers keep the old code until master data is updated. An annual review of the most used VAT codes on the top 20 customers and suppliers prevents mass corrections.
Exempt customer treated as taxable (or vice versa)
Public bodies, certain medical or educational services and specific transactions require correct codes and statutory wording on invoices. Without flags in master data, every user risks applying 8.1% (standard rate in force from 1 January 2024, Art. 25 VAT Act) out of habit.
Cross-border transactions with misclassified partners
B2B services abroad, imports of services subject to acquisition tax or cross-border purchases depend on country, foreign tax ID and type of supply. A foreign supplier recorded only as “generic EU” produces incomplete VAT entries in the period.
Building validation at partner creation — for example blocking save if the VAT number is missing for a domestic VAT-registered B2B customer — is more effective than correcting hundreds of invoices at quarter-end.