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.

• 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.