AP Aging Report Interpreter

Les responsables comptes fournisseurs, contrôleurs et DAF utilisent ce prompt en fin de mois ou en période de tension de trésorerie pour comprendre leur situation en matière de dettes, prioriser les paiements, et détecter les risques de concentration fournisseurs.

You are a cash flow specialist and accounts payable analyst with expertise in [INDUSTRY] businesses. I will provide you with our accounts payable aging report as of [REPORT DATE] in [CURRENCY]. Our current cash position is [CASH BALANCE] and our average monthly outflow is approximately [MONTHLY OUTFLOW].

AP Aging Report:
[AP AGING DATA]

Perform a comprehensive analysis of this AP aging report covering the following areas:

1. **Aging Summary & DPO Calculation**
   - Summarize total AP balance by aging bucket (current, 1–30 days, 31–60 days, 61–90 days, 90+ days)
   - Calculate Days Payable Outstanding (DPO) using the formula: (Total AP / Total Purchases) × Days in Period
   - Compare our DPO to the [INDUSTRY] industry benchmark and assess if we are paying too fast or too slow

2. **Overdue Items Analysis**
   - List all invoices past their due date, sorted by oldest first
   - For each overdue item: flag the risk (late fees, strained vendor relationship, service disruption, credit hold)
   - Identify invoices where we may have already missed early-payment discounts

3. **Vendor Concentration Risk**
   - Calculate what percentage of total AP is owed to the top 3 and top 5 vendors
   - Flag any single vendor that represents more than 20% of total AP (concentration risk)
   - Identify vendors where outstanding balance has grown significantly, suggesting invoice approval backlogs

4. **Payment Prioritization Recommendations**
   - Tier vendors into three payment priority groups:
     - Priority 1: Critical vendors (utilities, key suppliers, those with late fees accruing)
     - Priority 2: Standard payables (within terms, no immediate risk)
     - Priority 3: Deferrable items (long-term vendors with flexibility, or disputed invoices)
   - Given our cash position of [CASH BALANCE], recommend an immediate payment run amount and timing

5. **Red Flags**
   - Duplicate invoice amounts from the same vendor
   - Invoices held for more than 90 days (investigate for disputes or approvals stuck in queue)
   - Unusual vendors or amounts that warrant verification

Present findings in a structured report with a summary dashboard table followed by detailed sections.

Variables du Prompt

Remplacez chaque placeholder par vos informations spécifiques :

Ce que vous obtiendrez

Un rapport structuré avec un tableau de synthèse des échéances, le calcul du DPO avec comparaison sectorielle, la liste des éléments en retard avec signaux de risque, l'analyse de concentration fournisseurs, et un calendrier de paiement prioritaire en trois niveaux.

💡 Conseil d'Expert

Incluez les conditions de paiement de chaque grand fournisseur dans les données (ex. Net 30, Net 60) — cela permet à l'IA de calculer précisément quelles factures sont réellement en retard versus simplement anciennes en raison de délais longs.

Outils IA Compatibles

Ressources Associées