Cost Unit Accounting

COST UNIT JOURNALS

Figure Cost Unit Journals

Project Account Journals

Figure Project Account Journals

Option	Description
Name	This field is used to enter a name for the project account journal.
Description	This field is used to enter a description for the project account journal.
Reason Code	Here you can enter a reason code for this journal and specify a characteristic that can be filtered in project account journals.

To edit the project account journal, select "Transaction -> Edit posting sheet".

Figure Edit Project Account Cost Journal

Option	Description
Posting Date	This field is used to enter the posting date.
Project Account Code	This field is used to enter the project account you want to post.
Project Account No.	This field is used to enter an account you want to post.
Description	This field is used to enter an appropriate description.
Quantity	This field is used to enter the quantity you want to post.
Operational Amount Fix	If you want to post with fixed amounts, enter the respective amount in this field.
Operational Amount Var	If you want to post with variable amounts, enter the respective amount in this field.
Document No.	It is recommended to specify a document number to simplify tracking of all postings. The Document No. is an optional field.

Reference Unit Journals

Figure Reference Unit Journals

Option	Description
Name	This field is used enter a name for the reference unit journal.
Description	This field is used enter a description for the reference unit journal.
Reason Code	Here you can enter a reason code for this reference unit journal and specify a characteristic that can be filtered in reference unit journals.

To fill in the reference unit journal, select “Process -> Edit Journal”.

Figure Edit Reference Unit Journal

Option	Description
Posting Date	This field is used to enter the posting date.
Project Account Code	This field is used to enter a project account you want to post.
Project Account No.	This field is used to enter an account you want to post.
Description	This field is used to enter an appropriate description.
Reference Unit Code	This field is used to enter the desired reference unit for the performance posting.
Department Code	This field is used to enter a department you want to post.
Quantity	This field is used to enter the quantity you want to post.
Cost Rate Fix	If you have specified a cost rate, this field will be filled automatically. If you want to evaluate the performances per document, enter the fixed cost rate here.
Cost Rate Var	If you have specified a cost rate, this field will be filled automatically. If you want to evaluate the performances per document, enter the variable cost rate here.
Operational Amount Fix	The fixed operational amount will be calculated and shown in the system when you specify the quantity and cost rate.
Operational Amount Var	The variable operational amount will be calculated and shown in the system you specify the quantity and cost rate.

Overhead Journals

Figure Overhead Journals

Option	Description
Name	This field is used to enter a name for the overhead journal.
Description	This field is used to enter a description for the overhead journal.
Reason Code	Here you can enter a reason code for this overhead journal and specify a characteristic that can be filtered in overhead journals.

To fill in the overhead journal, select “Process -> Edit Journal”.

Figure Edit Overhead Journals

Option	Description
Posting	This field is used to enter the posting date.
Cost Object Code	This field is used to enter a project account you want to post.
Cost Object Account No.	This field is used to enter an account you want to post.
Description	This field is used to enter an appropriate description.
Operational Amount Fix	The fixed operational amount will be determined and shown for each project account and for each cost center to be credited by running the “Calculate Overheads” batch job. You can also enter the values manually. To do this, enter the fixed amount in this field.
Operational Amount Var	The variable operational amount will be determined and shown for each project account and for each cost center to be credited by running the “Calculate Overheads” batch job. You can also enter the values manually. To do this, enter the variable amount in this field.
Code Department	This field is used to enter a department you want to post.

Recurring Project Account Journals

Figure Recurring Project Account Journals

Option	Description
Recurring Type	This field is used to define how to process the amount specified in the journal line during posting. Fix: The values entered in the amount fields will be posted. Percentage: The amounts to be posted will be calculated as a percentage of a reference cost account. Performance related: The amounts to be posted will be determined based on cost rate of the cost center and its posted performances.
Recurring Rate	Here you can enter a date formula to calculate the period length. For example, entering 1M+LM means that the amounts will always be posted at the end of the month.
Posting	Here you need to enter the first posting date for the transaction.
Posting Type	This field is used to define whether you want to post: Costs: Select this option if you want to post costs as amounts. Performance: Select this option if you want to post quantities as performances.
Project Account Code	This field is used to enter the project account you want to post.
Project Account No.	If you have selected the “Costs” posting type, enter the account you want to post in this field.
Description	Here you can enter text constants which will be automatically updated each time you post. For example, if you enter %5, the month name will be inserted into the description.
Quantity	If you have selected the “Performance” posting type, enter the quantity in this field.
Operational Amount Fix	If you have selected the “Costs” posting type, enter the fix operational amount in this field.
Operational Amount Var	If you have selected the “Costs” posting type, enter the variable operational amount in this field.
Reference Unit Code	If you have selected the “Performance related” recurring type, you need to enter the reference unit quantities for which the costs are calculated based on the cost rate.

