Works with the AI Agents you already use

    Claude CodeClaude CodeCursorCursorCodex CLICodex CLIMuseMuseDotsDots+21 more

    freelancer books vat

    1

    Turn bank statement exports into organized books, VAT estimates, and subscription reports for freelancers.

    $5

    Secure checkout via Stripe

    Money-back guarantee

    Converts to your local currency at checkout

    Security scanned
    freelancer books vat

    freelancer books vat

    Example session with this skill installed

    I have two CSV exports from my business account and credit card for Q1. Can you help me organize these for my VAT filing? The bank files are bank_main.csv and card_tx.csv.

    • Read your context and instructions
    • Compiled the freelancer books vat

    I have inspected your bank files and prepared the quarterly summary. I found 124 transactions across both accounts. After applying the standard rules, I have identified a few recurring subscriptions and estimated your VAT balance.

    Books · Q1 Summary

    QuarterIncomeExpensesVAT balance
    Q1 (Jan-Mar)€14,500.00€4,250.60€2,145.00 (Due)

    Recurring payments:

    • Adobe Systems: €24.39/mo (€292.68/yr) - Creative Cloud
    • AWS: ~€55.00/mo (€660.00/yr) - Hosting
    • Google Workspace: €12.00/mo (€144.00/yr) - Email

    Questions for you:

    • AMZN Mktp (Feb 14): €89.99. Was this a business equipment purchase or personal?
    • TFL Travel (8 entries): Total €45.20. Should these be categorized as business travel?
    • Apple.com (Mar 05): €0.99. Is this an iCloud business expense or personal?

    Next steps

    1. Review the books.xlsx ledger to confirm the "To review" items.
    2. Update rules.json with your answers to the questions above to automate next time.
    3. Hand the final Ledger tab to your accountant for the formal VAT return.

    Note: VAT figures are estimates based on bank movement dates. Please verify against your actual invoices.

    Connects securely to your tools. The creator never sees your data.

    About this skill

    Bookkeeping is a chore that freelancers often delay until tax season becomes a crisis. This skill bridges the gap between messy bank statement exports and the organized data your accountant actually needs.

    What it does

    • Standardizes exports by converting various bank CSV or PDF statement formats into a unified schema.
    • Automates categorization using a rules-based engine to map counterparties to specific expense accounts.
    • Estimates VAT for each quarter based on user-defined rates and deductibility percentages.
    • Detects subscriptions by identifying recurring weekly or monthly payments to highlight potential savings.
    • Generates dashboards including an Excel ledger and an HTML summary for quick financial health checks.

    How it works

    1. Inspect files using the inspect command to map column headers and validate date formats across different bank exports.
    2. Define rules in a JSON file to handle recurring merchants, setting their VAT rates and business-use percentages.
    3. Execute build to merge statements, deduplicate transactions, and generate the books.xlsx and books.html outputs.
    4. Review and refine the generated list of unclassified items to update the rules for the next run.

    Frameworks & tools

    The system uses a standalone Python 3.8 script requiring only the standard library. It operates entirely offline for data privacy, processing CSV and PDF inputs to output JSON, Excel, and HTML formats.

    Why this beats prompting it yourself

    Manual prompting often fails at deduplication and consistent categorization across hundreds of rows. This skill uses a persistent rules engine, ensuring that a merchant classified once stays classified correctly across different quarters and accounts.

    Use cases

    • Preparing quarterly VAT estimates for a small business or freelancer.
    • Auditing annual bank statements to identify unused software subscriptions.
    • Cleaning up mixed personal and business transactions for an accountant.
    • Converting bank PDF statements into a structured ledger for tax filing.

    Known limitations

    VAT calculations are estimates based on payment dates, not invoice dates. The script requires Python 3.8 or higher and does not support direct API connections to banks.

    Requires Python 3.8+. VAT figures are estimates only. Does not support direct bank API integration; relies on manual CSV/PDF exports.

    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 any payment.

    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 1 month ago

    Requires

    Python

    Permissions

    No special permissions declared or detected

    Listed1 month ago

    What's inside

    Frequently Asked Questions

    The skill accepts CSV and PDF bank statement exports. It uses an inspection command to map headers from different banks, allowing you to merge data from multiple accounts into a single, unified ledger.

    This skill provides a standalone Python-based engine that processes data offline. Unlike standard prompts, it uses a persistent JSON rules engine to ensure consistent categorization and perfect deduplication across hundreds of rows.

    Privacy is a priority; the script runs entirely on your local machine and does not require an internet connection or bank API access. Your sensitive financial data never leaves your environment.

    You will receive the core Python processing engine, a template for the rules configuration file, and documentation on how to generate the Excel and HTML financial dashboards.

    The tool provides a VAT estimate based on transaction dates and user-defined rates. While it is an excellent tool for organization and preparation, the outputs should be reviewed by a professional as it does not account for accrual-based accounting or specific tax legalities.

    New in Finance & Accounting