You will find this import in Essentials -> Update.
If you don't want to connect XLReporting to your accounting system, or if your accounting system does not allow integration, you can import your data via our standard Excel template. Most accounting systems have some way to export data into a file. We designed our Excel template to make it easy to be populated from any other source with a few simple copy & paste operations.
Below is a step-by-step guide on how to use the populate and import our Excel template.
If you are getting validation messages after the import, please check the
1. The company codes in your Excel file must be exactly the same as the company codes you entered in Essentials -> Update -> Settings.
2. Your file may not contain any rows with other data, or any rows without proper reporting codes and accounts (columns B, C, and D).
Our Excel file contains 3 example sheets, each for a different company. You can add, copy, or delete sheets as needed, one for each of your companies. Please follow these instructions for filling in each sheet:
These simple steps will import your balances from any system via Excel into XLReporting. This process ensures that your financial data remains up-to-date, accurate, and easily accessible.
If you want to get more out of your data, you can! Our import connectors can access all information available in 40+ systems and file types. Contact us and ask about the possibilities. Or read our documentation about integrations and connectors.