Team & time
Hours, attendance and time off, tracked without a payroll system. For small employers with a handful of people, who need overtime and leave balances to be right at the end of the pay run.
Checking one week before you buy? The free time card calculator adds up the shifts, and the overtime calculator settles each week separately, the way overtime is owed.
The templates side by side
Every one works in Excel and Google Sheets. "You type into" counts the tabs where your numbers go; "calculated for you" counts the tabs that need no typing at all, and "set up once" the tabs you fill in at the start.
| Template | Tabs | You type into | Calculated for you | Set up once | Price |
|---|---|---|---|---|---|
| Small Business Bookkeeping (Income/Expense) | 9 | 3 | 4 | 2 | $4.79 |
| 1099 / Schedule C Self-Employed Tax Spreadsheet | 9 | 2 | 5 | 2 | $3.80 |
| S-Corp Reasonable Salary & Distribution Optimizer (US) | 8 | 1 | 5 | 2 | $8.69 |
| Mileage Tracker | 8 | 2 | 4 | 2 | $2.81 |
| Business Budget Spreadsheet | 6 | 2 | 2 | 2 | $3.29 |
| Profit & Loss Statement Generator | 7 | 2 | 3 | 2 | $3.80 |
| Pricing Calculator | 7 | 2 | 3 | 2 | $4.49 |
| Inventory Tracker | 6 | 2 | 2 | 2 | $2.69 |
| Employee Timesheet | 6 | 2 | 2 | 2 | $3.29 |
| Invoice Tracker & Generator | 8 | 3 | 3 | 2 | $2.99 |
| Cash Flow Spreadsheet | 8 | 4 | 2 | 2 | $3.29 |
| Employee Attendance and PTO Tracker | 6 | 2 | 2 | 2 | $3.29 |
| Client Tracker & CRM | 7 | 2 | 3 | 2 | $5.69 |
| Business Expense Tracker | 8 | 2 | 4 | 2 | $1.79 |
| Product Profit Tracker | 6 | 1 | 2 | 3 | $2.69 |
Which template do I need?
Two records have to agree at the end of the month: what people worked, and what they have left. Shifts and overtime calculated rather than estimated is the first. Leave balances that stay current as absences are recorded is the second.
Buying them together covers up to 20 employees, 500 shifts and 300 absences, which is most small employers.
What federal law asks of an employer
Under the Fair Labor Standards Act, non-exempt staff are paid time and a half for hours over 40 in a workweek. Payroll records have to be kept for at least 3 years, and the time cards behind them for at least 2. (29 CFR 516)
Federal law does not require paid vacation or paid holidays; those come from your own policy or a contract, and some states set their own rules on paying out unused vacation. (DOL: vacation leave)
For one-off sums, the free time card, overtime and PTO accrual calculators each answer a single week or a single balance in the browser.