Datagate: How to Export Invoices to Xero
Table of Contents
Scope
Intended Audience: White Label Partners
The following steps will show you how to export invoices from Datagate to Xero.
Requirements
- Access to Datagate
- Xero Integration
Export of Invoices via Dialog Box
- Log in to Datagate
- Navigate to Invoicing
- Switch to Action Invoices
- Change Invoice status to Sent Manually
-
Note: Invoices cannot be exported in the Generated Status
-
Note: Invoices cannot be exported in the Generated Status
- Select the invoices with the Generated status
- Click the Action Button and Select Mark as Sent
- Your invoices status should now show as Sent Manually
- Your invoices status should now show as Sent Manually
- Select the invoices you want to export
-
- Click the Action Button and Select Export Invoice
- Select Xero Multiline and configure the parameters below, then click Export
- Type of Export: Xero Multiline
-
Xero Account: If you want to use a single GL Code for all invoice lines – choose a single Xero Account.
- This option means that you do not need to set up multiple GL Codes against Products or Usage Call Types, you can just set it once here when exporting.
-
Override account with GL code: If you want to use multiple GL Codes per invoice line – use the “Override account with GL Code” checkbox.
- This will override the default “Xero (GL) Account” selected above and use the Datagate GL Codes from the invoice lines (based on products and usage call type GL Codes in Datagate).
- The Xero Account GL account field can also be used to post the Datagate Invoice Tax lines to a separate Xero GL account. Selecting the Xero Account for the Tax lines will ensure the Invoice tax lines are posted to a different GL Account than the other non-tax lines.
- Note: If you created surcharges, these surcharge lines will use the same GL code as the products the surcharges are calculated from. There is currently nowhere to set a different GL Code for surcharges.
- Xero Payment: Optional field where you can select the Xero payment account.
-
Invoice Status: The status of exported Invoices in Xero. The following statuses are available:
- Draft Status – does not create accounting GL entries. Requires finalization/approval of invoices in Xero. Some Users like this option to review and approve invoices in Xero instead of Datagate
- Note: Draft Status is recommended if you are testing Invoice export since it does not create GL Entries etc.
- Awaiting Payment – creates an approved invoice awaiting payment. This option does create GL Entries. If the invoice in Xero is wrong the invoice would need to be “VOIDED” and recreated.
- Draft Status – does not create accounting GL entries. Requires finalization/approval of invoices in Xero. Some Users like this option to review and approve invoices in Xero instead of Datagate
-
Mark Invoice as sent: To mark invoices as sent in Xero.
- The progress bar will now show invoices being exported and will show you once completed
Invoices should now appear in Xero. Make sure to confirm this before sending invoices to customers
Export of Invoices via Export Wizard
- Follow the same steps above to export invoices
- The Invoice export wizard consists of two steps:
- Export Options
- Tax Mapping
- The Export Options step contains the same parameters as above
- The Tax Mapping step contains options related to exporting telecom taxes.
- Multiline Taxes: If enabled, each tax (taxes grouped by name) will be exported to Xero as a single invoice line. Otherwise, a single invoice line for all taxes will be created in Xero.
-
Split Taxes by State: If enabled, taxes will be additionally grouped by the State they are related to.
- Click Export to begin the export process. The process is the same as described above for the dialog box export.