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
- Export journals to e-binder
- 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
- Closing Tasks
- Users and User Groups
- Value sets
- Currency Amount Groups
- Mail notifications
- Tax codes
- 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
- Task Generation
- Administrative tasks
- Aico Announcements
How to create Recurring Allocation journal entries
Modified on Mon, 21 Nov 2022 at 02:05 PM
Create a new Master Template for a Recurring Master (Allocate)
A recurring allocation allows you to enter a base amount and spread this across a defined period. For example, a rent invoice for 100 000 € which should be allocated monthly between the 15th of January and the 21st of September.
In the top left-hand corner, select Actions and New document. This will open a blank template.
First, choose the Company Code.
Then select the Allocate template you need. We will use the SAP Recurring master (Allocate) for this example.
Complete the mandatory data in the Header area. Mandatory fields are denoted with an asterisk *.
In the Allocation Details section, complete:
Base Amount: Enter the base amount.
Allocation Start Date: Select the date when the allocation period starts.Frequency: Select how frequently the journals are created:
- Monthly - the duplicate will begin on a monthly basis from the date selected
- Quarterly - the quarters will begin from the first date in the series. This does not have to be months one, three, nine and 12, but any you choose
- Annually - again, this series will repeat on the same day each year as you chose, rather than a key date like the start of the new tax year
Allocation Method: Select the allocation method. The following options are available:
- Spread by days - Aico determines the total number of days between the start and end dates and divides the base amount by the total number of days and then calculates the total depending on the number of days in each month in the journal series. If you select this option, you do not select the number of recurrences, only the end date.
- Spread evenly - the base amount will be divided equally between the number of recurrences. If you select this option in the Allocation Method field, you can't set an end date, only a number of recurrences.
Number of Recurrences: Specify the number of recurrences you want.
Allocation End Date: Select the date when the allocation period ends.
Click Save. If you do not specifically save the master template, you cannot create any of the allocation journals.
See this article to see how to create an automatic reversal.
In the Row Data you need to specify the Accounts and the percentage of how much of the base amount you want to debit and credit. You can also add in the Credit and Debit amounts, and Aico will work out the percentages.
Click Calculate percentages and Aico will work out the sums for you in the specific rows (1).
In the example below, 100% of the amount is going to be debited from Account number 194500 (2). 67% will be credited to Account 194503 and 33% to 194504 (3).
Click Create Journals, then Transfer and complete.
The master template contains the details of the journal series and links to each created journal. Each journal contains a link back to the master template.
You can transfer journals from the recurrence master template. The master template itself will never be transferred.
In the right-hand panel Linked Documents, there are now the three individual recurring journal entries:
1. The Posting Date is the same day each month.
2. The Document amount could vary each month based on the allocation method selected.
3. None have been posted yet, and so are in the Created phase of the Workflow Status.
You can click on the Aico Document ID in blue to see each individual journal.
Making changes to the recurrence
If you have made an error or need to change something and recreate the journals, make the changes required to the master template, then press the Create Journals button again.
This will delete all unposted journals and recreate them as per your new specifications.
If any journals from the series have been posted, you cannot delete the posted documents or the master document.
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