CHART OF PROJECT ACCOUNTS

Figure Call Chart of Project Accounts

Figure Chart of Project Accounts

Option	Description
No.	This field contains the number of the account in the chart of project accounts.
Name	This field contains the name of the account in the chart of project accounts.
Account Category	If you assign an account category to the account, the system will automatically generate a cost account schedule in the Project Account Category table.
Project Account Type	Here you can define the type you want to apply to the project account: Project Account: Select this option if the project account is to be posted. Heading: Select this option if it is a heading. Total: Select this option if it is a total. Begin-Total: Select this option if it is a begin total. End-Total: Select this option if it is an end total. Note: You can run the ”Indent Chart of Project Accounts” batch job for automatic totaling of the data if you select the “Begin-Total” or “End-Total” option.
Totaling	This field is used to specify an account interval or a list of account numbers. The entries in the account are totaled to form a total balance. The totaling entries depends on the value of the Totaling Type field.
Operational Amount	This field shows the posted operational amount.
Tax Amount	This field shows the posted tax amount.
Budgeted Amount	This field shows the budgeted amount.

Project Account Card

Figure Project Account Card

Option	Description
General
No.	This field contains the number of the account.
Name	This field contains the description of the account.
Account Category	If you assign an account category to the account, the system will automatically generate a cost account schedule in the Project Account Category table.
Account Subcategory	If you assign an account subcategory to the account, the system will automatically generate a cost account schedule in the Project Account Category table.
Project Account Type	Here you can define the type you want to apply to the project account: Project Account: Select this option if the project account is to be posted. Heading: Select this option if it is a heading. Total: Select this option if it is a total. Begin-Total: Select this option if it is a begin total. End-Total: Select this option if it is an end total. Note: You can run the ”Indent Chart of Project Accounts” batch job to automatically indent the data if you select the “Begin-Total” or “End-Total” option.
Totaling	This field specifies an account interval or list of account numbers. The entries in the account are added together to form a total balance. The totaling of entries depends on the value in the Aggregation Type field.
Search Name	This field shows the search term of the cost type which is identical with the name. The search term can be changed.
Operational Amount	This field shows the posted operational amount.
Tax Amount	This field shows the posted tax amount.
Blocked	This field indicates whether the account is blocked. If you want to block the account, you need to activate this field.
Posting
Operational	This field indicates whether the account is to be used for operational cost analysis.
Tax	This field indicates whether the account is to be used for tax cost analysis.
Distribute Performance	This field indicates whether the account is to be used for performance distribution.
Distribute Overhead	This field indicates whether the account is to be used for overhead distribution.
Distribution Cost Account No.	This field shows the cost type to be used for credit posting in connection with performance and overhead distribution.

CHART OF COST UNITS

Figure Call Chart of Cost Units

Figure Chart of Cost Units

Option	Description
Code	This field shows the code of the project account.
Name	This field shows the name of the project account.
Dimension Value Type	This field is used to specify the dimension value type. The following 5 options are available: Default: Select this option if it is a dimension which can be posted, such as a cost center. Heading: Select this option if it is a heading. Total: Select this option if it is a total. Begin-Total: Select this option if it is a begin total. End-Total: Select this option if it is an end total. Note: You can use the “Indent Dimension Values” batch job for automatic totaling if you select the “Begin-Total” or “End-Total” option.
Totaling	This field is used to specify an account interval or a list of account numbers. The entries in the account are totaled to form a total balance. The totaling entries depends on the value of the Totaling Type field.
Default Cost Account Schedule	This field indicates whether a cost account schedule has been assigned to the project account to perform overhead distribution..
Reference Unit Code	This field indicates whether the project account is linked to a specific reference unit.
Assigned User ID	This field indicates if e. g. a responsible user has been assigned to the project account.
Operational Amount (Primary)	This field shows the operational primary cost amount.
Operational Amount (Distribution)	This field shows the distributed operational amount.
Budgeted Amount (Primary)	This field shows the budgeted primary cost amount.
Budgeted Amount (Distribution)	This field shows the distributed budget amount.
Quantity	This field shows the posted quantity.
Budgeted Quantity	This field shows the budgeted quantity.
Blocked	This field indicates whether the project account has been blocked.

