Weekly

List the bills to pay this week

Each Monday you get the unpaid supplier bills falling due in the next seven days.

Runs: Weekly
Apps: QuickBooks
AI: Not needed
Access: accounting (read)

Send this to your assistant

Create a ClickRuntime automation: every Monday at 8am, email me unpaid QuickBooks bills due in the next 7 days with vendor, 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

A bookkeeper or owner who pays vendors from QuickBooks needs to know which bills are coming due, but the Bills page shows everything unpaid and sorting by due date is manual. A bill for rent, a supplier with strict terms or a tax payment slips past, and the cost is a late fee, a strained relationship or a supplier putting your account on hold.

Every Monday, ClickRuntime queries QuickBooks for bills with an open balance whose due date falls in the next seven days and emails you the list. Each line shows the vendor, the due date and the amount still owed, and the total gives you the cash you need available for the week.

It is especially handy for owners who batch payments once a week and want one list to work from.

What you get out of it

Late fees are avoided
A bill noticed on Monday gets paid before its Friday due date. Missing even a few per year can cost more in penalties than the time it takes to read one email.
Vendor relationships stay healthy
Suppliers remember who pays on time. Reliable payment can mean better terms, early shipment priority and goodwill when you eventually need an extension on a larger order. Reputation with suppliers is built one payment at a time.
Cash needs are visible up front
The total at the bottom tells you how much will leave the account this week. That lets you move money or delay a purchase before a payment fails, instead of discovering the shortfall at the bank.
Payment day becomes one task
With the list in hand, you can sit down once and work through it. That is faster than opening each bill from the vendor center and deciding whether it is due soon enough to pay.
Only open balances appear
Bills with a zero balance are filtered out, so paid items do not clutter the list. What you read is the actual work for the week, with partially paid bills showing the remainder owed.

How it works

What happens, step by step

Once a week, ClickRuntime finds the unpaid bills in QuickBooks that are due in the next 7 days.
It sorts them by due date, soonest first.
You get an email listing each one with its due date, the vendor and the amount, so you can plan payments.

Before it runs live

Connect QuickBooks

What you get

RunsWeekly

List the bills to pay this weektoday, 9:00Succeeded

Email · Bills due this week- 2026-10-21 Contoso Hosting: $420.00 - 2026-10-24 Fabrikam Supplies: $1,180.00

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 QuickBooks 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_this_week_reminder.pyexample

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

REALM_ID = "1234567890"
API = f"https://quickbooks.api.intuit.com/v3/company/{REALM_ID}"

def qb(method, path, **kw):
    headers = {"Authorization": f"Bearer {credentials.connection('quickbooks', 'company')}", "Accept": "application/json"}
    resp = http.request(method, f"{API}{path}", headers=headers, params={"minorversion": 73, **kw.pop("params", {})}, **kw)
    resp.raise_for_status()
    return resp.json()

def query(sql):
    return qb("GET", "/query", params={"query": sql})["QueryResponse"]

@on_trigger
def run(event):
    until = (date.today() + timedelta(days=7)).isoformat()
    bills = query(f"select * from Bill where Balance > '0' and DueDate <= '{until}'").get("Bill", [])
    if not bills:
        return {"due": 0}
    lines = [f"- {b['DueDate']} {b['VendorRef']['name']}: ${b['Balance']:,.2f}"
             for b in sorted(bills, key=lambda b: b["DueDate"])]
    total = sum(b["Balance"] for b in bills)
    notify.email_me(f"{len(bills)} bills due this week, ${total:,.2f}", "\n".join(lines))
    return {"due": len(bills), "total": total}

FAQ

Common questions

Does it include bills that are already overdue?

The list covers bills due within the next seven days. Overdue bills have a due date in the past and are outside that window, so they would need a separate query. Many people add a section for overdue items so nothing is missed.

What does the email show for a partially paid bill?

The balance, not the original total. QuickBooks keeps a balance field on each bill, and only bills with a balance above zero are listed, so a bill half-paid on Friday appears with the amount still owed.

Do I need a particular QuickBooks plan?

Bills are available in QuickBooks Online Simple Start and above for entering and tracking, though pay-bill features and automated reminders vary by plan. The data is read through the QuickBooks API, which works for any company file you can connect.

What permissions does it need?

accounting (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