Skip to main content

ExtractPayroll: Manage Timesheet Tracking and Payroll Preparation

Written by Charlie Troccaz

🤖 This article was translated by AI.

ExtractPayroll will help you to:

  1. track the submission of timesheets (production, absences, and internal) and expense reports for your resources and their approvals

  2. prepare payroll by displaying for the selected month and for each resource:

    • the current HR contract(s)

    • contractual benefits to be paid (e.g.: meal vouchers)

    • Excel export for your payroll manager


Track Timesheet and Expense Report Submission and Approvals

Apps > ExtractPayroll

From this overview dashboard, you will know the status of timesheet submission for all your resources with a contract for the current month:

Capture_ExtracPayrol.png
  1. Check your search filters: agency and period

  2. As mentioned above, ExtractPayroll filters results by HR contracts entered in Boond. This is an opportunity to verify contractual information by clicking directly on the bold contract!

  3. These two columns are the most important. They directly show you the status of your timesheet and expense collection. You’ll find the legend for these icons at the bottom of the result list. This icon is a direct shortcut to your consultant’s timesheet and expense report, allowing you to quickly approve (or not) their content.

  4. These three columns provide a summary of the reported times: production, internal, and absence. This way, you get a quick overview of the resource’s timesheet content.

Let’s zoom in on the Note column:

Capture_d_e_cran_2020-01-29_a__15.55.04.png

This allows you to add one-off notes for the selected month to include in the export file. For example, you can indicate a change to your accountant (such as a new bank account or address for the resource).


Configure Contractual Benefit Payment Rules

This is where you can configure the rules for paying benefits by clicking the "Configuration" button above the result list

Capture_d_e_cran_2019-11-25_a__14.16.33.png

.

Payment of Contractual Benefits

Prerequisites

  • For each resource, assign the benefits they are eligible for on their HR contract

    Resources > Resource card > Administrative tab > Contract

  • List all your benefits in
    Admin Interface > Legal Agency > Resources tab

Apps > ExtractPayroll > Configuration card

Capture_2_-_EP_config.png

From the "Benefit Payment Rules" table:

  1. Select the benefits for which you want to define payment rules by clicking "+ Add a row" each time.
    If you have several agencies, add as many rows as you have benefits for each agency.

  2. Determine the calculation formula for each benefit.
    For example, for meal vouchers: do you grant them if the person worked a half-day? Do you grant them for both assignments and internal work, or only one?
    Check the list of variables below for the calculation formula that fits your needs and copy/paste it into the corresponding field.

  3. You can also specify which month(s) the benefit payment applies to. For a quarterly bonus, for example, indicate the four payment periods.

Deduction of Benefits Linked to an Expense

It is possible to configure a calculation rule linked to a declared expense type. For example, if you do not grant meal vouchers when a resource declares a "Lunch" expense, you can use the variables [EXP] & [EXP_PREV].

To learn more, see the dedicated article.

Don’t forget to save! Then return to ExtractPayroll.

If you have correctly assigned benefits to each contract, you will see the "purse" icon at the end of the row, indicating that Boond has found at least one contractual benefit to pay for this resource this month.

Capture_3_-_Avantages_.png

You can:

  • Either pay benefits one by one by clicking the icon at the end of the row

  • Or pay all benefits for all your resources at once by clicking the icon at the top right of the table

IMPORTANT!

If a contractual benefit has already been paid manually, other contractual benefits will not be generated when you click the icon at the top right of the table.

Click the button to generate benefits; the tool will indicate the number of contracts where benefits have been generated:

Capture_4_avantage_verse__.png

You can see in the "Benefits" column how many benefit(s) found by Boond are paid for the relevant resource(s). Then click the arrow

fleche_basse.png

to open the details and view the types and amounts of benefits paid.

If one of your resources has not yet submitted their times, the tool will not calculate their benefits.

Payment of Non-Contractual Benefits

How to handle, for example, an exceptional bonus?

Resources > Resource card > Administrative tab

You can access your resource’s card directly from ExtractPayroll by clicking on the bolded name. You will then return to the Resource module, on the desired card.

Let’s focus on the "Paid Benefits" section:

Capture_Avantage_Sup_.png

Click on the + to add a benefit.

Capture_d_e_cran_2020-01-29_a__16.58.12.png

In the pop-up window that appears on your screen, select the non-contractual benefit type before clicking Yes.

Capture_avantage_except.png

On the Benefit card:

  1. Update the payment date for this benefit

  2. Select the type of non-contractual benefit from the list already created

  3. Enter the amount for this bonus

You can add a comment if you wish in the corresponding section on the left.


Then save and return to the resource card.

Now, you can see that this bonus is correctly recorded in the history of all contractual and non-contractual benefits for your resource:

Capture_avantage_except_verse_s.png

If you now return to ExtractPayroll, you’ll see that the exceptional bonus has been correctly taken into account

Capture_avantage_verse__EP.png


Generate a Payroll Preparation File

Now we will choose the columns your payroll manager needs.

Again, click the "Configuration" button

Capture_d_e_cran_2019-11-25_a__14.16.33.png

In the "Select columns to export" section, choose the necessary data from the dropdown list, then save and click Back.

Capture_-_Extraction_.png

You can then click the Excel icon

Capture_d_e_cran_2020-01-29_a__17.24.46.png

at the top right of the table to extract the appropriate file with all your information and send it to your payroll manager!


FAQ

💡 I mistakenly paid some benefits; can I correct this for several resources at once?

Absolutely! To bulk delete benefits, use the Advantages app. A tutorial is available here.

💡 Why can’t I generate benefits via ExtractPayroll anymore?


Make sure no benefit has been paid manually before attempting a bulk payment. If this has been done, it will not be possible to pay benefits in bulk.

💡 Can I permanently delete a benefit for one of my resources?

Absolutely! To do this, delete the benefit in their contract in the Administrative section of their Resource card. You can also add new ones the same way.

Did this answer your question?