Cost Unit Card

Figure Cost Unit Card

Option	Description
General tab
Code	This field shows the code of the project account.
Name	This field shows the name of the project account.
Dimension Value Type	field is used to specify the dimension value type. The following 5 options are available: Default: Select this option if it is a dimension which can be posted, such as a cost center. Heading: Select this option if it is a heading. Total: Select this option if it is a total. Begin-Total: Select this option if it is a begin total. End-Total: Select this option if it is an end total. Note: You can use the “Indent Dimension Values” batch job for automatic totaling if you select the Begin-Total or End-Total option.
Totaling	This field is used to specify an account interval or list of account numbers. The entries in the account are totaled to form a total balance. The totaling entries depends on the value of the Totaling Type field.
Assigned User ID	This field indicates if e. g. a responsible user has been assigned to the project account.
Default Cost Account Schedule	This field indicates whether a cost account schedule has been assigned to the project account to perform overhead distribution..
Reference Unit Code	This field indicates whether the project account is linked to a specific reference unit.
Blocked	This field indicates whether the project account is blocked.
Statistics tab
Operational Amount (Primary)	This field shows the operational primary cost amount.
Tax Amount (Primary)	This field shows the tax primary cost amount.
Budgeted Amount (Primary)	This field shows the budgeted primary cost amount.
Operational Amount (Distribution)	This field shows the distributed operational amount.
Tax Amount (Distribution)	This field shows the distributed tax amount.
Budgeted Amount (Distribution)	This field shows the distributed budget amount.
Quantity	This field shows the posted quantity.
Budgeted Quantity	This field shows the budgeted quantity.
Consolidation/Intercompany tab
Consolidation Code	This field is not a Cost Accounting 365 field. The “Consolidation Code” field is part of the standard dimensions. It has no impact on Cost Accounting and is only displayed for information purposes.
Map to IC Dimension Code	This is not a field of Cost Accounting 365. The “Map to IC Dimension Code” field is part of the standard dimensions. It has no impact on Cost Accounting and is only displayed for information purposes.

LINK TO G/L ACCOUNT

Transfer G/L Accounts to Project Accounts

Figure Call Transfer G/L Accounts to Project Accounts

Figure Transfer G/L Accounts to Project Accounts

Option	Description
Transfer Headings and Sums as well?	Activate this field if you want to copy headings and sums from the chart of accounts.
No.	Here you can enter the name of the financial budget from which you want to copy the cost account budget.
Account Type	For example, if you only want to transfer sums, you can filter the account type during transfer. The following options are available: Account: Select this option if it is a dimension which can be posted, e. g. a cost center. Heading: Select this option if it is a heading. Total: Select this option if it is a total. Begin-Total: Select this option if it is a begin total. End-Total: Select this option if it is an end total.
Income Statement/Balance Sheet	Select the filter “Income Statement” to transfer G/L accounts from the income statement area of the General Ledger.

TRANSFER TO COST UNIT ACCOUNTING

Transfer G/L Entries

Figure Call Transfer G/L Entries

Figure Transfer G/L Entries

Figure Transfer G/L Entries to Project Accounts

Option	Description
Project Account No.	Generally, the filter value for the cost account no./project account no. is predefined. The filter is initially set to <>” so that when transferring the G/L entries, only entries with a specified cost account no./project account no. will be considered. This way, you can simplify and accelerate the transfer of G/L entries that have not yet been copied to the cost account/project account journal.
No.	Here you can enter the number of specific accounts if you want to consider specific cost types.
Income Statement/Balance Sheet	Select the filter “Income Statement” to transfer G/L accounts from the income statement area of the General Ledger.
Posting Date	Here you can enter a date filter, for example 01.01.21..01.31.21, if you want to perform transfers on a monthly basis.

Transfer Sales Orders

Figure Call Transfer Sale Orders

Figure Transfer Sale Orders

