|
55.10 Export to Xero |
  
|
|
55.10 Export to Xero |
|
55.10.1 Export Latitude Clients and Invoices to Xero
Under 'Name' in the Accounting Link screen, double-click on 'Xero-Export Clients & Invoices'. Alternatively, click on the report name and then on the 'Preview' button.
In the Report Dialog Box, enter a date range to select the invoices to be exported.
To export all invoices during the date range, enter '*' in the 'Invoice Ref' field.
If you select the 'Consolidate GL Account and Tax Type' option, invoice line items with the same GL Account and Tax Type are exported as a single line into XERO.
Click the 'Preview' button to open a report showing all invoices to be exported.
Verify that the invoices shown on the report are the ones you want to export.
Close print preview.
Click 'Yes' to confirm the export of the Invoice records out to a XERO text file format.
Click 'Ok' to continue exporting.
Click 'Ok' to confirm completed invoice export.
You will find two text files (xeroContacts.csv and xeroInvs.csv) in the directory you specified in the 'Export and Statement Path' setting in Setup Latitude unless you have not set it up properly.
55.10.2 Import Contacts and Sales to Xero
On the online Xero, click the 'Contacts' menu and select 'All Contacts' from the drop-down.
Click the 'Import' button.
If there are no errors to resolve, click the 'Complete Import' button. NOTE: This action cannot be undone.
You will see a message above the list of contacts confirming that a number of contacts have been added.
Click the 'Accounts' menu and select 'Sales' from the drop-down.
Click the 'Import' button.
Select the 'Xero' radio button.
Click 'Browse' in Step 3 and locate the 'xeroInvs.csv' file.
Click the 'Import' button.
55.10.3 Import Xero Contacts into Latitude
Log in to Latitude (Business or Professional editions).
On the ribbon, click 'Finance' and select 'Accounting Link' from the drop-down.
Click 'Link Xero' under 'Group'.
Under 'Name', double-click on 'Xero-Import Cards (Clients and Contacts)'. Alternatively, click on the report name and then on the 'Preview' button.
Enter the path of the Contacts.csv file location in the Import Xero dialog.
Click 'OK'.
This will open a report listing imported Xero contacts.
Close the preview.