Financial reports and graphs for nonprofit organizations

If your organization uses the Nonprofit QuickStart template, then you also have access to several of out-of-box financial reports designed to help you comply with the FASB report formats and guidelines quickly and easily.

Depending on if you have admin privileges, do one of the following.

Verification paths for user types
User Verification path
Admin

Go to the Accounting tab in your Company information, then ensure the QuickStart template field is set to Nonprofit.
Non-admin users

Create a new General Ledger account, then click in the Category field and search for Net assets.

  • If the Net assets category appears, then your organization uses the Nonprofit QuickStart template.
  • If you see the Category field but Net assets isn't one of your options, then your organization uses a different QuickStart template.
  • If you don't see the Category field, then your organization doesn't use any QuickStart template.

If your organization doesn't use the Nonprofit QuickStart template, but you still want these categories, reports, and dashboards, contact your account manager to discuss your options.

View and install reports

To help you comply with report formats, we offer premade financial reports you can install from the financial reports library.

To view Nonprofit financial reports:

  1. Go to General Ledger > All > Financial reporting > Financial reports.

  2. Select QuickStart library to view all financial reports included with the Nonprofit QuickStart.

To install financial reports:

  1. Go to General Ledger > All > Financial reporting > Financial reports.

  2. From the Create dropdown button, select Create from library.
  3. Optionally select Layout to see what the report contains.
  4. Select Install next to a report you want to install.
  5. Optionally, change the Report name to the report name you want to appear in your company.
  6. Select Save.
  7. When you're finished, select Done to return to the reports library. The installed reports appear in your Financial reports list.

  1. Go to General Ledger > All > Financial reporting > Financial reports.

  2. Select QuickStart library on the upper right of the page.
  3. Optionally select Layout to see what the report contains.
  4. Select Install next to a report you want to install.
  5. Optionally, change the Report name to the report name you want to appear in your company.
  6. Select Save.
  7. When you're finished, select Done to return to the reports library. The installed reports appear in your Financial reports list.

Configure reports

If you choose to use these reports, some may require additional configuration after installation. Follow the directions in the Configuration task table to complete your configuration for the following reports:

Since nonprofit organizations are all configured in different ways to meet each organization's needs, most reports, including reports not listed below, need some additional configuration in terms of filtering for the right dimensions. Learn more about filtering by dimensions in the Financial Report Writer.
  • Statement of activities: 958 format
  • Statement of activities: 117 format
  • Investments footnotes 2
  • Investments footnotes 3
  • 990IX Statement of functional expenses
  • 990VIII Statement of revenue

Organizations are implemented to track dimensions in a way deemed best to fit their specific needs, resulting in variation in how organizations are configured. Therefore, before you begin making changes to restrictions in these account groups and reports, be sure you know how your organization uses and applies Restriction tracking.

Account groups

Account groups section task details
Configuration task Details and resources
Update restriction report filters on specific net assets account groups related to the Statement of financial position: 958 format report

Update specified net assets account groups so that they filter for the correct restrictions on your Statement of financial position: 958 format report.

To update net assets account groups:

  1. Go to General Ledger > All > Account groups.
  2. Search for, then select Edit next to an account group listed and make edits to the account group as described in the table below.
    Restriction 2 only appears if Restriction 1 is set to Specific restriction(s).
    Account groupRequired restrictions
    Net Assets_Board Designated

    Restriction 1: Specific restriction(s)

    Restriction 2: Board designated

    The 958 requires the inclusion of the Board designated restriction. If your organization doesn't have board designated funds, consider keeping this for future use.

    Net Assets_Not Specified

    Restriction 1: No restriction specified

    Net Assets_Perm

    Restriction 1: Specific restriction(s)

    Restriction 2: Permanently restricted

    Net Assets_Temp

    Restriction 1: Specific restriction(s)

    Restriction 2: Temporarily restricted

    Net Assets_Unrestrict

    Restriction 1: Specific restriction(s)

    Restriction 2: Unrestricted

Dimension groups/structures

Dimension groups/structures section task details
Configuration task Details and resources
Create dimension groups/structures for use with the Statement of activities: 958 format report

The 958 update makes donations easier to track and report on overall, separating funds into only two categories instead of three: With donor restrictions and Without donor restrictions. Create dimension groups/structures that can be used with the Statement of activities: 958 format report to reflect these filters.

For With donor restrictions:

  1. Go to Reports > Setup > Dimension groups, then select the + icon beside Restriction.
  2. In Restriction group ID, enter With restrictions.
  3. In Name, type With donor restrictions.
  4. In Description, type Restricted donations, or some other explanation of the dimension group.
  5. In Group type, choose Specific members.
  6. Select the Dimension structure checkbox.
  7. Add the following members:
    • Temporarily restricted
    • Permanently restricted
  8. Select Save.

For Without donor restrictions:

  1. Go to Reports > Setup > Dimension groups, then select the + icon beside Restriction.
  2. In Restriction group ID, enter Without restrictions.
  3. In Name, type Without donor restrictions.
  4. In Description, type Unrestricted donations, or some other explanation of the dimension group.
  5. In Group type, choose Specific members.
  6. Select the Dimension structure checkbox.
  7. Add the following members:
    • Unrestricted
    • Board designated

      The 958 requires the inclusion of the Board designated restriction. If your organization doesn't have board designated funds, consider keeping this for future use.

      Additionally, some organizations find it helpful to create and include a Not specified restriction that can serve as a catch-all to ensure all transactions have an appropriate restriction selection.

  8. Select Save.

