Cross-App Integration: Projects, P&L, & Payroll

Timesheets in SmartERP 19 serve as the central operational bridge between project delivery and financial accounting.

1. Project Commercial Controls & P&L Integration#

Every logged timesheet line links directly to an analytic account (account.analytic.account):

$$\text{Labor Cost Incurred} = \text{Logged Hours} \times \text{Employee Hourly Cost}$$

$$\text{Estimate at Completion (EAC)} = \frac{\text{Actual Labor Cost} + \text{Vendor Bills}}{\text{Percent Complete}}$$

1. Timesheet hours debit the project's work-in-progress (WIP) ledger.
2. On fixed-price milestones, timesheet velocity determines the project's Earned Value (EV).
3. On Time & Materials (T&M) contracts, approved timesheets automatically generate billable customer invoice lines.

2. Monthly Payroll & Overtime Integration#

At the end of each monthly payroll cycle (Day 20 cutoff), the payroll engine queries account.analytic.line and hr.attendance:

+--------------------------------------------------------------------------+
|                     PAYROLL RECONCILIATION ENGINE                        |
+--------------------------------------------------------------------------+
| [Timesheet Hours] <==== Cross-Reconcile ====> [Biometric Check-in Hours] |
|                                |                                         |
|                                v                                         |
|           [Categorize Approved Overtime Categories]                      |
|           - OT_DAY (1.5x)    : Mon-Fri Day Hours > 8.0/day               |
|           - OT_NIGHT (1.75x)  : Mon-Fri 10:00 PM - 06:00 AM              |
|           - OT_REST (2.0x)   : Weekend Hours                             |
|           - OT_HOLIDAY (2.5x): Bahire Hasab National Holidays            |
|                                |                                         |
|                                v                                         |
|           [Inject into Monthly Salary Slip hr.payslip]                   |
+--------------------------------------------------------------------------+

3. Discrepancy Resolution Protocol#

If an employee's logged timesheet hours diverge from biometric attendance by more than 10%, SmartERP flags the payslip line with an Attendance Variance Warning, requiring the HR manager to review turnstile logs before payslip confirmation.