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
| Column | What to enter |
|---|---|
record_type | customer or supplier. Use a separate row for each role. |
company_name | Required company name, no more than 200 characters. |
country_code | Required uppercase two-letter country code, such as SG. |
identifier | Required stable business identifier, up to 100 characters. |
peppol_id | Optional confirmed ID. The checker checks format only. |
email | Optional 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
| Column | What to check |
|---|---|
invoice_number | A unique reference within the file, up to 100 characters. |
invoice_date | A real calendar date in YYYY-MM-DD format. |
currency | A supported uppercase currency code. |
net_amount | Non-negative amount before tax, up to two decimal places. |
tax_amount | Non-negative tax amount, up to two decimal places. |
total_amount | Exactly 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.00If 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.
- IRAS: Adopting GST InvoiceNow RequirementSection 9 covers mandatory invoice-data elements. PDF.
- SGNIC: InvoiceNow Service Metadata PublisherExplains the Singapore directory and participant lookup.
Check a small sample of your data
Download the actual CSV templates and review the issues in your browser.
Open the CSV data check