Skip to main content

Timecard Entries

Visual Mapping​

Procore and Sage 100 Timecard Entries Mapping

FAQ​

What Pay Types does Agave support?​

By default, Agave supports the following Pay Types:

  • Regular Time ("Regular" in Sage 100)
  • Double ("Premium" in Sage 100)
  • Overtime
  • Vacation
  • Per Diem (Requires a custom field in Procore)

How does Agave calculate pay rates?​

Regular, Overtime, and Premium Pay Types​

Pay rates for Regular, Overtime, and Premium are calculated with the following steps:

  1. Determine if a Pay Group should be used for this employee
    • For company-level Pay Groups, this is determined by the "Paygroup" field on the "Compensation" tab of the Employee record
    • For job-specific Pay Groups, this is determined by matching the Employee's "Position" field with the job-level Pay Groups
  2. If a Pay Group is used, fetch the rate for the relevant pay type
  3. Fetch the rate for the relevant pay type from the "Compensation" tab on the Employee record
  4. Compare the Pay Group rate (step 2) and the Employee default rate (step 3), then use the higher one

Note: You may choose to set up a custom Pay Group field on your Procore timecards. When this is used, Agave will use the rate for this Pay Group regardless of other calculations. Work with your Agave rep to set this up if desired.

Per Diem​

To use Per Diem with Agave, you will need to create a custom field in Procore (usually called "Per Diem Amount") to hold the dollar amount. The name of this custom field is flexible; work with your Agave rep to enable it.

Agave will ignore hours and put the flat amount from the Procore custom field into Sage's "Pay Rate" field for Per Diem timecards.

Vacation​

The Employee's "Regular Hourly Rate" is used for the Vacation earnings type.

How does Agave set the Comp Code?​

If the "Always use employee comp code" setting is checked on the "Human Resources" tab of the Employee record, Agave will use the Comp Code on the Employee record.

Otherwise, Agave does the following:

  • If the Cost Code on the timecard has a Comp Code assigned, use that one
  • Otherwise, default to the Comp Code on the employee record

How does Agave set whether a Timecard is Certified?​

When syncing the timecard, Agave checks whether the job associated with it has "Require Certified Payroll Reporting" checked on the "General Information" tab.

If it does, Agave marks "Yes" on the timecard. If not, "No".

How does Agave set the Department on the Timecard in Sage 100?​

Agave sets this value in the following order of priority (progressing to the next if not set):

  1. Department on the Job record in Sage 100
  2. Department on the Cost Code used on this timecard in Sage 100
  3. Department from this Employee's position

Can Agave use the Procore Classification as the Pay Group when syncing time to Sage 100 Contractor?​

Yes.

If your employees often have timecards for varying Pay Groups (aside from their default), you may wish to specify the Pay Group in Procore when time is created/approved. With this setting, you can use the Classification field on the Procore timecard to specify a Pay Group:

Procore and Sage 100 Timecard Entries

Configuration​

To use this Pay Group feature, the Pay Group names in Sage 100 must match the Classifications in Procore exactly. Follow this setup and then notify your Agave account manager to enable it.

Getting Pay Group Names from Sage 100

To see your Pay Groups in Sage 100, navigate to Payroll > Payroll Administration > Paygroups:

Procore and Sage 100 Timecard Entries

From the 5-3-4 Paygroups screen, use the Name column to determine what you will need to enter in Procore:

Procore and Sage 100 Timecard Entries

Configuring Classifications in Procore

To set up Classifications in Procore, navigate to the company-level classifications setup.

Then, add a Classification for each of the Pay Groups from Sage 100 that you wish to use. Note that the Class Code in Procore must match the Pay Group Name from Sage 100:

Procore and Sage 100 Timecard Entries

Filters​

Agave can apply default filters for you to sync only a subset of Timecard Entries to either Sage 100 C or Procore. For example, you may only want to sync Timecard Entries that are "Approved". Let your Agave Account Manager know what filters you would like to apply and we can apply these for you.

For Procore -> Sage 100 C, most customers filter to "Approved" timecards.