Comparison matrix
The same report generates a different column layout for each platform. Capabilities are the same across all three; only the file format changes.Sage
Sage exports come in two flavours, VAT-registered and non-VAT-registered, selected by a tick box on the report screen. The export includes a customer reference column that uses the Accounts software code field on each customer. If the field is blank, the export falls back toCUST{id} truncated to ten characters, which keeps the import valid but won’t match an existing Sage customer. Set the field on your credit-account customers before your first export to avoid hand-editing the file.
Ledger account is set to 4000 on every row. If your Sage chart of accounts uses a different sales code, you’ll need to remap it during import, either in the file or in Sage’s import mapping step.
VAT handling is simple. The export tags each row as Standard or Zero Rated based on the order’s VAT rate. Lower-rate, exempt, and no-VAT items aren’t broken out as separate codes; review those manually if your shop sells outside the usual two rates.
Required setup fields
Setting up Sage exports
Confirm your role has Exports: Financial
Set the Accounts Software Code on your credit customers
Run the export
Import into Sage
4000.Xero
Xero’s export matches the column layout of Xero’s invoice CSV import template, including the asterisk-prefixed required columns (*ContactName, *InvoiceNumber, *InvoiceDate, and so on).
Tax handling is more detailed than Sage. Digital Florists matches each invoice’s VAT against the tax rates configured in your instance and writes a label in Xero’s format (for example 20% (VAT on Income)). An invoice that mixes VAT rates exports one row per rate, using the VAT recorded on the invoice when it was issued.
Two things to watch for:
- Currency is your shop’s currency. The Currency column carries the currency your Digital Florists instance uses.
- Account code is
200. This matches Xero’s default Sales account out of the box. If you’ve changed yours, remap during import.
Required setup fields
No per-customer setup is strictly required. The export uses the customer’s name as the Xero contact, so first-time imports will create a new contact for any name Xero doesn’t already know. Review for duplicates after the first run.Setting up Xero exports
Confirm your role has Exports: Financial
Review your tax rates
Run the export
Import into Xero
QuickBooks
QuickBooks gets a leaner file: invoice number, customer, invoice date, due date, item amount (excluding VAT) and item tax code, plus VAT amount (reference) and Gross amount (reference). The first six columns are what QuickBooks needs to create an invoice on import. Leave the two reference columns unmapped and use them to check QuickBooks’ VAT against the VAT you issued, as QuickBooks may calculate it differently. An invoice that mixes VAT rates exports one row per rate, using the VAT recorded on the invoice when it was issued. The item tax code is the name of the VAT rate, so map each one onto your QuickBooks tax codes during import.Required setup fields
No per-customer setup is strictly required, same as Xero. QuickBooks will create a new customer record if it doesn’t recognise the name on a row.Setting up QuickBooks exports
Confirm your role has Exports: Financial
Map your tax codes
Run the export
Import into QuickBooks
When an invoice can’t be exported
Xero and QuickBooks need each invoice’s VAT to add up line by line. If an invoice’s issued VAT can’t be broken down reliably, it’s refused rather than exported with figures that might be wrong. When that happens, the download is a ZIP instead of a CSV, holding:- The import CSV with every invoice that could be exported. Import this file only.
refused_invoices.csv, listing each refused invoice number and the reason.READ_ME.txt, with how many invoices were exported and refused and what to check.
What’s included and what’s not
Worth knowing before you reconcile against the export:- Only invoices are exported. Credit notes, drafts, and deleted or archived invoices are excluded.
- Due dates fall back to the invoice date unless the customer is on a credit account, in which case the due date is worked out from the payment terms the invoice was issued with.
- Customer details are the ones each invoice was issued with, so editing a customer later doesn’t change an export. The Accounts software code and email address come from the customer’s current record.
- No customer master file. If you’re starting fresh on the accounting side, you’ll likely create new contacts on first import. Review for duplicates.
- No payment reconciliation back. Payments recorded against an invoice in your accounting package don’t flow back into Digital Florists.
Common questions
Why isn't this a live sync like Stripe or Shiptheory?
Why isn't this a live sync like Stripe or Shiptheory?
How often should I run the export?
How often should I run the export?
My Sage chart of accounts uses a different sales code, not 4000. What do I do?
My Sage chart of accounts uses a different sales code, not 4000. What do I do?
200).Can I export credit notes or refunds?
Can I export credit notes or refunds?
Why did I get a ZIP file instead of a CSV?
Why did I get a ZIP file instead of a CSV?
READ_ME.txt and refused_invoices.csv in the ZIP, import the CSV inside it, then check and export the refused invoices again. See When an invoice can’t be exported.My role doesn't show the Accounting Export tab.
My role doesn't show the Accounting Export tab.