Draft for BOC team review. Please do not forward, publish or print this page until Rich's approves it.

BOC Grants Tracker

One place for the Better Our Communities team to follow each grant from committee approval through documentation, vendor set up and invoice submission to the completed stage. This page explains what the tracker does today and what still needs a decision.

Open the tracker

Where it stands today

Figures read from the live tracker on November 17, 2026. They cover 2026 records, meaning grants with an approval date in 2026.

Grants in 2026

129

126 are at the completed stage, 3 are in progress and 2 of those are flagged as stale. The completed stage means the workflow is finished. It is not a record that a payment went out.

See the stages

Approved in 2026

$230,843

The budget setting in the tracker is $200,000, so approved amounts are 115% of it, or $30,843 over. The setting is a guide. Going past it does not stop the team from entering grants.

See the breakdown

Active accounts

9

Nine active accounts, including support accounts, and one pending invitation. In June, Daniela Gawel wrote that she and Adrianna Rolling were "now solely using the tool v. spreadsheets."

See the timeline

Signing in

The tracker lives at boc.rw.institute. There is no password and no sign-in link to click.

  1. Open boc.rw.institute and enter the email address your invitation was sent to.
  2. A six-digit code arrives by email from an rw.institute address. Because it comes from outside Rich's, your usual external-sender notice may appear.
  3. Type the code into the sign-in page you already have open.
  4. Each code works once and expires after 10 minutes. Do not share it.

If something looks wrong, send a note or voice message with the page you were on, what you were doing, the approximate time and a screenshot. Leave out sign-in codes and the contents of confidential documents.

Why it exists

Better Our Communities (BOC) makes small grants to nonprofits. Before the tracker, the program ran on four Excel spreadsheets: the BOC Invoice Tracker, the Monthly Gig Budget, the Monthly Budget Worksheet and the YTD Budget Breakdown. Status lived in color coding and in running notes, and nobody else could see where a grant stood without asking.

At the March 3, 2026 working session the team decided to use the dashboard prototype as an interim working tool while Rich's finished choosing a longer-term grant platform, to start with 2026 data, and to keep the seven program categories so reporting would carry forward. The prototype was then loaded from two documents Daniela sent on March 9: the 2026 YTD Budget Breakdown (36 grants, with category, business priority and new or existing partner) and the Status of 2026 BOC Grants notes. The State of BOC deck from February 2025 was supplied as the model for reporting.

Planning documents from March 2026 estimated about 60 minutes of handling per grant, roughly 40% of grants missing a document at any time, and a target of 30 to 40 hours a month saved. Unverified These are planning estimates. No measurement after launch was found.

How a grant moves

The tracker launched with seven stages. In June 2026 Daniela and Adrianna narrowed them to five. Since August 11, authorized users can move a grant between stages, forward or back, from a dropdown on the grant. Declined is a separate outcome, not a stage.

Stages in the live tracker, with 2026 grant counts on November 17, 2026
StageWhat it meansGrants now
1. ApprovedThe BOC Committee has approved the grant and its amount.0
2. DocumentationCollecting the nonprofit's invoice, W-9 and IRS determination letter.0
3. Vendor Set UpThe nonprofit is being set up as a vendor so it can be paid.1
4. Invoice SubmittedThe invoice has gone to Accounts Payable.2
5. Coded & CompletedThe grant is recorded at the completed stage. On its own this does not show that a payment was issued, or when.126

Manual check requests. At Invoice Submitted, a grant can be given an optional payment route. A requested check stays pending there until an authorized user moves the grant to Check Request & Completed. Choosing a route does not issue a check or change a payment date. Grants entered before this option existed show "Route not recorded."

Stale grants. A grant with no activity for seven days or more is flagged on the dashboard. That is an inactivity warning, not a payment status.

Earlier years. Unfinished grants from before the selected year are listed separately as prior-year unfinished work, so they stay easy to find. Today that list is empty.

What the tracker does

Each feature below was seen in the live tracker on November 17, 2026, unless a card says it was not tested. Details that cannot be seen on screen come from the November release records.

Dashboard and year view

A year selector switches the Dashboard, Grants and Reports between 2026 and 2027. A grant belongs to the year of its approval date. The dashboard shows budget used, grants in progress, stale grants and a count at each stage. A new year's budget shows as not set until BOC provides one.

Open dashboard

Grant records