Option	Description
Item No.	If you only want to transfer specific items, you can specify a filter here.
Posting Date	Here you can enter a date filter, for example 01.01.21..01.31.21, if you want to perform transfers on a monthly basis.

Transfer Resource Quantity

Figure Call Transfer Resource Quantity

Figure Transfer Resource Quantity

Option	Description
Resource No.	If you only want to transfer specific resources, you can specify a filter here.
Posting Date	Here you can enter a date filter, for example 01.01.21..01.31.21, if you want to perform transfers on a monthly basis.

Transfer Resource Performance

Figure Call Reference Unit Journal

Figure Call Transfer Resource Performance

Figure Transfer Resource Performance

Option	Description
Resource No.	If you only want to transfer specific resources, you can specify a filter here.
Posting Date	Here you can enter a date filter, for example 01.01.21..01.31.21, if you want to perform transfers on a monthly basis.

Transfer Capacity Performance

Figure Call Transfer Capacity Performance

Figure Transfer Capacity Performance

Option	Description
No.	If you only want to consider specific work centers, you can specify a filter here.
Posting Date	Here you can enter a date filter, for example 01.01.21..01.31.21, if you want to perform transfers on a monthly basis.

Transfer Performance Types

Figure Call Transfer Performance Types

Figure Transfer Performance Types

Option	Description
Code	If you only want to consider specific work centers, you can specify a filter here.
Performance Date Filter	Here you can enter a date filter, for example 01.01.21..01.31.21, if you want to perform transfers on a monthly basis.

DISTRIBUTION IN COST UNIT ACCOUNTING

Distribute Performance

Figure Call Distribute Performance

Figure Distribute Performance

Option	Description
Post	Activate this field if you want to post the credit memos to the cost centers across modules.
Posting Date	Here you can enter the date you want to use for posting.
Output with Picture	Activate this field if you want the report to include your company logo.
Alternate Mode	This field is activated by default and represents section lining within the report.
Posting Date	Here you can enter a date filter if you want to consider project accounts for performance distribution for a specific period.

Distribute Overhead

Figure Call Distribute Overhead

Figure Distribute Overhead

Option	Description
Post	Activate this field if you want to post the credit memos to the cost centers across modules.
Posting Date	Here you can enter the date you want to use for posting.
Output with Picture	Activate this field if you want the report to include your company logo.
Alternate Mode	This field is activated by default and represents section lining within the report.
Posting Date	Here you can enter a date filter if you want to consider project accounts for overhead distribution for a specific period.

COST UNIT ARCHIVE

In the Project Accounting archive, you can find all posted transactions and track each posting in the registers.

Project Account Registers

Figure Call Project Account Registers

Figure Project Account Registers

Option	Description
No.	This field shows the number of the register.
Creation Date	This field shows the actual creation date of the register.
User ID	This field shows the user ID who has generated the register.
Source Code	This field shows the register’s source code, for example, whether the data result from the transfer of G/L Entries of the General Ledger.
Journal Name	This field shows the number of the register.
From Entry No.	This field shows the first "sequential number" of the generated entries.
To Entry No.	This field shows the last "sequential number" of the generated entries.

Project Account Ledger Entries

Figure Call Project Account Ledger Entries

Figure Project Account Ledger Entries 1

Figure Project Account Ledger Entries 2

Option	Description
Posting Date	This field shows the posting date of the entries.
Posting Type	This field shows indicates whether the entries are cost or performance postings.
Project Account Code	This field shows the posted project account.
Project Account No.	This field shows the posted account.
Description	This field shows the description of the posting.
Reference Unit Code	This field shows the posted reference unit.
Quantity	This field shows the posted quantities.
Cost Rate Fix	This field shows the posted fixed cost rate.
Cost Rate Var	This field shows the posted variable cost rate.
Operational Amount	This field shows the posted amount.
Operational Amount Fix	This field shows the posted fixed amount.
Operational Amount Var	This field shows the posted variable amount.
Document Date	This field shows the posted document date.
Department Code	This field shows the posted department.
Entry No.	This field shows the "sequential number" of the entry.

Project Account Budget Entries

Figure Call Project Account Budget Entries

Figure Project Account Budget Entries

