ouderdomsbalans-analyse
by Nex AI
Automated Dutch accounts receivable aging analysis (ouderdomsbalans) with Python-driven bucket categorization.
- Generate an aging report for period-end closing and GL reconciliation
- Identify overdue customers for debt collection and dunning actions
- Calculate the percentage of debt >90 days for bad debt provisioning
$19
· or 95 creditsSecure checkout via Stripe
Included in download
- Generate an aging report for period-end closing and GL reconciliation
- Identify overdue customers for debt collection and dunning actions
- terminal, file_read, file_write automation included
Sample input
Maak een ouderdomsbalans van facturen.csv met peildatum 2026-06-10 en controleer de top 3 risico's.
Sample output
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.
ouderdomsbalans-analyse
by Nex AI
Automated Dutch accounts receivable aging analysis (ouderdomsbalans) with Python-driven bucket categorization.
$19
· or 95 creditsSecure checkout via Stripe
Included in download
- Generate an aging report for period-end closing and GL reconciliation
- Identify overdue customers for debt collection and dunning actions
- terminal, file_read, file_write automation included
- Instant install
Sample input
Maak een ouderdomsbalans van facturen.csv met peildatum 2026-06-10 en controleer de top 3 risico's.
Sample output
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.
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.
Use Cases
- Generate an aging report for period-end closing and GL reconciliation
- Identify overdue customers for debt collection and dunning actions
- Calculate the percentage of debt >90 days for bad debt provisioning
- Automate the netting of credit notes against outstanding customer balances
Known Limitations
- Cannot detect customer insolvency or disputes automatically.
- No multi-currency support (single currency per run).
- Requires strictly formatted CSV input for accuracy.
How to Install
mkdir -p ~/.claude/skills && curl -sL https://www.agensi.io/api/install/ouderdomsbalans-analyse -o /tmp/ouderdomsbalans-analyse.zip && unzip -o /tmp/ouderdomsbalans-analyse.zip -d ~/.claude/skills && rm /tmp/ouderdomsbalans-analyse.zipFree skills install directly. Paid skills require purchase - use the download button above after buying.
Reviews
No reviews yet - be the first to share your experience.
Only users who have downloaded or purchased this skill can leave a review.
Early access skill
Be the first to review this skill.
Only users who have downloaded or purchased this skill can leave a review.
Security Scanned
Passed automated security review
Permissions
File Scopes
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.
Compatible with SKILL.md-compatible agents including Claude Code and Cursor.
Creator
Founder of Nex AI. I build production-grade Claude Skills from systems that actually run: multi-tenant SaaS, Telegram agents, Raspberry Pi infrastructure, 3D multiplayer rooms. Every skill ships battle-tested patterns, not theory. 33+ open source skills published, commercial catalog growing.
Frequently Asked Questions
Learn More About AI Agent Skills
More Premium Skills
local-seo-audit
Automated local SEO auditing and keyword generation for agencies and small businesses.
designing-hybrid-context-layers
Architects the right retrieval strategy for every query — teaching your agent when to use RAG, a knowledge graph, or a temporal index instead of defaulting to vector search for everything.
ai-automation-qa-pack
Professional QA & UAT documentation generator for AI automation agencies and complex agent deployments.
Bounty Security Pattern Master Library — 399 Vulnerability Patterns
A premium library of 399 vulnerability patterns and DeFi attack vectors for AI-driven bug hunting and security audits.