Weekly

See overdue invoices every week

Each Monday you get open invoices past their due date, oldest first.

Runs: Weekly
Apps: Stripe
AI: Not needed
Access: read

Send this to your assistant

Create a ClickRuntime automation: every Monday at 8am, email me all open Stripe invoices past their due date with the customer, amount and days overdue, oldest first.

Paste it into your assistant. It tells you what it will send or change before it runs live.

Add to ChatGPT Add to Claude

First time? Adding ClickRuntime to your assistant takes about two minutes.

Why use it

Why teams use this automation

An agency invoices clients on net-30 terms and then forgets about them. Some pay on time, some a few days late, and a few drift to 60 or 90 days because nobody chased. Stripe shows each open invoice but nothing pulls the late ones together, so the owner discovers on the 28th that 9,000 dollars is outstanding and the payroll account looks thin.

Every week, ClickRuntime lists open invoices in Stripe, keeps the ones whose due_date has passed, sorts them with the oldest first and emails you the list with customer, amount and days overdue. It gives you a single page to work through on Monday morning, starting with the accounts that matter most.

It suits businesses that bill by invoice rather than automatic card charge, where collecting is a manual task.

What you get out of it

Late payments get chased in order
Oldest first puts the most urgent accounts at the top. You start with the 75-day-old invoice rather than the one that went overdue yesterday, which is how collections work best, and is what most credit control routines recommend.
Cash flow surprises shrink
Seeing the total outstanding every week lets you predict what will arrive this month. You can decide whether to delay a purchase or ask a client for a deposit before a gap appears in the account balance.
Small amounts stop slipping away
Invoices of a few hundred dollars are the ones most likely to be forgotten, and they add up. A weekly list keeps them in view, so those amounts are collected instead of written off after a year.
Client relationships stay professional
A short, polite reminder sent on day five lands very differently from an angry email on day ninety. Regular visibility lets you chase early and in a friendly tone, which protects the relationship while still getting paid.
Bad debt gets spotted before it is too late
An account that appears on the list week after week becomes a clear signal. You can pause new work, call the client or escalate while there is still leverage, rather than after the company has stopped responding.

How it works

What happens, step by step

Every Monday, ClickRuntime lists your open Stripe invoices.
It keeps the ones that are past their due date and sorts them oldest first.
You get an email with each invoice's days overdue, customer, amount and link, plus the total.

Before it runs live

Connect Stripe

What you get

RunsWeekly

See overdue invoices every weektoday, 9:00Succeeded

Email · 5 overdue invoices ($3,940.00) 41 days Northwind Traders 1,200.00 USD https://invoice.stripe.com/i/…

Build your own

Need it to work differently?

This template is a starting point. Copy the prompt and change it, or describe a different automation from scratch, with your own conditions, more apps or an AI step. Your assistant writes it, tests it and runs it on ClickRuntime.

Your own rules
Conditions, thresholds, filters and exceptions, written the way you'd explain them to a colleague.
Any number of apps
One automation can read from one app and update several others. Over 248 apps are ready, and anything with an API works too.
AI where it helps
Summaries, classification, extraction and drafts use ClickRuntime's built-in AI, with no extra key.
On a schedule or on each event
Runs as often as every 5 minutes, or the moment an app sends an event, and keeps track of what it already handled.

Changes you can ask for

Run it at a different time, more or less often, or only on weekdays
Add an AI step, for example to summarize, sort or draft a reply
Add another app, for example also send it to Slack
Combine it with other Stripe steps into one automation

Under the hood

The code that runs this automation

This is the Python script that runs each time the automation starts. Your AI assistant writes it for you when you send the prompt, and you allow each step in your assistant. To change how the automation works, describe the change to your assistant and it updates the script for you. For every function it can use, see the script reference.

overdue_invoice_digest.pyexample

import time
import stripe
from clickruntime import on_trigger, credentials, notify

@on_trigger
def run(event):
    stripe.api_key = credentials.secret("STRIPE_API_KEY")
    now = time.time()
    overdue = [i for i in stripe.Invoice.list(status="open", limit=100).auto_paging_iter()
               if i.due_date and i.due_date < now]
    if not overdue:
        return {"overdue": 0}
    overdue.sort(key=lambda i: i.due_date)
    lines = [f"{int((now - i.due_date) // 86400):>3} days  {i.customer_name or i.customer_email}  "
             f"{i.amount_remaining / 100:,.2f} {i.currency.upper()}  {i.hosted_invoice_url}" for i in overdue]
    total = sum(i.amount_remaining for i in overdue) / 100
    notify.email_me(f"{len(overdue)} overdue invoices (${total:,.2f})", "\n".join(lines))
    return {"overdue": len(overdue)}

FAQ

Common questions

Does it include invoices that are still within their payment terms?

No. Only open invoices whose due_date is earlier than the moment the report runs are included. An invoice due next Friday will not appear until it passes that date, which keeps the list focused on money that is actually late.

What about invoices set to charge automatically?

Invoices collected by automatic card charge usually fail through the payment failure flow instead. This digest lists any open invoice past due, so it can include those that are retrying, and you can filter to send_invoice collection if you want only manually paid ones.

Can the email show the customer's contact details?

Yes. Stripe holds the customer's email and name, and the digest can include them next to each invoice, along with the hosted invoice link. That way you can click through and send a reminder immediately without searching for the contact.

What permissions does it need?

read. Nothing else in your accounts is used.

Does it need AI?

No. It runs without AI, so it doesn't use your plan's AI allowance.

How many runs does it use?

One run each time it runs (weekly). Checks that find nothing to do and stop right away aren't counted.

Can I change how it works?

Yes. Describe the change to your AI assistant, for example a different schedule, channel or filter. It updates the automation, tests it and tells you what changed.

Daily