How do I create a salary table ?

A table is used to define a value limited by a range of two other values. It is used in wage type calculation formulas, when a rate can only be determined at the time of wage slip calculation, because it depends on another amount. This is the case, for example, with tax at source, for employees whose salary is not fixed but varies each month.

The most typical use of tables is for automatic calculation of tax at source. But you can also create your own tables, for example to calculate seniority bonuses or sales commissions.

The Tables file can be accessed via the Data menu. To create a new table, call up the Action>New command.

Boundaries and table values are entered in a spreadsheet (like in Excel or Numbers), but very simplified. To the left of the spreadsheet, buttons allow you to Add or Delete a Row or Column.

Tax at source calculation tables

The official tables for calculating tax at source can be downloaded from the Swiss Federal Tax Administration website. These tables are subject to change each year and differ from canton to canton. Once you've obtained the file, you can import it into the Tables file using the Source tax tables ESTV/AFC format. In this case, the names of the columns in the spreadsheet are those of the table scales. These tables cannot be modified.

Note: in the Light and Standard versions of Office Maker Staff, it is only possible to import the official Source Tax Tables from the Swiss Federal Tax Administration. The PRO version lets you create your own tables.