Advanced Cost Allocations - extended cost allocation in Business Central

The Advanced Cost Allocations application for Microsoft Dynamics 365 Business Central facilitates the detailed recording and accounting of production costs. Among other things, it enables precise calculation and posting of production costs, thanks to advanced cost allocation, deviation allocation and parallel posting functions, definition of cost allocation steps and sequences, allocation of amounts to KG accounts according to defined allocation keys, and recording of costs by typeand by calculation.

It allows accurate calculation of the actual cost of production of finished goods - taking into account differences between standard costs and incurred costs - by accounting for deviations on open orders or adjusting production receipts. The application is characterized by flexibility and ergonomics: the user can independently configure the rules of cost reclassification and valuation, without having to change the system standard or support of an external consultant. Advanced Cost Allocation is compliant with Polish production cost accounting standards and can be adapted to other national requirements.

• Accurate costing: advanced cost and variance allocation allows you to record and repost all production costs with precise settlement keys
• Stepwise allocation of costs: the user defines allocation steps, i.e. individual sources and reallocation targets, combining them into sequences with a fixed order. The allocation methods available are "Fixed key" (distribution of costs by percentage) and "Proportionally" (calculation of the proportion key based on selected data).
• Parallel accounting: the function allows you to automatically or batch parallel transfer cost entries between KG accounts - e.g., from a generic to a costing system and vice versa - which the Business Central standard offers only to a limited extent
• Default dimensions for the inventory journal: you can define a set of default dimensions (e.g., cost center, branch) depending on the type of record and accounting groups (major economic, commodity, inventory); as a result, the system automatically assigns the specified dimensions to the corresponding lines of the inventory journal
• Precision in production costs: the application takes into account both costs imposed by the standard and actual inputs (e.g., labor, materials), which allows you to accurately determine the value of finished goods and immediately account for production deviations on orders

Extension of standard functionality

The Advanced Cost Allocations application greatly expands the capabilities of standard Business Central in the area of cost and production accounting. The BC standard allows only simple cost allocations or calculations derived from individual modules, while ACA adds advanced rules and reports. Key differences and additions include:

• Parallel accounting in practice - ACA allows you to create additional general ledger entries when recording cost transactions. For example, you can automatically transfer costs from general accounts to target cost accounts (costing layout) without manual entry. The setting of the mode (automatic or batch) and the corresponding journals is defined in the application configuration
• Advanced allocation schemes - you can define multiple allocation steps combined into sequences, precisely indicating source and target accounts and allocation keys. In particular, we have access to the Fixed Key (fixed percentage) and Proportional (dynamically calculated key) methods, which allows, for example, to allocate indirect costs by fixed percentages or based on a definable table of weights
• Dimensions for inventory journal - by default, Business Central does not automatically assign dimensions to inventory journal entries. The application adds a mechanism that applies a predefined set of default dimensions based on record type and accounting groups (e.g., cost centers, product groups). This ensures that, for example, any inventory transfers related to production or adjustments automatically receive the required dimensions (department, project, etc.) according to company rules
• Integration with production - unlike standard BC, which treats either standard or actual costs in a simplified manner, ACA provides strict control of deviations. The balance of the cost account (the difference between actual and imputed costs) can be accounted for directly on production orders or by adjusting finished goods, allowing cost records to be accurately matched to market reality

Examples of practical application

The Advanced Cost Allocations application is applicable in various cost scenarios especially where indirect and common costs need to be separated:

• Allocation of indirect costs - e.g. administrative, office rental or IT support costs can be allocated to production departments or products. In practice, a single allocation step is defined with central cost accounts being the source and multiple target accounts and a fixed percentage key (e.g. 40/30/30%) or a proportional method (e.g. depending on the number of employees or office space)
• Interdepartmental settlement - common costs (e.g., management, headquarters) are distributed among business units. For example, the finance department can allocate common administrative fees to individual subsidiaries according to revenue shares or fixed percentages. This method promotes fair allocation of costs within the company structure
• Allocation by shares and metrics - with allocation keys, you can use any metric: number of products, sales value, man-hours or even any size defined in system tables. E.g. energy costs in the plant can be allocated proportionally to kWh consumed (if such a table exists) or a fixed share can be set for each hall
• Cost centers and dimensions - costs can be allocated to different cost centers or departments using dimensions. For example, the costs of a purchasing office post to multiple projects; ACA allows you to create a step where the source is overhead and the target accounts are project accounts, with the key proportional to project budgets‍.
• Accounting for production deviations - actual costs incurred by production departments (e.g., materials consumed, labor hours) can account for the standard costs of orders. If production used more raw materials than planned, the ACA algorithm will allow this difference to be shifted directly to orders or to finished goods, adjusting the financial result

In summary, the Advanced Cost Allocations application provides finance departments with advanced tools for full and flexible handling of production costs. It allows to accurately reflect the cost structure within the organization, automates tedious reclassifications and improves the accuracy of finished goods pricing.

Thanks to its compliance with Polish regulations and simple user interface, ACA accelerates period closings and improves the financial transparency of the company, which is an important added value for any financial department.