Total given
$4,585
Tithes
$3,080
Designated funds
$675
Church Tithes and Offerings Tracker
Record tithes and offerings by family and fund, see each family’s giving by month and produce annual giving statement totals.
SpreadsheetClubs, Churches & Community GroupsFree
Track members, dues by membership type, renewal dates and who is paid, due soon, overdue or lapsed.
Shown with sample data
Track members, dues by membership type, renewal dates and who is paid, due soon, overdue or lapsed.
A treasurer-friendly membership list that knows when everyone renews. Set dues for each membership type once; for each member enter the last payment date and amount, and the sheet works out the renewal date, days left, any balance owed and a status of Paid, Partly paid, Due soon, Overdue or Lapsed. The Rates sheet totals expected and collected dues by type.
Record the date each member last paid. The renewal date is 12 months later; the tracker counts down the days and flags members due within 30 days or overdue.
Overdue means the renewal date has passed within the last 60 days: worth a friendly reminder. Lapsed means more than 60 days have passed; treat them as a former member to win back.
Yes. Change EDATE([lastPaid],12) to EDATE([lastPaid],1) in the Renewal date column and set the monthly amount on the Rates sheet.
Download a copy
Downloads need a free account.