Using LodgeiT Excel templates you can import financials data for Annual, Quarterly or Monthly periods.
In This Article
Download one of the following templates in order to prepare you import file.
- LodgeiT Import Template (Annual)
- LodgeiT Import Template (Quarterly)
- LodgeiT Import Template (Monthly)
Preparing Import File
- Specify Company Name and Financial Year. The template will automatically fill comparative periods for the specified FY.
- Add more comparative period columns if needed. You can add as many as you need.
- Add all your accounts and associated data for Profit & Loss and Balance Sheet.
- In LodgeiT select a client you want to import financials for.
- Go to Financials and select Excel from the list.
- Select prepared Excel file from your device and click Upload.
In order to refresh financials repeat actions described above.