Connectors

/

Rillet

/

Find Rillet bills due with no TickTick task
Report
Cross-Connector

Find Rillet bills due with no TickTick reminder

For finance teams who want to ask their AI assistant which unpaid Rillet bills due soon have no task in TickTick.

Try PopdockAI free
Get a live demo
Find Rillet bills due with no TickTick task
Which unpaid Rillet bills due in the next 14 days have no reminder task in TickTick?
2 of the 6 bills due in the next 14 days have no TickTick task. - EXP-3021, Contoso Supplies: due 29 Oct, no task - EXP-3034, Fabrikam Cloud: due 3 Nov, no task - Flagged: EXP-3040, task due 12 Nov, after the bill due date of 8 Nov Want the matched bills listed with their tasks?
Rillet
Sample figures. Your results come from your own account.
rillet-get-bills
rillet-get-vendors
ticktick-get-tasks

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Rillet

Rillet
Run it on your own Rillet data.

Connect Rillet, pick your AI tool and paste the prompt.

Try PopdockAI free

The problem

Bills fall due with no reminder to pay them

Finance staff keep payment reminders in TickTick, separate from the Rillet ledger. When a bill falls due with no reminder, nothing prompts anyone to pay it, and the miss shows up as a late payment.

Without PopdockAI

  • List unpaid Rillet bills due soon
  • Search TickTick for a task for each one
  • Check whether each task is due in time
  • Find the gap after the vendor chases you

With PopdockAI

  • Unpaid bills due in your window read from Rillet, with vendors named
  • Open TickTick tasks searched by expense number or vendor name
  • Unmatched bills listed first, soonest due first
  • Tasks due after the bill flagged, and nothing changed

The prompt

Use this prompt

Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.

Prompt
**Objective:** Report Rillet bills due within the next {days-ahead} days (default 14) that have no open TickTick task referring to them. Read-only.

**Step 1: Read the bills (Rillet)**

Call `rillet-get-bills` with `due-date.from` set to today and `due-date.to` set to today plus {days-ahead} days. Ignore bills whose `status` shows paid or void. Keep `bill-id`, `expense-number`, `vendor-id`, `due-date`.

**Step 2: Name the vendors (Rillet)**

Call `rillet-get-vendors` and map each `vendor-id` to the vendor `name`.

**Step 3: Look for tasks (TickTick)**

Call `ticktick-get-tasks` for open tasks, with `project-name` = {project-name} if given. Match a task to a bill when its `title` contains the bill's `expense-number` or the vendor name, case-insensitive.

**Step 4: Report**

A table of bills: expense number, vendor, due date, matched task title and task `due-date` (or "no task"). List unmatched bills first, soonest due first. Flag matched tasks whose due date is later than the bill due date.

**Rules & Guidelines:**

* `ticktick-*` tools are on the TickTick MCP server; `rillet-*` tools are on the Rillet MCP server. Both servers must be connected.
* Do NOT call any write tool on either server, including `ticktick-add-task`, `ticktick-update-task`, `ticktick-batch-tasks`, `rillet-add-bill`, `rillet-update-bill` or `rillet-add-bill-payment`.

**Validation:**

* If `rillet-get-bills` returns nothing, say no bills are due in the window and stop.
* If task matching is ambiguous, list the candidate tasks instead of choosing one.

Who it's for

One answer, three teams that use it

Accounts payable

Never miss a payment date

See which bills have no reminder before they fall due, soonest first.

Which Rillet bills due in the next 7 days are not in my TickTick Payments project?

Finance managers

Check the team's payment tasks are complete

Spot bills that nobody has a task for, and tasks scheduled after the bill is due.

Check unpaid Rillet bills due this month against open TickTick tasks and flag late ones.

Small business owners

Keep bills and to-dos in step

Your task list and your ledger agree, so nothing due slips past while you work.

Do I have a TickTick task for every Rillet bill due in the next two weeks, like the Contoso one?

How it works

What PopdockAI does when you ask

You give a window, and optionally a TickTick project, and your AI assistant checks every bill due against your open tasks. It only reads, and it lists candidates when a match is unclear.

01

Ask

You give a window in days and, if you like, a TickTick project.

Your AI tool

02

Read

It lists unpaid Rillet bills due in that window and names each vendor.

rillet-get-bills
rillet-get-vendors

03

Match

It searches open TickTick tasks by expense number or vendor name.

ticktick-get-tasks

04

Report

It shows unmatched bills first, and flags tasks due after the bill.

Your AI tool

What PopdockAI provides

The tools behind the answer

Ready made tools for Rillet and one secure connection to your AI tool. No code, no exports.

get-data

rillet-get-bills

Returns vendor bills (expense number, vendor, dates, status) from Rillet.
get-data

rillet-get-vendors

Returns vendors (name, contact, address, payment terms, 1099 status) from Rillet.
get-data

ticktick-get-tasks

Returns open TickTick tasks with their project, due date, priority, status, assignee and tags. Filter by project, due date range or status.
Read only.Nothing in Rillet Changes

This report is built from Get data tools only. PopdockAI applies the row, field and parameter rules your admin sets, and every query is written to the audit trail.

How Popdock AI secures your data

The outcome

A reminder for every bill falling due

Try PopdockAI free
Get a live demo

Related use cases

More ways to put this data to work

All Ramp use cases

One prompt template with infinite possibilities.

‍

Your AI assistant adapts its approach, tone, and capabilities to match each unique context while you maintain a single, manageable workflow.

Join forward-thinking companies that are transforming their operations with intelligent, secure AI automation.

Try PopdockAI Free
See Documentation