Most agencies track monthly recurring revenue in a spreadsheet that someone updates manually after each payment confirmation. It is always slightly out of date, reconciliation takes an hour each month, and the number is wrong at least occasionally. Airtable with Make.com connected to Stripe eliminates the manual step entirely — MRR is always current, always accurate, and requires zero effort to maintain.
The Airtable MRR Structure
MRR tracking in Airtable requires three linked tables: Clients (each with a Monthly Retainer field), Invoices (each linked to a client with amount, due date, and payment status), and a Summary view that rolls up MRR from the Clients table. Airtable's Rollup field type can sum the Monthly Retainer across all Active client records, updating automatically when any client record changes status. This gives you live MRR, ARR, and pipeline at a glance in the Clients table.
Stripe Webhooks Write Payment Status Back to Airtable
When a Stripe payment is received, Make.com fires a webhook handler that finds the corresponding invoice in Airtable by Stripe Invoice ID and updates its status to Paid with the payment timestamp. This keeps the Invoices table accurate in real time — the MRR rollup reflects only actually-paid retainers, not just billed amounts. Churn is tracked automatically when a client's status is changed to Paused or Churned, immediately removing them from the active MRR calculation. The Softr portal reflects payment status for each client instantly. The full billing and MRR stack is demonstrated at omnionlinestrategies.com/client-portal-demo.