We have a number of expenses that are allocated on a fixed basis to multiple programs/departments. I have set up the Reallocation through GL, but unfortunately there is no transaction detail when the reallocation batch is created, therefore when doing a GL analysis or financial statement review, you have to go back to the original account to see what is being allocated on a detailed level.

I have also tried setting up a Distribution Set in AP which allows you to keep the detail but still requires that someone calculate the allocation and enter the amount multiple times.

Is there any way to run the Reallocation at a detailed level, based on individual transactions rather than based on account balances? Or is there a way to have the AP Allocation/Distribution automatically allocate based on the fixed % without having to enter the amounts?

For example, if we get a parking invoice for a program manager, we want to split it between the 8 programs that they manage. But we want this process to be as automated AND detailed as possible so that when looking at the GL account we can see it was an allocation for parking, not just that it was an allocation of some undescribed transaction(s). What is the best way of doing this?

Thank you,
Tanja