Skip to main content

Prepare customer, supplier and invoice data for InvoiceNow

Start with a clean copy of your contact records and invoice summaries. Map them to the MUST preparation templates, resolve missing values and duplicates, then reconcile invoice totals. These CSV checks help prepare a provider handover; they do not validate a complete Peppol invoice or establish GST compliance.

Written and reviewed by MUST TechnologyReviewed

Make a working copy with a clear scope

Keep the original export unchanged and note its source system, entity and date. Prepare a small representative sample before processing a large file. Use one invoice-number namespace per file: the checker treats repeated invoice numbers as duplicates, so unrelated entities with overlapping numbering should be checked separately.

The CSV data check runs locally in your browser without uploading your file. It accepts files up to 2 MB and 5,000 data rows. Keep the exact lowercase headers, remove extra columns and quote values containing commas. Download fresh templates if your spreadsheet has renamed the columns.

Map customer and supplier records

Contact preparation template
ColumnWhat to enter
record_typecustomer or supplier. Use a separate row for each role.
company_nameRequired company name, no more than 200 characters.
country_codeRequired uppercase two-letter country code, such as SG.
identifierRequired stable business identifier, up to 100 characters.
peppol_idOptional confirmed ID. The checker checks format only.
emailOptional single email address.

The duplicate key combines role, country and identifier. Compare conflicting rows with the source records before choosing which to keep. A company may legitimately appear once as a customer and once as a supplier.

Verify the intended recipient with the trading partner and the SG Peppol Directory. A value matching the checker’s four-digits, colon and identifier pattern does not prove that a participant exists. Leave an unconfirmed optional ID blank while you investigate.

Directory context: SGNIC’s InvoiceNow directory guidance. The field rules above describe MUST’s preparation checker.

Reconcile the invoice-summary columns

All six invoice-summary columns are required
ColumnWhat to check
invoice_numberA unique reference within the file, up to 100 characters.
invoice_dateA real calendar date in YYYY-MM-DD format.
currencyA supported uppercase currency code.
net_amountNon-negative amount before tax, up to two decimal places.
tax_amountNon-negative tax amount, up to two decimal places.
total_amountExactly net amount plus tax amount.

Supported currencies are SGD, MYR, USD, EUR, AUD, GBP, HKD, CNY, INR, NZD and CHF. Remove currency symbols and grouping commas from amounts. The template does not support negative credit-note amounts; agree that mapping separately with your provider.

Illustrative CSV row: the numbers below demonstrate arithmetic only, not the tax treatment of a real transaction.

invoice_number,invoice_date,currency,net_amount,tax_amount,total_amount
EXAMPLE-001,2026-11-18,SGD,100.00,9.00,109.00

If the total is wrong, reconcile the underlying invoice and rounding first. Changing a cell merely to make the check pass can conceal the original problem.

Take the remaining mapping into implementation

The six-column summary contains no invoice lines, addresses, tax-category mapping or document relationships. IRAS specifies mandatory invoice-data elements separately; your provider must map the complete records for the intended submission flow.

Source: IRAS e-Tax Guide, section 9: mandatory data elements (PDF).

  • Download the issue report and assign each correction to the source-data owner.
  • Correct the working copy, rerun the check and retain both versions.
  • Record unresolved recipient IDs and tax questions for provider review.
  • Carry representative invoices and credit notes into workflow testing.

A clean preparation file is a useful handover artifact. Full document validation, registration checks and accounting review remain separate implementation tasks.

Official sources

Sources checked on . Use the linked guidance for current requirements and your business’s circumstances.

Check a small sample of your data

Download the actual CSV templates and review the issues in your browser.

Open the CSV data check
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.