Shopping Cart

Time Savings Sheets

Easy to Use & Implement

Instant Download

Browse

Need custom solutions?

hello@luxtemplates.com


USD
  • USD
  • EUR
  • GBP

Work smart, not hard - use our Dashboards!

Remember, you can use our products to run your business, but you can’t resell them!

Payroll Calculator (Weekly, Bi-Weekly & Monthly)

USD$ 39,00

(1 customer review)

Payroll Calculator to simplify your work.

The spreadsheet consists of:

  • Settings
  • Employee Information
  • Payroll 7 versions:
    • Weekly (US),
    • Bi-Weekly (US with Withheld tax),
    • Monthly (US),
    • Bi-Weekly tax % based (Canada)
    • Bi-Weekly tax number based (Canada)
    • Bi-Weekly Salary base (Canada)
    • Monthly (Ireland)
  • Pay Stubs – ready to be printed or downloaded (pdf)

Compatible Excel 2010, 2013, 2016, 2019, 365

USD
  • USD
  • EUR
  • GBP

30-Days Return

Secure Checkout

Instant Download

Work smart, not hard - use our Dashboards!

Payroll Calculator - what's inside our spreadsheet?

The Payroll Calculator consists of:

  • Settings
  • Employee Information
  • Payroll (Weekly or Monthly)
  • Remittance Summary (Total)
  • Remittance Summary (by Employee)
  • Pay Stubs

Each tab does its job and helps you manage your payroll. Payroll also includes advanced features and dynamic drop-down lists that automate your work.

Weekly Payroll Sheet

Employee Information

The first task is to collect information from your employees. You can do that with Form W-4. After that provide data like hourly wage, taxes: state tax, federal income, social security, medicare, and insurance deductions. You need all of this information to properly run and distribute payroll. Also, you can set your billing year and currency.

employee tax information

There are 3 types of spreadsheets: weekly, bi-weekly, and monthly.

All sheets contain tables where you can record regular working hours, overtime and sick/vacation hours. You can also set an overtime rate and deductions for each employee. As a result, the spreadsheet calculates gross pay, net pay and taxes for you.

Monthly & Weekly Payroll

Regular & Overtime Hours

Overtime normally begins after an employee has worked 40 hours in a week. Overtime is paid at one and a half times the normal rate of pay. However, you can set the overtime hours and the overtime rate.

Taxes

Our spreadsheet handles taxes such as State Tax, Federal Income, Social Security, and Medicare.

Deductions

A deduction is any money you subtract from an employee’s total wages.

Pay Stubs in Payroll Calculator Spreadsheet

To make it easier for you, we have prepared a Pay Stubs sheet – ready to print or generate PDF. It contains all information about worked hours, earnings, deductions, and taxes.

How it’s working? All you have to do is choose Month / Week and then employee. The formulas will handle the rest.

excel pay stub

Remittance Records - Great for Federal 941 reporting purposes

payroll remittance records and federal 941

Contents

  • Excel Spreadsheet – Monthly Payroll (xlsx)
  • Excel Spreadsheet – Weekly Payroll (xlsx)

Also, would you like to manage projects or track your sales?

Compatible

Excel 2013, 2016, 2019, 365

1 review for Payroll Calculator (Weekly, Bi-Weekly & Monthly)

  1. evilTwinMe

    Works great on my excel 365

Add a review

Your email address will not be published. Required fields are marked *

No time to learn Excel? No problem.

Consider Premium version

Would you like to get a high-end custom Dashboard?

You may also like

Instant Download

A few seconds and the dashboard is yours

Friendly Refund Policy

30 days money back guarantee

High Quality Spreadsheet

Automate your work like never before

100% Secure Checkout

PayPal / MasterCard / Visa

Free excel templates download now

Instant download

The link will be sent to your email

Check your license

Free

Single-User

Professional

Business

Commercial use:
Remember, you can use our products to run your business, but you can't resell them!

Reseller license:
To request products and rights for reselling, please contact hello@luxtemplates.com

  • *Editable: Modifiable/Professional/Business: Sheets are protected due to unexpected formula modification. You can unprotect sheets. No password is required
  • *VBA code: Templates using the VBA code are marked with the appropriate information in the description
  • *Support: We help in the implementation of the file and in small modifications of the template
  • *Users: If you intend to have more than 5 users or copies of the template, then you must choose the Business license.
  • *Apps: VBA supported templates are available only on MS Excel.

Take 15% off

Your First Order

Save15Lux

Analytics by Conversios