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 from your resources and their validations

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

    • the current HR contract(s)

    • contractual benefits to be paid (example: meal vouchers)

    • Excel extraction for your payroll manager


Track timesheet and expense report submissions and their validations

Apps > ExtractPayroll

From this synthesis dashboard, you will know the status of timesheet submissions 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 contract 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 will 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 validate (or not) their content.
    ​

  4. These three columns provide a summary of the reported times, by production, internal, and absence type. At a glance, you know the overall content of your resource's timesheet.

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 occasional notes for the selected month to include in the export file. For example, you can indicate a change to your accountant (change of bank account or consultant address).

⠀


Configure contractual benefit payment rules

This is the app where you can configure benefit payment rules 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

  • Assign, for each of your resources, 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" dashboard:

  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 mission and internal, or only one?
    Check the list of variables below for the corresponding calculation formula and copy/paste it into the appropriate field.
    ​

  3. You can also specify the month(s) concerned by the benefit payment. For a quarterly bonus, for example, indicate the 4 payment deadlines.

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 one of your resources declares a "Lunch" expense, you can use the variables [EXP] & [EXP_PREV].

For more information, see the dedicated article.

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

If you have properly entered the benefits on each contract, you will see at the end of the row the "purse" icon indicating that Boond has found at least one contractual benefit to be paid 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 above and to the right of the dashboard

IMPORTANT!

If a contractual benefit has already been paid manually, other contractual benefits will not be generated when you click the icon above and to the right of the dashboard.

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

Capture_4_avantage_verse__.png

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

fleche_basse.png

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

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 an exceptional bonus, for example?

Resources > Resource card > Administrative tab

You can directly access your resource's card from ExtractPayroll by clicking the bold 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 + to add a benefit.

Capture_d_e_cran_2020-01-29_a__16.58.12.png

In the pop-up window that appears, 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 non-contractual benefit type from the already created list

  3. Enter the amount of 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 properly recorded in the history of all contractual and non-contractual benefits for your resource:

Capture_avantage_except_verse_s.png

If you return now to ExtractPayroll, you can see that the exceptional bonus has been properly taken into account

Capture_avantage_verse__EP.png

⠀


Generate a payroll preparation file

Now we will choose the columns you need for your payroll manager.

Again, click the "Configuration" button

Capture_d_e_cran_2019-11-25_a__14.16.33.png

In the "Column selection for extraction" section, choose the required 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 dashboard to extract the appropriate file with all your information and send it to your payroll manager!

Useful link:

You can use this infographic to ensure you don't miss any step during your payroll preparation


FAQ

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

Absolutely! To bulk delete benefits, use the Advantages app, with a tutorial available here.

💡 Why can I no longer generate benefits via ExtractPayroll?


Make sure that no benefit has been paid manually before attempting mass payment. If so, mass payment will not be possible.

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

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

Did this answer your question?