Payroll Calculator
Enter each employee's basic pay, allowances and overtime hours, rate and multiplier, plus fixed deductions, a percentage deduction on basic pay and a tax percentage. The calculator works out overtime pay, gross pay, total deductions and net pay per person, then totals the whole payroll. Export the sheet as CSV for your records or bank upload preparation.
How to use the Payroll Calculator
- Enter the pay period and choose a currency.
- Add a row for each employee with basic pay and allowances.
- Fill in overtime hours, hourly OT rate and multiplier (for example 1.5 for time-and-a-half).
- Add fixed deductions, a percentage deduction (such as a pension or provident fund) and the tax rate.
- Read the per-employee table and totals, then download CSV.
Features
- Overtime = hours × rate × multiplier
- Fixed and percentage-of-basic deductions
- Flat tax percentage on gross pay
- Per-employee breakdown and payroll totals
- CSV export and copyable summary
Benefits
- Run a small team's payroll check in one screen
- See the true cost of overtime before approving it
- Spot employees whose deductions exceed their gross pay
Frequently asked questions
What does the overtime multiplier mean?
It scales the hourly overtime rate. Use 1.5 for time-and-a-half or 2 for double time. If you already entered the enhanced rate, set the multiplier to 1.
Does it apply real tax brackets?
No. Tax is a single flat percentage of gross pay that you choose. Real income tax and social security usually use bands, thresholds and allowances, so the result is an estimate.
What is the percentage deduction based on?
It is calculated on basic pay only, which is how many pension and provident-fund contributions work. Use fixed deductions for flat amounts such as loan repayments.
Can I rely on this for statutory payroll?
Treat it as an estimate, not payroll or tax advice. Statutory payroll must follow your local rules, so confirm figures with your payroll provider or accountant.
Related tools
- Income Statement Generator — Build a profit and loss statement from revenue, cost of sales and expense lines, with margins, tax, PDF and CSV export.
- Balance Sheet Generator — Create a balance sheet from assets, liabilities and equity, check that it balances and see current, quick and debt-to-equity ratios.
- GST / VAT Calculator — Add or remove GST or VAT at any rate and see the net, tax and gross amounts, with an optional CGST and SGST split.
- Trial Balance Generator — List ledger accounts with debit or credit balances, check that debits equal credits, sort by code or name, and export PDF or CSV.
- Journal Entry Generator — Record multi-line double-entry journal entries, check each one balances, see a ledger summary by account and export CSV or PDF.
- Profit and Loss Calculator — Enter cost price, selling price, quantity and extra costs to get profit or loss, profit percentage, markup and margin explained.