What you get
Fjordbill creates a CSV for Xero’s sales invoice import (Sales → Invoices → Import). It uses the exact column headings of Xero’s import template, including the asterisks, so Xero recognizes every column. Each row is one invoice line; rows with the same invoice number become one invoice, and Xero adds them as drafts for you to approve.
| Column | What Fjordbill puts in it |
|---|---|
| *ContactName | The client name. Match the contact name in Xero to avoid duplicates |
| EmailAddress | The client’s email from Fjordbill |
| POAddressLine1–4, POCity, PORegion, POPostalCode, POCountry | Left blank, so existing contact addresses aren’t touched |
| *InvoiceNumber | Your Fjordbill invoice number |
| Reference | The PO number, or the job title |
| *InvoiceDate / *DueDate | MM/DD/YYYY, the format Xero uses for US organizations |
| *Description, *Quantity, *UnitAmount | Each line with its quantity and tax-exclusive unit price |
| Discount | Percentage discounts as a number without the % sign. Fixed-amount discounts become a separate negative “Discount” line |
| *AccountCode | Your sales account code. You enter it once in Fjordbill (200 by default); it must match your Xero chart of accounts |
| *TaxType | The tax rate name for taxed lines (by default the tax name on the invoice, or one you type in) and “Tax Exempt” for untaxed lines |
| TaxAmount | The sales tax Fjordbill calculated for the line, so Xero’s totals match to the cent |
| Tracking, Currency, BrandingTheme, InventoryItemCode | Left blank |
How to import Fjordbill invoices into Xero
- Open Reports in FjordbillTap QuickBooks · Xero · Wave export and choose Xero · sales invoices.
- Set the range, status and codesPick the invoice dates and choose all sent invoices or only paid ones. Check the sales account code and tax rate names against your Xero organization.
- Share the CSVSave it to Files or Drive, or email it to yourself, and open Xero on a computer.
- Import in XeroGo to Sales → Invoices → Import and choose the file. Decide whether Xero should update contact details (Fjordbill leaves addresses blank).
- Choose “Tax exclusive”Fjordbill’s unit amounts are before tax, so select tax exclusive when Xero asks.
- Review and approveFix anything Xero flags, complete the import, then review and approve the draft invoices.
Tips for a clean import
- Xero recommends no more than 500 lines per file. For a busy year, export a quarter at a time.
- Each invoice number can only be imported once. If an invoice already exists in Xero, that invoice is skipped.
- Marking invoices as paid in Xero is a separate step: record the payments there, or reconcile them against your bank feed.
Frequently asked questions
Can I import Fjordbill invoices into Xero?
Yes. Fjordbill exports a CSV with the column headings of Xero’s sales invoice import template. Upload it under Sales → Invoices → Import and the invoices arrive as drafts.
Do I need to connect Fjordbill to my Xero account?
No. There’s no connection, login or partner app. Fjordbill isn’t affiliated with Xero; it simply creates a file that you import with Xero’s own import tool.
What account code and tax type should I use?
Use the code of the revenue account you post sales to (many Xero charts use 200 for Sales, but check yours) and the exact names of your tax rates from Settings → Tax rates. You can change both on Fjordbill’s export screen.
Will the totals match Fjordbill?
Yes. Unit amounts are exported before tax and every line carries the tax amount Fjordbill calculated, so choose “Tax exclusive” when importing and the totals line up to the cent.
Is the Xero export free?
Yes. Every export is included in Fjordbill’s free plan.
QuickBooks, Xero and Wave are trademarks of their respective owners. Fjordbill is not affiliated with or endorsed by them. Import screens and limits are described as documented in each program’s help center in November 2026 and may change; check the program’s current help article if a screen looks different.