Skip to main content

ExtractPayroll: Manage timesheet tracking and payroll preparation

Written by Charlie Troccaz
Updated over 3 weeks ago

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 contractual information by clicking directly on the contract in bold!

  3. These two columns are the most important. They directly indicate your progress in collecting times and expenses. You will find the legend for these icons at the bottom of the result list. This icon is a direct shortcut to your collaborator's timesheet and expense report, allowing you to quickly validate (or not) their content.

  4. These three columns provide a summary of entered times, by type: production, internal, and absence. 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 one-off notes for the chosen month to include in the export file. For example, you can indicate a change to your accountant (change of bank details or collaborator address).


Configure rules for paying contractual benefits

This is the App 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 in 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 missions 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) are 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 type of declared expense. 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 entered benefits for 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 pay for this resource for 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, at the top 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 benefits paid.

If one of your resources has not yet entered their times, you will notice that the tool does not calculate their benefits.

Payment of non-contractual benefits

How to proceed in the case of an exceptional bonus, for example?

Resources > Resource card > Administrative tab

You can directly access your resource's card from ExtractPayroll by clicking the bolded name. You will then land in the Resource module, on the desired card.

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

Capture_Avantage_Sup_.png

Click 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 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 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 now return to ExtractPayroll, you will 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 necessary data from the dropdown list, then save and click Return.

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!

Did this answer your question?