VAT projection
banana_vat_projectionRetrieve projected VAT amounts for a VAT code or group, starting from a specified date. Returns taxable, notdeductible, posted, or rowcount totals.
Instructions
Return the projection VAT figure for a VAT code or VAT group. Requires projectionstart.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| doc | No | Accounting document name as opened in Banana (e.g. "accounting.ac2"). Append "_p1", "_p2" for previous years. Defaults to BANANA_DEFAULT_DOC if set. | |
| type | Yes | VAT amount type to return (taxable, amount, notdeductible, posted, rowcount). | |
| filter | No | JavaScript expression to filter transactions, e.g. filter=row.value("Date")==="2024-01-15". Available: row, rowNr, table. | |
| period | No | Period filter: an abbreviation like "Q1"/"3M"/"1Y" or a date range "2024-01-01/2024-03-31". | |
| vat_code | Yes | VAT code ("V80"), group ("Gr=..."), or pipe-separated codes ("V0|V80"). | |
| frequency | No | Frequency: D=daily, W=weekly, M=monthly, Q=quarterly, S=semesterly, Y=yearly. | |
| projectionstart | Yes | Mandatory projection start: a period abbreviation ("Q1") or a date ("2024-07-01"). |