Report showing subtotal by Project and Transaction Code

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
  • Tammie Shappee
  • Oct 28 2019
  • Needs review
  • Attach files