Free Payroll Templates

Want to do payroll yourself? Spreadsheet software with free payroll templates can help you calculate wages and taxes, print checks, and keep accurate financial records. Spreadsheet software costs as little as nothing (for instance, Google Sheets) or a low monthly fee (Microsoft Excel), which makes payroll templates extremely affordable for budget-conscious small business owners. Check out our top payroll template recommendations below.

A payroll template is a spreadsheet-based template that lets you calculate employee pay and determine payroll tax withholding amounts.

If you want to run payroll with a free template, start by downloading spreadsheet software (we recommend the three best below). Then, search for a free payroll templates that syncs with your spreadsheet software. These templates have pre-filled cell formulas, so all you have to do is enter your employees' pay rate and tax information, and the spreadsheet takes care of the rest.

Some payroll templates, such as those from ExcelPayroll, generate pay stubs and payroll checks that you can print from your computer. You can also find payroll summary report templates, printable payroll templates, and payroll template PDFs that make it easier to keep accurate financial records for your business. 

Smartsheet offers several customizable, free payroll templates, including an all-in-one payroll calculator and registrar.  You can also use Smartsheet to find professional payroll summary report templates and payroll ledger templates. You can also print or export payroll templates as PDFs. 

Smartsheet starts with a 30-day free trial, but to make the most of the software, you'll want one of its paid plans. They start at the relatively low fee of $7.00 per user per month, but if you don't want to pay for your spreadsheet software, you can still download one of Smartsheet's free templates. It should sync to your Google Sheets or Microsoft Excel account.

Already using Gmail? A Google Sheets payroll template is the logical (and completely free) payroll spreadsheet solution for you. Hundreds of users have created free payroll templates that sync with Google Sheets. While the software is less secure than Excel and Smartsheet, it's the most affordable choice for most business owners.

Microsoft’s professional templates set the gold standard in calculation accuracy and ease of use. Unfortunately, Excel isn’t truly free. Instead, Microsoft Office costs a monthly subscription fee—but at $6.99, it's more affordable than some monthly payroll subscriptions.

Since Microsoft Excel is such a popular spreadsheet brand, you can find fantastic payroll templates not just from Microsoft but from third-party payroll template creators. The best Excel payroll template is ExcelPayroll, which you can download for free anytime.

Payroll software can dramatically cut down the number of hours you spend entering payroll data each week. Depending on the plan you choose, online payroll solutions can deduct payroll taxes, remit them to the correct government agency, fill out tax forms, and submit tax paperwork at the end of the year. 

There are dozens—even hundreds—of payroll software options for small business owners. Let us help you narrow down your options: enter some basic information about your business, including your payroll expectations and business size, and we'll match you with up to five payroll providers.

Both Microsoft and Smartsheet offer templates for a range of payroll-related needs, including employee timesheets, hourly and salary payslips, and sick leave and vacation tracking. Visit Excel's payroll template page or Smartsheet's payroll template page to see their free options.

If you don't need a template but do want help calculating payroll, we have two free calculators: a salary payroll calculator and hourly paycheck calculator. Both calculators will help you determine how much money to send your employees home with and how much to remit to the IRS.

If you're trying to calculate taxes for paying bonuses, we've got you covered there too—try our bonus paycheck calculator.

Want to download a free payroll template today? 

For a truly free option, we recommend using a Google Sheets payroll template. While Excel is one of the most popular options for spreadsheet-based payroll templates, it costs a monthly subscription fee—which means that while a template download is free, the spreadsheet software itself isn't.

Similarly, while you can download free payroll templates from Smartsheet, you'll get the best experience with Smartsheet's paid software. 

Looking for other free ways to run payroll? Read through our list of the best free payroll software for small businesses.

While the following columns are generally listed in most payroll templates, you might need to modify yours to fit your specific needs:

• Federal income tax
• State income tax (if your state has an income tax)
• FICA taxes, which include Medicare and Social Security taxes

You can use a payroll calculator to multiply the current tax rate against your employees' salaries and determine the right deduction (many templates include a payroll calculator in a separate tab), then log it in the corresponding cell. If the template doesn't include a payroll calculator, your payroll spreadsheet template probably calculates payroll taxes line by line with a cell formula.

After the first time you run payroll, you'll be able to copy the same employee information and cell formulas into a new spreadsheet or tab. To ensure your spreadsheets don't spiral out of control, clearly label each new payroll template or tab with the pay period date.

Disclaimer

At Business.org, our research is meant to offer general product and service recommendations. We don't guarantee that our suggestions will work best for each individual or business, so consider your unique needs when choosing products and services.