Option	Description
Budget Name	This field shows the budget.
Date	This field shows the date of the budget entries.
Project Account No.	This field shows the account that has been budgeted.
Amount Var	This field shows the budgeted variable amount of the cost center.
Amount Fix	This field shows the budgeted fixed amount of the cost center.
Department Code	This field shows the department that has been budgeted.
Project Account Code	This field shows the budgeted project account.
Reference Unit Code	This field shows the budgeted reference unit.
Quantity	This field shows the budgeted quantity.

Analysis View Entries

Figure Call Analysis View Entries

Option	Description
Analysis View Code	This field shows the analysis view.
Project Account No.	This field shows the analyzed account of the entries.
Reference Unit Code	This field shows the analyzed reference unit of the entries.
Business Unit Code	This field shows the analyzed business unit of the entries.
Dimension Code 1	This field shows the first analyzed dimension of the entries.
Dimension Code 2	This field shows the second analyzed dimension of the entries.
Dimension Code 3	This field shows the third analyzed dimension of the entries.
Dimension Code 4	This field shows the fourth analyzed dimension of the entries.
Posting Date	This field shows the posting date of the entries.
Operational Amount	This field shows the analyzed operational amount of the entries.
Operational Amount Fix	This field shows the analyzed fixed operational amount of the entries.
Operational Amount Var	This field shows the analyzed variable operational amount of the entries.
Tax Amount	This field shows the analyzed tax amount of the entries.
Tax Amount Fix	This field shows the analyzed fixed tax amount of the entries.
Tax Amount Var	This field shows the analyzed variable tax amount of the entries.
Quantity	This field shows the analyzed quantity of the entries.
Entry No.	This field shows the "sequential number" of the entries.

Analysis View Budget Entries

Figure Call Analysis View Budget Entries

Option	Description
Posting Date	This field shows the posting date of the entries.
Project Account No.	This field shows the analyzed account of the entries.
Reference Unit Code	This field shows the analyzed reference unit of the entries.
Analysis View Code	This field shows the analysis view.
Budget Name	This field shows the budget name that was used.
Business Unit Code	This field shows the analyzed business unit of the entries.
Dimension Code 1	This field shows the first analyzed dimension of the entries.
Dimension Code 2	This field shows the second analyzed dimension of the entries.
Dimension Code 3	This field shows the third analyzed dimension of the entries.
Dimension Code 4	This field shows the fourth analyzed dimension of the entries.
Operational Amount Fix	This field shows the analyzed fixed operational amount of the entries.
Operational Amount Var	This field shows the analyzed variable operational amount of the entries.
Amount	This field shows the analyzed amount of the entries.
Quantity	This field shows the analyzed quantity of the entries.
Entry No.	This field shows the "sequential number" of the entries.

PROJECT ACCOUNT BUDGETS

Figure Call Project Account Budgets

Figure Edit Project Account Budgets

Option	Description
Name	This field is used to enter a name for the budget.
Description	This field is used to enter a description for the budget.
Budget Dimension Code 1	If you want to plan additional dimensions apart from the main dimensions, enter the desired budget dimension here.
Budget Dimension Code 2	If you want to plan additional dimensions apart from the main dimensions, enter the desired budget dimension here.
Budget Dimension Code 3	If you want to plan additional dimensions apart from the main dimensions, enter the desired budget dimension here.
Budget Dimension Code 4	If you want to plan additional dimensions apart from the main dimensions, enter the desired budget dimension here.
Blocked	Place a check mark in this field for budgets that you no longer want to use.

To specify budgeted values in the budget, select “Process -> Edit Budget”.

Figure Project Account Budgets

