- Home
- Skills
- Finance & Accounting
- btw-klantenlisting
Works with the AI Agents you already use
Btw Klantenlisting
Automates aggregation and threshold filtering for the annual Belgian VAT client listing from sales journals.
$7
btw-klantenlisting
Example session with this skill installed
Check dit verkoopdagboek van 2023 en bereid de btw-klantenlisting voor met de standaard drempel van 250 euro.
- Read your context and instructions
- Compiled the btw-klantenlisting
- Generated the data export
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.
listing.csv
CSV · data export
Example file from a real run - the skill writes it into your workspace.
Connects securely to your tools. The creator never sees your data.
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.
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.
- Requires CSV input with specific columns.
- Does not submit directly to Intervat.
- Manual verification of tax year thresholds required.
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.