A True Story
When I was an employee, I never thought about how my monthly salary was calculated.
As long as the money showed up in my account at the end of the month, I figured that was that.
It wasn’t until I became a boss that I realized—
paying salaries is about a lot more than transferring money into employees’ accounts. At first, I didn’t even know I had to provide a pay stub every month.
When I actually started calculating payroll, I ran into all sorts of questions:
- How should overtime be calculated?
- Are the rates the same for overtime on regular workdays and rest days? When do you multiply by 1.34, and when by 1.67? It made my head spin.
- How much should be deducted for one day of personal leave?
- How should sick leave be calculated?
How much should be deducted from employees’ pay for labor insurance, employment insurance, and health insurance?
What if an employee starts or leaves during the month? How should their pay be calculated?
There was even a time when we finished calculating payroll and thought, “This should be right, shouldn’t it?”
Then an employee came to us saying their pay didn’t look right. (How embarrassing.)
It’s not just a matter of entering the wrong number in an Excel sheet. It affects the actual amount an employee receives that month: overpay, and the company pays more; underpay, and the employee gets less.
And a pay stub isn’t just something that’s “nice to have.” Employers are required to provide one when paying wages. At a minimum, it should show the total wages, each type of payment, any deductions required by law or agreed upon, and the final amount paid.
How We Do It
We didn’t choose an expensive system. We used what we knew best:
Google Form + Google Spreadsheet
We use Google Forms to collect employee information, attendance, leave, and overtime records. Once submitted, the data syncs to Google Spreadsheet. We store payroll and basic labor and health insurance information in another spreadsheet, then link everything together with formulas. When the source data changes, the payroll calculations update accordingly. Finally, we put together a pay stub for each employee.
After doing this for a while, we thought, “If everything’s already calculated automatically, why are we still emailing the pay stubs one by one?” So we added a menu to Google Spreadsheet. Once payroll is calculated each month, all we have to do is click:
- Generate pay stubs
- The system automatically:
- Generates a PDF pay stub for each employee
- Saves it to Google Drive
- Finds the corresponding employee email address
- Emails the PDF to the employee
And that’s it. What used to take two days of work each month now takes just 15 minutes to check that the information is correct, and we’re done.
With AI, we can now build a complete attendance tracking and payroll system tailored to the needs of a company with just five or six employees. There’s no longer any need to settle for Google Forms and spreadsheets just to save money and handle this tedious task. If you have a need, use the Free AI Estimate below to tell us what you’re looking for.
