I need an online management database developed using PHP/MYSQL with the following features:
1. Security Users Access Levels
Admin Level
Can see everything and enter everything in the database(can have more than 1)
Under The Admin level
———————————————–
User Level A – Will enter Member information
Userl Level B – Will handle Contributions
User Level C – Will enter Activities (Calendar)
User Level D – Attendance, Visitation
DATABASE ENTRY AREAS
2. Ability To Add Members
* Keep important family, individual, and organizational information
* Customize data for specific needs with an unlimited number of user defined fields and dates
* Create and record an unlimited amount of notes by type for individuals, families and organizations
* Store an unlimited amount of phone numbers and email addresses
* Maintain alternate addresses, with activation dates, for college students, military personnel and people with winter or summer homes
* Customizable grids that allow you to sort, group and/or filter records by any standard field such as family or individual name, envelope number, member status, gender, birthday and more
* Customizable quick lists can be printed directly from the individual or family grid list view
* Deactivate records with a simple click to eliminate them from being included in reports, labels, lists, searches and filters
* Easily add people to Groups from the individual or family record
* Import individual and family pictures from digital files or scanned images
* Create phone directories and church directories with or without pictures
* Quickly view a map and driving directions to any persons address right from their record (internet connection required)
3. Contributions
* Enter individual or combined contributions entries
* Track an unlimited amount of giving funds using fund names or fund numbers
* Track multi-year giving history
* Indicate if a fund is tax deductible fund or non tax-deductible (can be over written during contribution entry
* Record pledges for individuals, families or organizations by fund and pledge period
* Record gifts to multiple giving funds in one contribution entry
* Customizable grids allow you to sort, group and/or filter records by contributor, contribution amount, contribution date, check number, deposit id, batch id, created date and more
* Print quick lists directly from the contribution grid list view
* Copy previous contributions for those who repeatedly give the same amount to the same fund(s)
* Print Contribution Statements and Receipts including Canadian Tax Receipts , checks and more
* Link Deposits to the Accounting General Ledger so that entries are made automatically. Link funds in contributions to specific accounts in Accounting for automatic entries to income and designated accounts
* Browse deposits to view detailed information such as contributions included in the deposit, bank totals, fund totals, date and amount
* Quickly print a deposit summary to attach to your actual deposit slip
* Use Contributions at home for offsite contribution entry
4. Activities
* Manage an unlimited number of groups, committees, volunteers, and activities
* Track an unlimited number of people for each group
* Track roles for each person that is a member of a group
* Print reports and lists for members of a group
* Collect, maintain and manage information about your members unique spiritual gifts, time, and talents
* Manage outreach programs
5. Visitation
* Track visitors and prospects
* Easily convert prospects to members
* Quickly track inward and outward visits
* Create customizable visit response codes
* Report on completed and/or scheduled visits
* Generate lists of visits by assigned callers, visitors or teams
6. Attendance
* Record summary or detailed attendance for classes, services, events, and more
* Set up an unlimited number of classes and small groups
* Print blank attendance marking sheets
* Quick attendance marking by defaulting the entire class or group present or absent, the only having to change the exceptions
* Report absentees by date or range of dates
* View and print attendance summaries
* Quickly promote members
7. Fund Accounting
* Maintain standard bookkeeping practices
* Easily categorize your account types with customizable Chart of Accounts
* Create custom filters to quickly find data that meets the same criteria
* Save frequently used filters for future use
* Maintain separate sets of books or funds
* Enter beginning balances for account start up
* Check writer program included that reminds you when checks are due to be printed
* Quickly perform budgeting and bank reconciliation tasks
* Enter budget amounts based on annual, weekly, monthly, bi-monthly, or quarterly time frames
* Copy budget from one year to another
* Generate standard accounting reports
* Operate on a calendar or fiscal year
* Store payee (vendor) information
8. Scheduler
* Track important dates, meetings, events
* Register attendees for events
9. Reporting, Security, & More
* Easily print and generate reports
* Export reports to pdf, html, csv or txt formats
* Set security level per user
Please make sure you have read and understand ALL REQUIREMENTS before bidding. Bidder should have the ability to complete items 1-9. NO EXCUSES. I will select a bid quickly as I need a fairly fast turnaround. I will only pay via escrow to someone that has a 4/5 rating with positive feedback. Thanks for your interest. Happy Bidding.
