billing-automation

name	billing-automation
description	Build automated billing systems for recurring payments, invoicing, subscription lifecycle, and dunning management. Use when implementing subscription billing, automating invoicing, or managing recurring payment systems.

Billing Automation

Master automated billing systems including recurring billing, invoice generation, dunning management, proration, and tax calculation.

When to Use This Skill

• Implementing SaaS subscription billing
• Automating invoice generation and delivery
• Managing failed payment recovery (dunning)
• Calculating prorated charges for plan changes
• Handling sales tax, VAT, and GST
• Processing usage-based billing
• Managing billing cycles and renewals

Core Concepts

1. Billing Cycles

Common Intervals:

• Monthly (most common for SaaS)
• Annual (discounted long-term)
• Quarterly
• Weekly
• Custom (usage-based, per-seat)

2. Subscription States

trial → active → past_due → canceled
              → paused → resumed

3. Dunning Management

Automated process to recover failed payments through:

• Retry schedules
• Customer notifications
• Grace periods
• Account restrictions

4. Proration

Adjusting charges when:

• Upgrading/downgrading mid-cycle
• Adding/removing seats
• Changing billing frequency

Quick Start

from billing import BillingEngine, Subscription

# Initialize billing engine
billing = BillingEngine()

# Create subscription
subscription = billing.create_subscription(
    customer_id="cus_123",
    plan_id="plan_pro_monthly",
    billing_cycle_anchor=datetime.now(),
    trial_days=14
)

# Process billing cycle
billing.process_billing_cycle(subscription.id)

Subscription Lifecycle Management

from datetime import datetime, timedelta
from enum import Enum

class SubscriptionStatus(Enum):
    TRIAL = "trial"
    ACTIVE = "active"
    PAST_DUE = "past_due"
    CANCELED = "canceled"
    PAUSED = "paused"

class Subscription:
    def __init__(self, customer_id, plan, billing_cycle_day=None):
        self.id = generate_id()
        self.customer_id = customer_id
        self.plan = plan
        self.status = SubscriptionStatus.TRIAL
        self.current_period_start = datetime.now()
        self.current_period_end = self.current_period_start + timedelta(days=plan.trial_days or 30)
        self.billing_cycle_day = billing_cycle_day or self.current_period_start.day
        self.trial_end = datetime.now() + timedelta(days=plan.trial_days) if plan.trial_days else None

    def start_trial(self, trial_days):
        """Start trial period."""
        self.status = SubscriptionStatus.TRIAL
        self.trial_end = datetime.now() + timedelta(days=trial_days)
        self.current_period_end = .trial_end

     ():
        
        .status = SubscriptionStatus.ACTIVE
        .current_period_start = datetime.now()
        .current_period_end = .calculate_next_billing_date()

     ():
        
        .status = SubscriptionStatus.PAST_DUE
        

     ():
        
         at_period_end:
            .cancel_at_period_end = 
            
        :
            .status = SubscriptionStatus.CANCELED
            .canceled_at = datetime.now()

     ():
        
         .plan.interval == :
             .current_period_start + timedelta(days=)
         .plan.interval == :
             .current_period_start + timedelta(days=)
         .plan.interval == :
             .current_period_start + timedelta(days=)

Billing Cycle Processing

class BillingEngine:
    def process_billing_cycle(self, subscription_id):
        """Process billing for a subscription."""
        subscription = self.get_subscription(subscription_id)

        # Check if billing is due
        if datetime.now() < subscription.current_period_end:
            return

        # Generate invoice
        invoice = self.generate_invoice(subscription)

        # Attempt payment
        payment_result = self.charge_customer(
            subscription.customer_id,
            invoice.total
        )

        if payment_result.success:
            # Payment successful
            invoice.mark_paid()
            subscription.advance_billing_period()
            self.send_invoice(invoice)
        else:
            # Payment failed
            subscription.mark_past_due()
            self.start_dunning_process(subscription, invoice)

    def generate_invoice(self, subscription):
        """Generate invoice for billing period."""
        invoice = Invoice(
            customer_id=subscription.customer_id,
            subscription_id=subscription.id,
            period_start=subscription.current_period_start,
            period_end=subscription.current_period_end
        )

        # Add subscription line item
        invoice.add_line_item(
            description=subscription.plan.name,
            amount=subscription.plan.amount,
            quantity=subscription.quantity or 1
        )

        # Add usage-based charges if applicable
        if subscription.has_usage_billing:
            usage_charges = self.calculate_usage_charges(subscription)
            invoice.add_line_item(
                description=,
                amount=usage_charges
            )

        
        tax = .calculate_tax(invoice.subtotal, subscription.customer)
        invoice.tax = tax

        invoice.finalize()
         invoice

     ():
        
        customer = .get_customer(customer_id)

        :
            
            charge = stripe.Charge.create(
                customer=customer.stripe_id,
                amount=(amount * ),  
                currency=
            )

             PaymentResult(success=, transaction_id=charge.)
         stripe.error.CardError  e:
             PaymentResult(success=, error=(e))

Dunning Management

class DunningManager:
    """Manage failed payment recovery."""

    def __init__(self):
        self.retry_schedule = [
            {'days': 3, 'email_template': 'payment_failed_first'},
            {'days': 7, 'email_template': 'payment_failed_reminder'},
            {'days': 14, 'email_template': 'payment_failed_final'}
        ]

    def start_dunning_process(self, subscription, invoice):
        """Start dunning process for failed payment."""
        dunning_attempt = DunningAttempt(
            subscription_id=subscription.id,
            invoice_id=invoice.id,
            attempt_number=1,
            next_retry=datetime.now() + timedelta(days=3)
        )

        # Send initial failure notification
        self.send_dunning_email(subscription, 'payment_failed_first')

        # Schedule retries
        self.schedule_retries(dunning_attempt)

    def retry_payment(self, dunning_attempt):
        """Retry failed payment."""
        subscription = self.get_subscription(dunning_attempt.subscription_id)
        invoice = self.get_invoice(dunning_attempt.invoice_id)

        # Attempt payment again
        result = self.charge_customer(subscription.customer_id, invoice.total)

         result.success:
            
            invoice.mark_paid()
            subscription.status = SubscriptionStatus.ACTIVE
            .send_dunning_email(subscription, )
            dunning_attempt.mark_resolved()
        :
            
            dunning_attempt.attempt_number += 

             dunning_attempt.attempt_number < (.retry_schedule):
                
                next_retry_config = .retry_schedule[dunning_attempt.attempt_number]
                dunning_attempt.next_retry = datetime.now() + timedelta(days=next_retry_config[])
                .send_dunning_email(subscription, next_retry_config[])
            :
                
                subscription.cancel(at_period_end=)
                .send_dunning_email(subscription, )

     ():
        
        customer = .get_customer(subscription.customer_id)

        email_content = .render_template(template, {
            : customer.name,
            : subscription.plan.amount,
            : 
        })

        send_email(
            to=customer.email,
            subject=email_content[],
            body=email_content[]
        )

Proration

class ProrationCalculator:
    """Calculate prorated charges for plan changes."""

    @staticmethod
    def calculate_proration(old_plan, new_plan, period_start, period_end, change_date):
        """Calculate proration for plan change."""
        # Days in current period
        total_days = (period_end - period_start).days

        # Days used on old plan
        days_used = (change_date - period_start).days

        # Days remaining on new plan
        days_remaining = (period_end - change_date).days

        # Calculate prorated amounts
        unused_amount = (old_plan.amount / total_days) * days_remaining
        new_plan_amount = (new_plan.amount / total_days) * days_remaining

        # Net charge/credit
        proration = new_plan_amount - unused_amount

        return {
            'old_plan_credit': -unused_amount,
            'new_plan_charge': new_plan_amount,
            'net_proration': proration,
            'days_used': days_used,
            'days_remaining': days_remaining
        }

    @staticmethod
    def calculate_seat_proration(current_seats, new_seats, price_per_seat, period_start, period_end, change_date):
        """Calculate proration for seat changes."""
        total_days = (period_end - period_start).days
        days_remaining = (period_end - change_date).days

        # Additional seats charge
        additional_seats = new_seats - current_seats
        prorated_amount = (additional_seats * price_per_seat / total_days) * days_remaining

        return {
            'additional_seats': additional_seats,
            'prorated_charge': max(0, prorated_amount),  # No refund for removing seats mid-cycle
            : change_date
        }

Tax Calculation

class TaxCalculator:
    """Calculate sales tax, VAT, GST."""

    def __init__(self):
        # Tax rates by region
        self.tax_rates = {
            'US_CA': 0.0725,  # California sales tax
            'US_NY': 0.04,    # New York sales tax
            'GB': 0.20,       # UK VAT
            'DE': 0.19,       # Germany VAT
            'FR': 0.20,       # France VAT
            'AU': 0.10,       # Australia GST
        }

    def calculate_tax(self, amount, customer):
        """Calculate applicable tax."""
        # Determine tax jurisdiction
        jurisdiction = self.get_tax_jurisdiction(customer)

        if not jurisdiction:
            return 0

        # Get tax rate
        tax_rate = self.tax_rates.get(jurisdiction, 0)

        # Calculate tax
        tax = amount * tax_rate

        return {
            'tax_amount': tax,
            'tax_rate': tax_rate,
            'jurisdiction': jurisdiction,
            'tax_type': self.get_tax_type(jurisdiction)
        }

     ():
        
         customer.country == :
            
             
         customer.country  [, , ]:
            
             customer.country
         customer.country == :
            
             
        :
             

     ():
        
         jurisdiction.startswith():
             
         jurisdiction  [, , ]:
             
         jurisdiction == :
             
         

     ():
        
        
        
        

Invoice Generation

class Invoice:
    def __init__(self, customer_id, subscription_id=None):
        self.id = generate_invoice_number()
        self.customer_id = customer_id
        self.subscription_id = subscription_id
        self.status = 'draft'
        self.line_items = []
        self.subtotal = 0
        self.tax = 0
        self.total = 0
        self.created_at = datetime.now()

    def add_line_item(self, description, amount, quantity=1):
        """Add line item to invoice."""
        line_item = {
            'description': description,
            'unit_amount': amount,
            'quantity': quantity,
            'total': amount * quantity
        }
        self.line_items.append(line_item)
        self.subtotal += line_item['total']

    def finalize(self):
        """Finalize invoice and calculate total."""
        self.total = self.subtotal + self.tax
        self.status = 'open'
        self.finalized_at = datetime.now()

    def ():
        
        .status = 
        .paid_at = datetime.now()

     ():
        
         reportlab.pdfgen  canvas

        
        
        

     ():
        
        template = 

         template.(
            invoice_number=.,
            date=.created_at.strftime(),
            customer_name=.customer.name,
            customer_address=.customer.address,
            line_items=.render_line_items(),
            subtotal=.subtotal,
            tax=.tax,
            total=.total
        )

Usage-Based Billing

class UsageBillingEngine:
    """Track and bill for usage."""

    def track_usage(self, customer_id, metric, quantity):
        """Track usage event."""
        UsageRecord.create(
            customer_id=customer_id,
            metric=metric,
            quantity=quantity,
            timestamp=datetime.now()
        )

    def calculate_usage_charges(self, subscription, period_start, period_end):
        """Calculate charges for usage in billing period."""
        usage_records = UsageRecord.get_for_period(
            subscription.customer_id,
            period_start,
            period_end
        )

        total_usage = sum(record.quantity for record in usage_records)

        # Tiered pricing
        if subscription.plan.pricing_model == 'tiered':
            charge = self.calculate_tiered_pricing(total_usage, subscription.plan.tiers)
        # Per-unit pricing
        elif subscription.plan.pricing_model == 'per_unit':
            charge = total_usage * subscription.plan.unit_price
        # Volume pricing
        elif subscription.plan.pricing_model == 'volume':
            charge = self.calculate_volume_pricing(total_usage, subscription.plan.tiers)

        return charge

    def calculate_tiered_pricing(self, total_usage, tiers):
        """Calculate cost using tiered pricing."""
        charge = 0
        remaining = total_usage

        for tier in sorted(tiers, key=lambda x: x['up_to']):
            tier_usage = (remaining, tier[] - tier[])
            charge += tier_usage * tier[]
            remaining -= tier_usage

             remaining <= :
                

         charge

Resources

• references/billing-cycles.md: Billing cycle management
• references/dunning-management.md: Failed payment recovery
• references/proration.md: Prorated charge calculations
• references/tax-calculation.md: Tax/VAT/GST handling
• references/invoice-lifecycle.md: Invoice state management
• assets/billing-state-machine.yaml: Billing workflow
• assets/invoice-template.html: Invoice templates
• assets/dunning-policy.yaml: Dunning configuration

Best Practices

1. Automate Everything: Minimize manual intervention
2. Clear Communication: Notify customers of billing events
3. Flexible Retry Logic: Balance recovery with customer experience
4. Accurate Proration: Fair calculation for plan changes
5. Tax Compliance: Calculate correct tax for jurisdiction
6. Audit Trail: Log all billing events
7. Graceful Degradation: Handle edge cases without breaking

Common Pitfalls

• Incorrect Proration: Not accounting for partial periods
• Missing Tax: Forgetting to add tax to invoices
• Aggressive Dunning: Canceling too quickly
• No Notifications: Not informing customers of failures
• Hardcoded Cycles: Not supporting custom billing dates