Sage CSV Import and Export: UK, AU, CA, and US Ledgers

Sage Is Template-Driven — CSV Must Match

Sage Accounting (cloud) and Sage 50 (desktop generations) remain core ledgers for UK SMEs, with strong footprints in Canada, Australia, South Africa, and parts of the US. CSV bridges bank lines, customers, suppliers, invoices, and journals — but each product edition expects its own column contract.

Download Sage’s sample for your exact product before reshaping Excel. A QuickBooks or Xero layout will not import cleanly.

Which Sage CSV Path?

Product family first; import type second.

Step-by-Step: Prep a Sage Import CSV

Works across most Sage CSV wizards.

• Export or download the official CSV template for that import type.
• Map your source columns to template headers exactly (spelling and order if required).
• Normalize dates to the format Sage shows in the sample for your locale.
• Strip currency symbols; use plain decimals with the decimal mark Sage expects.
• Match nominal codes, VAT rates, and customer names to existing records.
• Save UTF-8 CSV; preview in the Online CSV Editor.
• Import a 5–10 row pilot; fix errors; then load the rest.

Company Name,Contact Name,Email,Telephone,Address 1,City,Postcode,Country
Acme Ltd,Sam Lee,sam@acme.example,02079460000,1 High St,London,SW1A 1AA,United Kingdom

UK Dates, AU Dates, and US Mix-Ups

Sage UK and AU companies live on day-first dates. US-trained Excel habits break imports on days 1–12.

• Test with a transaction dated the 13th or later — if it fails, the mask is wrong.
• See the CSV Date Formats guide for cross-border teams.

VAT, GST, and Tax Codes

Tax columns fail more often than amount math.

• UK: VAT rate names/codes must match the company settings (e.g., standard T1-style codes in older desktop worlds, named rates in cloud).
• AU: GST codes must exist before invoice import.
• CA: tax groups differ by province — do not reuse UK VAT labels.
• Never put “20%” in a tax code field unless that is literally the code name.
• Net vs gross amount columns: follow the template; do not assume.

Customer,Invoice Number,Date,Due Date,Nominal Code,Description,Quantity,Unit Price,Tax Rate
Acme Ltd,INV-1001,01/05/2026,31/05/2026,4000,Design services,1,1200.00,Standard

Bank Statement CSV into Sage

Reconciliation still wants clean Date, Description, and Amount.

• Prefer bank CSV or OFX/QIF converted to CSV for review.
• Collapse money-in/money-out into one signed amount if Sage’s mapper expects it.
• Remove running balance columns that shift field mapping.
• German/EU bank files with semicolons: convert delimiter before a UK Sage comma import.

Excel and Encoding for Sage 50

Desktop generations are pickier about code pages.

• Prefer UTF-8 when the version supports it; otherwise follow Sage’s documented encoding.
• Avoid title rows, logos, and blank lines above headers.
• Keep account and phone fields as text.
• UK postcodes need spaces preserved — trim carefully.
• Do not upload .xlsx renamed to .csv.

Migrating from QuickBooks or Xero to Sage

CSV is the usual bridge; patience beats one giant file.

• Recreate chart of accounts and tax rates in Sage first.
• Import customers/suppliers before invoices.
• Bring opening balances as a controlled journal batch.
• Convert QuickBooks IIF leftovers to CSV for review — do not paste IIF into Sage.
• Keep a mapping sheet: old code → Sage nominal.

Common Mistakes

Frequent rejects.

• Using Xero TaxType names in a Sage tax column.
• US date order in a UK company file.
• Nominal codes that do not exist yet.
• Duplicate customer names creating split histories.
• Semicolon EU CSV uploaded without conversion.
• Editing Sage export columns and reordering without checking the wizard’s map step.

Best Practices

Treat Sage’s sample as the API.

• Re-download templates after product updates.
• Pilot imports every time.
• Archive each uploaded CSV with the company name and date.
• Document the company date locale in the bookkeeping SOP.
• Clean client files in-browser when handling multi-client practices.

Why Use Convert CSV Online?

Convert CSV Online is free, browser-based, and requires no account for everyday conversions. Fix Sage bank and contact tables in the Online CSV Editor, convert QIF/OFX-family downloads via the Finance File Converter, and switch European delimiters before UK Sage imports. Works on Windows, macOS, and Linux browsers.

Conclusion

Sage CSV success is template discipline plus locale discipline. Match headers, tax codes, and day-first UK/AU dates — then pilot — whether you run Sage Accounting cloud or Sage 50 desktop.