Option	Description
General
Budget Name	Here you can select the name for the budget you want to work on. In the Cost Accounting Budget Names window, select the budget dimensions you want to include in the budget. These four budget dimensions are specific to each budget. Therefore, you can specify different budget dimensions for different budgets. You select the budget dimensions from the dimensions that have already been set up.
Show as Lines	Here you can select the dimension you want to show in the lines of the Budget window. The following options are available: cost account, project account, cost type, and period. If you set up additional dimensions in the Budget Name window, they will also be available in this field.
Show as Columns	Here you can select the dimension you want to show in the columns of the Budget window. The options available in the Show as Columns field are identical with those of the Show as Lines field.
View by	Here you can select the view by specifying a period type. the following options are available: Day, Week, Month, Quarter, Year and Accounting Period.
Rounding Factor	Here you can specify to round the delivered quantities to: None, 1, 1000 or 1000000.
Show Column Names	Activate this field if you want to show the name of the column, e. g. a cost account name.
View as	In this field, you can specify whether you want to show the quantities as: Net Change: Within a month or year, depending on the specified date filter. Balance at Date: Cumulative balance, depending on the specified date filter.
Cost Account Budget Matrix
Code	This column shows the code of the dimension value listed in the line.
Name	This column shows the name of the dimension value listed in the line.
Budgeted Amount	This column shows the entire budget of the dimension or cost account. If you have specified a name in the Budget Name field, the sum for a specific budget will be shown here.
Period as Column View	Here you can use e. g. the column view to show the period.
Filter
Date Filter	This field is used to define which date range you want to use to display the selected budget.
Cost Account Filter	This field is used to define which cost accounts you want to use to display the selected budget.
Department Filter	This field is used to enter the dimension values to filter the shown data.
Project Account Filter	This field is used to enter the dimension values to filter the shown data.
Area Filter	This field is used to enter the dimension values to filter the shown data.
Profit Account Filter	This field is used to enter the dimension values to filter the shown data.
Budget Dimension Filter	In this field, you can select a budget dimension as a filter so that the values in the budget fields are only based on the budget entries with these dimension values.

Transfer Budget to Actual

Figure Call Transfer Project Account Budget to Actual

Figure Transfer Project Account Budget to Actual

Option	Description
Budget Name	This field is used to enter the name of the budget you want to copy the values to.
Date	This field is used to specify a period for which you want to create the budget.
Project Account No.	If you want to consider budgeted values for specific accounts, enter the account numbers in this field.
Department Code	If you want to consider budgeted values for specific departments, enter the departments in this field.
Project Account Code	If you want to consider budgeted values for specific project accounts, enter the project account numbers in this field.

Copy Project Account Budget to G/L

Figure Call Copy Project Account Budget to G/L

Figure Copy Project Account Budget to G/L

Option	Description
Budget Name	This field is used to enter the name of the financial budget to which you want to copy the cost account budget.
Date Change Formula	Here you can enter a formula to calculate the date for the new entries based on the copied entries. For example, if you want to copy the budget of the last month to the current month, use the formula +1M (one month).
Budget Name	This field is used to enter the name of the financial budget from which you want to copy the cost account budget.
Project Account No.	If you want to consider budgeted values for specific accounts, enter the account numbers here.
Date	This field is used to specify a period for which you want to create the budget.
Project Account Code	If you want to consider budgeted values for specific project accounts, enter the project account numbers here.

Copy Project Account Budget from G/L Budget

With the copy function, you can transfer all budgeted amounts to G/L accounts which have a link to the cost accounts in Project Accounting.

Figure Copy Project Account Budget from G/L Budget

Figure Copy Project Account Budget from G/L Budget

Option	Description
Budget Name	This field is used to enter the target budget you want to copy to.
Date Change Formula	Here you can enter a formula to calculate the date for the new entries based on the copied entries. For example, if you want to copy the budget of the last month to the current month, use the formula +1M (one month).
Budget Name	This field is used to enter the target budget to copy to.
G/L Account No.	If you want to consider budgeted values for specific G/L accounts, enter the G/L account numbers here.
Date	This field is used to specify a period for which you want to create the budget.
Department Code	If you want to consider budgeted values of specific departments, enter the department numbers here.
Project Account Code	If you want to consider budgeted values of specific project accounts, enter the project account numbers here.

Copy Budget

Figure Call Copy Budget

Figure Copy Budget

