Earmark designated giving ledger

Where the money actually is

Earmark is a designated-giving ledger. A gift is split across funds in integer cents, a redesignation moves it, and a refund comes back out of the funds that are really holding it. Nothing is stored as a running total, so nothing can drift away from the ledger that produced it.

Standing invariant: gifts outstanding $95005.99 == allocated across funds $95005.99 ✓. Checked on every page load against the tables themselves.

Funds

annual
$13278.59
Annual Fund
athletics
$17293.15
Athletics
scholarship
$21708.06
Chen Family Scholarship
restricted
unrestricted
$19727.99
Greatest Need
library
$22998.20
Library Acquisitions
restricted

Recent gifts

ReceivedDonorGiftRefunded Designated to
Aug 16 Hugo Bennett $2214.58 unrestricted $492.13, annual $492.13, library $1230.32 open
Jul 27 Dmitri Volkov $1410.51 scholarship $1410.51 open
Jun 17 Keiko Tanaka $7453.88 athletics $931.74, unrestricted $4658.67, annual $1863.47 open
Jun 17 Alice Warren $5624.52 library $2812.26, unrestricted $2812.26 open
Jun 16 Ingrid Salo $1491.78 scholarship $1491.78 open
Jun 9 Elena Marsh $3418.57 unrestricted $788.90, annual $1314.83, scholarship $1314.84 open
Jun 4 Clara Diaz $4682.06 $2746.37 athletics $276.53, unrestricted $553.05, scholarship $1106.11 open
May 9 Luis Fuentes $1731.06 scholarship $1731.06 open
May 9 Frank Ibarra $3905.71 scholarship $3905.71 open
May 8 Omar Haddad $6532.07 athletics $3266.03, unrestricted $3266.04 open
May 3 Grace Lin $3524.82 library $3524.82 open
Apr 30 Elena Marsh $5161.62 $1894.82 athletics $1088.93, library $725.96, scholarship $1451.91 open
Apr 23 Jonas Pike $3571.72 unrestricted $3571.72 open
Apr 23 Dmitri Volkov $5194.16 annual $5194.16 open
Apr 19 Omar Haddad $5686.23 scholarship $3249.27, library $2436.96 open
Apr 16 Marta Reyes $1521.33 annual $912.80, library $608.53 open
Apr 14 Hugo Bennett $1244.24 annual $710.99, library $533.25 open
Apr 5 Ingrid Salo $3155.90 scholarship $3155.90 open
Mar 27 Marta Reyes $422.92 library $120.84, athletics $151.04, unrestricted $151.04 open
Mar 26 Nils Berg $4355.72 library $1583.90, athletics $791.95, unrestricted $1979.87 open
Mar 16 Alice Warren $2902.28 library $2902.28 open
Mar 14 Ben Okafor $1646.19 $1101.54 athletics $226.94, scholarship $226.94, library $90.77 open
Mar 9 Jonas Pike $2868.38 scholarship $358.55, athletics $1792.74, unrestricted $717.09 open
Mar 7 Nils Berg $6659.08 athletics $4439.39, library $2219.69 open
Feb 17 Luis Fuentes $4650.35 annual $2790.21, library $1860.14 open