- Home
- Skills
- Finance & Accounting
- ouderdomsbalans-analyse
Works with the AI Agents you already use
Ouderdomsbalans Analyse
Automated Dutch accounts receivable aging analysis (ouderdomsbalans) with Python-driven bucket categorization.
$7
ouderdomsbalans-analyse
Example session with this skill installed
Maak een ouderdomsbalans van facturen.csv met peildatum 2026-06-10 en controleer de top 3 risico's.
- Read your context and instructions
- Compiled the ouderdomsbalans-analyse
Analyse voltooid op peildatum 2026-06-10.
Totaal openstaand: €142.500 (>90d: 31%).
Top 3 Risico's:
- Klant Janssen: €5.445 (>90d, factuur 2025-201)
- BVBA De Smet: €3.200 (61-90d)
- Firma Pieters: €1.150 (>90d)
Check 400-rekening aansluiting; adviseer bespreking waardevermindering voor Janssen.
Connects securely to your tools. The creator never sees your data.
About this skill
Automated Accounts Receivable Aging Analysis
This skill automates the creation of an "Ouderdomsbalans" (Aging Report), a critical task for accountants and financial controllers. It processes raw invoice exports to categorize outstanding balances into aging buckets, providing a clear overview of credit risk and liquidity.
What it does
The skill utilizes a Python-based processing engine to transform a CSV export containing customer names, invoice numbers, due dates, and amounts. It handles partial payments, credit notes, and net balance calculations per customer.
- Bucket Distribution: Categorizes receivables into Not Due, 1-30, 31-60, 61-90, and >90 days.
- Deep-Dive Reporting: Generates a specific detail block for items over 90 days, facilitating immediate action on bad debt.
- Reconciliation Flagging: Compares results against General Ledger (GL) balances to identify export discrepancies.
- Strategic Insights: Calculates the ">90-day percentage" and identifies top-risk customers to guide provision discussions.
Why use this skill?
Manual aging reports in Excel are prone to formula errors and struggle with credit note netting. This skill ensures a consistent, programmatic approach that is repeatable for every period-end closing. It transitions the accountant from data entry to data analysis, focusing on which debts are truly doubtful.
Built by Nex AI. More skills and info at nex-ai.be and slopsome.com.
Find more skills like this on the Claude Skills Marketplace, the Codex Skills Marketplace and the Gemini Skills Marketplace, or browse Claude Skills for Finance & Accounting.
- Cannot detect customer insolvency or disputes automatically.
- No multi-currency support (single currency per run).
- Requires strictly formatted CSV input for accuracy.
How to use
- 1
Connect your agent to the Agensi MCP
Copy the prompt and paste it into Claude, ChatGPT, Cursor or any agent that supports MCP. It sets up the connection for you. Manual setup
- 2
Sign in to Agensi
Your agent shows a sign-in link. Sign in and click Allow.
- 3
Ask for what you need
Your agent loads this skill and uses it on your task. It always asks before buying a skill.
Reviews
No reviews yet
Be one of the first to try it. Every listed skill goes through the trust checks below.
Security scanned
Checked by our 8-point scan before listing
Fresh listing
Recently published to Agensi
Money-back guarantee
Doesn't do what its page promises? You get your money back.
Trust & safety
Security scan
Security scan passed 3 months ago
Permissions
Terminal/Shell: the agent runs the bundled Python script (argparse CLI). Read/Write Files: the script reads user-supplied local input files (CSV/JSON) and writes the result to a user-specified path. No network access, no environment variables, no secrets.