Xero Credit Note CSV Validator

🥦

Validate Complete

Validation Report Format
valid rows

Check your credit note CSV for errors before importing to Xero.

Free preview — then from $5. Save with bundles.
Free preview before you pay
Files never leave your browser
No account needed to start

Download Clean Sample

Valid Xero credit note CSV (no errors)

Clean Template

Download Error Sample

Sample with validation errors for testing

Error Example

Validation Questions Answered

What columns are required for Xero credit notes?

Required columns are ContactName, CreditNoteNumber, CreditNoteDate, Description, Quantity, UnitAmount, AccountCode, and TaxType. Optional: EmailAddress, Reference, DueDate, Currency.

Why must amounts be positive?

Xero automatically treats credit note amounts as credits that reduce the customer's balance. Using positive values follows Xero's convention.

What happens to my data?

Your file is processed entirely in your browser. No data is uploaded to our servers.

How Validation Works

1

Prepare Your Xero Credit Note CSV

Export or prepare your Xero Credit Note CSV file following the platform's template requirements.

2

Upload and Validate

Upload your Xero Credit Note CSV file. The validator checks every row against the expected format rules.

3

Review Validation Results

Fix flagged errors using the row-level report, then import your clean file with confidence.

Issues are flagged inline with clear fix suggestions — review and correct before you import.

How People Use This

Xero's credit note import has strict field requirements that aren't well documented. The validator checks every row against Xero's actual schema — catches missing contact names, invalid tax rate codes, and date formats that would fail silently on import.

Bridget O.
Xero-Certified Bookkeeper · 14 clients across 3 industries

We issue partial credit notes against invoices regularly, and the Reference field linking has to be exact or Xero creates orphaned credits. The validator flagged 17 rows where the Reference didn't match any existing invoice number and 5 rows with negative amounts that Xero would have rejected outright.

Jerome D.
Accounts Receivable Specialist · 200+ credit notes per quarter

Shopify exports refunds as negative amounts, but Xero credit notes require positives. The validator caught every negative in the UnitAmount column and also flagged rows where TaxType was 'Tax Exempt' instead of the org-specific rate code our Xero instance expects. Saved a full re-import cycle.

Suki P.
E-Commerce Finance Lead · Shopify refunds to Xero monthly

Why Validate Credit Notes Before Import?

Avoid Sign Errors

Xero credit notes require POSITIVE amounts (Xero treats them as credits automatically). Negative amounts cause import errors or incorrect accounting.

What This Tool Checks

We validate your credit note CSV against Xero requirements: - Required columns present (ContactName, CreditNoteNumber, CreditNoteDate, Description, Quantity, UnitAmount, AccountCode, TaxType) - Regional date formats (DD/MM/YYYY or MM/DD/YYYY) - Amounts are POSITIVE (Xero convention) - CreditNoteNumber is unique You get a detailed error report with row numbers to fix issues.

Your Data Stays Private During Validation

Every Row Checked

Each record is validated against format rules. Catch errors before they reach your platform.

Runs in Your Browser

Validation happens locally. Your data never leaves your browser.

GDPR Compliant

No files uploaded, no data retained. Full EU privacy compliance.

More credits - more savings

Buy bundles and get up to 60% off. Perfect for recurring monthly conversions.

Why Validate Before Importing?

Column Validation

Checks for required columns like ContactName, CreditNoteNumber, CreditNoteDate.

Positive Amount Check

Ensures amounts are positive (Xero credit note convention).

Regional Date Validation

Validates dates in DD/MM/YYYY (UK/AU/NZ) or MM/DD/YYYY (US) format.

Reference Linking

Validates Reference field format for linking to original invoices.

Browser-Based

Files processed locally. Your data never leaves your computer.

Instant Results

Get validation results in seconds.

Common Target Import Errors

Issues you might encounter when importing Source data to Target - and how we solve them

Missing Contact Name

The ContactName column is required for each credit note

(blank ContactName)
John Smith

Each credit note needs a contact name (customer)

Add contact names matching the original invoice customer

Missing Credit Note Number

The CreditNoteNumber column is required

(blank CreditNoteNumber)
1001-R

Each credit note needs a unique CreditNoteNumber

Add credit note numbers; often use original invoice + '-R' suffix

Invalid Date Format

CreditNoteDate must match your Xero region format

2025-01-15
15/01/2025 (UK) or 01/15/2025 (US)

UK/AU/NZ uses DD/MM/YYYY, US uses MM/DD/YYYY

Reformat dates to match your Xero organization's region

Negative Amount on Credit Note

Credit note amounts should be positive (Xero treats them as credits)

-49.99
49.99

Use positive values; Xero automatically treats them as credits

Convert negative amounts to positive

Tax Type Not Found

TaxType must exactly match a configured tax rate in Xero

20% VAT
20% (VAT on Income)

Use exact tax rate names from Xero Settings > Tax Rates

Update TaxType to match Xero's configured tax rates exactly

Frequently Asked Questions

Your data never leaves your device. All files are processed entirely in your browser using client-side JavaScript - no data is stored on our servers or sent anywhere. There's no account to hack, no database storing your files, and no API connections to your bank or accounting software. You upload, convert, download, and we forget it immediately.
No payment or signup required. You can upload your file, see a free preview of the conversion results, and verify everything looks correct before paying anything. If it doesn't work for your files, you haven't wasted any money. We only charge when you're satisfied and ready to download the final converted file.
You can, but free scripts and AI often miss edge cases that break real-world data: missing SKUs, currency formatting quirks, tax calculation errors, or date format mismatches. We have battle-tested validators specifically designed for accounting software imports that catch these issues before they corrupt your books. Plus, you get instant browser-based conversion without installing Python or managing dependencies.
Required columns are ContactName, CreditNoteNumber, CreditNoteDate, Description, Quantity, UnitAmount, AccountCode, and TaxType. Optional: EmailAddress, Reference, DueDate, Currency.
Xero automatically treats credit note amounts as credits that reduce the customer's balance. Using positive values follows Xero's convention.
Use the Reference field to store the original invoice/order number. In Xero, you can then allocate the credit note against the matching invoice.
Our converter tools automatically convert negative refund amounts to positive. This validator warns if negatives are present.
Your file is processed entirely in your browser. No data is uploaded to our servers.
Use ACCRECCREDIT for sales credit notes and ACCPAYCREDIT for purchase credit notes. The wrong Type can cause import validation errors.
Your TaxType must match a tax rate in Xero exactly (spelling/case). Pick a valid tax rate name/code from your Xero org.
The AccountCode must exist in Xero and be active. Match it exactly (no extra spaces) and ensure it’s valid for that credit note.
Use a consistent date format across the file (e.g., DD/MM/YYYY or MM/DD/YYYY). Mixed formats often cause import errors.
Small differences in ContactName can create a separate contact. Standardize names (and fix typos) before importing credit notes.

Learn More:

vs SaaSant vs Synder vs ApprovalMax vs Hubdoc vs Relokia vs Hevo Data vs CSVBox vs Datograde