This manual explains how to correctly create and validate calculation formulas in FirstBIT software, following 1C calculation logic.
It is intended for HR, Payroll, Finance, and ERP users who configure salary, allowance, overtime, or commission calculations.
1. Key Principles of Formula Creation
...
due to system logic
When creating formulas in FirstBIT software, always follow these core principles:
...
| Parameter | Description | Correct Use | Do NOT Use When |
|---|---|---|---|
| Absence Days | Number of absent working days | Reducing day-based payments | Calculating hourly salary |
| Absence Hours | Number of absent hours | Reducing hour-based payments | Calculating day-based salary |
| Days In Period | Total days in the period | Denominator for proportional logic (if justified)logic | Replacing Norm Days without reason |
| Days Worked | Actual worked days | Monthly salary proration | Hour-based formulas |
| Fixed Amount | Fixed value | Allowances, bonuses, deductions | Without proration logic if required |
| Hours Worked | Actual worked hours | Hourly salary calculation | Day-based salary |
| Hours Worked by Jobs | Hours per job/project | Multi-job or project payroll | Simple single-job payroll |
| Norm Days | Standard working days | Monthly salary base | Hour-based calculations |
| Norm Days by Schedule | Norm days per employee schedule | Shift / flexible schedules | Fixed schedules |
| Norm Hours | Standard working hours | Hourly & overtime base | Day-based formulas |
| Overtime Hours | Hours beyond norm | Overtime calculation | Regular salary |
| Sales Amount | Total sales value | Turnover-based commission | Margin-based commission |
| Sales Margin | Profit from sales | Margin-based commission | Turnover-based commission |
| Tariff | Salary rate (daily/hourly/monthly) | Base of all calculations | When unit does not match formula |
...
This leads to double reduction.
✔ Choose one unit only, based on how the salary is calculated.
...
This may distort salary calculations.
✔ Use Use Norm Days unless there is a documented business reason.
...
Hourly tariff × Days Worked
✔ Always Always match tariff unit with calculation unit.
...
This may overpay or underpay in partial months.
✔ Clearly Clearly define whether the amount should be prorated.
...