Worker Fee & Payout Model Reference Table

Represents the total calculated compensation owed to a specific user for work performed on a task or project. A Worker Fee aggregates multiple compensation components such as Hourly Fee, Frame Fee, and Fixed Fee.

Reference to the task for which the Worker Fee was generated. Allows tracking cost per task and later aggregation per shot or project.

Reference to the assignee receiving compensation.

Total calculated compensation amount before payout adjustments. This is the sum of all applicable fee components.

Defines how compensation is calculated: Hourly, Frame-based, Fixed, or combined. Determines which fee components are active.

Calculated as: Person Hourly Rate (for Task Type) × Spent Hours. Used when compensation is time-based.

Calculated as: Person Frame Fee (for Task Type) × Working Duration × Frame Fee Multiplier. Used for frame-based compensation.

A flat amount agreed upon for completing a task. Independent of time spent.

Additional compensation granted at the project level. Not tied to a specific task. Used to reward exceptional performance or adjust overall compensation.

User-specific hourly rate for a given Task Type. May differ per project.

User-specific per-frame rate for a given Task Type.

Total hours logged by the user for the task. Used in Hourly Fee calculation.

Total number of frames actually worked on. Used in Frame Fee calculation.

Multiplier applied to frame-based compensation. Default value is 1.

Exchange rate used to convert between User Currency and Project/Studio Currency.

Currency in which the user is paid.

Currency in which the project budget is defined.

Primary accounting currency of the studio.

Worker Fee amount converted into Project Currency using the applicable exchange rate.

Worker Fee amount converted into Studio Currency for financial reporting.

Optional note explaining special adjustments, agreements, or compensation rationale.

Date when the Worker Fee record was created.

Represents an actual payment event. A payout may include one or multiple Worker Fees and may also include adjustments.

Name or identifier for the payout batch (e.g., "June 2024 Freelancer Payments").

Total amount transferred to the user in this payout.

Currency in which the payout was made.

Exchange rate applied at time of payout.

Amount previously paid in advance to the user. Reduces the final payout balance.

Deduction applied during payout to offset previously granted advances.

Date when the payout was executed.

List: Pending Approval, Approved, Postponed, Paid, Cancelled, Failed. Tracks payout lifecycle.

Identifier of accounting document associated with the payout.

Attachment of invoice, contract, or payment confirmation.

Time period covered by the payout (e.g., May 1–May 31).

Calculated as: Bill Price – Worker Fee (converted into project currency). Indicates profitability per task.

Aggregated difference between total invoiced revenue and total Worker Fees within a project.

Calculated effective hourly rate: Worker Fee / Spent Hours. Useful for analyzing profitability and efficiency.

Calculated as Worker Fee / Working Duration. Used for benchmarking frame-based efficiency.

Difference between Invoiced Amount and Studio Currency Amount. Identifies over- or under-margin.