Exporting billing data
While Autotask allows you to generate invoices and financial reports, it does not have a system for tracking Accounts Receivable and Accounts Payable, or General Ledger functionality. Billing items are considered pending revenue before they are approved and posted, and billed revenue as soon as they are posted. Exporting or invoicing an item has no impact on revenue recognition.
Because of this limitation, a large number of Autotask customers use external accounting applications. For a complete list of accounting integrations with Autotask, refer to the list of accounting integrations on the Datto website.
Autotask provides the following export tools:
- A tool that lets you export invoices to generic XML format. Refer to Exporting invoices to generic XML.
- An export wizard that lets you export billing transactions (not invoices) to .CSV. Refer to Exporting billing data using the Export Wizard.
- The same export wizard will allow you to export billing transactions to XML in the format required by Sage 50 Accounts or SageLine 200.
Exports using the export wizard (to .CSV and the XML format required by Sage) are tracked on the Export History page. Refer to Search and manage the Export History.
Exports using the export wizard are tracked on the Export History page. Refer to Search and manage the Export History.
How exporting and invoicing work together
The same transactions can both be invoiced in Autotask, and exported: the two methods do not conflict with each other. This is because the invoice and export status of each transaction is tracked separately. A transaction that has been exported is still available for invoicing, and one that is invoiced is still available for exporting.
How Multi-currency impacts exports
If Multi-currency is enabled, the following columns will use the customer currency values instead of the internal currency:
- Hourly Billing Rate
- Extended Price
- Milestone Amount
- Billed Amount
- Service Unit Price
- Service Extended Price
- Setup Fee
- Unit Price
- Total Tax
All other existing columns will export internal currency values.
The following columns will be added to the end of the output for CSV and Excel exports. These columns will represent the values of their corresponding existing columns in the internal currency.
- Internal Currency Hourly Billing Rate
- Internal Currency Extended Price
- Internal Currency Billed Amount
- Internal Currency Total Tax
Sage exports will be unaffected.
