Sage Invoice Import Errors
Fix the most common failures when importing a DocuClipper invoice CSV into Sage — file-format rejections, missing columns, wrong Type codes, and unrecognized supplier or nominal codes.
Last updated
Sage has stricter import rules than QuickBooks or Xero, so most failures come down to file formatting rather than the data itself. DocuClipper exports a Sage-compatible CSV; if Sage rejects it, work through the cases below.
"The file could not be imported" / file won't import
Almost always a CSV-format problem. Save the file as CSV (UTF-8) with the column headers in the very first row — no blank rows above them and no merged cells. Re-export a fresh CSV from DocuClipper rather than editing and re-saving in Excel, which can reintroduce formatting Sage rejects.
Missing required columns
Sage rejects the whole file if a required field is absent. For Audit Trail Transactions you need at minimum Type, Account Reference (Nominal Code), Date, and Net Amount. Add any missing columns in DocuClipper before exporting so the header row is complete.
Wrong or blank transaction Type code
A blank or invalid Type column fails the row. Sage does not infer these — set them explicitly:
| Type code | Meaning |
|---|---|
PI | Purchase invoice |
SI | Sales invoice |
PC | Purchase credit note |
SC | Sales credit note |
Unrecognized supplier or nominal code
Sage will not auto-create suppliers or nominal codes on import the way Xero auto-creates contacts. Make sure the Account Reference and Nominal Code already exist in Sage, or the row is flagged.
Date or amount format mismatch
Dates must match your Sage regional format (commonly DD/MM/YYYY), and amounts must be plain numbers — no currency symbols or thousands separators. Adjust the column in DocuClipper and re-export.
Duplicate invoice numbers
Sage flags repeated references. Confirm each invoice number is unique before re-importing.
When Sage reports failed rows
Sage lists the failed row and its error message. Correct the field in DocuClipper, re-export the CSV, and re-import only the corrected rows.
FAQs
Why won't my CSV import into Sage?
Most often the file format. Re-export a fresh CSV (UTF-8) from DocuClipper with headers in the first row, no blank rows, and no merged cells.
What Type code should I use for a supplier invoice?
Use PI for purchase (supplier) invoices, SI for sales invoices, PC for purchase credit notes, and SC for sales credit notes.
Does Sage create suppliers automatically on import?
No. Unlike Xero, Sage does not auto-create suppliers or nominal codes. They must already exist, or the row is rejected.
Can I upload PDF invoices directly to Sage?
No. Sage needs a formatted CSV. Use DocuClipper to extract the PDF data and export a Sage-compatible CSV, then import that.