Getting started with Aico
- Logging into Aico for the First Time
- Creating your first journal
- Creating your first request
- Creating your first payment
- Creating your first Intercompany Invoice
- Working with Closing Tasks
Working with Journals
- An overview of Aico journals
- How to create a manual journal
- Create a journal by copying existing journals
- Import new journals from Excel
- How to import multiple journals from one Excel spreadsheet
- What are recurring journal entries?
- How to create Recurring Duplicate Journal entries
- How to create Recurring Allocation journal entries
- Create recurring journals with automatic reversals
- Reversing documents
- Import data to existing journals
- Working with Reconciliations
- Basic settings in Aico documents
- Excel Support
- An overview of Aico Dashboards and Lists
- How to use lists in Aico
- How to use dashboards in Aico
- How to use charts in a dashboard
- Dashboards: Advanced Settings
- Manual closing tasks
Users and User Groups
- Overview of Users and User Groups
- Add user accounts
- Edit user account data
- Manage user groups
- Manage user roles
- Copying roles at the company level
- Copy user roles from individual users
- Create a user report
- Manage administrative user rights
- Super user mode
- Additional super user global admin rights
- User and User group export and import
- Value sets
- Currency Amount Groups
- Mail notifications
- Tax codes
- Managing PDFs
- Users and User Groups
- Introducing Automation Manager
- Core Set Up
- Introducing task templates
- Creating task template details
- The Aico Document
- Aico document headers
- Preparer and Approver workflow settings
- Overriding parameters at a company level
- Master data export and import
- Set a custom schedule
- Dependent tasks in Aico
- How to use Smart tags in Aico
- How to add an attachment to a task template
- How to create a preparer start time
- Task Generation
- Administrative tasks
- Release notes
- Maintenance Schedule
- Support Alerts
Importing document data via Excel
Modified on Thu, 08 Jun 2023 at 03:46 PM
Aico can interact with Excel in several ways.
This article shows how data is imported from Excel, either to create a new document from scratch, or to import data from Excel once a document has been created.
Creating the document
If you are creating a document from scratch, select:
2. Import document
Select the Excel file to be imported from the import from template pop-up and press import.
If you have already created the document then you can press the Import from Excel button from within the document and again select your Excel to be imported, as shown below:
There are a few things to be aware of:
- You cannot import data into headers or rows that are not editable by the role that you are currently working in. So, if the document is being created and the header is only editable by the Approver 1, you will not be able to upload data into that field even if it is correctly mapped in the Excel.
- You cannot upload data into any header or rows where a formula is set
- You cannot upload data into headers that are automatically set by Aico. For example, Workflow Status, Creator, Created At, Approver etc.
For all of these you will be given a warning and those fields will be ignored.
In Aico release 22.2 and earlier:
When you upload the Excel Aico will automatically recalculate any formulas set in the file. You should review this document for some limitations to the capability here.
In Aico release 23.1 by default, we no longer automatically recalculate the Excel formulas but now use the saved values in the Excel.
There is then a checkbox in the import dialog which you can tick to ask Aico to recalculate the formulas.
Aico mappings in the Excel sheet
The Excel import works based on the Excel Name manager mappings set in the worksheet. The mappings do not need to be created each time. You can simply open a document (empty or filled) and press the export to Excel. All the mappings are automatically included in the file into which you can enter your data and then use as an import.
The below image shows Header Mappings.
The below image shows Row Mappings.
Name Manager can be found under the Formula tab in Excel.
Was this article helpful?
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
We appreciate your effort and will try to fix the article