Using Rate Sheets

LiquidPlanner rate sheets allow you to associate both a bill rate and a pay rate with various clients, projects, activities, and members.  When you load rates, those rates will be used in timesheet export to calculate totals suitable for billing or cost analysis.  

Workspace owners can create and edit rate sheets at settings > timesheet management > rate sheets:

Creating a Rate Sheet

• Your rate sheet consists of a series of rate rules, one per row.  Each rule specifies the pay rate and billing rate that should be applied when certain conditions are met for a time entry.  
• The pay rate is how much the task owner gets paid for that work, while the billing rate is how much you charge a client for that work.  Rates are formatted as US currency only. 
• The conditions can be any combination of Client, Project, Activity or Person. 
• The order of rules matters!  For a given time entry, LiquidPlanner runs down the rate sheet rules until it finds the first rule that matches the time entry conditions.  It applies the rate for the first rule match only, even if there might be another rule match further down the list.
• Use the up and down arrows next to each rule to arrange the list order of your rules.  

Here's an example of a very simple rate sheet:

Editing a Rate sheet

• Be thoughtful about editing existing rate rules!  When you edit a rule, the new conditions or rates are applied retroactively to all existing time entries.  
  
• It's typically advisable to create a new rule with a new effective date, rather than editing an existing rule. 
• To prevent inadvertent rate sheet edits, you can't edit an existing rule directly via the user interface.  You must export your rate sheet, make the edits in the spreadsheet and then import the rate sheet back in. 

Rates Captured in Timesheet Export