Beancount advancement Thread

nugget · January 3, 2023, 12:17am

Hi all
for those living in the Kanton of Zurich and normal taxation regime, i wrote a tax forecast plugin that will predict the tax load of a ongoing or past fiscal year and add monthly tax liabilities accordingly:

github.com/Dr-Nuke/drnuke-bean

src/drnukebean/plugins/tax_forecast.py

master

"""
A beancount plugin to make predictions on tax liabilities in kanton zurich switzerland

it uses a very messy config string like

'{"taxable_accounts": ["Income:Jobs:Taxable:Salary", "Income:Jobs:Taxable:Bonus", "Income:Invest:IB:.*:Div"], "deductable_accounts": [], "taxable_assets_accounts": [], "tax_expenses_main_account": "Expenses:Taxes", "liability_account": "Liabilities:Tax", "year": 2022, "api_year":2022 "assets": 200000, "taxable_income": 100000, "witholding": 500, "municipality": 261, "marial_srtatus": "single", "n_children": 0, "tax_day_of_month": 24, "precision": 2}'

that can be generated with json.dumps(<config_dict>)

use the plugin in your ledger file like: plugin "drnukebean.plugins.tax_forecast" <config_string>
"""

from beancount.core import data
from beancount.core.amount import Amount
from beancount.core.data import Transaction
from beancount.core.number import Decimal

from beancount.query.query import run_query

import datetime

This file has been truncated. show original

this plugin greatly benefits from @the_p’s shared api queries to the Steuerrechner of the Kanton Zurich.

based on your taxable income accounts, it extrapolates your current income to the full year, queries the according tax load at the Steuerrechner, and adds the resulting tax debt as a liability to your ledger

Warning: this is totally immature and needs some more work but it basically works:

room for improvement:

add Vermögenssteuer
add deductables (accounts, lump sum,…), as it currently strongly overestimates the due taxes
switch to the ESTV Steuerrechner, which should work for all Kantons
add more choices & options support
reflect on any feedback here
i cant get behind some things in beancount, probaby there are some really poor workarounds in the source…
add tax credit (Witholding etc.)