Description of Organization
CAGS is Canada’s only national organization representing the interests of General Surgeons. Our Mission is to empower general surgeons to improve patients’ lives through continued advocacy, education, and research. We advocate on behalf of academic, community, rural and remote General Surgeons on issues related health human resources, transition of practice, pay equity, and the required access to resources to provide care for patients, and for quality of care for surgical patients.
CAGS manages the planning and delivery of the Canadian Surgery Forum – the largest scientific and networking event for General Surgeons in Canada. In addition, through our General Surgery Learning & Resource Centre, we provide educational opportunities to ensure general surgeons can upgrade their skills as part of their Continuing Medical Education and assurance of optimal patient care. To learn more about or join CAGS, explore our website, connect with us on LinkedIn, or donate to the Canadian General Surgery Foundation (CGSF) to help further surgical research in Canada.
CAGS also manages 4 other societies focused on surgery:
- CSSO
- CSCRS
- CHS
- CHPBA
As well as the Canadian General Surgery Foundation.
We are a very lean team of 6 people and we need help to digitize things!
Problem area
Conference budgets are often managed through spreadsheets, separate financial reports, and information collected from different departments or systems. This can make it difficult to maintain an accurate and up-to-date view of the conference's financial position.
Budgeted amounts, actual expenses, committed costs, anticipated expenses, and revenue may be recorded separately. As a result, financial changes may not be reflected immediately, overspending can go unnoticed, and forecasting may require significant manual effort.
Additionally, sponsorship revenue and registration revenue may be tracked in separate systems, making it challenging to consolidate all revenue and expense information into one reliable financial overview. Without a centralized system, conference organizers may have difficulty identifying budget variances, monitoring financial commitments, and determining whether the conference is on track to meet its financial objectives.
The problem this project addresses is the lack of a centralized, timely, and integrated budget management system that provides real-time financial visibility, identifies budget variances, tracks committed costs, and forecasts the overall financial position of a conference.
The proposed application will consolidate financial information from multiple sources, track budget changes, highlight variances exceeding 2% of budgeted amounts, and provide a current view of projected revenue, expenses, and the expected financial outcome.
Main objectives
The primary objective is to develop a centralized conference budget application that provides timely financial information, improves budget control, and supports informed financial decision-making throughout the conference planning process.
The specific objectives are to:
- Centralize conference budget information: Provide one application where authorized users can enter and manage budget categories, approved amounts, actual expenditures, commitments, and forecasts.
- Track budget changes and maintain an audit trail: Record adjustments to budgeted amounts, including the date, reason for the change, person responsible, and approval status.
- Identify budget variances automatically: Implement alerts that highlight expense categories or other agreed financial measures that exceed their budget by more than 2%, enabling early intervention.
- Monitor committed and anticipated expenses: Track amounts that have already been agreed to or contractually committed, even if invoices have not yet been received or payments have not been made.
- Develop forecasting capabilities: Provide projected revenue, expenses, and final financial outcomes using actual results, committed costs, anticipated costs, and expected revenue.
- Integrate sponsorship revenue: Consolidate sponsorship revenue data from the sponsorship management process or application to ensure that agreed, invoiced, and received sponsorship amounts are appropriately reflected.
- Integrate registration revenue: Import or synchronize revenue information from the conference registration system to provide an up-to-date view of registration income.
- Provide real-time financial reporting: Deliver dashboards and reports that show the current financial position, budget utilization, revenue performance, outstanding commitments, forecast results, and areas requiring attention.
- Improve financial accountability: Establish appropriate access controls, consistent reporting definitions, and reliable records of financial changes to support transparency and accurate decision-making.
Scope of work
The project will cover requirements gathering, financial process analysis, application design, development or configuration, data integration, testing, and implementation planning.
Phase 1: Requirements Gathering and Financial Analysis
- Review existing conference budgets, spreadsheets, financial reports, and forecasting processes.
- Identify budget categories, revenue streams, expense types, and financial reporting requirements.
- Define how budgeted, actual, committed, and forecast amounts will be recorded.
- Establish the 2% variance threshold and determine which measures it applies to.
- Identify the data available from sponsorship and registration systems.
- Document user roles, approval requirements, and reporting needs.
Phase 2: Application and Dashboard Design
- Design the budget input screens and financial dashboard.
- Establish standardized budget categories and financial data fields.
- Design budget change tracking, variance alerts, and approval workflows.
- Develop a reporting layout showing revenue, expenses, commitments, forecasts, and projected surplus or deficit.
- Define how frequently information will refresh and how users will see the latest update time.
Phase 3: Budget Application Development
- Build or configure the central budget database and user interface.
- Enable authorized users to enter and update budget amounts.
- Track original budgets, revised budgets, actual expenses, and committed costs.
- Implement automatic variance calculations and alerts for amounts exceeding the 2% threshold.
- Create forecasting functionality using agreed assumptions and available financial information.
- Develop dashboards, summary reports, and financial status indicators.
Phase 4: Revenue Integration and Data Validation
- Define how sponsorship revenue will be received from the sponsorship tracking process or system.
- Determine how registration revenue will be imported or synchronized from the registration platform.
- Map data fields, identifiers, reporting periods, and revenue statuses.
- Establish checks to identify duplicate, missing, or inconsistent records.
- Reconcile imported revenue against source-system reports.
- Configure refresh schedules or event-driven updates, depending on available system capabilities.
Phase 5: Testing and User Acceptance
- Test budget calculations, variance thresholds, and forecast outputs.
- Confirm that committed costs are reflected correctly without being double-counted as actual expenses.
- Test sponsorship and registration revenue imports.
- Verify that dashboard totals reconcile with source data.
- Test access permissions, change logs, and reporting accuracy.
- Conduct user acceptance testing with conference and finance staff.
Phase 6: Implementation and Evaluation
- Prepare user guides and financial reporting instructions.
- Establish procedures for updating, reconciling, and approving financial information.
- Demonstrate the application to stakeholders.
- Evaluate improvements in financial visibility, reporting time, and budget monitoring.
- Document limitations, lessons learned, and future enhancements.
Deliverables
- Report, Resources, New protocols/processes
- Requirements and financial process documentation Budget categories, financial definitions, variance rules, and reporting requirements are documented and approved.
- Budget management application Authorized users can enter, update, and review budget amounts and financial commitments.
- Budget change log Changes to approved budget amounts can be traced to a user, date, reason, and approval status.
- Variance alert functionality Test cases confirm that variances greater than 2% trigger the correct alerts.
Forecasting module The application calculates projected revenue, expenses, and final financial outcomes using documented assumptions. - Revenue integration Sponsorship and registration data can be imported or synchronized and reconciled to their source reports.
- Financial dashboard Users can view current revenue, actual expenses, commitments, forecast amounts, and projected surplus or deficit.
- Testing and user documentation Core calculations and workflows pass agreed test cases, and users receive operating instructions.
Frequency
- Bi-Weekly
Skills and training required
The project requires a combination of financial management, business analysis, data integration, application development, and reporting skills.
Skill area Required skills and training
- Project management Planning, scheduling, task allocation, risk management, and stakeholder coordination.
- Business analysis Requirements gathering, process mapping, identifying financial reporting needs, and documenting business rules.
- Budget and financial management Budget preparation, variance analysis, committed cost tracking, revenue recognition concepts, forecasting, and financial reconciliation.
- Spreadsheet and data analysis Advanced spreadsheet skills, formulas, pivot tables, data cleaning, and financial modeling.
- Database management Data modeling, data validation, structured financial records, and database queries.
- Application development Form design, workflow automation, application configuration, and dashboard development.
- Data integration APIs, file imports, data mapping, refresh schedules, error handling, and source-system reconciliation
- Reporting and visualization Dashboard design, financial KPIs, trend analysis, exception reporting, and executive summaries.
- Testing and quality assurance Testing formulas, checking data integrity, validating forecasts, and conducting user acceptance testing
- Information security and governance Role-based access, audit trails, financial data confidentiality, and controlled changes to approved budgets
- User training and documentation Developing user guides, reporting instructions, and procedures for financial updates and reconciliation.
- For a smaller capstone team, individuals can take on multiple roles. The team should also consult conference finance staff to ensure that the financial calculations and definitions match organizational practices.
Resources required
A. Human resources
- Project manager/team lead: Coordinates project activities, timelines, risks, and deliverables.
- Business analyst: Documents requirements and defines financial workflows and business rules.
- Finance or budget specialist: Validates budget calculations, variance rules, commitments, forecasts, and reporting requirements.
- Application developer or technical specialist: Builds or configures the budget application.
- Data integration specialist: Connects sponsorship and registration revenue data to the application.
- Data analyst/reporting specialist: Designs the financial dashboard, forecasts, and management reports.
- Conference stakeholders: Provide feedback on usability and operational requirements.
- Testers/end users: Validate the application's accuracy, functionality, and usefulness.
- For a small team, the developer may also handle database and integration tasks, while the business analyst and finance specialist collaborate on reporting requirements.
B. Technology and software resources
- Computers and reliable internet access.
- A development platform, such as Microsoft Power Platform, a web application framework, or another institution-approved tool.
- A database or structured data repository.
- Form-building and workflow automation tools.
- Spreadsheet and document software for program templates and financial reports.
- Version control and project collaboration tools, where applicable.
- A test environment with sample speaker records and fictional financial information.
C. Information and documentation
- Current and previous conference budgets.
- Standard budget categories and expense codes.
- Original approved budgets and records of subsequent revisions.
- Actual expense data and available invoices.
- Contracts, purchase orders, and other records of committed costs.
- Forecast assumptions and anticipated expenses.
- Sponsorship agreements and revenue status information.
- Registration revenue reports from the registration system.
- Definitions of gross revenue, refunds, taxes, fees, and net revenue, as applicable.
- Existing financial reports and reconciliation procedures.
- Approval limits, financial policies, and reporting requirements.
- This information will be essential for developing realistic test cases and validating that the application calculates the financial position correctly.
D. Financial resources
- Software licensing and subscriptions.
- Cloud hosting or database services.
- Data integration or API access fees.
- Technical support and training.
- Testing and implementation.
- Contingency expenses.
- The budget will depend on the selected technology and the integration capabilities of existing conference systems. Using existing organizational software and scheduled file imports may reduce initial c
E. Time and stakeholder availability
- Time for requirements gathering and financial process review.
- Access to finance staff and conference organizers.
- Cooperation from the teams responsible for sponsorship and registration systems.
- Time for data mapping, reconciliation, and testing.
- Stakeholder availability for demonstrations and user acceptance testing.
- A defined timeline for development, testing, and final delivery.
NDA or a commercialization agreement for this project?
Yes