How to Track Membership Dues & Recurring Payments Collected via Jotform

Membership organizers get a submission count, not a dues ledger. How to total dues by tier, tell renewals from new members, and see who has paid this period — from your Jotform data.

A dues form gives you a submission count, not a dues ledger. To run the numbers a membership organizer actually needs: total dues by tier (group the amount field by the tier field), tell renewals from new members by matching on email, and see who has paid this period by matching your roster against submissions. It’s a monthly spreadsheet exercise — or a live view a reader computes from the form.

Membership organizations — clubs, associations, alumni groups, HOAs — collect dues through Jotform because it’s quick to set up. The gap is that Jotform is built to capturepayments, not to answer “how are dues tracking this year and who still owes?” Here’s how to close that gap.

1. Dues by tier, not one lump total

If members pick a tier (Individual, Family, Patron, Student), a single total hides your mix. Group the dues amount by the tier field so you see revenue and headcount per tier. Two cleanups first: strip $ and commas so the amount sums as a number, and remove test submissions. See the exact grouping math if you’re doing it by hand.

2. Renewals vs. new members

This is the number boards care about — retention. Match on member email: a first-time email is a new member; an email seen in a prior period is a renewal. If your form asks “new or renewing?”, use it as a cross-check, but let email be the source of truth — typed names drift (“Bob” vs. “Robert”) and split one member into two.

3. Who has paid this period — and who hasn’t

The outstanding-dues question needs two lists: your member roster and this period’s Jotform dues submissions, matched by email. Members with a submission have paid; members without one are outstanding and ready for a reminder. In a spreadsheet this is a lookup between the two tabs; the key is a shared, clean email column on both sides.

4. Track the trend across periods

Group dues submissions by month or renewal period to see whether collections are pacing ahead of or behind last year. A count of members isn’t a trend — dated dollars are. Watch the timezone on the submission date so a payment near midnight doesn’t land in the wrong month.

Turning this into a standing view

Done by hand, this is a recurring build: export, clean, group by tier, dedupe by email, reconcile against the roster. TutuMargin connects to your Jotform read-only and computes dues by tier, total collected, monthly trend, and new-vs-renewing members the moment it reads your submissions — and you can ask it plain-English questions (“Patron dues collected this quarter”) and get the chart.

See the dues view on live sample data — no signup ▸

Your member data stays in your browser, it’s free for the first ~10 questions, then $19/mo — light enough for a volunteer-run organization, and you can try it before committing.

Frequently asked questions

How do I total membership dues collected through Jotform?

Sum the dues-amount field across submissions after cleaning it to plain numbers and removing test rows. If members choose a tier (e.g. Individual, Family, Patron), group by the tier field and sum within each group so you see dues by tier, not just one lump total.

How can I tell renewals from new members in Jotform?

Match on the member's email. An email appearing for the first time is a new member; an email that appeared in a prior period is a renewal. If your form has a 'new or renewing' question, use that too — but email matching is the reliable backstop, since names get typed inconsistently.

How do I see who has paid dues this period and who hasn't?

You need your member roster on one side and the Jotform dues submissions on the other, matched by email. Members with a submission in the current period have paid; members without one are outstanding. In a spreadsheet this is a lookup between roster and submissions; a tool that reads the form can flag paid-vs-outstanding for you if you provide the roster.

Does Jotform handle truly recurring (auto-charging) dues?

Jotform can collect recurring payments through its payment integrations, but the form records each payment as it comes in — it isn't a membership CRM. For reporting, treat each dues payment as a dated row keyed by member email, then total by period and tier. That gives you a clean dues ledger regardless of whether charges are manual or automatic.