Skip to main content
Command Established

Member Pay Rates for Payroll

The payroll report counts hours, and pay codes sort those hours into the kinds your payroll service pays differently: REG, OT, WKD and so on. Pay rates add the last piece: what each member is paid an hour under each code. With them, the report and its exports show what to pay, not just how many hours.

Pay rates are optional. Until you set any, the report and every export work exactly as before, with no pay columns.

Before you start

Pay rates are set per pay code, so your department needs pay codes first. Set them up under Settings › Payroll › Pay codes (see Pay codes). Until it has some, the Pay Rates section doesn't appear on personnel records.

Each code has its own hourly rate. If you pay overtime at time and a half, the overtime code's rate is one and a half times the member's regular rate. You can type that amount, or enter a formula such as #REG * 1.5 and let it follow the regular rate. Weekend, holiday and other differential codes work the same way.

Who can see and set pay rates

  • Admins and Owners set and change every member's rates.
  • Anyone with Payroll read access can see every member's rates, since they see the priced report anyway. They can't change them. Payroll update access covers the department's pay rules, not what each member earns.
  • Each member can see their own rates on their personnel record, read-only.

Everyone else never sees a member's rates. They don't appear on the roster, in search, or on anyone else's screen.

Setting a member's rates

  1. Open the member's personnel record. Pay Rates is on the Details tab.
  2. Click Set rates (or Add change once they have some).
  3. Choose Effective from: the first payroll day the rates apply to.
  4. Enter an hourly rate for each code the member is paid under, as an amount or a formula. Leave a code blank if they aren't paid under it.
  5. Click Save rates.

A new change starts from the rates the member has today, so for a raise you only edit the codes that change.

Adding a pay rate change: the date it takes effect, then an hourly rate for each of the department's pay codes, with Standby left blank

Formulas

A rate box works like a spreadsheet cell: type an amount, or a formula that works the amount out.

  • Add things up. 23.50 + 2.00 is a base rate and a stipend, kept apart so you can see each.
  • Follow another code. #REG * 1.5 is one and a half times whatever the member's REG rate is. Type # and the code's export code, in any case.
  • Combine them. Use +, -, *, / and parentheses: (#REG + 1.25) * 1.5.

The box shows what the formula comes to, with the formula underneath. Click into it to change the formula. On the member's record, the formula is listed under the rate it produced.

A pay rate change entered with formulas: Regular is 24.50 + 2.00, and Overtime, in focus, shows its formula #REG * 1.5 with the $39.75 it comes to underneath

A formula reads the other codes in the same rate change. So when a raise comes, add a change, edit the base rate, and every rate worked out from it follows.

Each rate is rounded to the cent, with half a cent rounding up, and a formula that reads another code reads its rounded rate. 23.37 * 1.5 is 35.055, so the rate is $35.06.

If a formula can't be worked out, the box says why and the change won't save until it's fixed. That covers a typing mistake, a code that has no rate, or two rates that each depend on the other.

Formulas are a convenience for entering rates. The payroll report and the exports show and use the rate each formula came to, exactly as if you had typed it.

Raises and history

Rates are effective-dated. Each change is the member's complete set of rates from its date until the next change:

  • Current is the change in effect today.
  • Upcoming is a change dated in the future. Enter a raise ahead of time and it takes effect by itself.
  • Show earlier rates lists the history behind the current rates.

A member's pay rates: the current rates since January 1, a raise starting next January, and the earlier rates below. Each lists its rate per pay code, and the codes the member has no rate for.

Because every hour is priced at the rate in effect on the payroll day it was worked, a raise never reprices the past. Re-running a pay period from before the raise gives the same amounts it did then. A pay period that spans a raise prices the days before it at the old rate and the days after at the new one.

To fix a mistake, edit the change, or remove it with the bin icon. Removing a change means its days are priced at the change before it, so re-exported periods change to match. Every save is recorded in the activity log.

What the payroll report shows

Once any member has rates, the payroll report adds a Pay column beside Paid hours: each member's coded hours priced at their rates. Hours the report couldn't price are called out under the amount, such as 12.0h unpriced. That's paid time with no pay code (a time-off type you haven't coded, say) or under a code the member has no rate for on that day. So a partial total is never mistaken for the whole.

The payroll report with the Pay column beside Paid hours. A member with no rates shows $0.00 and 96.7h unpriced; another shows 12.0h unpriced under their amount.

Click a member's name for their timesheet. Its Pay section breaks the amount down by code, hours, rate and amount, with a row per rate when their rate changed during the period.

A timesheet's Pay section: Regular and Weekend hours, each with its rate and amount, and the total

Each amount is worked out from the exact minutes and rounded to the cent once, so it can differ by a cent or two from the rounded hours shown times the rate. The amounts always add up to the total.

What the exports include

Pay columns appear in every export once any member in your department has rates, and always come last, so an import mapping set up before rates still lines up:

  • Summary: pay_amount and unpriced_hours for each member.
  • Pay codes: pay_rate and amount on each row. A member whose rate changed in the period gets a row per rate, and hours under a code with no rate get a row with both left blank.
  • Time segments: pay_rate, the member's rate for the segment's code on its day.

Amounts are plain numbers with two decimals and no dollar sign (1234.50), the way payroll importers expect them. Day by day shows hours only.

Questions

Does Command Established run payroll? No. It works out hours and, with rates, amounts. Your payroll service still pays people, withholds tax and handles deductions.

What about salaried members? Leave them without rates, or give them only the codes paid by the hour. Their hours still show, as unpriced.

We removed a pay code. What happens to rates under it? They stop pricing anything, since no hours are coded to it, and they no longer show on the member's record. They stay in the history, so if you add the code back, its rates come back with it. A formula that read the removed code keeps the rate it came to. The next time you edit that rate change, the formula asks to be fixed, since the code it named is gone.

What can an export code be? One to six letters, such as REG or OT, and each pay code needs its own. A formula names a code by it, so it has to be a single short word. If one of yours is longer, has digits or punctuation, or matches another code's, Settings asks you to change it the next time you save your pay codes.