To upload your accounting using Excel, you must first log in to the parent company's account. Then, click "Corporate group" at the bottom of the left menu.
Click on "Corporate group Consolidation" to access the consolidation tool.
Once you're in the consolidation tool, click the "Legal Accounting" tab.
You will now see several options. Click on the arrow next to the "Upload accounting files" button and select "Export accounting template".
Choose the fiscal year for which you want to download the template. You can also choose to create a new fiscal year. Please note that this only creates a fiscal year for the accounting data, not the consolidation tool. Select "Save" and then "Export".
A download of the accounting template will automatically start. Please check that your browser is not blocking downloads if nothing happens. The accounting template is in Excel format and contains three tabs:a cover sheet, a tab for balance accounts, and a tab for income statement accounts. Fill in the account number, account name, opening balance, and amounts for each period in the balance tab. Fill in the account number, account name, accumulated amount, and amounts for each period in the income statement tab.
Save the Excel file and return it to the consolidation tool. Then click on "Upload accounting files".
Choose the file you want to upload and verify the correct information. Then click on "Upload accounting files".
You can now verify that the accounting has been uploaded by navigating to the subsidiary's account and then to Data Management.