Google Sheets automation · portfolio sample

Payroll & Commission Calculator

Turns two weeks of timesheets and sales into gross pay for every employee: weekly overtime, salaries and tiered commission. Before anything is submitted, it points out the rows a person should check.

Based on the monthly pay sheet I run for the staff of my own building-supply stores. The people and amounts below are fictional example data.

% to
$
then %
Gross pay  
Overtime  
Commission  
To check  

Payroll register

Select a row to see that person’s pay stub.
EmployeeStoreRegular hOvertime hWagesSalarySalesCommissionGross payCheck

Check before you submit

The data behind it

Try it: fix a name, change hours or remove a row. Everything above updates as you type.

Pay stub


      


      

      

        
Planted in the sample

        

        
    
      
    
    
    
  
    

  
    
    
    How it runs in Google Sheets
    
    
      
      
    1. Employees tab
      Name, store, hourly or salary, the rate, and whether they earn commission.
      2. 
      
    2. Timesheet & Sales
      Paste the time-clock export and the sales-by-employee report. Hours like 7:45 or 7.75 both work.
      3. 
      
    3. Calculate
      One menu click fills a Payroll tab, a list of items to check, and a pay stub for each person.
      4. 
      
    4. Submit
      Copy the register into Gusto, QuickBooks Payroll or ADP, then move the sheet to the next period.
      5. 
    
    
    
    
      
    Permissions
    This spreadsheet only, its own menu, and sending the summary from your account. It cannot open anything else in your Google Drive.
    
      
    Tested
    19 automated tests cover weekly overtime, salaried staff, tiered commission, duplicate and misspelt rows, US and day-first dates, and a simulated Google Sheets run.
    
    
    
    
    Shows gross pay before taxes and deductions; those stay with the payroll provider, which keeps up with each state’s rules.