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.
Check your preparation file
Row numbers count CSV records, with the header as row 1. A quoted field with line breaks still belongs to one row.
| Row | Column | What to fix |
|---|
The report includes every issue, with spreadsheet formula protection. It does not include original data rows.
These checks cover the selected MUST template only. Confirm source records, identifiers and import requirements with your provider before implementation.
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 templateInvoice 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 templateTurn 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.
Your file and check results are not added to the enquiry.