Financial reports

Financial reports section task details
Configuration task Details and resources
Update column filters on Statement of activities: 958 format report to filter for With donor restrictions and Without donor restrictions

Configure columns to filter for With donor restrictions and Without donor restrictions.

To update your financial report columns:

  1. Go to Reports > > Core > Financial reports.
  2. Select Edit beside Statement of activities: 958 format.
  3. Go to the Columns tab.
  4. Click in Column 2: Without restrictions.
  5. Click in the Dimension structure field.
  6. In the pop-up window, select the following values for each field:
    • Dimension: Restriction
    • Dimension structure: Without donor restrictions
  7. Select Okay.
  8. Click in Column 3: With restrictions.
  9. Click in the Dimension structure field.
  10. In the pop-up window, select the following values for each field:
    • Dimension: Restriction
    • Dimension structure: With donor restrictions
  11. Select Okay.
  12. Select Save & done to exit the financial report writer.
Verify the Statement of activities: 117 format report is set to expand by the Restriction dimension

Since dimension tracking is handled differently in every organization to best fit their requirements, be sure the Statement of activities: 117 format reports expands by the Restriction dimension.

To verify your report:

  1. Go to Reports > > Core > Financial reports.
  2. Select Edit besides Statement of activities: 117 format.
  3. Go to the Columns tab.
  4. Click in Column 2.
  5. Check your Expand by field.
    • If it says Restrictions: One level down, with roll-up, then your report is correct, and you can exit the financial report writer by selecting Save & done.
    • If it expands by a dimension other than Restrictions, then proceed to step 6.
  6. Click in the Expand by field, then match the fields in the pop-up window to the following:
    • In Expand by, choose Restrictions.
    • In Show, choose One level down, with roll-up.
  7. Select Set.
  8. Select Save & done.
Update column filters on the Investments footnote 2 and Investments footnotes 3 reports to filter for With donor restrictions and Without donor restrictions

Configure columns to filter for With Donor Restrictions and Without Donor Restrictions.

To update your financial report columns:

  1. Go to Reports > > Core > Financial reports.
  2. Select Edit beside Investments footnote 2.
  3. Go to the Columns tab.
  4. Click in Column 2.
  5. Click in the Dimension structure field.
  6. In the pop-up window, select the following values for each field:
    • Dimension: Restriction
    • Dimension structure: Without donor restrictions
  7. Select Okay.
  8. Click in Column 3: With restrictions.
  9. Click in the Dimension structure field.
  10. In the pop-up window, select the following values for each field:
    • Dimension: Restriction
    • Dimension structure: With Donor Restrictions
  11. Select Okay.
  12. Select Save & done to exit the financial report writer.
  13. Repeat steps these steps for the Investments footnote 3 report.
Update column filters on 990IX Statement of functional expenses

Configure the columns on these two reports to filter by the appropriate dimension structure specified in the column name. You'll need to do this for three columns:

  • Program service
  • Management & general
  • Fundraising
If you plan to use this report, be sure you have the proper dimension groups/structures already created before you begin editing the columns on your financial reports. Learn how to create a dimension group and structure simultaneously.

To update your financial report columns:

  1. Go to Reports > > Core > Financial reports.
  2. Select Edit beside 990IX Statement of functional expenses.
  3. Go to the Columns tab.
  4. Click in Program service (Column 3).
  5. Click in the Dimension structure field.
  6. In the pop-up window, select the Dimension and Dimension structure that corresponds to that column.
  7. Select Okay.
  8. Repeat steps 4-7 for the Management and Fundraising columns on the report.
  9. Select Save & done to exit the financial report writer.
Update column filters on the 990VIII Statement of revenue

Configure columns to filter by the appropriate dimension structure specified by the column name. You'll need to do this for three columns:

  • Related/Exempt revenue
  • Unrelated biz revenue
  • Excluded revenue
If you plan to use this report, be sure you have the proper dimension groups/structures already created before you begin editing the columns on your financial reports. Learn how to create a dimension group and structure simultaneously.

To update your financial report columns:

  1. Go to Reports > > Core > Financial reports.
  2. Select Edit beside 990VIII Statement of revenue.
  3. Go to the Columns tab.
  4. Click in Related/Exempt revenue.
  5. Click in the Dimension structure field.
  6. In the pop-up window, select the Dimension and Dimension structure that corresponds to that column.
  7. Select Okay.
  8. Repeat steps 4-7 for the Unrelated biz revenue and Excluded revenue columns on the report.
  9. Select Save & done to exit the financial report writer.
If your organization doesn't use one of these revenue groupings, remove the column by selecting the dropdown arrow beside the column indicator and selecting Remove so that your report balances.

View and install graphs

We also offer premade financial graphs which you can install from the financial graphs library:

  • Cash balance: weekly
  • Net assets
  • Operating expense by function
  • Revenue

To view Nonprofit financial graphs:

To install financial graphs:

  1. Go to General Ledger > All > Financial reporting > Financial graphs.
  2. Select QuickStart library.
  3. Select Install along the same row as the graph you want to install.
  4. Optionally, change the name of the graph, then select Save.
  5. When you're done, select Done to return to the Financial graphs list and find the graph there.
  1. Go to General Ledger > All > Financial reporting > Financial graphs.
  2. From the Create dropdown button, select Create from library.
  3. Select Install along the same row as the graph you want to install.
  4. Optionally, change the name of the graph, then select Save.
  5. When you're done, select Done to return to the Financial graphs list and find the graph there.