These cookies are required for the website to function properly. They ensure security, enable basic features like page navigation, and store user session data. You cannot disable these cookies.
- Payroll Processing System
- Payroll data model
The tables behind Payroll Processing System
Payroll Processing System ships with 22 tables, grouped here by the feature that uses them. Every record your team works with lives in one of them, and you can add fields and tables in Proto.
- Tables
- 22
- Features
- 6, plus shared settings
- Change it
- Add fields and tables in Proto
How the model is organised
Payroll setup and compensation
Employees links to Compensation, bank accounts and the employee's pay records. Pay calendars defines cadence, while tax and code references establish the configuration reviewed before calculation.
Timecards and one-time payments
Timecards references Employee, earning code and Approver. One time payments connects Employee and earning code with Manager, payroll approved by and target pay run.
Gross-to-net pay runs
Pay runs contains pay run items through the pay run reference; each item points to Employee and Compensation. Payslip lines connects detail to pay run item and the applicable earning, deduction or jurisdiction reference.
Benefits and garnishments
Benefit deductions references Employee and deduction code. Garnishments references Employee and retains its own order limits and remaining balance.
Payslips and tax forms
Payslips references Employee, pay run item and bank account. Tax forms references Employee and tax jurisdiction. File locations require separate document access checks.
Settlement and payroll accounting
Bank payment confirmations references pay run. Journal entry lines belongs to journal entries, whose pay run reference provides the source cycle. GL account map supplies the account targets used by earning and deduction codes.
Every table, by feature
- Payroll setup and compensation9
- Timecards and one-time payments6
- Gross-to-net pay runs10
- Benefits and garnishments7
- Payslips and tax forms8
- Settlement and payroll accounting9
- Shared and settings1
- Employees
Workforce master for payroll: who is paid, in which department and location, who approves them, and their employment status. Landing table for the Core HR inbound feed.
Linked to Employees - Compensation
Versioned per-employee comp record. Pay Runs read the row in effect on the pay-period end date.
Linked to Employees, Pay calendars, Tax jurisdictions, Compensation - Pay calendars
Pay-period schedules that drive Pay Run cadence, cutoffs and pay dates.
- Bank accounts
Employee direct deposit accounts with split allocation rules. Masked except to the employee and the payroll manager.
Linked to Employees - Earning codes
Catalog of earning categories with tax, pension and overtime flags and GL targets.
Linked to GL account map - Deduction codes
Catalog of deduction categories with pre-tax, employer-match and GL targets.
Linked to GL account map - Tax jurisdictions
Federal, state and local withholding jurisdictions with filing frequency and filing partner.
Linked to Tax jurisdictions - GL account map
Maps earning and deduction codes to GL accounts so pay-run posting is deterministic.
- Exchange rates
Read-only effective exchange rates for this app.
- Timecards
Hours worked per period per employee per earning code, from the Time and Attendance feed or entered in app.
Linked to Employees, Earning codes - One time payments
Bonuses, commissions, awards, severance and reimbursements routed through Manager then Payroll approval.
Linked to Employees, Earning codes, Pay runs - Employees
Workforce master for payroll: who is paid, in which department and location, who approves them, and their employment status. Landing table for the Core HR inbound feed.
Linked to Employees - Earning codes
Catalog of earning categories with tax, pension and overtime flags and GL targets.
Linked to GL account map - Pay calendars
Pay-period schedules that drive Pay Run cadence, cutoffs and pay dates.
- Pay runs
A pay-period aggregation and the unit of payroll work: Draft through Reviewed, Approved, Paid and Posted.
Linked to Pay calendars, Employees, Journal entries
- Pay runs
A pay-period aggregation and the unit of payroll work: Draft through Reviewed, Approved, Paid and Posted.
Linked to Pay calendars, Employees, Journal entries - Pay run items
One row per employee per pay run: the gross-to-net header that drives the payslip.
Linked to Pay runs, Employees, Compensation - Payslip lines
The exploded gross-to-net detail per employee per pay run: the audit grain.
Linked to Earning codes, Deduction codes, Pay run items, Tax jurisdictions - Compensation
Versioned per-employee comp record. Pay Runs read the row in effect on the pay-period end date.
Linked to Employees, Pay calendars, Tax jurisdictions, Compensation - Employees
Workforce master for payroll: who is paid, in which department and location, who approves them, and their employment status. Landing table for the Core HR inbound feed.
Linked to Employees - Timecards
Hours worked per period per employee per earning code, from the Time and Attendance feed or entered in app.
Linked to Employees, Earning codes - Earning codes
Catalog of earning categories with tax, pension and overtime flags and GL targets.
Linked to GL account map - Deduction codes
Catalog of deduction categories with pre-tax, employer-match and GL targets.
Linked to GL account map - Pay calendars
Pay-period schedules that drive Pay Run cadence, cutoffs and pay dates.
- Tax jurisdictions
Federal, state and local withholding jurisdictions with filing frequency and filing partner.
Linked to Tax jurisdictions
- Benefit deductions
Per-employee benefit elections feeding the deduction side of each pay run.
Linked to Employees, Deduction codes - Deduction codes
Catalog of deduction categories with pre-tax, employer-match and GL targets.
Linked to GL account map - Garnishments
Court-ordered and statutory deductions with caps, priority and remaining balance.
Linked to Employees - Employees
Workforce master for payroll: who is paid, in which department and location, who approves them, and their employment status. Landing table for the Core HR inbound feed.
Linked to Employees - Pay run items
One row per employee per pay run: the gross-to-net header that drives the payslip.
Linked to Pay runs, Employees, Compensation - Payslip lines
The exploded gross-to-net detail per employee per pay run: the audit grain.
Linked to Earning codes, Deduction codes, Pay run items, Tax jurisdictions - GL account map
Maps earning and deduction codes to GL accounts so pay-run posting is deterministic.
- Payslips
The employee-facing payslip artifact for a pay period, generated on pay run approval.
Linked to Pay run items, Employees, Bank accounts - Payslip lines
The exploded gross-to-net detail per employee per pay run: the audit grain.
Linked to Earning codes, Deduction codes, Pay run items, Tax jurisdictions - Pay run items
One row per employee per pay run: the gross-to-net header that drives the payslip.
Linked to Pay runs, Employees, Compensation - Pay runs
A pay-period aggregation and the unit of payroll work: Draft through Reviewed, Approved, Paid and Posted.
Linked to Pay calendars, Employees, Journal entries - Employees
Workforce master for payroll: who is paid, in which department and location, who approves them, and their employment status. Landing table for the Core HR inbound feed.
Linked to Employees - Bank accounts
Employee direct deposit accounts with split allocation rules. Masked except to the employee and the payroll manager.
Linked to Employees - Tax forms
Year-end and event tax artifacts issued per employee per tax year per jurisdiction.
Linked to Employees, Tax jurisdictions - Tax jurisdictions
Federal, state and local withholding jurisdictions with filing frequency and filing partner.
Linked to Tax jurisdictions
- Bank payment confirmations
Inbound bank payment confirmations. One row per confirmed settlement of a pay run: the evidence that funds actually left the company. WF-04 payrun-settlement fires on a new row here and moves the linked Pay Run to Paid.
Linked to Pay runs - Pay runs
A pay-period aggregation and the unit of payroll work: Draft through Reviewed, Approved, Paid and Posted.
Linked to Pay calendars, Employees, Journal entries - Pay run items
One row per employee per pay run: the gross-to-net header that drives the payslip.
Linked to Pay runs, Employees, Compensation - Payslip lines
The exploded gross-to-net detail per employee per pay run: the audit grain.
Linked to Earning codes, Deduction codes, Pay run items, Tax jurisdictions - Journal entries
Balanced GL posting header for each pay run.
Linked to Pay runs, Employees - Journal entry lines
One debit or credit line per GL account target, rolled up across the run.
Linked to Journal entries - GL account map
Maps earning and deduction codes to GL accounts so pay-run posting is deterministic.
- Earning codes
Catalog of earning categories with tax, pension and overtime flags and GL targets.
Linked to GL account map - Deduction codes
Catalog of deduction categories with pre-tax, employer-match and GL targets.
Linked to GL account map
Keys and references
Use the exact record identifiers and reference targets supplied by the app. Employee ID and core HR employee ID support agreed employee matching; do not replace references with similarly named people. Pay run number, payslip number and journal entry number explain the operational context but do not substitute for the stored links.
The operational screens draw on the underlying employee and payroll records. Users holds account names, email and role values, with its own User reference. Agree how accounts resolve to Employees before granting self-service access so the employee can retrieve the correct pay and tax artifacts.
Migration order
- Reference configuration. Prepare GL account map, earning codes, deduction codes, tax jurisdictions and pay calendars with the verified business rules.
- Employee context. Match Employees and import authorized Compensation and bank accounts with their references and dated approval information.
- Source inputs. Prepare Timecards, benefit deductions, Garnishments and one time payments with actual source decisions and effective dates.
- Payroll detail. Rehearse pay runs computation and inspect pay run items and payslip lines; avoid importing duplicate calculated children over an existing run.
- Artifacts and evidence. Verify Payslips and tax forms documents, then configure controlled bank payment confirmations intake and reconcile journal entries and journal entry lines.
Set up Payroll Processing System your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.