Nonprofit Financial Management

Executive Summary
This project was designed for a start up not-for-profit organization that provides support services and tools for disaster relief efforts. They are seeking to expand their fundraising efforts as well as implement a for-profit subsidiary to their organization that will aid them in their efforts. These two endeavors create multiple financial implications that could put their tax exempt status with the IRS in jeopardy. They are seeking to develop a financial management system to help them mitigate these risks.
To help them in these efforts I designed a basic financial spreadsheet to track revenues, expenses, donors, and budget variances. Since financial controls are essential to protect information as well as funds, a few basic controls have also been included. The general system functions as follows:

1. Starting: A welcome worksheet activates when the workbook is opened. A basic login and password are required to proceed. Depending on the user only specific worksheets will be available.

2. Revenues: The authorized user clicks on a button on the “Home” page which opens the “Revenues” worksheet and opens a form for inputting the transaction information. If required fields are not completed the user cannot continue. The data input by the user is then saved to the “Revenues” worksheet.

3. Expenses: Similar to revenues, the authorized user clicks a button on the “Home” page and a form appears for inputting expenses. Since the organization desires to restrict expenditure authorization to only one individual, the appropriate password must be entered to proceed. Again, if required fields are not completed the user cannot continue. The data input by the user is saved to the “Expenses” worksheet.

4. Donors: On the revenue form the user must indicate if the funds are donations. If they are, a second form opens requesting the user input the donor’s information: name, address, and so on. This information is saved to a separate worksheet for keeping track of donors. On the home screen the authorized user can click on a button to generate and print donor receipts.

5. Budget Variances: The authorized user clicks on a button on the “Home” page which generates a budget variance report. The totals from the revenues and expenses transactions are compared to the budgeted amounts. Any expense totals above those budgeted are flagged for further scrutiny.


WORKBOOK (You may need to enter username (CFO) and password (123456) to access this file)

DOCUMENTATION