Skip to main content

Prepare cleaner data.
Find the issues before setup.

Check customer and supplier records, or invoice summaries, against a MUST preparation template. Get a clear list of missing fields, duplicates and values to review.

Your CSV stays in this browser tab. No upload. No sign-up.

Enable JavaScript to check a file in your browser. You can still download the preparation templates and review the field guide below with your finance team.

Start with the right columns.

Export or copy your data into a MUST preparation template. Keep the exact lowercase headers; column order can vary. Extra columns are flagged. Blank data rows need removing.

Customer & supplier master
record_type Required
Use customer or supplier. A company with both roles has one row per role.
company_name Required
The company name, up to 200 characters. Quote a value containing commas or line breaks; double any quotes inside it.
country_code Required
An uppercase ISO two-letter code, such as SG, MY or TW.
identifier Required
A stable registration or business identifier from your source records, up to 100 characters. Letters, digits, spaces, dots, underscores, slashes and hyphens are accepted; start with a letter or digit. Identifier validity is not verified.
peppol_id Optional
If known, four scheme digits, a colon and an identifier without spaces. This preparation format check does not confirm a scheme, registration or reachable endpoint.
email Optional
One address, up to 254 characters, or blank. This is a basic format check, not a mailbox check.

Duplicates use record_type + country_code + identifier, ignoring identifier letter case and outer spaces. Matching records are flagged as duplicates; different values under the same key are flagged as conflicts. Company names alone do not determine duplicates.

Download contact template
Invoice summaries

One row per invoice, for one issuing entity and one invoice-number series per file. All six columns are required. This template covers non-negative invoice summaries; credit notes, line items, allowances, charges and rounding adjustments need a separate provider review.

invoice_number
Up to 100 letters, digits, dots, underscores, slashes or hyphens, starting with a letter or digit. Duplicate numbers are compared without letter case.
invoice_date
A real calendar date in YYYY-MM-DD format, from 1900 to 9999.
currency
Supported two-decimal currencies: SGD, MYR, USD, EUR, AUD, GBP, HKD, CNY, INR, NZD, CHF. Other currencies are outside this template.
net_amount, tax_amount, total_amount
Non-negative decimals, with up to two decimal places and a maximum of 999999999999.99 per field. No symbols, grouping commas or exponent notation. total_amount must equal net_amount + tax_amount exactly.

The checker does not decide tax rates, GST treatment, jurisdictional rules or whether your invoice is valid for submission.

Download invoice template

Turn the findings into a setup plan.

Review the source records with your finance team, then confirm the target format with your provider. A clean preparation file is one step in the wider implementation.

Review preparation with MUST

Your file and check results are not added to the enquiry.

Built and maintained by MUST Technology, Singapore.Explore MUST InvoiceNow

Speak to our team.

Tell us what you need. We reply within 3 business days.

  1. 1Your business
  2. 2Contact details
Your business
Contact details

A conversation about your requirements. No obligation.