Btw Klantenlisting

    by Nex AI

    1

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

    Secure checkout via Stripe

    0 installsSecurity scanned

    Works with the AI tools you already use

    CClaude CodeCCursorCCodex CLIGGitHub CopilotGGemini CLIVVS CodeWWindsurf+15 more

    See it in action

    You say

    Check dit verkoopdagboek van 2023 en bereid de btw-klantenlisting voor met de standaard drempel van 250 euro.

    Your agent does

    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.

    What you get

    Aggregate annual sales per BE VAT number automaticallyFilter clients based on the official reporting threshold (e.g., €250)Validate Belgian VAT number formats and normalize data entry errorsSeparate intra-community (ICP) transactions from domestic listingsReconcile sales journals with credit notes for accurate annual totals

    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.

    How to install

    Drop the file into your AI Agent. Works with Claude, Cursor, ChatGPT, and 20+ more.

    Reviews

    No reviews yet

    Be one of the first to try it. Every listed skill passes our trust checks below.

    Security scanned

    Passed our 8-point scan before listing

    Fresh listing

    Recently published to Agensi

    30-day refund

    Not a fit? Get your money back

    Trust & safety

    Security scanned

    Verified clean 1 month ago

    Listed1 month ago

    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

    Popular in Finance, Legal & Accounting