There may be times where you have a more “Complex” funding setup that would include a ‘category within a category’ and furthermore a ‘split within a split’. Instructions on how to do this (with examples) are below.
Some agencies split their funding categories by project and then by sub group.
...
Project A & B need to be set up as a ‘Leading Category’.
...
Then, to add sub categories, click on ‘split’ under Project A. These will be entered as a ‘Final Category’.
...
Some Projects Have a Complex Funding Split Setup
To set up the splits for each sub group, click on ‘Split’ under that group. (i.e click on splits under Storm Sewer)
...
If there are MULTIPLE LEVELS of funding ('splits within a split') then you will enter the first as a ‘Leading’ split. This means, your funding is split in a more complex manner; for example, 80% CSAH, and 20% Local, BUT, the 20% local is split 90/10 between Local Funds and Local Agency Sales Tax Funds, OR, you have multiple ‘rollover’ accounts that funds will run to and you want the funds to roll in to one before it goes to the other.
In this example, Storm Sewer will be funded 80/20 CSAH & Local.
Then, Local will be split 100/0 between Local funds and Local Agency Sales Tax.
What this means is that 100% will go to Local Funds until the cap is met, and then any rollover will go to the Local Agency Sales Tax fund.
**Recall that splits always have to add to 100% per split level.
Add CSAH Reg as a Final Split as this is not being split again. (If you have max funding amounts enter those in, but for these examples, I have not added any).
...
Transactions will be funded 80%/20% by CSAH & Local
The 20% Local will be pulled from Local Funds until the $500,000 cap is met and then will go to the Local Agency Sales Tax funding source.
Now, continue on to the Item setup and assign items per Category.
Related Articles: