How to Create Automated Invoice-from-Proposal Systems

This system automates invoice creation from approved proposals with zero data re-entry. The moment a proposal is approved, the invoice is ready to send.

What You Need Before Starting

• Python 3.8+
• Claude or GPT API key
• Jinja2 for templating
• weasyprint for PDF generation

Step 1: Define Your Data Model

Set up the structure for invoices records.

import json
import sqlite3
from datetime import datetime

def init_db():
    conn = sqlite3.connect("invoices.db")
    conn.execute("""CREATE TABLE IF NOT EXISTS invoices (
        id INTEGER PRIMARY KEY AUTOINCREMENT,
        deal_id TEXT, content TEXT, status TEXT DEFAULT 'draft',
        created_at TEXT, updated_at TEXT
    )""")
    conn.commit()
    return conn

Step 2: Pull CRM Context

Get deal and company data to populate your invoices.

def get_context(crm_client, deal_id):
    deal = crm_client.get_deal(deal_id)
    company = crm_client.get_company(deal["company_id"])
    return {
        "deal_name": deal["name"],
        "company": company["name"],
        "industry": company["industry"],
        "amount": deal["amount"],
        "notes": deal.get("notes", ""),
    }

Step 3: Generate Content with AI

Use Claude to create customized invoices content.

import anthropic

def generate_content(context):
    client = anthropic.Anthropic()
    message = client.messages.create(
        model="claude-sonnet-4-20250514", max_tokens=2000,
        messages=[{"role": "user",
            "content": f"Generate invoices content for {context['company']} in {context['industry']}.\nDeal value: ${context['amount']:,.0f}\nNotes: {context['notes']}"}]
    )
    return message.content[0].text

Step 4: Format and Export

Create a professional output document.

def export_document(content, context, output_dir):
    filename = f"{context['deal_name']}_{datetime.now().strftime('%Y%m%d')}.md"
    path = os.path.join(output_dir, filename)
    with open(path, "w") as f:
        f.write(f"# {context['company']}\n\n{content}")
    return path

Step 5: Track and Measure

Log every document and track conversion.

def log_document(conn, deal_id, path, status="draft"):
    conn.execute(
        "INSERT INTO invoices (deal_id, content, status, created_at, updated_at) VALUES (?, ?, ?, ?, ?)",
        (deal_id, path, status, datetime.now().isoformat(), datetime.now().isoformat()))
    conn.commit()

What to Build Next

Connect to your accounting system so invoices flow straight into your books.

Related Reading

• AI for Proposal and Document Creation - ai proposal document creation
• Setting Up Automated Invoice Reminders - automated invoice reminders guide
• Creating Automated Proposal Generation - automated proposal generation guide