{ "today": "2026-11-09", "source": "examples/invoices.csv", "invoices": 6, "outstanding": 1369.83, "overdue_total": 1113.24, "overdue_count": 4, "by_reminder": { "friendly reminder": [ "INV-1055" ], "firm reminder": [ "INV-1052", "INV-1047" ], "final notice": [ "INV-1041" ] }, "list": [ { "invoice": "INV-1041", "client": "Marisol Ortega", "email": "marisol@example.com", "issued": "2026-08-28", "due": "2026-09-11", "subtotal": 359.5, "tax": 15.63, "total": 375.13, "paid": 0, "balance": 375.13, "days_overdue": 59, "days_until_due": 0, "status": "overdue", "reminder": "final notice", "lines": [ { "item": "Replace kitchen faucet (labor hours)", "qty": 2, "unit_price": 85, "amount": 170, "tax_rate": 0, "tax": 0 }, { "item": "Faucet and supply lines", "qty": 1, "unit_price": 189.5, "amount": 189.5, "tax_rate": 8.25, "tax": 15.63 } ] }, { "invoice": "INV-1052", "client": "Dev Patel", "email": "dev.patel@example.com", "issued": "2026-10-06", "due": "2026-10-20", "subtotal": 382.8, "tax": 3.53, "total": 386.33, "paid": 100, "balance": 286.33, "days_overdue": 20, "days_until_due": 0, "status": "overdue", "reminder": "firm reminder", "lines": [ { "item": "Patch and paint drywall (labor hours)", "qty": 4, "unit_price": 85, "amount": 340, "tax_rate": 0, "tax": 0 }, { "item": "Paint and patch supplies", "qty": 1, "unit_price": 42.8, "amount": 42.8, "tax_rate": 8.25, "tax": 3.53 } ] }, { "invoice": "INV-1047", "client": "Hollis Bakery", "email": "owner@hollisbakery.example", "issued": "2026-09-22", "due": "2026-10-22", "subtotal": 191.5, "tax": 5.28, "total": 196.78, "paid": 0, "balance": 196.78, "days_overdue": 18, "days_until_due": 0, "status": "overdue", "reminder": "firm reminder", "lines": [ { "item": "Fix walk-in cooler door hinge", "qty": 1.5, "unit_price": 85, "amount": 127.5, "tax_rate": 0, "tax": 0 }, { "item": "Heavy-duty hinge set", "qty": 1, "unit_price": 64, "amount": 64, "tax_rate": 8.25, "tax": 5.28 } ] }, { "invoice": "INV-1055", "client": "Greenway Dental", "email": "frontdesk@greenway.example", "issued": "2026-10-20", "due": "2026-11-04", "subtotal": 255, "tax": 0, "total": 255, "paid": 0, "balance": 255, "days_overdue": 5, "days_until_due": 0, "status": "overdue", "reminder": "friendly reminder", "lines": [ { "item": "Install 3 shelving units", "qty": 3, "unit_price": 85, "amount": 255, "tax_rate": 0, "tax": 0 } ] }, { "invoice": "INV-1060", "client": "Corner Lot Cafe", "email": "hello@cornerlot.example", "issued": "2026-11-03", "due": "2026-11-10", "subtotal": 249.99, "tax": 6.6, "total": 256.59, "paid": 0, "balance": 256.59, "days_overdue": 0, "days_until_due": 1, "status": "due soon", "reminder": "not due", "lines": [ { "item": "Mount TV and hide cables", "qty": 2, "unit_price": 85, "amount": 170, "tax_rate": 0, "tax": 0 }, { "item": "Wall mount bracket", "qty": 1, "unit_price": 79.99, "amount": 79.99, "tax_rate": 8.25, "tax": 6.6 } ] }, { "invoice": "INV-1058", "client": "June Albright", "email": "june.a@example.com", "issued": "2026-10-30", "due": "2026-11-13", "subtotal": 220, "tax": 0, "total": 220, "paid": 220, "balance": 0, "days_overdue": 0, "days_until_due": 4, "status": "paid", "reminder": "none", "lines": [ { "item": "Gutter cleaning", "qty": 1, "unit_price": 220, "amount": 220, "tax_rate": 0, "tax": 0 } ] } ] }