Service · Data and analytics

Master data management

Suppose a plumbing wholesaler in St. Pölten has run Microsoft Dynamics 365 Business Central for twelve years. One and the same installer appears as Huber Installationen GmbH, as HUBER INST. and as a third record without a VAT number, created in a hurry one Friday afternoon. A thermostatic valve carries two item codes because it was once bought per piece and once per carton. Every guest checkout in the Shopware store spawns yet another customer. No report adds up, the sales reps have stopped trusting the revenue lists, and accounts staff patch things by hand before each EC Sales List goes out. We put these records in order. Just as importantly, we agree with you who may create new entries in future and under which rules, so that a year from now you are not back where you started.

Send an enquiry Inclusions overview

VAT IDs verified

through VIES and FinanzOnline

Duplicates

merged only after your team signs off

Named owners

for every master data domain

Quality report

monthly rather than once a decade

Everything this covers

Tidy data is not an end in itself. We start where bad records cost money, time or trouble with the tax office, and only then move on to cosmetic flaws.

Settle the details with an engineer

Customers elsewhere in the EU

VAT identification numbers confirmed through VIES or the FinanzOnline lookup. Anyone making tax-exempt intra-community supplies needs valid numbers, otherwise the EC Sales List will not reconcile.

Suppliers and bank details

One verified bank account per supplier, changes only under a four-eyes rule with confirmation over a second, known channel, and a log of every edit. That way a forged notice of new account details never turns into a payment to fraudsters.

Items ready for shop and marketplace

GTINs, pack units, weights and dimensions, so that Kaufland.at, Amazon and your own store show identical data and shipping with Post, DPD or GLS is priced correctly.

Addresses that get delivered

Postcodes, towns and streets written one consistent way, delivery and billing addresses kept apart, and delivery notes moved out of the name field. The result is fewer returned parcels and usable reports by federal state.

Commodity codes and origin

For goods crossing the EU border or appearing in Intrastat returns: tariff number, country of origin and net mass as mandatory fields instead of free text in a comments box.

Merging without forgetting

Each code that disappears is recorded against its successor in a lookup table, so historic documents, interfaces and reports continue to resolve correctly.

Weeding out what nobody needs

Guest accounts and dormant private customers from the online store, listed for a decision by you and whoever handles data protection. Records relevant to bookkeeping remain for the retention period set by Austrian tax law.

Our working method

We work on exports or through secured access to your system. Every change is preceded by a backup and by your approval.

Data profile

An automated analysis of every record set: empty mandatory fields, probable duplicates, invalid VAT IDs, items lacking a GTIN or weight. You receive one page of hard numbers rather than impressions.

Agreeing the rules

Together we define what counts as a valid customer record, who may create one and which fields are compulsory. Two short video sessions are usually enough.

Clean-up in batches

Suggested corrections are collected in a checklist for the data owner to approve line by line. Only then do we load them, each time after a fresh backup.

Locking it in

Mandatory fields, a duplicate check at the point of entry, restricted permissions and a monthly quality summary that catches stray records early.

A clean-up without an owner lasts about as long as a tidy desk. The moment the big exercise is over, sales, the web shop and accounts start adding customers again, each in their own style. That is why we name someone in your team for every data domain who spot-checks new entries and receives the monthly report. If nobody can take on that role, we will honestly advise you against an expensive clean-up.

Frequently asked questions

Typically BMD and RZL on the accounting side; Business Central, Mesonic WinLine, SAP Business One or Odoo for stock and orders; and Shopware, WooCommerce or Shopify for the online shop. What matters is that data can be exported and re-imported, which every mainstream system allows.

The data profile is ready within a few days. The actual clean-up is spread over several weeks so it never collides with invoicing or month-end. You receive a concrete timetable along with the profile.

Not across the board. Data relevant to bookkeeping is subject to statutory retention, whereas marketing data without a legal basis should go. We supply a reasoned list of proposals; the decision is yours, taken together with your tax adviser and your data protection contact.

Only if you want us to, and then always after a backup and in approved batches. Alternatively, we prepare import files that your own staff load.

Once the data profile is done, you receive a quote with an estimated hours budget at €110 per hour plus VAT.

Related work in the same area

Open the full area page

Service Data warehouse Figures from accounting, web shop and marketplaces gathered in one EU-hosted place Service Intelligent document processing Delivery notes, foreign invoices and freight papers read automatically and checked by people

Get your master data in order

Tell us which reports never match or where duplicate records get in the way. Our first step is a data profile that puts a number on the size of the problem.

Email
office@apply.at

Availability
Monday to Friday, 8:00-17:00 Austrian time (CET/CEST), reply within one working day

Meetings
By video on Microsoft Teams or Google Meet

By ticking this box I allow Apply to process my details for the purpose of answering this request (see our privacy notice for details)