Free Payslip Template Spreadsheet Template for Google Sheets & Excel
Enter the hours, the rates they are paid at, a bonus and the deduction percentages, and gross pay, each deduction and net pay come back on the same sheet. The Free Payslip Template template works out regular pay and overtime pay separately before gross, applies four percentage deductions at rates you set, and takes a flat insurance amount that does not move with gross pay. Ten inputs, ten results. Google Sheets or Excel, one file. No macros, no VBA, no sign-up.
The FinancialAha Free Payslip Template Spreadsheet Template is a one-sheet workbook for Google Sheets and Excel, with a How to Use guide on a second tab. It works as a Free Payslip Template Excel template and a Free Payslip Template Google Sheets template from the same download. This Free Payslip Template spreadsheet template works one pay period out end to end: hours and rates on the left, and gross pay, every deduction and the net figure on the right. No macros, no VBA, no sign-up.
Inside the workbook
What's inside the FinancialAha Free Payslip Template spreadsheet template
The FinancialAha Free Payslip Template Spreadsheet Template runs on one working sheet, with the instructions on a tab of their own. It works in both Microsoft Excel and Google Sheets and here is what the Free Payslip Template spreadsheet holds.
01of 01
Payslip
The single working sheet, and the whole template. Ten figures go in on the left - the regular hours and what they are paid at, any overtime and its rate, a bonus, four deduction rates, and a flat amount for insurance - and ten come back on the right. Regular pay and overtime pay are worked out separately before they are added to the bonus for gross pay, then each deduction is shown on its own line rather than rolled into one number, so the total and the net figure underneath can both be checked against the lines above them. Every rate is a cell you set, which is the point: the sheet does the arithmetic and takes no view on what any rate should be.
Payslip
Included guide
How to Use
A step-by-step guide on its own tab, covering how to replace the sample values, how the deductions are applied, and how to change the currency. Because it ships inside the file, the instructions travel with the template wherever it is opened.
Works in both Google Sheets and Excel
Free Payslip Template Spreadsheet template for Google Sheets
Upload the Free Payslip Template Spreadsheet Template to Drive, right-click it, and choose "Open with Google Sheets". This Free Payslip Template Google Sheets template needs no conversion step and nothing gets rewritten on the way in - the figures recalculate exactly as they do in Excel. The currency dropdown beside the title relabels each money field, and the whole Free Payslip Template spreadsheet is small enough to open instantly.
Free Payslip Template Google Sheets template setup
A shared copy of the Free Payslip Template Google Sheets template works when the person running payroll is not the person checking it, and Sheets version history covers a rate typed over. One screen of figures also makes the Free Payslip Template Spreadsheet Template quick to open on a phone.
Sharing the Free Payslip Template Google Sheet
The Free Payslip Template Google Sheet is a per-period job rather than a daily one: put the hours in, confirm the rates still apply, and read the net figure. Because the Free Payslip Template spreadsheet holds one period at a time, saving a copy per period is how a record gets kept.
Free Payslip Template Spreadsheet template for Excel
The Free Payslip Template spreadsheet Excel download is a plain .xlsx. Excel opens this Free Payslip Template Excel template directly, with no import step and no compatibility prompt, and every figure updates the moment an input changes. There are no macros and no VBA in the file, so it opens without a security warning.
Free Payslip Template Excel template setup
The same Free Payslip Template Excel template opens in Excel on Windows, Excel on Mac, and Excel for the web. It is also the identical file you would upload to Drive, so there is no separate Free Payslip Template spreadsheet download to choose between.
Free Payslip Template spreadsheet Excel notes
The Free Payslip Template spreadsheet Excel file carries no macros and no VBA, so Excel opens it without a trust prompt. The same Free Payslip Template spreadsheet Excel download also opens in Excel for the web, which matters when you move between a work machine and a personal one.
Opening the Free Payslip Template spreadsheet Excel file
Nothing in the Free Payslip Template Excel template is version-specific, so this Free Payslip Template spreadsheet Excel workbook behaves identically in Excel on Windows, Excel on Mac, and older builds.
What the Free Payslip Template spreadsheet template tracks
Everything on the left is yours to set, and everything on the right follows from it. The Free Payslip Template Spreadsheet Template takes no view on any rate:
Regular hours
the hours worked in the period at the standard rate
Hourly rate
what those hours are paid at
Overtime hours
any hours paid at a different rate
Overtime rate
what the overtime hours are paid at
Bonus
a flat amount added to the period
Federal tax rate
a rate you set, applied to gross pay
State tax rate
a rate you set, applied to gross pay
Social Security rate
a rate you set, applied to gross pay
Medicare rate
a rate you set, applied to gross pay
Insurance per period
a flat deduction rather than a percentage
Gross pay auto
derived, regular pay plus overtime pay plus the bonus
Total deductions auto
derived, the four percentage deductions plus the insurance
Net pay auto
derived, gross pay less the total deductions
Compare builds
FinancialAha Payslip Template spreadsheet template: Free, Essentials, and Ultimate compared
5, each a rate you set, including a 401(k) contribution
Flat insurance deduction
Yes
Yes
Employee details
–
Name, ID, department, job title
Pay period
–
Start, end and pay date
Itemised earnings and deductions
–
Yes, with room to add rows
Notes area
–
Yes
Formula cells protected
–
Yes
The FinancialAha Free Payslip Template Spreadsheet Template covers one working sheet and resolves a single pay period to a net figure. It is a calculator rather than a document, which is the honest limit of the Free build: there is nowhere to record who the payslip is for, what period it covers, or anything else about it. The Essentials Payslip Template Spreadsheet Template for Google Sheets and Excel is the one shaped like a payslip you would actually hand over - employee name, ID, department and job title at the top, the pay period and pay date beside them, earnings and deductions itemised with room to add lines, a notes area at the foot, and the formula cells protected so tabbing through cannot break them.
We use Claude AI to draft each template, after a deep research. Then our team steps in. We refine the layout, stress-test every formula, fix edge cases, and polish the design until it feels like something we would actually use ourselves. The AI gets us 80% there. The last 20% is all human judgment.
Excel
Sheets
No signup
Download instantly, no email required
Formula-driven
All calculations update automatically
Dual compatible
Works in Excel and Google Sheets
Sample data included
See the template in action right away
Frequently Asked Questions
What is the difference between the free and Essentials Free Payslip Template spreadsheet template?
Free is a single-sheet starter template with sample data and a How to Use guide. Essentials ($19) is the fuller build - more capacity, more detail, and more worked out for you rather than typed. This template has no Ultimate build. What each tier holds differs by template - the comparison table on every template page lists it exactly.
Which Free Payslip Template spreadsheet template should I download?
Upgrade to Essentials if you want a dashboard with charts, more categories, larger capacity, and a more polished spreadsheet for ongoing use. The Free version is a good fit for one-off planning or trying out the layout.
Can I upgrade the Free Payslip Template spreadsheet template later?
Essentials is a one-time $19 purchase with no subscription. It typically adds a full dashboard, 30-50% more categories or rows than the Free version, and richer formulas. Most buyers upgrade after using the Free version for a few weeks and hitting its limits.
Is the FinancialAha Free Payslip Template Spreadsheet Template a Google Sheets template?
Yes. Upload the file to Drive and choose "Open with Google Sheets". Nothing needs rewriting in the Free Payslip Template Google Sheets template, and the currency dropdown still relabels the money fields.
Is the FinancialAha Free Payslip Template Spreadsheet Template an Excel template?
Yes. The download is a plain .xlsx, so the Free Payslip Template Excel template opens directly in Excel with no import step. There are no macros and no VBA, so it opens without a security warning.
Will the Free Payslip Template spreadsheet Excel file open in older versions of Excel?
Yes. The Free Payslip Template spreadsheet Excel workbook ships as a plain .xlsx, so it opens identically in current Excel and in builds that predate dynamic arrays.
Does the FinancialAha Free Payslip Template Spreadsheet Template record employee and pay period details?
No. The Free build works the pay out as figures - hours and rates in, gross, deductions and net out - with nowhere to record who it is for or which period it covers. The Essentials build is laid out as a payslip you can hand over, with employee details, the pay period, itemised lines and a notes area.
Which deduction rates does the Free Payslip Template spreadsheet use?
Whichever ones you enter. Federal, state, Social Security and Medicare each have a rate cell, and the values that ship in the file are placeholders showing the layout rather than rates that apply to anyone in particular. Set each one to what actually applies.
Can I switch a deduction off in the Free Payslip Template spreadsheet?
Set its rate to 0%. The line stays where it is and the total simply stops counting it, which keeps the layout consistent between periods.
Is the Free Payslip Template spreadsheet safe to download?
Yes. No macros, no sign-up, no tracking. The file is a plain .xlsx that opens directly in Excel or Google Sheets.
How do I open the Free Payslip Template spreadsheet template in Google Sheets?
Upload the .xlsx file to Google Drive, then open it with Google Sheets. All formulas and formatting will be preserved.
Can I use the Free Payslip Template spreadsheet template for commercial work?
All free templates are released under CC BY 4.0 (Creative Commons Attribution). You can use, modify, and share them freely - including for commercial purposes - as long as you credit FinancialAha.com. They are provided as-is and do not constitute financial advice.
