Cuiar
Sign inDownload

Prepare the figures for your VAT return

Sales and input VAT by rate for the period, checked against your sales platforms, with the box values.

  • You start it: When you start it
Use in CuiarRun from your AI agent

What it does

The task

Run the VAT report in Xero for period. Compare its sales totals with the Shopify and Stripe payouts for the same period, and list each difference above 50 EUR. Find the bills that have VAT but no attached invoice. Put the value for each box of the VAT return for country in a new Google Sheet, with the source of each value. Do not file the return.

  • It works in Xero, Shopify, Stripe and Google Sheets, in the workspace you pick, and signs in with passwords from your Cuiar vault.
  • It runs once, when you start it.

What you give it

BlankWhat to giveExample
periodThe VAT periodQ3 2026
countryThe country of the VAT returnGermany

What you get back

An example run with the example values above. Your run uses your own data.

VAT return, Q3 2026, Germany

BoxValueSource
81: Sales at 19%, net214,380.00 EURXero VAT report
86: Sales at 7%, net12,450.00 EURXero VAT report
66: Input VAT18,926.42 EURXero VAT report
83: VAT to pay22,677.28 EURCalculated

Difference: Shopify payouts for September are 1,240.00 EUR higher than the sales in Xero.

Bills with VAT and no invoice: 3 (Printwell, Cloudbase, Railway Café)

Saved to the sheet "VAT Q3 2026".

Run it in Cuiar

  1. 01

    Open it

    Click Use in Cuiar on this page. The side panel opens with the task in the composer.

  2. 02

    Fill in 2 blanks

    Type period and country. Tab moves to the next blank.

  3. 03

    Run it

    Run sends it to the agent. Follow each step in the panel, and stop it at any time.

From the terminal

cuiar exec "Run the VAT report in Xero for Q3 2026. Compare its sales totals with the Shopify and Stripe payouts for the same period, and list each difference above 50 EUR. Find the bills that have VAT but no attached invoice. Put the value for each box of the VAT return for Germany in a new Google Sheet, with the source of each value. Do not file the return."

Run it from your AI agent

Claude Code, Codex, Cursor and other MCP clients reach Cuiar at https://mcp.cuiar.com/mcp. Add the server one time, then ask for the task in plain words, or call run_task yourself.

1. Add Cuiar to Claude Code

claude mcp add --transport http cuiar https://mcp.cuiar.com/mcp

2. Ask your agent

Use the Cuiar tool run_task to run my "Prepare the figures for your VAT return" template with period = Q3 2026; country = Germany.

Setup for other agents: AI agents.

The tool call

{
  "name": "run_task",
  "arguments": {
    "task": "Run the VAT report in Xero for Q3 2026. Compare its sales totals with the Shopify and Stripe payouts for the same period, and list each difference above 50 EUR. Find the bills that have VAT but no attached invoice. Put the value for each box of the VAT return for Germany in a new Google Sheet, with the source of each value. Do not file the return."
  }
}

Related templates

All finance templates

  • Finance

    Match Stripe payouts to your bank deposits

    Each payout matched to a deposit, with fees and refunds, and the payouts that did not arrive.

    You start it: When you start it
    • Stripe
    • Any bank site
    • Google Sheets

  • FinanceAsks first

    Answer a Stripe dispute with evidence

    The order, the delivery proof and your messages for the disputed payment, with a draft answer.

    You start it: When you start it
    • Stripe
    • Shopify
    • Gmail
    • +1 more: Any carrier site

  • Finance

    Build a 13-week cash flow forecast

    Weekly cash in and out from your bank, open invoices and bills, with the weeks below your minimum marked.

    You start it: When you start it
    • Any bank site
    • Xero
    • Google Sheets

  • Finance

    Check supplier invoices against purchase orders

    Each invoice matched to its PO and delivery note, with price, quantity and duplicate problems marked.

    You start it: When you start it
    • Google Drive
    • Google Sheets
    • Xero

  • FinanceAsks first

    Create client invoices from your tracked hours

    One draft invoice per client from your hours sheet, with rates and dates, sent after you approve it.

    On a schedule: On the 1st of each month at 10:00
    • Google Sheets
    • Xero

  • Finance

    Compare your budget with actual spending

    Budget against actual for each account, the largest differences first, with the transactions behind them.

    On a schedule: On the 5th of each month at 9:00
    • Xero
    • Google Sheets