Currency

A Currency column stores money with correct formatting and precision. Use it for every monetary value (pay rates, bill rates, reimbursement amounts ) so formulas, rollups, and exports treat money as money.

Illustrative example

Money amounts with proper formatting: pay rates, bill rates, and reimbursements.

01
Table
Placements
02
Field
Bill rate
03
Purpose
Placement specific rate that overrides the role default.

A suggested way to organize your information. This diagram is not a product screen.

When to use this type

1Pay and bill rates on roles, placements, and shifts.
2Reimbursement and adjustment amounts.
3Invoice line values rolled up per client or period.

Column ideas for your team

Placements

Bill rate

Placement specific rate that overrides the role default.

Custom

Amount

The requested value on a reimbursement.

Good to know

1Use Currency instead of Number for anything monetary; formatting mistakes in payroll erode trust fast.
2Placement level rates typically override role defaults; keep the precedence documented in the schema.