Allocation Management - Anyone Able to Provide Examples?

Stephen Dignam

Hi, our organization recently installed Allocation Management in Blackbaud in order to hopefully make our allocation accounts easier to manage and have a system in place to facilitate automatic posting from one General Ledger account to multiple other General Ledger accounts based on a percentage basis established at the start of each fiscal year.

As an example of what we are trying to accomplish, in AP I would post a utility bill of $100.00 to 1234-987-01 where 987 is the allocation department subaccount. However, we would then want the allocation to be automatically redirected based on a percentage to the following three accounts: 1234-123-01 $60.00 (60% allocation), 1234-456-01 $30.00 (30% allocation), and 1234-789-01 $10.00 (10% allocation).

Is this possible to do using this module? If so, could someone please provide screenshots walking through such a setup? I'm much more of a visual learner so seeing the setup end to end would be very helpful. If it's easier to do through private message, please feel free to reach out in that manner.

Additionally, is there any sort of way to set up all of this using import functionality to achieve everything at the outset? Or is there some sort of Excel add in that could be used to assist with it? For reference, our subaccount will always be the driver and we would want to allocate to other subaccounts from the same initial expense account repeatedly. So, any expense booked to subaccount 987 as an allocation department should be split based on the percentage method. So, 1234-987-01, 2345-987-01, 3456-987-01, and so on. Is it possible to do this with one allocation or one pool where the subaccount is the main component or do you need one separate allocation or pool for each account instance?

Thanks,
Stephen

Pamela Jenkins

@Stephen Dignam Did you ever get a response on this matter as I am interested.

Stephen Dignam

@Pamela Jenkins:

@Stephen Dignam Did you ever get a response on this matter as I am interested.

Hi @Pamela Jenkins, I did reach out to a few other users who have the module and had some direct messages but neither are using it in the way I describe in my original post. I have opened a case directly with support as well to see if it can do as described above. From what I've seen, it looks like it can only do a one to many relationship and not a many to many relationship which is what I would want. It appears you have to specify a single source account and then tie it to multiple destination accounts. I wanted to have it all be based on the subaccount and then allocate based on that to multiple different subaccounts without the need to specify the account itself. If what I find changes, I'll try to remember to update you with what I find.

Claudia Becker

Have you been able to successfully use the allocation module? I am trying to set it up and having quite some difficulty. I want to allocate employer personnel expenses to programs based on salaries. However I am having difficulty setting the pool and then creating the allocation using the pool