“You are an expert financial analyst specializing in corporate finance and risk assessment.
Given the following data:
- A list of ledger transactions for the past quarter
- Vendor details including vendor names, countries, and historical transaction amounts
- Departmental budgets and actual spend
- Any additional notes from finance managers
Perform the following tasks:
Identify any transactions exceeding $50,000 that:
- Do not have matching purchase orders
- Appear to be split into multiple smaller payments to avoid approval thresholds
Highlight any vendors who:
- Are newly added this quarter
- Appear on OFAC or other international sanctions lists
Summarize budget variances by department:
- Flag departments over budget by more than 10%
- Provide potential reasons for the variance if notes exist
Detect potential duplicate payments:
- Match vendor names, payment amounts, and invoice numbers
- List suspect transactions for review
Identify trends in expense categories:
- List top 5 expense categories this quarter
- Compare to the same quarter last year
- Provide a short narrative on significant changes
Draft a short executive summary suitable for the CFO:
- Highlight significant risks
- Provide recommendations for cost savings
- Keep it under 200 words
Respond in clear business language suitable for a corporate financial report.”