Excel Expert Needed to Build & Manage Weekly Payroll with Employer Tax Calculations (3 Employees + 1 Contractor)
Budget: $25 – $50 USD
Description:
We are seeking an experienced Excel payroll specialist to design, implement, and manage a customized payroll system for a small business with three employees and one independent contractor.
The spreadsheet must accurately calculate employee withholdings and employer tax obligations, including Social Security, Medicare, and unemployment taxes. In addition to building the system, the freelancer will run weekly payroll using data we provide (hours worked, pay rates, etc.) and maintain up-to-date employer tax calculations.
Responsibilities:
Develop a professional Excel-based payroll and tax tracking system.
Automate formulas for:
Gross pay (hourly rate × hours worked)
Employee withholdings: Federal, state, and local (Wisconsin preferred)
Employer taxes:
Social Security (FICA – employer share)
Medicare (employer share)
Federal Unemployment Tax (FUTA)
State Unemployment Tax (SUTA)
Net pay and total employer cost per pay period.
Create a separate worksheet for independent contractor payments (no tax withholdings).
Include Year-to-Date (YTD) tracking for all wages, withholdings, and employer contributions.
Format outputs for printable pay stubs and employer summary reports.
Run weekly payroll with 100% accuracy and confidentiality.
Provide a brief user guide or documentation for updating rates or tax tables.
Qualifications:
Proven experience building payroll systems in Excel or Google Sheets.
Strong understanding of U.S. payroll tax requirements, including both employee and employer obligations.
Experience with Wisconsin or Midwest regional tax structures preferred.
Advanced Excel knowledge (nested formulas, data validation, pivot tables, conditional formatting).
Detail-oriented, trustworthy, and responsive for weekly processing.
(Preferred) Background in accounting, bookkeeping, or small business payroll.
Deliverables:
Fully automated and tested Excel payroll spreadsheet.
Employer tax summary and liability tracking per pay period.
Weekly payroll processing for 3 employees + 1 contractor.
Year-end summary with cumulative totals.
Printable and professional check stubs.
Project Type:
Phase 1: One-time setup of payroll and tax spreadsheet.
Phase 2: Ongoing weekly payroll and employer tax calculations.
Budget:
Please include:
Your estimated cost for initial setup.
Your proposed rate for weekly payroll processing.
We are seeking an experienced Excel payroll specialist to design, implement, and manage a customized payroll system for a small business with three employees and one independent contractor.
The spreadsheet must accurately calculate employee withholdings and employer tax obligations, including Social Security, Medicare, and unemployment taxes. In addition to building the system, the freelancer will run weekly payroll using data we provide (hours worked, pay rates, etc.) and maintain up-to-date employer tax calculations.
Responsibilities:
Develop a professional Excel-based payroll and tax tracking system.
Automate formulas for:
Gross pay (hourly rate × hours worked)
Employee withholdings: Federal, state, and local (Wisconsin preferred)
Employer taxes:
Social Security (FICA – employer share)
Medicare (employer share)
Federal Unemployment Tax (FUTA)
State Unemployment Tax (SUTA)
Net pay and total employer cost per pay period.
Create a separate worksheet for independent contractor payments (no tax withholdings).
Include Year-to-Date (YTD) tracking for all wages, withholdings, and employer contributions.
Format outputs for printable pay stubs and employer summary reports.
Run weekly payroll with 100% accuracy and confidentiality.
Provide a brief user guide or documentation for updating rates or tax tables.
Qualifications:
Proven experience building payroll systems in Excel or Google Sheets.
Strong understanding of U.S. payroll tax requirements, including both employee and employer obligations.
Experience with Wisconsin or Midwest regional tax structures preferred.
Advanced Excel knowledge (nested formulas, data validation, pivot tables, conditional formatting).
Detail-oriented, trustworthy, and responsive for weekly processing.
(Preferred) Background in accounting, bookkeeping, or small business payroll.
Deliverables:
Fully automated and tested Excel payroll spreadsheet.
Employer tax summary and liability tracking per pay period.
Weekly payroll processing for 3 employees + 1 contractor.
Year-end summary with cumulative totals.
Printable and professional check stubs.
Project Type:
Phase 1: One-time setup of payroll and tax spreadsheet.
Phase 2: Ongoing weekly payroll and employer tax calculations.
Budget:
Please include:
Your estimated cost for initial setup.
Your proposed rate for weekly payroll processing.