
Company Magazine
Docs + Word7 pages
FeaturedFree
Owners of very small businesses and their bookkeepers use the Small Business Payroll Calculator to run a pay period from one sheet. The Pay run tab works as a form: business name and pay date first, then period dates, then one line per employee with regular hours, overtime hours and hourly rate. Gross pay and totals are calculated for you, and the withholding rate you type yields estimated withholding and net pay. The Pay log tab keeps the totals from earlier runs.
Replace the sample withholding rate with a figure from your own estimate or your payroll provider's tables before you rely on any net pay number. Check overtime against the rules that apply in your state, and keep a record for each pay date. The sheet does not calculate employer taxes, benefits or the full withholding schedule, so use it to plan and check, not to file returns.
Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.
Start on the Pay run tab: replace the sample rows with your own.
Keep the formula columns as they are; they fill in as you type.
Read the How to use tab for tips. For Excel, download the .xlsx file instead.
No. It helps you work out pay and see the totals in one place. A payroll service or your accountant still handles tax filings, deposits and year-end forms. Use the figures here to check their work rather than as a substitute.
Net pay here subtracts only the withholding rate you enter. Real paychecks also reflect exact withholding tables, employer and employee taxes and benefit deductions. Treat your payroll statement as the final figure.
The Gross pay formula pays overtime hours at time and a half, a multiplier of 1.5 on the hourly rate. Federal rules set that multiple for most hourly staff on hours over 40 in a workweek, and some states add their own requirements. Confirm which rules apply before you pay anyone.

Docs + Word7 pages
FeaturedFree
Docs + Word21 pages
FeaturedFree
Slides + PowerPoint16 slides
FeaturedFree
Sheets + Excel5 tabs
Free
Sheets + Excel4 tabs
FreeSheets + Excel5 tabs
Free
Sheets + Excel5 tabs
Free
Sheets + Excel4 tabs
FreeSheets + Excel5 tabs
Free
Sheets + Excel3 tabs
Free
Sheets + Excel3 tabs
Free
Sheets + Excel3 tabs
Free