Skip to content
Guides

Xero export: paid jobs to your accountant without retyping

Typing invoices into your accounts a second time wastes an evening. How the Xero-formatted sales invoice export works, and the defaults your accountant should know.

The short version
  • Sales invoices can be exported in a format Xero imports.
  • The file uses account code 200 and 20% VAT on income by default.
  • Your accountant can adjust codes on import if yours differ.

Double entry, the bad kind

You raise an invoice for the customer. Then, at the end of the month or the quarter, you or your bookkeeper type the same invoice into your accounting software. Customer name, date, amount, VAT. For a business sending forty invoices a month, that is an evening of copying, with every chance of a wrong digit. It is the kind of job that gets put off until the VAT return is due, and then done in a hurry when mistakes are most likely.

One file for Xero

From the billing area of your settings you can download a sales invoice export formatted for Xero. It contains your invoices laid out in the columns Xero's import expects. In Xero, your bookkeeper chooses to import sales invoices and selects the file. The invoices appear in your accounts without anyone retyping them. What took an evening takes a few minutes, and the figures in your accounts match the invoices your customers received.

The defaults to know about

The export uses account code 200, which is the standard sales account in a default Xero chart of accounts, and applies 20% VAT on income. Those suit many small VAT-registered businesses as they are. If your chart of accounts uses different codes, or some of your sales are at a different rate or exempt, your accountant can change them during the import or straight afterwards.

If you aren't VAT registered

Tell your accountant before the first import. A business that isn't registered for VAT shouldn't be recording VAT on its sales, so the tax setting needs changing on import. This is a quick adjustment for anyone who knows Xero. It is worth one conversation at the start so that every later export goes in cleanly.

A sensible routine

Pick a day each month. Mark invoices paid as money arrives, so your records are current. On your chosen day, download the export and send it to your bookkeeper, or import it yourself. Keeping to a routine means your accounts are never more than a month behind, and the quarter-end rush becomes a non-event. It also means you can see how the month went while there is still time to act on it.

Other accounting software

If you use something other than Xero, the general CSV export gives you your leads, messages and timeline as spreadsheets that open in any program. Many accounting packages can import invoices from a spreadsheet with a little column matching. For a live connection to other software, a webhook can send each new lead to Zapier or Make, which connect to most common tools.

Questions people ask

Can I export invoices to Xero?

Yes. A Xero-formatted sales invoice export is available from the billing area of your settings, ready for Xero's import.

Which account code and VAT rate does the export use?

Account code 200 and 20% VAT on income by default. Your accountant can adjust these on import.

What if I don't use Xero?

Use the general CSV export, which opens in any spreadsheet and can be mapped into most accounting software.

This is what Lead Capture AI does for you

She answers the calls you can’t, knows your business, and texts you the details in seconds. Your number is live the day you sign up, and the first 7 days are free with no card.