Payroll calculator to simplify your work.
Let our payroll calculator simplify your work by automating tax calculation and pay stub generation!
⚊Supports both Salaried and Hourly paid employees⚊
Looking for a payroll spreadsheet that takes local/state regulations into account? Contact us!
⚊⚊⚊ The spreadsheet consists of ⚊⚊⚊
✔ Pay Stubs – ready to be printed or downloaded to pdf
✔ Employee Information sheet
✔ Dashboard
✔ Remittance records (All Employees)
✔ Form W-2
✔ Form 941
✔ Daily Hours sheet to register hours worked (Hourly employees), Overtime, Vacation Hours
✔ Payroll sheet (Weekly, Bi-Weekly, Semi-Monthly, Monthly)
⚑ Payroll was created following IRS guidelines (US)
⚊⚊⚊ Employee Information ⚊⚊⚊
The first task is to collect information from your employees. You can do this using Form W-4. Next, provide information such as hourly wage (or fixed salary), taxes: state tax, federal income tax, Social Security, Medicare, other deductions, and additional withholdings (federal, state). It would be best to have all of this information to run and distribute payroll properly.
⚊⚊⚊ Weekly – Bi-Weekly – Sem-Monthly – Monthly ⚊⚊⚊
The sheet supports 4 types of pay periods: Weekly, Bi-Weekly, Sem-Monthly, Monthly
⚊⚊⚊ Payroll and Taxes ⚊⚊⚊
The main area of work is the Payroll sheet in which you can enter:
- Hour Worked (if income base is hourly rate)
- Custom Hourly Rate or Custom Salary
- Overtime
- Vacation
- Bonus
- Fringe Benefits
- Other Deductions
The payroll calculates these for you:
- State Tax
- Federal Tax
- Social Security Tax
- Medicare Tax
⚊⚊⚊ Payment Remittance Summary ⚊⚊⚊
- Great for Federal 941 reporting purposes
- Calculate Federal Unemployment Tax Act (FUTA) amount
- Calculate the State Unemployment Tax Act (SUTA) amount
- Quarterly & Weekly Summary
- Total Summary
- Summary by Employee
⚊⚊⚊ Pay Stubs – Payroll Calculator ⚊⚊⚊
To make it easier, we have prepared a Pay Stubs sheet - ready to print or generate PDF. It contains all the information about hours worked, earnings, deductions, and taxes.
All you have to do is select Month / Week and then Employee. The formulas will do the rest.
⚊⚊⚊ Compatible ⚊⚊⚊
Excel 2013, 2016, 2019, 365
The file extension is .xlsx
Check out:
-> US Google Sheets version: https://www.etsy.com/listing/1504862075/payroll-template-google-sheets-with-pay
-> Canada Payroll Spreadsheet: https://www.etsy.com/listing/1594139781/canada-payroll-spreadsheet-google-sheets
---------------------------------------------------------------
★ This is a digital product ★
After purchase, you will immediately receive a link from Etsy to download a .zip package and .pdf file.
To use the product unzip the package.
★ Terms of use ★
After buying the product, you can edit it make as many copies as you want, and use it in your home or business. However, you may not resell, give someone, or reproduce to create a new product for resell
★ Support ★
If you have any questions, please feel free to reach out to us.
---------------------------------------------------------------