We have the concept of Cost Centers (back office and other support functions) and Profit Centers (business lines/departments). We use Analytic Accounts to mark all journal entries with the relevant expense owner. Some of the costs go directly to Profit Centers, some go to Cost Centers. For example,
front office requested to buy computer - expense account 4013 - Computers and related equipment, Analytic Account - Lending Department (Profit Center),
front office requested to buy computer - expense account 4013 - Computers and related equipment, Analytic Account - Treasury Department (Profit Center),
back office requested to buy computer - expense account 4013 - Computers and related equipment, Analytic Account - Back Office (Cost Center).
So, at the month-end I need to allocate all balances from all Expense Accounts accumulated on Cost Centers to the Profit Centers. In the example above I need to ask Back office for the time-spent and allocate balance within the expense account 4013 from Back Office to the Lending Department 40% and to the Treasury Department 60%.
I have about 100 expense accounts and 10 Cost Centers, the allocation rates for each Cost Center are used to allocate balances from all 100 accounts in the same way. Is there a way to automate it?