CFC07003: Training on QuickBooks and Advanced Excel for Non-Profit Organizations

Module 1: Introduction to Non-Profit Accounting and Financial Management

Overview of Non-Profit Financial Management Principles

• Key differences between for-profit and non-profit accounting
• Fund accounting concepts

Financial Reporting for Non-Profits

• Statement of Financial Position
• Statement of Activities and Cash Flows

Regulatory Compliance and Standards

• IFRS/GAAP compliance for non-profits
• Donor reporting requirements

Module 2: Setting Up and Using QuickBooks for Non-Profits

Specific QuickBooks Areas to be Covered:

1. Setting Up QuickBooks for Non-Profits:
   • Selecting the right QuickBooks version (Online, Desktop, or Enterprise).
   • Customizing the QuickBooks environment for non-profits.
2. Chart of Accounts:
   • Creating and categorizing accounts for restricted and unrestricted funds.
   • Managing classes and locations for tracking different funds or grants.
3. Managing Transactions:
   • Recording pledges and donations.
   • Handling accounts payable and receivable for non-profits.
   • Tracking restricted vs. unrestricted contributions.
4. Bank Reconciliation:
   • Linking bank accounts to QuickBooks.
   • Reconciling bank statements with QuickBooks entries.
5. Donor and Grant Management:
   • Creating donor profiles.
   • Tracking donations and grants by purpose.
6. Generating Reports:
   • Profit and Loss by Class (to track restricted vs. unrestricted funds).
   • Statement of Financial Position.
   • Budget vs. Actuals reports.
7. Payroll and Tax Reporting for Non-Profits:
   • Setting up payroll for employees.
   • Generating tax-compliant reports specific to non-profits.

Module 3: Advanced Excel for Non-Profit Financial Management

Specific Excel Functions and Features to be Covered:

1. Basic Functions for Accounting and Data Entry:
   • SUM, AVERAGE, IF, COUNT, COUNTA, LEN, TRIM, CONCATENATE.
   • Conditional formatting for quick financial insights (e.g., flagging budget overruns).
2. Budgeting and Financial Forecasting:
   • VLOOKUP, HLOOKUP, INDEX, MATCH for cross-referencing donor information.
   • Data validation to create dropdowns for restricted vs. unrestricted funds.
3. Advanced Data Analysis:
   • Pivot Tables and Pivot Charts for donor and grant reports.
   • Power Query to combine and clean data from multiple sources.
4. Financial Dashboards:
   • CHARTS (Bar, Pie, Line, Combo) for visual representation of financial data.
   • Slicers and timelines to filter data dynamically.
5. Advanced Financial Reporting and Automation:
   • IFERROR, ISNUMBER, and Nested IF Statements for error-proof formulas.
   • Recording and running Macros for automated tasks.

Module 4: Integrating QuickBooks and Excel for Enhanced Reporting

QuickBooks Areas:

1. Exporting Data to Excel:
   • Exporting customized reports (e.g., Budget vs. Actuals) for analysis.
2. Customizing Reports for Donors:
   • Tailoring QuickBooks exports to fit donor reporting templates.

Excel Functions and Techniques:

1. Formatting exported data for better presentation:
   • Using TEXT, LEFT, RIGHT, MID for text manipulation.
   • Custom number formatting for financial statements.
2. Automating QuickBooks Report Analysis in Excel:
   • Advanced use of Formulas like INDIRECT and OFFSET.
   • Creating dynamic summaries with Pivot Tables linked to QuickBooks data.

Module 5: Practical Applications and Case Studies

1. QuickBooks Areas:
   • Generating and exporting a full non-profit financial report (e.g., donor-specific).
   • Tracking funds across multiple projects or locations.
2. Excel Functions:
   • Creating a dynamic dashboard that links donor contributions to fund utilization.
   • Using FORECAST, TREND, and Goal Seek for financial projections.
   • Combining Power Query and Power Pivot for advanced analytics.