Importing from Xero Online Accounting
Requirements
- Your Engagement properties must be manually set before import, as currently this import has no information about client profile.
- Create export files in Xero. This can be performed by a user with the Adviser role. For each report type, specify the corresponding options to ensure a functional import into Working Papers:
| Report type | Product | File type | Specify |
|---|---|---|---|
| Trial balance | Lacerte Tax | CSV | Year-end date |
| General ledger | Xero | TXT | Date range |
Prerequisites
- If Protection is activated, the File permission "Import" is required to perform this operation.
Procedure
-
Open the client file in which you want to import.
-
On the Engagement tab, in the Data group, click Import | Accounting Software.
-
In the Import From field, select Xero and in the Version field, select version 2013.
Note: Click here to see all accounting software supported versions.
-
In the Import Path field, type the exact path where the file you want to import resides or use Browse to locate the file manually.
-
Under Import Components, choose to import either:
- The Trial Balance (Opening Entries) or,
- The General Ledger Detail.
When importing general ledger imports or trial balance imports with Period Balances, the transaction file must be specified.
-
To import client information, click Import Client Information. This information will be displayed in the Engagement Properties dialog.
- Click TB file to specify the trial balance file in *.csv format.
- Click GL file to specify the transaction file, *.txt format if applicable.
- Click OK to begin importing.
Results
Accounting data is imported into the client file.
For more on exporting data from Xero, see their Exporting help guide.
