Weekly

Get a Monday list of bills falling due

You start the week knowing which supplier bills need paying in the next seven days.

Runs: Weekly
Apps: Xero
AI: Not needed
Access: accounting.transactions.read

Send this to your assistant

Create a ClickRuntime automation: each Monday at 8am, email me Xero bills due in the next 7 days with supplier, amount and due date.

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

Missing a supplier payment has real costs. A landlord adds a late fee, a software vendor suspends the account, and a key subcontractor gets paid last and stops returning calls. In Xero the bills are all recorded, but nobody opens the Bills to pay screen until the end of the month, and by then two of them are already overdue.

Each week, the automation queries Xero for bills, which are ACCPAY invoices, that fall due within the next seven days and emails you the list with supplier, amount and due date. It does not pay anything, it simply puts the upcoming obligations in front of you.

Owners who pay by hand and bookkeepers who prepare payment batches tend to schedule it for Monday morning. It is a plain list with no decisions made for you, which is exactly what many owners want.

What you get out of it

Late fees are avoided
Knowing on Monday that rent and a supplier bill are due Friday gives you time to move cash and pay, so penalties and interest are not part of your costs.
Supplier relationships stay healthy
Paying on time keeps credit terms and goodwill, which matters when you need a supplier to rush an order or extend a payment term. A reliable payer also gets priority when suppliers have limited stock or capacity.
Payment runs are planned
A weekly list of what is due lets you pay several bills in one session instead of reacting to each reminder email as it arrives. Grouping payments saves time and bank fees compared with paying in dribs and drabs.
Cash needs are known early
Adding up the week's bills shows how much cash must be in the account, which prevents the surprise of a payment that bounces. Knowing the total ahead of time helps you avoid a failed payment and the fees that follow.
The list matches your books
Because the reminder reads the bills recorded in Xero, it reflects what you actually entered, not a separate calendar someone has to keep updated. Your recorded bills are the single source, so nothing depends on a separate reminder list.

How it works

What happens, step by step

Every Monday ClickRuntime looks through your unpaid supplier bills in Xero.
It keeps the ones falling due in the next seven days.
You get an email listing each bill's due date, supplier and amount, soonest first.

Before it runs live

Connect Xero

What you get

RunsWeekly

Get a Monday list of bills falling duetoday, 9:00Succeeded

Email · Bills due this week2026-10-22 Acme Supplies: 1,140.00 2026-10-24 Northwind Logistics: 386.50

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 Xero 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.

bills_due_soon_reminder.pyexample

from datetime import date, timedelta
from clickruntime import on_trigger, credentials, http, notify

API = "https://api.xero.com/api.xro/2.0"

def xero_headers():
    token = credentials.connection("xero", "work")
    tenant = http.get("https://api.xero.com/connections", headers={"Authorization": f"Bearer {token}"}).json()[0]["tenantId"]
    return {"Authorization": f"Bearer {token}", "xero-tenant-id": tenant, "Accept": "application/json"}

@on_trigger
def run(event):
    end = date.today() + timedelta(days=7)
    where = f'Type=="ACCPAY" AND Status=="AUTHORISED" AND DueDate<=DateTime({end.year},{end.month},{end.day})'
    bills = http.get(f"{API}/Invoices", headers=xero_headers(), params={"where": where, "order": "DueDate"}).json()["Invoices"]
    lines = [f"{b['DueDateString'][:10]}  {b['Contact']['Name']}: {b['AmountDue']:,.2f}" for b in bills]
    if lines:
        notify.email_me(f"{len(lines)} Xero bills due this week", "\n".join(lines))
    return {"bills": len(lines)}

FAQ

Common questions

Does it include bills I have already paid?

No. Only bills still awaiting payment with a due date in the next seven days are listed. Once a bill is paid and marked in Xero, it drops off the list, so you are not reminded about settled invoices.

Can I extend the window beyond seven days?

Yes. The window is just a date range in the query, so you can set it to 14 days or to cover until the end of the month. Tell your AI assistant the range you want, then approve the updated version.

Will it flag bills that are already overdue?

The default looks forward from today. Overdue bills would need a second condition, which can be added so the email has a past-due section at the top. Many people include it so late bills are not forgotten.

What permissions does it need?

accounting.transactions.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.

On a schedule