How to Transfer Invoices from Autotask to Sage 50
There are two ways to transfer invoices from Autotask to Sage 50 Accounts: export and import the data yourself, or send them across automatically. This guide covers both, so you can pick the one that suits your invoice run.
Can you transfer invoices from Autotask to Sage 50?
Yes. Autotask doesn't connect to Sage 50 Accounts out of the box, so you either export your invoice data and use Sage's data import, or use an integration that posts invoices straight into Sage. Importing by hand works for a few invoices a month. For a full monthly invoice run, an automated tool is quicker and far less error-prone.
The manual way: export from Autotask, import into Sage 50
This needs no extra software, but you'll be preparing and checking a spreadsheet every time you bill.
Imported records post to Sage as sales invoice transactions on each customer's account. They aren't full invoice documents you can open, print or email from Sage's invoicing screen. For details of the import format, see Sage's own help.
-
1
Export your invoices from Autotask
After processing your invoice batch in Autotask, export the invoices for the period, including line items, to a spreadsheet.
-
2
Check your Sage customers
Every invoice needs a matching Sage account reference. Any new Autotask customers have to be created in Sage first, or imported separately.
-
3
Build the import file
Reformat the data into Sage's import layout: account reference, date, invoice reference, details, nominal code, net amount, tax code and VAT for each line.
-
4
Import and reconcile in Sage 50
Run Sage's data import, fix any rows it rejects, then check the totals against Autotask before you send anything to clients.
Why it's painful to transfer invoices from Autotask to Sage 50 by hand
The spreadsheet route works at first. As your client list grows, so does the time it takes and the chance of a mistake.
Manual import
- Export, reformat and import every invoice run
- Nominal and tax codes entered by hand each time
- New customers must be set up in Sage first
- Imports post as transactions, not printable invoices
- Credit lines and purchase orders handled separately
Automatic transfer with AT2Sage
- Invoices downloaded from Autotask and sent to Sage in a few clicks
- Billing codes mapped to Sage nominal codes once
- Missing customers created and details kept up to date
- Real Sage invoices, with a free invoice template
- Credit notes and purchase orders handled too
The automatic way: transfer invoices from Autotask to Sage 50 with AT2Sage
AT2Sage is a Windows application built by an MSP to end double entry between Autotask and Sage 50. It runs on the same computer as Sage and posts invoices directly into your accounts.
It works with UK and Ireland editions of Sage 50 Accounts. Subscriptions start from £595 + VAT a year, and there's a free, fully functional 30 day trial.
Download a free trial-
1
Install AT2Sage
Install it on the same computer as Sage 50 and start your trial. See how.
-
2
Connect Autotask
Your Autotask administrator creates a free API user for AT2Sage. See how.
-
3
Connect Sage and map your codes
Enable Sage's third party integration, then set your nominal codes and tax codes.
-
4
Download and send to Sage
Download invoices by date range, check them, then click Send To Sage to transfer them from Autotask to Sage 50. See how.
Autotask to Sage questions
Does Autotask integrate with Sage 50?
Not out of the box. Autotask doesn't include a native Sage 50 connection, so you need to import invoices by hand or use an integration such as AT2Sage.
Which versions of Sage 50 does AT2Sage support?
AT2Sage works with UK and Ireland editions of Sage 50 Accounts. Check the compatibility guide in our knowledge base before updating Sage.
Does AT2Sage calculate VAT?
No. Items are sent to Sage excluding VAT with the correct Sage tax code, and Sage calculates the VAT, so your VAT return stays accurate.
Can AT2Sage send purchase orders as well as invoices?
Yes. It downloads Autotask purchase orders and sends them to Sage 50, matching supplier accounts by account number or creating them when they're missing.
What if we're moving from Sage to Xero?
Use upSync instead. AT2Sage customers can trade in their licence for upSync, and our guide on how to transfer invoices from Autotask to Xero explains the options.
Stop keying Autotask invoices into Sage
Try AT2Sage free for 30 days and transfer your next invoice run from Autotask to Sage 50 in minutes.