Option	Description
Source	By selecting the entry type, you specify the source in this field: Project Account Entries: The budget will be based on actual project account entries for a specified period. You can use the Project Account No. and Date fields to specify a project account and/or date range to specify the information to copy. If you click the AssistButton in the Dimensions field, you can select the dimensions that will be copied to the newly budgeted entries. You can filter the copied data by setting specific dimension value filters. The project account needs to be specified for the dimensions. Project Account Budget Entries: The budget will be based on project account budget entries of an existing budget. You must enter the name of an existing budget from which you want to copy. Then, you can use the Project Account No. and Date fields to specify a project account and/or date range if the copied data is to be filtered. If you click the AssistButton in the Dimensions field, you can select the dimensions that will be copied to the newly budgeted entries. You can further filter the copied data by setting specific dimension value filters. The project account needs to be specified for the dimensions.
Budget Name	Here you can select the name of a budget from which you want to copy the budget entries by clicking the AssistButton in the Copy to Budget Name field.
Project Account No.	If you want to copy several entries from a single project account or a single department, you can also select the project account in the Copy from Project Account No. field.
Date	Select the date range of the budget entries you want to copy.
Dimensions	Click the Assist button to select the dimensions to be copied into the target budget.
Budget Name	Here you can select the name of a budget you want to copy to by clicking the AssistButton in the Copy to Budget Name field.
Project Account No.	If you want to copy several entries in a single project account or department, you can also select the project account in the Copy to Project Account No. field.
Correction Factor	The application can multiply the source entries by using a correction factor when copying.
Rounding Method	Here you can specify the rounding of the new budget entries.
Date Change Formula	You can enter a formula to calculate the date for the new entries based on the copied entries. For example, if you want to copy the budget of the last month to the current month, use the formula +1M (one month).
Date Compression	To reduce the number of newly created entries, you can compress the entries copied to a selected period.

Export to Excel

You can export a budget from the application to an Excel workbook in order to make any changes to the budget in Excel. It is also possible to create new budgets based on the exported budget figures. Similarly, you can create a new budget based on actual numbers from an exported account schema. You can re-import the budget by using the Import Budget from Excel function.

Warning

If you specify dimension filters on the Project Account Budget entries tab, you must always enter the same dimensions in the Column Dimensions field on the Options tab. Otherwise, the dimension data will get lost when you re-import the data from Excel.

Figure Call Export to Excel

Figure Export to Excel

Option	Description
Starting Date	In this field, enter the first date to include in the budget to be exported to Excel.
Number of Periods	In this field, specify the number of periods to be exported to Excel.
Period Length	In this field, specify the length of the periods to be exported to Excel.
Column Dimensions	In this field, specify which dimensions to display as columns when exporting the budget to Excel. This data must include the dimensions that have been defined as filters on the Project Account Budget entries tab.
Include Totaling Formulas	Activate this field if you want to include totaling formulas for dimension values in Excel, based on the Totaling field of the Chart of G/L Accounts window.
Budget Name	Here you can enter the budget you want to export.
Business Unit Code	This field is used to enter the business unit code if you want to export the entries for a specific business unit.
Cost Account No.	If you enter specific cost accounts in this field, the specified cost accounts will be considered during export.
Department Code	If you enter specific cost centers in this field, the specified cost centers will be considered during export.
Project Account Code	If you enter specific project accounts in this field, the specified project accounts will be considered during export.
Budget Dimension Code 1	If you enter an additional dimension in this field, the dimension specified in this field will be considered during export.
Budget Dimension Code 2	If you enter an additional dimension in this field, the dimension specified in this field will be considered during export.
Budget Dimension Code 3	If you enter an additional dimension in this field, the dimension specified in this field will be considered during export.
Budget Dimension Code 4	If you enter an additional dimension in this field, the dimension specified in this field will be considered during export.

Import from Excel

After having opened the budget in Excel, you can change the data without having to access the application database. You can then import the modified data into the application to create a new budget or to edit an existing budget.

Warning

The dimension filter and budget name in Excel must be entered at specific positions in the Excel worksheet. The columns must also be in the correct order to import the budget correctly. Therefore, it is recommended that you create the structure of the budget, including all dimension value filters, and export this structure to Excel. Before importing the completed budget amounts, you can add additional columns and lines for dimension value filters to both the Excel worksheet and the budget dimensions as needed.

Figure Import Project Account Budget from Excel

Option	Description
Budget Name	This field is used to enter the name of the Excel file and of the worksheet in which the budget is included. Then select the name of the budget to which you want to import the entries as well as the import method:
Option	The following options are available: Replace Entries: Existing entries will be replaced by the imported entries that have the same combination of dimension, date, and cost type. Add Entries: Imported entries will be added to existing items with the same combination of dimension, date, and cost type. This feature can be used to create a single consolidated budget from a number of individual budgets created in separate Excel workbooks.
Description	You can assign a description to each imported budget entry to distinguish it from other budget entries.

---

Personal support available at www.ckl-software.de/en/