Click to download (right-click and select "Save Target As..." to save the file to your computer)
This Excel tool has been designed by Mike Ling in the University Budget Office to facilitate grouping of data from detailed fund statements (Reportmart3 report "FIN FUND 153 YTD FUND STATEMENT") by Project within an award.
Instructions:
If you have not already done so, run the above report in Reportmart3 (for multiple awards, if you wish), and select the YTD Detail tab to export to Excel. With the Excel spreadsheet with the fund data open, use this tool by hitting the "Process" button. The tool will take all the individual transaction lines from the Fund Statement and organize/group it by project within award on each row of a new spreadsheet, grouping assets, liabilities, fund balances, revenues, transfers, and expenses together. In essence, this gives you an "Income Statement" ("Profit & Loss") picture for each project within the award. If there is more than one award's fund statement in the spreadsheet, it will do this for each of them.
Of course, there are some transactions that reside at the "default" project level of 1000000. You may need to manually adjust the results to assign these to appropriate projects within the award.
We hope you find this tool helpful. If you have any questions. comments, or suggestions, please contact Mike at 5-0962 or mikeling@stanford.