Works with the AI Agents you already use

    Claude CodeClaude CodeCursorCursorCodex CLICodex CLIDeepSeekDeepSeekMuseMuse+22 more

    Btw Klantenlisting

    5

    Automates aggregation and threshold filtering for the annual Belgian VAT client listing from sales journals.

    $7

    Secure checkout via Stripe

    Money-back guarantee

    Converts to your local currency at checkout

    Security scanned
    btw-klantenlisting

    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

    Generated

    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. 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. 2

      Sign in to Agensi

      Your agent shows a sign-in link. Sign in and click Allow.

    3. 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
    Read Files
    Write Files

    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.

    Listed5 months ago
    Updated3 months ago

    What's inside

    Frequently Asked Questions

    The skill automates the aggregation of your sales journals, calculates year-to-date totals per client, strips formatting errors from VAT numbers, and automatically applies the €250 threshold to identify which clients must be included in your annual Belgian report.

    Upon purchase, you receive the full Python-based workflow, detailed documentation on input requirements, and a template for your sales journal exports to ensure seamless processing.

    This skill is designed for use with AI agents that support data processing or code execution (such as ChatGPT's Advanced Data Analysis or custom Replit agents), as it requires the ability to run Python scripts on your uploaded CSV or Excel files.

    The skill is optimized for standard CSV or Excel exports from common accounting software (like Exact Online, Yuki, or Odoo); as long as your export contains client VAT numbers and net amounts, the tool can be mapped to your specific column headers.

    Yes, the tool is programmed to detect non-BE prefixes and will flag those entries for you, ensuring they aren't incorrectly included in your domestic listing while reminding you to include them in your Intracommunity (ICP) reporting.

    New in Finance & Accounting