Skip to content · Zum Inhalt

Introduction

Advanced Allocations shares amounts that were booked once in the general ledger over several G/L accounts and dimensions, using a template instead of guesswork. Instead of deciding the split each month by hand, you take what Business Central already has - actual posted G/L entries, statistical entries such as headcount or square metres, or a predefined template - and let the app build allocation journal lines that are synchronized with current activity. That makes the data entry more accurate and efficient.

Typical uses are allocating fringe benefits with the same allocation percentage you use for the salary expense, sharing rent by headcount or square metres, or posting IT supplies to the departments that use them. Actual posted expenses and other general ledger activity are automatically available for the allocation process, so you don't enter them again, and you can set up ad-hoc or monthly allocations as often as you like.

At QUALIA Technik GmbH, Monika Vogel (financial accountant) runs the Advanced Allocations worksheet every month to share electricity and rent over the four departments, books purchase invoices with Quick Key templates and posts the results. Timo Schulz (controller) keeps the statistical accounts, the journal batches and the Quick Key templates up to date. Iris Baumann (managing director) reviews the department costs after the close.

When Monika Vogel runs Calculate Allocation for the January electricity, the worksheet creates one allocation line per department on the target account (chapter 1).