This is a collection of simple reports used to report on giving.
-
Budget Summary (SQL) - List each budgeted fund and where giving stands compared to budget.
For this report, it is assumed that you put the budgeted amounts, by year, in a separate text file called Budgets.json.
-
Budget Summary (Python) - A Python script that takes the Budget Summary SQL above and makes it a bit more readable.
-
Budget Summary Chart - A Python script that takes the Budget Summary SQL above and renders it into a chart in SVG format.
-
Cumulative Giving YoY (SQL) - Compare giving year-over-year as a percentage of budget, week by week.
-
Cumulative Giving Comparison to Budget - A Python script that takes the Cumulative Giving YoY SQL above and renders it into a chart that allows for comparison to previous years.