| name | vat-summary |
| description | Produce a VAT / sales-tax summary for a period from a Well workspace's posted ledger. Use when the user asks for a VAT return, VAT summary, sales tax owed, output vs input VAT, or tax declaration figures for a period. |
VAT summary from Well
A VAT return is a byproduct of closed books, not a separate project. If the ledger is posted and correct, the figures already exist — the work is presentation. Work backward from the filing deadline and forward from the posted ledger, and surface uncertainty rather than reporting a number you're not sure of.
Build it from the posted ledger + tax rates
- Discover the schema first (see
well:querying-well-data).
- Output VAT (collected on sales) — from issued
invoices / invoice_items and their tax_rates, or the corresponding VAT ledger_accounts / journal_entries for the period. Group by rate (standard / reduced / zero / exempt).
- Input VAT (paid on purchases) — from received
invoices / invoice_items + tax_rates, or the input-VAT ledger accounts.
- Net VAT due = output VAT − recoverable input VAT, per the period's date filter.
- By rate and jurisdiction — break the totals down by VAT rate and, for multi-jurisdiction workspaces, by jurisdiction. Read the rate from the data (
tax_rates), don't assume it.
Rules — conservative by design
- "The books are not closed yet." If the period's
journal_entries are still DRAFT / unposted, say so before producing a final figure — declarations fall out of closed books. Offer a provisional figure clearly labelled as such.
