Define the rule before calculating
A bonus is more than a percentage. Agree ownership of sales, treatment of returns and the qualifying payment date. The SBT CRM payroll guide describes salary, bonus schemes, monthly calculation, approval and Excel export. Access depends on plan and permissions.
Seven checks
- Correct employee inclusion and working days.
- A defined base: sales, received payments or profit.
- Documented treatment of returns, cancellation and partial payment.
- Evidence for additions, advances and deductions.
- A common period and data cut-off.
- Named preparation, review and approval roles.
- Reconciled totals and Excel output.
Pilot a month
Use a small authorised dataset covering normal transactions, returns and boundary cases. Compare results with an independent calculation by the accountant. Keep identifiable payroll data out of public demonstrations.
Preserve history
Corrections to an approved month require permission and an explanation. Help describes draft, approval and payment states, plus configurable 1C transfer. The responsible accountant must check current tax and deduction parameters; this article describes process controls rather than tax rates.
Connect HR consulting, finance consulting and Excel training. Discuss the scope.