It would be great to have a report that displays that account & project balance in a single row. Currently you can summarize by project, but when you export to do analysis you can't do a lookup to the data on the project. Trying to get balance data through query is cumbersome and time consuming (trying to run for a single project took over 20 minutes - I stopped timing. I can only imagine trying to run for multiple projects or the entire db if needed).
For example:
Project # | Project Description | Account # | Account Description | Balance |
Project # | Project Description | Account # | Account Description | Balance |
Where each line is either a different project or a different account.
This would be very effective for my team as well!