I am trying to find a canned report but I think it may be something I have to create. I need a schedule of my projects for my fiscal year. It needs to be set up in columns and the columns are the project number and desciption. The rows are beginning fund balance of the year then income and expenses for each month and ending fund balance for each month. Our auditors want to see a schedule in this format. I hate to use excel and manually enter this info when it can be pulled from FE. I am familiar with Crystal Reports (Though I'm not an expert). Has anyone built a report like this or is there a canned report I am missing?

Thanks,
Hillary Murphy
Phoebe Foundation
Phoebe Putney Health System
[Email Removed]

I've used my regular canned report under the Statement of Activities or Statement of Functional Expenses and LOTS of columns.  I've run into a couple of issues:

1. Not enough columns in the canned reports - my work around has been to use multiple versions of the same report, export to excel and then copy/paste for the monster report - this has been more of an issue of dealing with lots of underlying budgets and showing staff where we're at than reporting to the auditors.

2. The inability in the canned software to layout where beginning fund balances or net assets shows up.  In the export to excel I have some simple macros set up from my keystrokes that cut that row past where I want it and then format some of the cells to formulas or add a few items.  I don't know what your comfort level is in excel, but mine is low end - turning macros on and then keystroking through what I want done, ending the macro has worked fairly well for me without a lot of thought.  Not efficient, but I can start the macro running, step out to get a drink of water and come back to Voila!

Under Account Reports, Use Trial Balance Report, Sort by Project. Depending on how many projects you have, the report could be long but you can export it to Excel to manipulate.