How to Transfer Invoices from Autotask to Xero
There are two ways to transfer invoices from Autotask to Xero: export them and import a spreadsheet by hand, or sync them automatically. This guide walks through both, so you can decide which one fits your month end.
Can you transfer invoices from Autotask to Xero?
Yes. Autotask doesn't have a built-in Xero connection, so you either export your invoice data and import it into Xero as a CSV file, or use an integration that talks to both systems through their APIs. The manual route works for a handful of invoices. Once you're billing dozens of clients every month, an automated sync saves hours and removes the keying errors.
The manual way: export from Autotask, import into Xero
This is how most MSPs start. It needs no extra software, but every invoice run has to be prepared and checked by hand.
Xero's own guidance on importing sales invoices from a CSV file is on Xero Central, including the template and the required columns.
-
1
Export your invoices from Autotask
Once you've processed your invoice batch in Autotask, open the invoice history and export the invoices for the period, along with their line items, to a spreadsheet.
-
2
Reformat the data for Xero
Download Xero's sales invoice import template and copy your data into it: contact name, invoice number, dates, line descriptions, quantities, prices, account codes and tax rates.
-
3
Map codes and contacts by hand
Swap each Autotask billing code for the right Xero account code and each tax category for a Xero tax rate. Contact names must match Xero exactly, or Xero creates duplicates.
-
4
Import and check in Xero
Import the CSV into Xero as draft invoices, fix any rows Xero rejects, then review and approve each invoice before it goes to your clients.
Why it's painful to transfer invoices from Autotask to Xero by hand
The CSV route is fine for a few invoices. As your client list grows, the same jobs come round every month and take longer each time.
Manual CSV import
- Export, reformat and import every invoice run
- Account codes and tax rates mapped by hand each time
- Duplicate contacts when names don't match exactly
- Payments in Xero never make it back to Autotask
- Easy to miss an invoice or post one twice
Automatic sync with upSync
- Invoices pulled from Autotask and pushed to Xero for you
- Billing and tax codes mapped once, then reused
- Contacts matched by name or account number, or created
- Paid status sent back to Autotask automatically
- Every sync logged, so you can see exactly what went where
The automatic way: transfer invoices from Autotask to Xero with upSync
upSync is a cloud app built by an MSP that had exactly this problem. It connects to the Autotask and Xero APIs, so there's nothing to install and no spreadsheets to build.
Plans start at £20 a month, every plan includes every feature, and you can try it free first. See choosing an upSync plan for the invoice limits.
Start a free trial-
1
Connect Autotask
Create a dedicated Autotask API user and enter its details. upSync finds your Autotask zone automatically. See how.
-
2
Connect Xero
Sign in to Xero securely and pick your organisation. upSync imports your account codes and tax rates. See how.
-
3
Map your codes once
Match Autotask billing codes to Xero account codes and tax categories to Xero tax rates.
-
4
Sync, or let it run on a schedule
Choose a date range and sync, or turn on scheduled sync and upSync transfers new invoices from Autotask to Xero every day.
Autotask to Xero questions
Does Autotask integrate with Xero?
Not out of the box. Autotask doesn't include a native Xero connection, so you need to either import invoices into Xero by hand or use a third-party integration such as upSync.
Can I import Autotask invoices into Xero with a CSV file?
Yes. Xero accepts sales invoices from a CSV file, but your Autotask export needs reformatting to match Xero's template, with account codes, tax rates and exact contact names filled in.
Will upSync create my Xero contacts?
Yes. upSync matches Autotask companies to Xero contacts by name or account number, and creates any contacts that are missing.
Does upSync update Autotask when an invoice is paid?
Yes. When an invoice is marked as paid in Xero, upSync can update the matching invoice in Autotask, so you don't have to chase payment status across two systems.
What if we use Sage 50 instead of Xero?
Use AT2Sage, our Autotask to Sage 50 integration. Our guide on how to transfer invoices from Autotask to Sage 50 covers both the manual and automatic options.
Stop keying Autotask invoices into Xero
Try upSync free and transfer your next invoice run from Autotask to Xero in minutes.