Mass Allocations- Can we use to allocate costs at Departmental level?

Hi Team,

We had below requirement,

Allocation of Departmental expenses- We need to allocate the expenses of the department to another department on agreed ratio and this allocation is not based on natural account level, instead it is source department Vs Destination department i.e. All the expenses booked under one department should be allocated to the other departments.

In this kind of scenario how to define the mass allocation formula?

We have % of allocations from source to destination departments.

And our reporting should look like,

                                        Department

+Direct Expenses                XXXX

+Allocation In                      XXXX

- Allocation Out                   (XXXX)

                                       -----------------

              Net Expenses        XXXX