I would like to be able to run a Project Balance report that will subtotal by Project and Transaction Code. Currently you can only run a balance report by Project or Transaction Code. Below is an example of what I would like to see. We utilize the transaction code 1 to track funding source. I would like to see the report with a balance by Project and funding source.
Project | Grant (Transaction Code) | Beginning Balance | Incoming Funds | Outgoing Funds | Remaining Balance |
408-Principal | General Funds | 15.00 | 5.00 | 0.00 | 20.00 |
Football | 25.00 | 0.00 | 0.00 | 25.00 | |
Cheer | 50.00 | 0.00 | 25.00 | 25.00 | |
Subtotal 408-Principal | 70.00 |