Rate Card Management

Modified on Fri, 17 Mar 2023 at 09:21 AM

User roles:  ✔ Financial Administrator


Rate cards are applied to project resources in order to establish their forecast and cost to the projects they are assigned to.


Rate cards are used to calculate:


Rate Cards can be managed and updated in one of two ways - both available from the Financial Administration console:

  1. Using the user interface; 
  2. Via spreadsheet download/upload

Both options are outlined in the article below.


To access the Financial Administration console navigate to 'Financial Administration' from the drop-down menu under your Avatar.






Configuring rate cards using the user interface


From the Financial Administration Console select Rate Card Management under the Financial Settings section to navigate to the rate cards page.



From here you can either EDIT rate cards by clicking on the edit pencil icon in front of the rate card entry or create a NEW rate card by clicking on ADD ITEM



Make your changes and additions to the rate card dialog and save your changes. See the table at the bottom of the article for a full description of each field.



Once you've made all the necessary updates to the rate cards, remember to click on APPLY TO ALL PROJECTS to apply the changes to all project financials forecast in open months.





Rate Cards Download/Upload


If you have many rate cards to create / update, you may want to use the rate card bulk edit functionality. You can find the bulk edit functionality under the Tools menu on the rate cards page or under the Data Management section of the Financial administration page.



Select the Download button to Download the rate cards file. Make the changes to the Excel spreadsheet that you downloaded. See the table at the bottom of the page for a full description of each column.


When you are happy with your changes, select Upload to upload the updated file.





Field and Column description


Column & Title in upload fileMatching field title in the rate card dialogDescriptionData TypeWhat happens if field is left blank in upload file?
A. IdN/AFluid unique ID of the rate card. When uploading the file, the ID is used to identify which rate card should be updated. NumericIf a GUID value (column AC) is set, then the value will be used to identify the rate card which should be updated.

Leave the ID and GUID values empty if you are creating a new rate card.
B. ClassificationClassificationThe classification or title of the rate card. You can have multiple rate cards with the same classification - but their date ranges cannot overlap.TextMandatory field
C. ActiveActiveWhether the rate card is active in the system and can be used.Yes/NoField is set to No.
D. HourlyRateHourly RateThe hourly rate of the rate card.NumericField is set to 0.
E. MonthlyAmountMonthlyThe monthly value of the rate card.NumericField is set to 0.
F. LocalCurrencyValueN/AValue equals E. MonthlyAmount.NumericThis is a derived value and is not needed for upload.
G. DefaultCurrencyValueN/AValue equals E. MonthlyAmount x R. ConversionRate ToDefault.NumericThis is a derived value and is not needed for upload.
H. MonthlyIndirectMonthly IndirectAny monthly indirect costs associated with the rate card.NumericField is set to 0.
I. MonthlyDirectMonthly DirectMonthly direct costs associated with resources on the rate card.NumericField is set to 0.
J. DailyDaily RateThe daily rate of the rate card.Numeric Field is set to 0.
K. MonthlyHoursN/AThe number of hours in a monthNumericField is calculated as Hours per day multiplied by Days per month.
L. DayHoursHours per dayThe number of hours per day associated with the rate card.NumericField is set to 0.
M. MonthDaysDays Per MonthThe number of days per month associated with the rate card.NumericField is set to 0.
N. ExpenseCategoryExpense CategoryThe expense category the rate card should be allocated against. The entry must match a configured expense category.TextField is left blank.
O. ExpenseTypeExpense TypeThe expense type the rate card should be allocated against. The expense type must have an expense class set to resource. TextField is left blank.
P. NoteNoteFree text field for notes associated with the rate card.TextField is left blank.
Q. CurrencyCodeCurrencyThe currency the rate card is in. In the upload, the field must match a configured currency. SelectionField is left blank.
R. ConversionRate ToDefaultConversion rate to default currencyThe conversion rate that should be applied to the rate card to convert it to the default currency. Click here for more on currencies and rates.NumericField is set to 0.
S. ConversionRate ToRestatedConversion rate to restatedThe conversion rate that should be applied to the rate card to restate it to the default currency. Click here for more on currencies and rates.NumericField is set to 0.
T. IsCapitalizableIs CapitalizableThe rate card is capitalisable.Yes/NoField is set to No.
U. StartMonthStart Date (Month)The date the rate card is in effect from.DateMandatory field.
V. EndMonthEnd Date (Month)The date the rate card expires.DateMandatory field.
W. EndMonthDayN/AN/AN/AN/A
X. UtilizedAllocationUtilized AllocationThe allocation value used to calculate whether a resource is fully utilised.NumericField is set to 0.
Y. IsCappedApply Capped HoursIs the rate card capped on how many hours per week can be charged to projects? Yes/NoField is set to No.
Z. CappedHoursWeekly Capped HoursThe number of hours allowed per week if Y. IsCapped is set to Yes. If a resource books over the capped hours allowed, excess hours are costed at 0.NumericField is set to 0.
AA. IsDailyRateApply Daily RateRegardless of the actual time booked in a day by a resource, the full day rate will be charged.Yes/NoField is set to No.
AB. IsNonProjectChargedIs Non Project ChargedIf set to Yes then time booked to non project related activity will carry a cost AND the hours will be included in the weekly Z. CappedHours allowed for the rate card. Yes/NoField is set to No.
AC. GuidN/AUnique string identifier for the rate card in Fluid.AlphanumericA new rate card will be created.




  • All fields containing monetary values must correlate (or financials will not be accurate):
    • Daily Rate = Hours per day x Hourly Rate
    • Monthly Direct = Daily Rate x Days per month
  • Rate cards with the same Classification cannot have overlapping date ranges. When assigning rate cards to resources, rate cards with the same Classification are only listed once for selection. The rate card applied depends on which date range the allocation or time booked falls into.
  • Apply Capped Hours (Y. IsCapped) and Apply Daily Rate (AA. IsDailyRate) cannot be set to Yes at the same time. Only one or the other can apply.






Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons

Feedback sent

We appreciate your effort and will try to fix the article