Embedded Files
Note: Our fiscal year runs from July 1 - June 30th each year. For example, FY20 began in July 2020 and FY21 begins July 2021.
DATA SOURCES
DATA SOURCES
Donor records and reports can be pulled from Salesforce
The following can be pulled from Aplos
Balance Sheet
Expenditures
Revenue
Payroll Records
We may be incorporating Airtable into our process of tracking, pulling in records from Aplos, Salesforce, and/or Mailchimp.
REGULAR DONATION TALLYING
REGULAR DONATION TALLYING
Run the report in Salesforce called "Regular Donations Report"
First, customize the close date range in "filters" to match the period you're entering data for
Add it into the master financial data spreadsheet in the appropriate tabs
Sort by "type of donation"
Paste "monthly" in all the boxes with a name and dollar amount (as that indicates a recurring monthly donation_
Paste "once" in all blank fields, as those are one-time donations
Add up the figures to add to the first tab to get totals
CALENDAR YEAR 2022
CALENDAR YEAR 2022
Contributions & Grants39. List the revenue amounts from contributions and grants during CY 2022.
Foundation grants (excluding contributions that are essentially individual or family donations), including any portion of a multi-year grant specifically allocated as 2022 revenue 68000
Individual donations, small-dollar donors (less than $1,000) 31505
Individual donations, mid-level donors ($1,000-4,999) 14250
Individual donations, major gifts ($5,000 or more; including gifts that are essentially individual donations given through a foundation), including any portion of a multi-year gift specifically allocated as 2022 revenue 5000
Other charitable contributions, specify source(s) 0 --
39b. Of the $68000 in revenue from total grants listed previously, how many individual foundations contributed to this total sum?
2
39c. Approximately what percentage of your total grant funding in CY 2022 was available for general operating expenses (as opposed to being restricted or project-specific funds)?
100
39d. Approximately what percentage of your total grant funding in CY 2022 came from local or community foundations (as opposed to national or global organizations)?
0
Earned Revenue (use gross revenue figures)40. List earned revenue amounts in CY 2022.
Advertising 0
Sponsorships and underwriting (non-events) 0
Events (including sponsorships, ticket sales) 0
Subscriptions 0
Syndication/commissions 0
Other earned revenue (such as training fees, investment income), specify source(s) 0 --
Number of Donors41. How many donors did you have in each of the following categories during calendar year 2022?
Small-dollar donors (less than $1,000) 355
Mid-level donors ($1,000-4,999) 9
Major donors ($5,000 or more) 1
42. Other than NewsMatch, how many fundraising collaborations did your outlet participate in over the past year?A fundraising collaboration can be understood as a joint effort of two or more organizations to raise more money than either group could alone.
0
43. Please list total operating expenses, both personnel and non-personnel for calendar year 2022, dividing total expenses into four categories: Editorial, Revenue Generation, Technology, and General Administration (such as rent, insurance, supplies, legal, and management costs). If you do not record expenses in this manner, it is OK to use estimates.
Editorial 24114.06
Revenue generation 19022.43
Technology 2702.02
General administration 15950.82
CALENDAR YEAR 2021
CALENDAR YEAR 2021
16. Contributions & Grants
Foundation grants (excluding contributions that are essentially individual or family donations), including any portion of a multi-year grant specifically allocated as 2021 revenue.
$ 37,918.00
Memberships (from a formal program distinct from donor programs and not if your organization simply calls all donors members).
$ 13,437.74
Individual donations - small dollar donors (less than $1,000)
$ 8,121.94
Individual donations - mid-range donors ($1,000-$4,999)
$6,000
Individual donations - major gift donors ($5,000 or more; including gifts that are essentially individual donations given through a foundation) including any portion of a multi-year gift specifically allocated as 2021 revenue.
$0
Other charitable contributions
Specify source(s)
17. Earned Revenue (use gross revenue figures)
Advertising
Sponsorships and underwriting (non-events)
Events (including sponsorships, ticket sales)
Subscriptions
Syndication/commissions
Other earned revenue (such as training fees, investment income)
$842.98
Specify source(s) Event raffle tickets
18. A. Donations. How many donors did you have in each of the following categories during calendar year 2021 (excluding revenue from any formal membership program)?
Individual donations - small donors (less than $1,000)
129
Individual donations - mid-range donors ($1,000-$4,999)
2
Individual donations - major gift donors ($5,000 or more)
B. How many members did your organization have as of Dec. 31, 2021? (Do not include donors who give on a recurring basis but are not part of a formal membership program. We are only interested in numbers of members in a formal program.)
94
CALENDAR YEAR 2020
CALENDAR YEAR 2020
Calendar Year 2020:
Earned Revenue (use gross revenue figures)
Advertising 0
Sponsorships and underwriting (non-events) 0
Events (including sponsorships, ticket sales) 150
Subscriptions 0
Syndication/commissions 400
Other earned revenue (such as fees, investment income) Specify source(s) 0 --
Contributions & Grants
Foundation grants 14195
Memberships 10628
Individual donations, small (less than $1,000) 14579.66
Individual donations, mid-range ($1,000-4,999) 0
Individual donations, major ($5,000 or more) 0
Other charitable contributions, specify source(s) 0 --
# of donors
SMALL DONORS: 340 (including 140 members)
Page updated
Google Sites
Report abuse