Using Fixed Allocations to Allocate Costs and Revenues
This topic explains how to allocate costs and revenues using fixed values. Allocation Examples are also available to help you understand how to create a fixed allocation. See Using Statistical Allocations to Allocate Costs and Revenues for information on allocating using statistical values, or Using Proportional Allocations to Allocate Costs and Revenues for information on allocating using proportional values. |
Fixed allocations use set percentages or amounts as the basis for the allocation. These set values can be saved as an allocation rule Stores distribution criteria for reuse and helps speed up the process of splitting costs and revenue from selected GLAs and dimensions, and allocating them to other GLAs and dimensions. Fixed allocation rules use set percentages or amounts as the basis for an allocation. Statistical allocation rules use sets of values that may vary as the basis for an allocation., ready for use at the distribution stage of the process. See Managing Allocation Rules.
Alternatively, you can enter the fixed allocation details when you reach the distribution stage of the allocation process, instead of using an allocation rule.
There is a clickable progress bar at the top of each page. This bar enables you to navigate within the allocation process by clicking on a point on the bar. It also illustrates what steps are complete and what still needs to be done: the icon indicates a completed step and the icon indicates an incomplete step. You cannot use the progress bar to jump forward in the allocation process, unless you have already completed some of the details on that page.
A collapsible progress side panel is also available and summarizes the current status of the allocation. To show or hide the side panel, click the arrow.
Using Allocations with Multiple Companies
If you want to allocate costs and revenues from multiple companies, check the following before starting the allocation:
- Your org is in multi-company mode and that all the appropriate companies are selected as current companies.
- All companies share the same dual currency. This is because the app cannot retrieve transactions lines in different currencies and convert them to a single document currency. The dual currency is used as the document currency when creating the allocation transactions.
- You are not using local GLAs A general ledger account that is used in local statutory reporting. You can only use local GLAs in allocations if you are in single-company mode. (you cannot use local GLAs in multi-company mode, even if this functionality appears to be selected). See What is a Chart of Accounts Structure? for more information on local GLAs.
Retrieving the Source Data
The Retrieve Source page enables you to specify the source data for your allocation:
- Check that you have the required company or companies selected.
- Click the Allocations tab.
- Click New on the Allocations home page or click New Allocation from the list view.
- [Single-company mode only] On the Retrieve Source page, select a time period and its associated values. For example, if you select "Soft Date", you must select the relevant soft date value, such as "Last N Months". If you select "Current Period", only transactions up to the current date are selected.
- [Multi-company mode only] If required, select Only Retrieve Intercompany Transactions on the Retrieve Source page. In the Filter Groups section, select a company and period details for this filter group.
- [Optional] Select the account In this context, accounts are organizations or people that you conduct business with, such as customers or vendors. Account is a standard Salesforce object. Certinia accounts can be any Account Record Type. you want to retrieve data from.
- [Optional] Add more accounts in the same way. To select all the accounts in a range, click and select "From-To". To select multiple accounts, click and select "Multi-select".
- [Optional] Select a general ledger account The general ledger will normally include general ledger accounts (GLAs) for items such as income, expenses, assets, liabilities, and reserves. or local GLA A general ledger account that is used in local statutory reporting. You can only use local GLAs in allocations if you are in single-company mode. from the list.
- [Optional] Add more GLAs or local GLAs in the same way. To select all the GLAs or local GLAs in a range, click and select "From-To". To select multiple GLAs or local GLAs, click and select "Multi-select".
- Select up to four analysis dimensions Custom objects that allow you to analyze the activity in your business in additional ways, such as by cost center, project, employee, or any other business entity important to you.. You can select from a list or type a name to search. Your administrator may have hidden unused dimensions.
- [Optional] Click Add Filter Group to add another set of filters.
- [Optional] When you have provided or exceeded the minimum retrieval criteria, click Preview to retrieve and view a summary of the source data. You must have entered at least one time period and either a GLA or one or more dimensions.
- [Optional] On the summary list, you can expand each entry to view the individual transaction line items. You can use standard sort and search features to navigate around.
- [Optional] Click Show More if there are more transaction line items to view.
- Click Next to continue.
Setting the Allocation Method
The Allocation Method page enables you to specify the type of allocation you want to perform:
- For Allocate To select "Single Company" or "Cross-Company".
- For Method of Allocation select "Fixed". This means that you are going to use set percentages or amounts as the basis of your allocation.
- Click Next to continue.
Entering the Distribution Details
The Distribution page enables you to specify where you want to allocate the source data to and the corresponding percentages or values:
- Do one of the following:
- If you have already created a fixed allocation rule Stores distribution criteria for reuse and helps speed up the process of splitting costs and revenue from selected GLAs and dimensions, and allocating them to other GLAs and dimensions. Fixed allocation rules use set percentages or amounts as the basis for an allocation. Statistical allocation rules use sets of values that may vary as the basis for an allocation. that contains the distribution criteria you want to use, select it from the Allocation Rule picklist.
- If you do not already have an allocation rule set up, select any GLAs, local GLAs or dimensions you want to allocate to from the grid and enter a corresponding percentage or amount for each one. Click next to the Allocation Rule field to save as a new allocation rule, if required.
- If you want to use the details saved in an existing allocation rule as the basis for your distribution criteria, select it from the Allocation Rule picklist and make changes as required. You can then click to update the original rule or change the rule name to save the changes as a new rule. Alternatively, you can use the distribution criteria you have entered without saving them as a rule.
- Click Next to continue. You must have allocated 100% of the source data before you can proceed.
See Managing Allocation Rules for further information.
Entering the Details
The Details page enables you to specify how you want to post the allocations:
- [Optional] Type a description to display on the resulting journal or transactions. If you leave this field blank, a description is automatically generated based on the posting date or period you enter, such as "Allocation 2017/008".
- [Multi-company mode only] Select the company the journals or transactions are to be created in.
- Specify whether you want to create journals or transactions.
- Enter the journal or transaction posting date and period.
- Click on the Preview heading to expand the Preview section.
- [Optional] Click next to Source to view details of the source data for this allocation.
- [Optional] Click next to Distribution to view details of the transactions that will be created for this allocation.
- [Optional] If you want to save the details you have entered for this allocation as an allocation template Used to store the details entered during the allocation process, such as the filter structure of the source data, allocation rules used, and distribution details. Dates, periods, and specific amounts are not stored. for future use, click Save in the Allocation Template Bar and enter a name and a description for your allocation template. If you save a template with the same name as an existing one, you will overwrite the existing template. You can manage your allocation templates from the Allocation Templates tab.
- Click Create.
Once an allocation transaction has been created successfully, you can view it from the Allocations list view or go on to create a new allocation.
The allocation transaction line items have a process status of "Not Processed" and a matching status of "Not Matchable". If you create an allocation transaction in error, you can reverse it. See Reversing an Allocation Transaction for more information.
Viewing an Allocation
To view details of an allocation:
- Click the Allocations tab.
- From the Allocations list view, click the allocation.
You can access logs created by the allocation process from the Allocation Detail page. See Allocation Detail Fields for more information about the fields on this page.