Help > Tracking Time > Using Rate Sheets
LiquidPlanner has the ability to load rate rules which will allow you to associate both bill rate and pay rate with various clients, projects, activities, and members.
When you load rates, those rates will be used on timesheet export to calculate totals suitable for billing or cost analysis.
Example timesheet export using rate information:

The rate sheet feature is currently flagged as beta because the user interface is not as simple as it should be yet. In short, the user interface is a spreadsheet. On the other hard it's pretty powerful and we wanted to make this available to people as we work on our larger budgeting feature set.
Example of a simple rate sheet:

Try editing a rate sheet
First you'll have to find it and it's a bit hidden. Go to settings | timesheets and look way down by the bottom for the Rate Sheet Setup button.

Once you find it and click it you'll want to get the hang of the updating process which is simply 1) export the current rules to a file, 2) edit the file, and 3) import the file.

The rate sheet file had three parts. Part 1 contains the actual rules which you will edit and extend by adding similar rows. Parts 2 and 3 are informational.
The lists in Part 3 are very important because you must copy and past the names exactly as shown into the corresponding rule column in Part 1 to build rules for specific clients, projects, activities, or members. (The numbers are internal object IDs in case you are curious.)
While you may be tempted to master the rate sheet outside of LiquidPlanner (a good idea for backup), you will still need to export the ratesheet to pick up any new clients, projects, activities, or members.
Tip: set the default rate to $0 so it stands out like a sore thumb (rates must be positive numbers).

You'll probably need to practice a bid to get the hang of it. One helpful feature is that you can name the rule in the rate sheet and this rule name will show up as a tool tip if you hover your mouse over the rule on the timesheet export preview like this:

If this is all as clear as mud but you really want to give it a go, contact support for more help.


