In order to import your financials data from Xero you must export your Profit & Loss and Balance Sheet reports into Excel. Each report can contain multiple comparative periods per file.
You can import financials for Annual, Quarterly or Monthly periods. Please follow the instructions below to import your financials from Xero.
In this Article
Exporting Profit & Loss
- Go to Xero > Accounting > Reports.
- Type Profit and Loss in the Search Reports field.
- Select OLD Profit and Loss report from the search results.
- Switch to Compare Periods tab.
- In the Date field select a reporting month.
- In Period select a reporting period. It can be Annually (12 months), Quarterly (3 months) or Monthly (1 month).
- Select a number of comparative periods in Compare With field if you need.
- Click Update.
- At the bottom right report's corner click Export > Excel.
Exporting Balance Sheet
- Go to Xero > Accounting > Reports.
- Type Balance Sheet in the Search Reports field.
- Select OLD Balance Sheet report from the search results.
- In the Balance Date field select a reporting balance date.
- In Compare To select a comparative period. It can be Annual (Previous Year), Quarter (Previous Quarter), Month (Previous Month) or None if you don't need to import comparative periods.
- Select a number of comparative periods in Compare Periods field if you need.
- Click Update.
- At the bottom right report's corner click Export > Excel.
Importing Financials
- In LodgeiT select a client you want to import financials for.
- Go to Financials and select Xero from the list.
- Select exported Excel files from your device and click Upload.
Refreshing Financials
In order to refresh financials repeat actions described above.