Btw Klantenlisting
by Nex AI
Automates aggregation and threshold filtering for the annual Belgian VAT client listing from sales journals.
- Aggregate annual sales per BE VAT number automatically
- Filter clients based on the official reporting threshold (e.g., €250)
- Validate Belgian VAT number formats and normalize data entry errors
$19
· or 95 creditsSecure checkout via Stripe
Included in download
- Aggregate annual sales per BE VAT number automatically
- Filter clients based on the official reporting threshold (e.g., €250)
- terminal, file_read, file_write automation included
Sample input
Check dit verkoopdagboek van 2023 en bereid de btw-klantenlisting voor met de standaard drempel van 250 euro.
Sample output
Klaar! De listing bevat 42 klanten boven de drempel van €250.
- Totaal bedrag (excl. BTW): €145.200,50
- 12 klanten onder drempel (genegeerd)
- 3 buitenlandse BTW-nummers gedetecteerd (zie log voor ICP)
- 5 records zonder BTW-nummer (particulieren) verwerkt. Hier is je listing.csv.
Btw Klantenlisting
by Nex AI
Automates aggregation and threshold filtering for the annual Belgian VAT client listing from sales journals.
$19
· or 95 creditsSecure checkout via Stripe
Included in download
- Aggregate annual sales per BE VAT number automatically
- Filter clients based on the official reporting threshold (e.g., €250)
- terminal, file_read, file_write automation included
- Instant install
Sample input
Check dit verkoopdagboek van 2023 en bereid de btw-klantenlisting voor met de standaard drempel van 250 euro.
Sample output
Klaar! De listing bevat 42 klanten boven de drempel van €250.
- Totaal bedrag (excl. BTW): €145.200,50
- 12 klanten onder drempel (genegeerd)
- 3 buitenlandse BTW-nummers gedetecteerd (zie log voor ICP)
- 5 records zonder BTW-nummer (particulieren) verwerkt. Hier is je listing.csv.
About This Skill
Automated Client Listing for Belgian VAT
This skill automates the tedious preparation of the annual Belgian "btw-klantenlisting" (client listing). Instead of manually wrestling with pivot tables and spreadsheet formulas to aggregate sales data, this tool provides an automated Python-driven workflow to process sales journals into submission-ready summaries.
What it does
- Aggregates total turnover per Belgian VAT number from export files.
- Applies the regulatory threshold (default €250) to filter reportable clients.
- Standardizes VAT number formatting by stripping spaces and dots to prevent duplicate entries.
- Identifies and flags non-BE VAT numbers for separate Intra-Community Listing (ICP) checks.
- Calculates net totals by automatically accounting for credit notes within the ledger.
Why use this skill
Manual preparation is prone to errors, especially with VAT number variations and threshold calculations. This skill ensures consistency by using a programmatic approach. It doesn't just filter data; it validates formats and signals anomalies—like domestic B2B sales missing a VAT number—allowing accountants to focus on review and filing via Intervat rather than data entry.
Output
The skill generates a structured CSV output and a summary report highlighting total reportable turnover, excluded private sales, and any international VAT numbers detected for further action.
Use Cases
- Aggregate annual sales per BE VAT number automatically
- Filter clients based on the official reporting threshold (e.g., €250)
- Validate Belgian VAT number formats and normalize data entry errors
- Separate intra-community (ICP) transactions from domestic listings
- Reconcile sales journals with credit notes for accurate annual totals
Known Limitations
- Requires CSV input with specific columns.
- Does not submit directly to Intervat.
- Manual verification of tax year thresholds required.
How to Install
mkdir -p ~/.claude/skills && curl -sL https://www.agensi.io/api/install/btw-klantenlisting -o /tmp/btw-klantenlisting.zip && unzip -o /tmp/btw-klantenlisting.zip -d ~/.claude/skills && rm /tmp/btw-klantenlisting.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
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.
Multi-Agent Orchestration Master Library
Transform Claude Code into a coordinated multi-agent system. Battle-tested tmux orchestration patterns, YAML task queues, event-driven communication, and parallel worker management for 8+ agents.