# nutrisaas_xero_sync.py # Sync automático Stripe → Xero para NutriSaaS Pro from xero_client import XeroClient from xero_auth import get_valid_token, get_tenant_id from datetime import datetime client = XeroClient() # 1. Webhook Stripe → factura Xero def on_stripe_payment(event): p = event["data"]["object"] contact = upsert_contact( name=p["metadata"]["clinic_name"], email=p["receipt_email"], is_customer=True, ) invoice = create_invoice( contact_name=contact["Name"], line_items=[{ "description": "NutriSaaS Pro · Plan Professional", "quantity": 1, "unitAmount": p["amount"] / 100, "accountCode": "200", }], due_date=today(), currency="EUR", ) mark_invoice_paid( invoice["InvoiceID"], amount=p["amount"] / 100, ) print(f"✓ {invoice['InvoiceNumber']} sincronizada") # 2. Importar extracto bancario (CSV Openbank) def import_bank_csv(csv_path, account_id): import csv transactions = [] with open(csv_path) as f: for row in csv.DictReader(f): transactions.append({ "date": row["fecha"], "contact": row["concepto"], "amount": float(row["importe"]), "description": row["concepto"], "account_code": "400", }) bulk_import_transactions(account_id, transactions) # 3. Generar P&L y notificar al CFO def monthly_pnl_email(year, month): pnl = get_profit_and_loss( f"{year}-{month:02d}-01", f"{year}-{month:02d}-31", ) send_email( to="cfo@nutrisaas.pro", subject=f"P&L {month}/{year}", body=format_pnl(pnl["summary"]), )