Creating and Configuring Transfer Actual Balance to Plan Wizards

Overview

The wizard can be used to transfer existing account balances from actual to planning periods for reporting entities. 

Creating a Transfer Actual Balance to Plan Wizard

To create a transfer actual balance to plan wizard:

  1. In the dimension bar, select the combination of a planning data level and reporting entity for which a transfer actual balance to plan wizard should be created.
  2. Right-click the root folder and choose Create | Transfer actual balance to plan from the context menu. 
  3. The system checks whether the selected planning data level is synchronized with the actual data level. If it is not, the Edit Transfer Actual Balance to Plan dialog is displayed:

    Synchronizing the planning data level with the Actual data level
  4. Click Synchronize.
  5. The Create Transfer Actual Balance to Plan Wizard dialog is displayed:

    Creating a transfer actual balance to plan wizard
  6. Specify the Element name and click Continue.
Configuring a Transfer Actual Balance to Plan Wizard

To configure a transfer actual balance to plan wizard, click the name of the desired element in the tree view, and then click Edit in the top right. The configuration is divided into general properties in the header and two configuration steps in the main section of the editing mode.

The section with general properties of a transfer actual balance to plan wizard is displayed.
General properties of a transfer actual balance to plan wizard

The following properties can be configured in the header:


Property

Description


Element name

Name of the wizard


Cost center

Cost center in which the posting is to be performed by the planning wizard


Currency

Currency in which the posting is to be performed by the planning wizard


Adjustment level

Adjustment level in which the posting is to be performed by the planning wizard


Basis

Adjustment level (group) used as the planning basis


The first step for configuring a transfer actual balance to plan wizard is displayed.
Configuration of the transfer actual balance to plan wizard

The following options can be configured in the Configuration step:


Option

Description


Account or item

An account or item that should be transferred


Transfer based on subledgers

In the subledger-based configuration, you can either define rules for items and accounts that differ from the existing accounting rules manually or adopt the accounting rules that have already been defined. 


Transfer based on subledgers

Defining accounting rules manually

The following needs to be specified:

  • Account or item: Select an account or item to be transferred from the drop-down list.
  • Basis: Select the value that corresponds to the period to which the transfer should apply.
  • VAT/input tax configuration
  • Cash flow impact
  • Bank account: Select the account to which the transfer amount is to be posted.
  • Do not consider values of subordinate items or accounts with accounting rules: This option determines whether the accounting rules of subordinate items and accounts are considered. The checkbox is activated by default. Deactivate the checkbox to reconcile only the difference between the selected item or account and its subordinate items or accounts with their own accounting rules, instead of the entire value. 

 

Adopting accounting rules

Click the Adopt accounting rules to automatically add all accounting rules of type Payment with a time offset (Time-delayed payment or Down payment transaction) to the table, provided the receivables or liabilities account matches the one being configured. Any existing accounts in the table will be removed.


Transfer according to rule

In the rule-based reconciliation, it is possible to specify a user-defined rule for the reconciliation of the general ledger. This option should be used if an accounting rule from the planning data level must be corrected, for example because a different payment modality was assumed in the original planning. 


Transfer according to rule

The following needs to be specified:

  • Basis: 
    Choose Month of the planning to enter the number of calendar months from the beginning of the planning data level.
    Choose Calendar year to enter certain calendar months for the cash flow impact.
  • Cash flow impact: 
    If Month of the planning was previously selected, enter the number of calendar months to calculate the cash flow impact from the beginning of the planning data level to the entered number of calendar months.
    If Calendar year was previously selected, enter the calendar month to calculate the cash flow impact of the calendar months you entered (see Cash flow impact).
  • Bank account: Select the account to which the transfer amount is to be posted.

Manual transfer

It is possible to adapt individual accounts using the manual transfer.

Select the Bank account to which the transfer amount is to be posted.


The Tranfer according to rule and Manual transfer options are mutually exclusive.

The screenshot shows details of the transferred amounts. 'Values' step in 'Transfer actual balance to plan' wizard
After configuring the Transfer balance to plan wizard, select Values to view the calculated amounts to be transferred in a table. The table includes a column for the Partner and one or more groups of columns. Each group represents a period from the wizard's data level, starting with the first period. The number of column groups depends on the accounting rules selected in Configuration and their Cash flow impact settings.

 


Option

Description


Partner

The partner(s) used for the postings that create the balance that is to be transferred. If multiple partners were used, they are shown in separate rows in the table.


Start value

  • Added only to the first month column and corresponds to the first month at the planning data level.
  • It displays the balance of the account or item whose balance is to be transferred using the wizard. The displayed value represents the balance from the last month of the actual data level.

P&L

  • Added to all displayed months 
  • Calculates the amount to be transferred from the account or item selected in the Account or item field to the account selected in the Bank account field within the Transfer based on subledgers table. The calculation is based on the rules configured in the Accounting rules workspace using the items selected in the configuration table.
  • If you hover over a cell in this column, a tooltip displays a breakdown of the calculation based on the different accounting rules selected during the configuration step.

This column is visible only if you selected the Transfer based on subledgers option during the Configuration step.


Balance

  • Added to all displayed months 
  • For the first month, it calculates the difference between the Start value and the amount in the P&L column for that group.
  • For subsequent months, it calculates the difference between the Balance column from the previous month and the P&L amount for the current month.

Manual

  • Added to all displayed months
  • Manually enter the amount to be transferred for the selected month. You can enter numbers with up to two decimal places; values are rounded from the third decimal (e.g. 0.044 rounds down to 0.04, while 0.045 rounds up to 0.05). You can also use basic mathematical operations: +, -, *, /, parentheses (), the equals sign =, and decimal separators.

This column is visible only if you selected the Manual transfer option during the Configuration step.


Rule

  • Added to all displayed months
  • Calculates the amount to be transferred from the account or item selected in the Account or item field to the account selected in the Bank account field within the Transfer according to rule table. The calculation is based on the rules defined in the Transfer according to rule section, using the items selected in the configuration table.

This column is visible only if you selected the Transfer according to rule option during the Configuration step.