Payment Lifecycle Manager

Automates scheduled-to-pending-to-late payment state transitions daily via PostgreSQL and cron-like triggers.

Updated Aug 23, 2026
One-click install
npx skills add https://github.com/mariasebarespersona/Tum-AI --skill payment-lifecycle-manager
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: Payment Lifecycle Manager
Source: https://github.com/mariasebarespersona/Tum-AI/tree/main/packages/automations/docs/payment-lifecycle
Command: npx skills add https://github.com/mariasebarespersona/Tum-AI --skill payment-lifecycle-manager

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Automates the lifecycle of scheduled payments by updating states automatically (scheduled → pending → late) on a daily schedule, removing the need for manual status checks and reducing errors.

Core Features & Use Cases

  • Automated state transitions: scheduled to pending before due date, and pending to late after due date
  • Batch processing: updates all payments that meet the transition conditions in a single run
  • Configurable: supports required variables (DB_CONNECTION, STATUS_TRANSITIONS, CHECK_CRON) and optional TIMEZONE for precise date calculations

Quick Start

Configure the required environment variables and start the daily scheduler to automatically update payment states.

Frequently Asked Questions about Payment Lifecycle Manager

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I automate scheduled payment state transitions in PostgreSQL?

Automate scheduled payment state transitions by running a daily batch process against a PostgreSQL database that checks due dates and updates payment statuses from scheduled to pending and pending to late.

How do I configure a daily scheduler for batch processing payment lifecycle updates?

Configure batch processing of payment lifecycle updates by setting the required CHECK_CRON variable to define the daily schedule, DB_CONNECTION for the PostgreSQL backend, and STATUS_TRANSITIONS for the state mapping.

Can I specify a timezone for date calculations when automating payment status changes?

Yes, you can specify a timezone for date calculations during payment status changes by setting the optional TIMEZONE variable alongside the required DB_CONNECTION, STATUS_TRANSITIONS, and CHECK_CRON variables.

What is the best way to automatically move pending payments to a late status?

The best way to automatically move pending payments to a late status is using a daily scheduled batch process that evaluates due dates and applies state transitions to all qualifying records in a single run.

Does this batch processing approach require a specific database for payment lifecycle management?

Yes, this payment lifecycle management batch processing requires PostgreSQL as the backend database to store connection details and execute the scheduled state transition queries.

Why do I need to manually update scheduled payment statuses instead of using a daily scheduler?

You do not need to manually update scheduled payment statuses; a daily scheduler automates the lifecycle by applying batch state transitions from scheduled to pending and pending to late, reducing manual errors.