Each grant page holds its details, stage, payment route, notes and history. From there you can correct a wrong nonprofit match, look up an EIN (the nonprofit's public tax ID), edit it with the right permission, and reset a verification that no longer applies. A correction affects that grant only.

Open grants

Documents and checks

Upload the application, invoice, W-9 and IRS letter to a grant. The tracker reads them and holds what it finds for staff review. Nothing overwrites existing details by itself. It compares the W-9 and invoice addresses when both have been read, and says so plainly when it cannot. Not tested New uploads and document reading.

What was checked

Reports

Approved amounts by category, business priority, partner type and month, with the average and median grant and the basis of each figure stated. Business Priority counts open to show the nonprofits and amounts behind them. Paid amounts come only from recorded check-issued dates.

Open reports

Excel and other downloads

The grant list downloads as CSV, Excel or PDF using the filters on screen. Excel offers default, full or chosen fields, including notes, descriptions, category and business priority. Private identifiers, contacts and document files are left out. Read notes and descriptions before sharing a file outside the team. Not tested File contents.

Open grant list

Reporting assistant

On the Reports page, a read-only assistant answers questions about report figures, such as comparing two months, and helps you find features. It does not edit grants or move stages, and the regular reports work without it. Not tested No question was asked for this page.

Open assistant

People and access

Access is by invitation, with Admin, User and Committee roles. Admins can filter invitations by status and renew an expired one, which creates a replacement link. Renewing does not email that link by itself. Active Committee members can read reports. Automatic follow-up on unanswered invitations is not switched on.

Open decisions

Reminders

Staff can send a reminder from a grant page for an approval, missing documents or a stale grant. The tracker records each one and guards against duplicates. A recorded send means the email service accepted it, not that it reached an inbox. The November release did not switch on any automatic schedule. Not tested Sending.

What was checked

Notes and history

Every grant has timestamped notes the whole team can see and an activity log of changes. Grants cannot be permanently deleted from the grant page, which protects the record.

See the stages

2026 giving in numbers

The State of BOC deck reported each year's contributions by category. The tracker holds the same data, so it can be shown in more than one way. Choose a view below. All 2026 figures are approved amounts read from the Reports page on November 17, 2026. They are not payments.

Two categories hold 62% of approved dollars

2026 approved amount by category, largest first, with the number of grants and each category's share of the $230,843 approved.

  • Health & Wellness$78,485 · 43 grants · 34.0%
  • Arts/Culture/Sports$64,585 · 34 grants · 28.0%
  • Social Services$41,470 · 23 grants · 18.0%
  • Education$29,203 · 18 grants · 12.7%
  • Environment$9,700 · 4 grants · 4.2%
  • Food Equity & Access$3,900 · 4 grants · 1.7%
  • Economic Development$3,500 · 3 grants · 1.5%

Arts/Culture/Sports grew the most since 2024

Dollars by category in 2024 and 2026 on the same scale, ordered from the largest increase to the largest decrease. 2024 is the full year from the State of BOC deck ($211,800 in total). 2026 is approved amounts to November 17 ($230,843), so the year is not finished.

  • 2026 approved, to November 17
  • 2024 contributions, full year
  • Arts/Culture/Sportsup $26,8352026 · $64,5852024 · $37,750
  • Health & Wellnessup $11,6752026 · $78,4852024 · $66,810
  • Educationup $6,4132026 · $29,2032024 · $22,790
  • Environmentdown $1,0502026 · $9,7002024 · $10,750
  • Social Servicesdown $3,1802026 · $41,4702024 · $44,650
  • Food Equity & Accessdown $8,6002026 · $3,9002024 · $12,500
  • Economic Developmentdown $13,0502026 · $3,5002024 · $16,550

Approvals passed the $200,000 setting in September

Each row is the running total of approved amounts at the end of that month. The solid part is what that month added. March added the most, $55,750 across 31 grants.

  • Approved that month
  • Approved in earlier months
  • $200,000 budget setting
  • Jan+$20,650
    total $20,650
  • Feb+$16,750
    total $37,400
  • Mar+$55,750
    total $93,150
  • Apr+$14,500
    total $107,650
  • May+$24,350
    total $132,000
  • Jun+$9,700
    total $141,700
  • Jul+$32,650
    total $174,350
  • Aug+$14,370
    total $188,720
  • Sep+$29,623
    total $218,343
  • Oct+$12,500
    total $230,843
  • Novno grants yet
    total $230,843

Three of every four dollars went to existing partners

The split of 2026 approved dollars between existing and new community partners, then the same dollars by business priority.

Existing partners · $173,743 · 97 grants · 75.3%New partners · $57,100 · 32 grants · 24.7%

By business priority

  • Culture - The Rich Promise$83,450 · 50 grants · 36.2%
  • Culture - ARG$41,250 · 19 grants · 17.9%
  • Culture - Associate Engagement$31,220 · 19 grants · 13.5%
  • Culture - ARG BOC Community Budget$23,673 · 13 grants · 10.3%
  • Culture - Executive Engagement$22,600 · 12 grants · 9.8%
  • Brand Recognition & Reputation - Community Partnership$12,150 · 5 grants · 5.3%
  • Culture - BOC Committee Engagement$11,000 · 7 grants · 4.8%
  • Culture - Rich's Plant$4,500 · 3 grants · 1.9%
  • Brand Recognition & Reputation - Talent$1,000 · 1 grant · 0.4%

The numbers behind the diagrams

By category: 2024 (State of BOC deck) and 2026 (live tracker)
Category2024 amount2024 share of budget2026 grants2026 approved2026 share of approved
Health & Wellness$66,81032%43$78,48534.0%
Arts/Culture/Sports$37,75018%34$64,58528.0%
Social Services$44,65021%23$41,47018.0%
Education$22,79011%18$29,20312.7%
Environment$10,7505%4$9,7004.2%
Food Equity & Access$12,5006%4$3,9001.7%
Economic Development$16,5508%3$3,5001.5%
Total$211,800129$230,843

The two share columns use different bases. The 2024 figures are the deck's own "% of Budget." The 2026 figures are each category's part of the $230,843 approved, calculated for this page. Shares are rounded, so a column may not add to exactly 100% (the deck's add to 101%). The deck's chart labels Economic Development as 16,500 while its list reads 16,550.

In 2026 the average grant is $1,789.48 and the median, the middle amount when grants are ordered by size, is $1,500. Existing partners received 97 grants totaling $173,743. New partners received 32 grants totaling $57,100. Of the 23 Social Services grants, 22 have no subcategory yet and 1 carries an older DEI label, because the approved subcategory list has not been set.

2026 by business priority (live tracker)
Business priorityGrantsApprovedShare of approved
Culture - The Rich Promise50$83,45036.2%
Culture - ARG19$41,25017.9%
Culture - Associate Engagement19$31,22013.5%
Culture - ARG BOC Community Budget13$23,67310.3%
Culture - Executive Engagement12$22,6009.8%
Brand Recognition & Reputation - Community Partnership5$12,1505.3%
Culture - BOC Committee Engagement7$11,0004.8%
Culture - Rich's Plant3$4,5001.9%
Brand Recognition & Reputation - Talent1$1,0000.4%
Total129$230,843
2026 by approval month (live tracker)
MonthGrantsApproved
January10$20,650
February13$16,750
March31$55,750
April10$14,500
May13$24,350
June5$9,700
July14$32,650
August7$14,370
September19$29,623
October7$12,500
November0$0
Total129$230,843

Shares calculated for this page from the amounts shown in the tracker. Paid reporting shows $0.00 because it counts only grants with a recorded check-issued date, and none has one. That is a gap in what is recorded, not a finding about payments.

How it got here

DateWhat happenedSource
Feb 4, 2026A review of the BOC workflow led to a standalone tool with its own dashboard. Two prototypes were shared. UnverifiedMarch 31 requirements summary. The February meeting record was not opened.
Mar 3, 2026Working session. The team chose the dashboard prototype as an interim working tool, kept the seven categories and agreed to start with 2026 data.Meeting recap email, March 6
Mar 9, 2026Daniela sent the 2026 YTD Budget Breakdown, the Status of 2026 BOC Grants, Rich's brand guidelines and the State of BOC deck.Daniela's email, March 9, and the files
Mar 31, 2026Orientation walkthrough of the dashboard with 36 real 2026 grants loaded.Orientation deck, March 31
Apr 16, 2026A check comparing the W-9 address with the invoice address was added at Daniela's request. She confirmed the warning appeared.Email thread, April 13 to 16
Jun 2026Grants were bulk imported from Excel. Daniela reported that she and Adrianna had moved off spreadsheets, and sent a wish list that included free movement between stages.Daniela's email, June 16. Import results as recorded in the July 13 audit.
Jul 9 to 13, 2026A grant-entry error was fixed by adding the Food Equity & Access category, and one missing grant was restored from the source workbook. The tracker then held 82 grants.Audit notes, July 13
Aug 11, 2026Stage dropdown went live, in time for the August 12 committee meeting.Email thread, August 6 to 12
Aug 17, 2026Single-grant Excel export, previous and next navigation, a merged notes view and a nonprofit contact export were released. Today's Excel download leaves contacts out. UnverifiedInternal status note, August 21. The August 17 email was not opened.
Sep 15, 2026The annual budget setting stopped blocking grant entry. It now warns instead.Tool change history
Oct 16 to 20, 2026Invitations and sign-in by emailed code were fixed and confirmed working at boc.rw.institute.Tool change history
Nov 10, 2026Review call on fixes and the 2027 year view. Everyone on the team logged in successfully by the end of the meeting.Call transcript and the November 12 written overview
Nov 12, 2026The requests from the November 10 call were built and tested. They were not yet released.November implementation record
Nov 16, 2026The November release was published. Three existing documents that had stopped opening were made available again, with their contents unchanged. Guarded reminder handling was switched on. No reminders were sent and no existing records were changed.November 16 release record
Nov 17, 2026The released features were seen in the live tracker and the figures on this page were read.Live tracker

November updates and open decisions

These are the twelve requests from the November 10 conversation and where each one stands after the November 16 release.

RequestStatusWhat to know
Year viewAvailableSwitch between 2026 and 2027. Earlier unfinished work stays findable. The 2027 budget still needs a value from BOC.
Nonprofit and EIN correctionsAvailableCorrect the match and the EIN with the right permission, and reset an outdated verification. A corrected identity does not by itself establish tax eligibility.
Less retypingAvailable for existing grantsUpload an application to a grant and review what was read before accepting it into empty fields. A direct Microsoft Forms connection is not built.
Manual-check trackingAvailableOptional route at Invoice Submitted, explicit completion, and a Check Request filter on the grant list. Older grants keep "Route not recorded."
Social Services detailReady, waiting on BOC listThe selector and report grouping are built. The selector stays off until BOC approves the subcategory list. No older grants were reclassified.
Reports that explain totalsAvailableNames and amounts behind Business Priority counts, average and median, and month-by-month detail. Organization-size comparisons wait on a definition of size.
Address warningAvailable when documents have been readCompares the W-9 and invoice addresses and can be rechecked. When a document has not been read, the tracker says the comparison is unavailable. That is not a match.
AI assistanceIn place, not yet exercisedRead-only help on the Reports page, with the regular reports as a fallback. Its answers to real questions were not tested for this page.
Refreshed lookAvailableRich's branding and the familiar layout are kept, with refreshed controls, contrast and phone-size screens.
Invitations and committee accessPartly availableStatus filter, renewal with a replacement link, and report access for active Committee members. Automatic three-day follow-up is not switched on.
Fuller Excel downloadsAvailable, with privacy limitsChoose the fields, including notes and descriptions. Review free text before sharing outside the team.
Simpler updatesAgreed way of workingVoice messages and occasional calls for requests, with follow-up emails on what changed. This is a habit, not a feature.

Decisions BOC still needs to make

DecisionWhat it unlocks
The approved Social Services subcategory listTurns on the selector and the subcategory report.
The 2027 budget, and whether $200,000 is still the right 2026 figureBudget tracking in the 2027 view, and an accurate 2026 comparison.
Who should have Committee accessCommittee members reading reports directly, the goal discussed for February 2027.
Invitation follow-up: who is notified, how often, and when it stopsAutomatic follow-up on unanswered invitations.
Microsoft Forms: whether to connect it, with a sample formApplications flowing in without an upload step.
How to define organization sizeSize comparisons in reports.

Not yet verified

Everything above comes from the sources listed below. These points could not be confirmed first-hand for this draft.

PointWhat is missing
Time per grant, share of grants missing documents, hours savedPlanning estimates from March 2026. The original workflow review was not opened and no measurement after launch was found.
February 4 decision and prototypesTaken from a later summary. The meeting record was not opened.
August 17 release contentsTaken from an internal status note. The release email was not opened.
DocumentsThe November 16 release record says access to three affected documents was rechecked. No new document was uploaded or read for this page, and a working address comparison was not seen. The one grant opened showed the comparison as unavailable.
Reporting assistant, downloads and remindersSeen on screen. No question was asked, no file was downloaded and no reminder was sent.
Email reaching Rich's inboxesWhether sign-in codes, invitations and reminders pass Rich's mail filtering was not tested. The exact sender address was not confirmed.
Budget of $200,000This is the setting in the tracker and the total in the March 9 workbook. Whether it is still the right 2026 figure was not confirmed.
PaymentsNo check-issued dates are recorded, so the tracker cannot say what has been paid. The completed stage count is not a payment total.
Who should have accessNine accounts and their roles were seen. Whether that list is right is for the team to confirm.
The 2027 viewThe option is in the year selector. The 2027 screens were not opened for this page.
Meetings on May 5, May 28 and July 8Transcripts exist and were not read for this draft. Emails come from copies saved in the project folder.
Builder creditLeft off this page until the credit line is confirmed.

Sources

SourceDateUsed for
Live trackerRead Nov 17, 2026All 2026 figures, stage counts and the features described as seen
2026 YTD Budget Breakdown and Status of 2026 BOC GrantsMar 9, 2026The starting data and the $200,000 budget total
State of BOC deckFeb 20252024 contributions by category
Orientation deck and requirements summaryMar 31, 2026The original workflow, roles and planning estimates
Emails with the BOC teamMar to Aug 2026Decisions, requests and the dates features arrived
Call transcript and written overviewNov 10 and 12, 2026The twelve November requests
Implementation record, release record and change history kept with the toolSep to Nov 2026What was built, tested and released, and when

The source documents are held in the project files and can be shared on request.