Payroll and wages tool by Smart Financial Reports

Smart Payroll System

A professional tool to manage employee records, monthly payroll inputs, net salary calculations, employer cost, and printable payroll slips with PDF and Excel export.

How to use
Employee recordsBasic salaries and fixed allowances
Monthly inputsAbsence, overtime, bonuses and loans
Full calculationNet salary and employer cost
PayslipsPrint, PDF and Excel export
Settings
Employees
Monthly Entries
Calculate
Payslips
Import/Export
Company Settings
Optional - appears on payslip
Country settings will be used for statutory calculations
Country Rules
v1.0
Minimum Wage (Information Only)
-
RuleValueSource
Rules are updatable from settings. Results are indicative and do not replace legal review.
Employee Basic Data
Only fixed data here: name, basic salary, fixed allowances. Do not enter absence or overtime here.
IDNameDepartmentSocial / Insurance NumberContractBasicAllowancesActions
Monthly Entries
Variable movements per period: absence, delay, overtime, bonuses, loans. Select an employee then enter monthly data.
Payroll Calculation
Payslips
Printing opens a dedicated professional report. When saving as PDF in Chrome, set Headers and footers to Off and Background graphics to On.

No Payslips

Run calculation first

Download Template

Download an Excel template with sheets: Employees (fixed data) and Monthly_Inputs (monthly movements).

Upload Data

Click or drag Excel file

XLSX, CSV

Export Results

How to Use the Smart Payroll System

  1. Start with Company Settings and select the country, currency, payroll period, and pay date.
  2. Add only the employees’ fixed records, such as basic salary and fixed allowances.
  3. Open Monthly Inputs to record absence, delays, overtime hours, bonuses, loans, and deductions.
  4. Run payroll to review gross pay, deductions, net pay, and employer cost.
  5. Approve the period, then issue payslips or export the results to Excel and PDF.

Quick Practical Example

For an employee with a basic salary of 1,000, a transport allowance of 100, and a housing allowance of 200, plus 5 overtime hours, a bonus of 50, and a loan deduction of 30, the tool combines earnings and deductions and calculates net pay and employer cost using the selected country settings.

When Should You Use This Tool?

Use it to prepare monthly payroll, compare employee costs, issue payslips, or build a streamlined payroll workflow for a small or medium-sized business.

Related Tools

BudgetingCash Flow AnalysisFinancial Ratio AnalysisBank ReconciliationAccounts Payable Aging

Professional Disclaimer

Payroll results are indicative and depend on the entered data and the country rules saved in the tool. Review local laws, social insurance requirements, taxes, and employment contracts before final payroll approval.