create_year_sheet
Creates a tax year's invoice workbook in .xlsx or Google Sheets, including income and expense tables, quarterly IVA declaration entries, formulas, and IRS/Segurança Social totals.
Instructions
Create a tax year's books: a local .xlsx workbook (default) or tabs in a Google Sheet, per the config. Expenses and income tables with the Declaração Periódica block (what to type each quarter, with the credit carried over), quarter sums, IRS / Segurança Social totals, formulas, dropdowns and formats. The opening credit (Q1 box 61) defaults to the previous year's Q4 box 96. Refuses to overwrite.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| year | Yes | ||
| dry_run | No | ||
| opening_credit | No |