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
Splitting document data via Excel import
Modified on Tue, 06 Jun 2023 at 11:06 AM
This article shows how you can use an Excel import file to create multiple Aico documents by splitting the data in the Excel file by, for example:
- company codes
Excel import supports splitting by one or more columns. The number of split columns is not technically limited. Each column that is used in splitting must have "split" written above the column header cell in the imported Excel sheet.
Split columns can reference to internal names of columns or headers in a document template with named cells, for example, "row.account" or "row.header.companyCode".
The splitting function is only allowed when importing a new document from the Action menu. It will not work from the Excel import button once you have already created the document.
Aico mappings in the Excel sheet
In this example, we will split this document into five journals based on the company codes in Column O.
1. Add a new column called Company Code and write the word split in the cell above the column you want to split by.
2. As you can see, the sheet already has a header called company code in row 1. This means this is mapped to the Aico document using the Name manager mapping of "header.companyCode".
This mapping must be overwritten by a new mapping which refers to your new Company Code column. This is done using Name manager to create a new mapping called "row.header.companyCode".
3. Where the data you want to split by is already in a column then you simply need to add the word split above it.
Name Manager can be found under the Formula tab in Excel.
The result here is that five New documents are created each of which must then be handled individually and sent through the workflow in the normal way.
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