Payroll Hours Calculator Spreadsheet with Deductions and Net Pay (ODS)
By EducoPrice in USD. Local taxes calculated at checkout.
Buy 3 or more, save 20% from this shop
- 1 ZIP download · ODS, TTF, TXT, ZIP formats · 3 tabs; ODS
- Buyer protection. Corrupt or mismatched files? Full refund.
Item details
A weekly payroll hours sheet that also applies one deduction percentage to give net pay for each person.
A deduction percentage cell turns gross into net pay for each employee (18% by default). 'Weekly Hours' has 12 rows; each takes a rate and daily hours for Mon, Tue, Wed, Thu, Fri, Sat, Sun, then calculates total, regular (up to 40 hours) and overtime hours and gross pay at 1.5× overtime. 'Cost Summary' links the first 12 rows and summary table gross pay by employee.
Cells with overtime hours highlight amber; hour cells only accept numbers from 0 to 24.
The editable tabs are Weekly Hours: 12 employee rows × 7 days with total, regular and overtime hours, gross pay, deductions and net pay.; Cost Summary: Hours and gross pay per employee with a column summary table..
7 employees named 'Employee 01'… with invented rates and hours are included as examples.
Download one ZIP containing ODS workbook, Poppins, Nunito OFL font files and licences, and README.txt. The Start Here tab explains inputs, calculations and how to clear the worked entries.
The workbook contains 121 formulas. Its emerald design uses coloured input cells and separate calculation cells. Unzip and install the included typefaces before opening the sheet.
Works with spreadsheet software supporting ODS files. Digital download; no macros or external data connections.
This ODS edition presents calculated results as cells and summary tables.
File specs
| Formats | ODS, TTF, TXT, ZIP |
|---|---|
| Dimensions | 3 tabs; ODS |
| Color space | sRGB |
| Downloadable files | 1 ZIP download · ODS, TTF, TXT, ZIP formats |
| Category | Templates |
| Last updated |
What you’ll download
- zippayroll-hours-calculator-spreadsheet-with-deductions-and-net.zip94 KB
License and usage
- Personal · $5.99
- Use the files in your own non-commercial projects: home prints, gifts, personal social posts and school work. Anything made with them can’t be sold.
- Commercial · $17.97
- Use the files in client work and in products you sell, up to 5,000 units across all products. Credit is appreciated but not required.
No license allows reselling, sharing or redistributing the original files as they are, including in free packs or AI training sets.
