How Do You Track Employee Advances and Overtime? A Guide to Recurring Salary Setup, Advance Offsetting, Overtime Calculation, Bonuses and the Personnel Expense Report
How do you track employee advances and overtime? Recurring salary setup, advance offsetting, overtime calculation, bonuses and the personnel expense report: an 8-lesson guide with examples.
Contents 14 sections
- What will you be able to do by the end of this training?
- Lesson 1: What does employee tracking solve, and what doesn't it?
- Lesson 2: How do you add employees and assign permissions?
- Lesson 3: How do you set up salary payments with a recurring setting?
- Lesson 4: How do you give and offset an advance?
- Lesson 5: How do you calculate and record overtime?
- Lesson 6: How do you track sales bonuses?
- Lesson 7: How do you record employee expenses and leave?
- Lesson 8: How do you prepare the month-end personnel expense report?
- What are the most common mistakes in employee tracking?
- How does NetKasam make employee tracking easier?
- Mini quiz: Test what you have learned
- Conclusion: Gather your advance and overtime records in a single list this month
- Frequently Asked Questions About Tracking Employee Advances and Overtime
Advances are in a notebook, bonuses in another spreadsheet and overtime stays verbal. At month end, an employee asks, "How much was I paid in total this month?" and the answer is pieced together from three different places. Someone forgets the advance, someone counts overtime twice and inconsistencies appear during the salary payment. In a small business, personnel records mostly show up on the expense side; when they are kept scattered, they become the source of disputes with both employees and the accountant.
This article is not just an explanation; it is an 8-lesson hands-on training. We will answer the question how do you track employee advances and overtime with numbers, using an example team of six: record-keeping and permissions, salaries and recurring settings, giving and offsetting advances, calculating overtime, bonuses, recording employee expenses and leave, and the month-end personnel expense report. At the end there is a mini quiz and an answer key. To calculate the total cost of staff, see the article how to calculate personnel cost; here we focus on the day-to-day recording and tracking routine.
What will you be able to do by the end of this training?
In short: You will define employees and their permissions, set up salaries with a recurring setting, give and offset advances, calculate overtime, track bonuses and report personnel expense at month end.
- 01RecordAdd the employee as a user and assign permissions.
- 02SalarySet up the regular payment with a recurring setting.
- 03AdvanceRecord the advance given.
- 04OvertimeWrite down overtime hours and amount.
- 05BonusTrack earnings from sales.
- 06ReportProduce the month-end personnel expense.
The 8 lessons of this training: (1) purpose and limits, (2) employee records and permissions, (3) salary and recurring settings, (4) advances and offsetting, (5) overtime, (6) bonuses, (7) employee expenses and leave, (8) the month-end personnel expense report.
Lesson 1: What does employee tracking solve, and what doesn't it?
In short: Employee tracking keeps an orderly record of payments made to employees. Official payroll, Social Security Institution (SGK) declarations and tax calculations are a separate job and the responsibility of your certified public accountant (mali müşavir).
| Without tracking | With tracking |
|---|---|
| Advances in a notebook, bonuses in a spreadsheet | All in a single record |
| Overtime stays verbal | Hours and amounts in writing |
| Hunting for totals at month end | Totals read from the report |
| Disputes with employees over amounts | The record settles the dispute |
In NetKasam, personnel data sits in the same place as bookkeeping; salaries, bonuses and advances are reported together with expenses. There is no limit on the number of users; you can manage your team with an unlimited number of users for free. For what payroll is, see the article what is a payroll and how is it prepared, and for the feature scope, the user and employee management page. Example business: a store with six employees; four receive salaries and advances, three work overtime and two earn sales bonuses.
Lesson 2: How do you add employees and assign permissions?
In short: Add the employee as a user from the general settings or invite them by email; assign permissions that fit their role. Do not give anyone more than they need for their job.
| Role | Access needed | Unnecessary access |
|---|---|---|
| Cashier | Cash register and sales screen | Salary, revenue and profit reports |
| Warehouse manager | Inventory and transfers | Staff payments |
| Accounting | Expenses, accounts, personnel payments | System settings |
| Management | All | – |
Predefined user groups and permissions come with your subscription; you can change them. Every transaction record is kept in the system and cannot be deleted; in a dispute, who did what can be seen retrospectively. With IP restriction, you can limit logins to the workplace network only. Salary and advance information is sensitive: only management and accounting should access these records. For details on permissions, see the article how to set user permissions.
Lesson 3: How do you set up salary payments with a recurring setting?
In short: Define the employee's salary and payment day once with a recurring setting; regular payments are generated by the system, and you do not enter a voucher by hand every month.
| Employee | Monthly salary | Days payable |
|---|---|---|
| Employee A | 30.000 ₺ | The 5th of the month |
| Employee B | 32.000 ₺ | The 5th of the month |
| Employee C | 28.000 ₺ | The 5th of the month |
| Employee D | 36.000 ₺ | The 5th of the month |
| Total | 126.000 ₺ | – |
A recurring setting keeps salaries from being forgotten and saves entering the same record by hand every month. When a salary changes, you just update the setting; past records stay in place. The amounts in the table are sample values; whether the salary is gross or net, and the SGK and tax deductions, are determined by payroll. For how salary payments are reflected in expense records, see the expense management page, and for the same logic with regular invoices, the article how to set up a recurring invoice.
Lesson 4: How do you give and offset an advance?
In short: Record every advance given with its date, amount and reason. On payday, deduct the advance from the salary to find the amount to be paid.
| Employee | Salary | Advance | To be paid |
|---|---|---|---|
| Employee A | 30.000 ₺ | 5.000 ₺ | 25.000 ₺ |
| Employee B | 32.000 ₺ | 8.000 ₺ | 24.000 ₺ |
| Employee C | 28.000 ₺ | 6.000 ₺ | 22.000 ₺ |
| Employee D | 36.000 ₺ | 7.000 ₺ | 29.000 ₺ |
| Total | 126.000 ₺ | 26.000 ₺ | 100.000 ₺ |
- Total salaries (4 employees)₺126,000
- Employee A advance−₺5,000
- Employee B advance−₺8,000
- Employee C advance−₺6,000
- Employee D advance−₺7,000
- To be paid (after deducting advances)₺100,000
Prepared with sample values. Total advances ₺26,000.
For each employee, salary minus advance gives the amount to be paid; the four advances total ₺26,000, and 126,000 − 26,000 = ₺100,000. Agree in writing with the employee on the month in which the advance will be offset and the number of installments (all at once or over three months); that way, no "I didn't think you would deduct this" dispute arises later.
If advances have become large or frequent, this is not an expense item but a cash flow signal: the employee may be unable to make ends meet on their salary, or the business may have made early payment a habit. At month end, read the total advances from the report (here ₺26,000, about 20.6% of salaries) and track the trend. Consult your certified public accountant (mali müşavir) about the legal limits and tax consequences of advances.
Lesson 5: How do you calculate and record overtime?
In short: Write down overtime hours per employee, then multiply by the hourly wage and the multiplier the business applies. Settle the multiplier and legal conditions with your certified public accountant (mali müşavir).
- Salary to be paid = Salary − Advance offset
- Overtime hourly rate = Hourly wage × Overtime multiplier
- Overtime amount = Overtime hours × Overtime hourly rate
- Personnel expense = Salary + Overtime + Bonus (excluding SGK and taxes)
Prepared with sample values.
Example: hourly wage ₺200, overtime multiplier applied by the business 1.5 (sample value; set your own multiplier according to the legislation). Overtime hourly rate 200 × 1.5 = ₺300.
| Employee | Overtime hours | Hourly rate | Overtime amount |
|---|---|---|---|
| Employee A | 12 | 300 ₺ | 3.600 ₺ |
| Employee B | 14 | 300 ₺ | 4.200 ₺ |
| Employee C | 10 | 300 ₺ | 3.000 ₺ |
| Total | 36 | – | 10.800 ₺ |
- Employee A₺1233.3%
- Employee B₺1438.9%
- Employee C₺1027.8%
Prepared with sample values. Employee B worked 38.9% of the total.
Recording overtime every month is not enough; write down the reason too: a busy campaign week, understaffing, a stock count. If the same employee works heavy overtime month after month, the problem is not the employee but the workload distribution. For the legal calculation of overtime pay, its limits and time off in lieu, see the article what is overtime pay and how is it calculated; the 1.5 multiplier in this article is only meant to show how the calculation is set up.
Lesson 6: How do you track sales bonuses?
In short: First, clarify the bonus rule: which sales are covered, and is the rate fixed or tiered? In NetKasam, bonuses are defined per employee, and earnings are generated automatically from sales.
| Bonus rule | Example | Note |
|---|---|---|
| Fixed rate | 1% of sales | Are returned sales deducted from the bonus? |
| Tiered rate | Higher rate above the target | Put the tiers in writing |
| Product-based | A different rate for a specific product group | Clarify the scope |
Example: the two employees eligible for bonuses had total sales of ₺400,000 in the period, and the business applies a 1% bonus; the bonus earned is ₺4,000. The figure is a sample value; you set your own bonus rates. Putting the bonus rule in writing is the most important step: if the rule is unclear, even an automatic calculation causes disputes. For details of bonus systems, see the article how to calculate sales bonuses. Linking bonus payments to expense records makes it easier to report personnel expense at the end of the period.
Lesson 7: How do you record employee expenses and leave?
In short: The employee enters out-of-pocket spending made on behalf of the company themselves, from mobile or a computer, and uploads the receipt or invoice. Record leave in the same place as well.
| Recording | Who enters it? | Document |
|---|---|---|
| Employee spending | Employee | Receipt or invoice |
| Advance | Accounting | Advance record |
| Overtime | Accounting, with manager approval | Overtime timesheet |
| Leave | Manager or accounting | Leave request |
When an employee enters their spending, the employee who incurred the expense is selected on the expense voucher, so the report can be filtered by employee. For detailed expense tracking, see the article how to track employee expenses, and for employee-based expense reports, the article how to run branch and employee reports. Do not confuse an employee's out-of-pocket spending with an advance: one is the business's debt to the employee, the other the employee's debt to the business; the two are settled separately at month end.
Recommended readingHow to Track Employee Expenses?Lesson 8: How do you prepare the month-end personnel expense report?
In short: Gather salaries, overtime and bonuses in a single table; show advances and the amount to be paid separately. The report answers "how much did we spend on staff this month" at a glance.
| Item | Amount | Share |
|---|---|---|
| Salary | 126.000 ₺ | %89,5 |
| Overtime | 10.800 ₺ | %7,7 |
| Bonus | 4.000 ₺ | %2,8 |
| Total personnel expense | 140.800 ₺ | %100 |
- Salaries₺126,000
- Overtime₺10,800
- Bonuses₺4,000
Prepared with sample values. Total ₺140,800 (excluding SGK and taxes).
- ₺126,000total salaries of four employees
- ₺26,000advances given; ₺100,000 to be paid after offsetting
- ₺10,80036 hours of overtime
- ₺140,800total personnel expense (excluding SGK and taxes)
For the report to be useful, run it the same way every month: the same items, the same period boundaries. With salaries at 89.5%, overtime rising to 7.7% is a sign of understaffing. Use the reports screen to save reports, export them to Excel and share them with your accountant. For where personnel expense fits in overall expense analysis, see the article how to do expense analysis.
At month end, also use an internal checklist: have all advances been offset, have overtime hours been approved by a manager, do bonus earnings match the sales report, are employee expenses documented? Do not close the personnel file until these four questions are answered. For the general order of month-end closing, see the article how to do month-end closing.
What are the most common mistakes in employee tracking?
- Not recording advances. A dispute over amounts arises on payday.
- Not putting the offset terms in writing. Whether it is all at once or in installments stays unclear.
- Leaving overtime verbal. Hours and amounts get lost.
- Guessing the overtime multiplier. The legal calculation may come out differently.
- Leaving the bonus rule unclear. The automatic calculation creates disputes.
- Opening personnel records to everyone. Salary information spreads unnecessarily.
- Mistaking the system for payroll. Official payroll and SGK run separately.
How does NetKasam make employee tracking easier?
- Salary, SGK, bonus and overtime tracking. Employee-related costs are tracked in the same place as bookkeeping (user and employee management).
- Recurring setting. Regular payments such as salaries are generated by the system.
- Advance tracking. Advances given to staff are recorded.
- Bonus earnings. Bonuses are defined per employee, and earnings are calculated automatically from sales.
- Employee expenses. The employee enters expenses from mobile or a computer and uploads the receipt or invoice (expense management).
- Permissions and transaction log. Report access is restricted, every transaction is recorded in a way that cannot be deleted, and IP restriction can be applied.
- Unlimited users. You manage your team for free; bookkeeping is free, and for the scope, see the pricing page.
Mini quiz: Test what you have learned
In short: Answer the 5 questions below, then compare with the answer key. 4 or 5 correct shows you have completed the training.
- If the salary is ₺40,000 and the advance is ₺9,000, what is the amount to be paid on payday?
- If the hourly wage is ₺250 and the overtime multiplier is 1.5, what is the pay for one overtime hour?
- If this employee worked 8 hours of overtime, what is the overtime amount?
- If sales for the period are ₺300,000 and the bonus rate is 1%, what is the bonus earned?
- Why shouldn't everyone have access to personnel records?
Answer key:
- 40.000 − 9.000 = 31.000 ₺.
- 250 × 1,5 = 375 ₺.
- 8 × 375 = 3.000 ₺.
- 300.000 × 0,01 = 3.000 ₺.
- Salary and advance information is sensitive; spreading it unnecessarily damages employee relations and trust.
Frequently Asked Questions About Tracking Employee Advances and Overtime
Can staff salaries and bonuses be tracked in NetKasam?
Yes. Salary, SGK, bonus and overtime spending can be tracked; with bonus definitions, bonus entitlements from sales are calculated automatically.
How is an advance recorded?
Advances given to employees are recorded and tracked; on payday, the advance is deducted to find the amount to be paid.
Does NetKasam replace official payroll?
No. These features do not replace a payroll program that prepares official payroll and Social Security Institution (SGK) declarations.
How is overtime calculated?
It is overtime hours multiplied by the hourly wage and the overtime multiplier; the multiplier and legal conditions depend on legislation, so consult your certified public accountant (mali müşavir).
Can staff enter their own expenses into the system?
Yes. Employees can enter their expenses by mobile phone or computer and upload receipts and invoices to the system.
Do salary payments have to be entered by hand every month?
No. Regular payments such as salaries are defined with a recurring setting and generated by the system.
Can I see what users are doing?
Yes. Every transaction record is kept in the system and cannot be deleted; users' full transaction log can be monitored.
Is there a user limit?
No. You can manage your team with an unlimited number of users for free.
Conclusion: Gather your advance and overtime records in a single list this month
The smallest step you can take this month is this: combine the information in your advance notebook, your overtime notes and your bonus spreadsheet into a single list. Fill in the salary, advance, overtime and bonus columns for each employee; calculate the amount to be paid and compare the total with the previous month. Then move these items into the system: set up salaries with a recurring setting, advances as records and bonuses as definitions. At the end of next month, the answer to "how much did we pay this employee in total" will be one report away.
Bookkeeping Is Now Completely Free
Manage your bookkeeping and e-Invoice operations with NetKasam without paying a thing. Customer and supplier accounts, inventory, collections and more in one panel, completely free.