Help - Questions / Answers

 Search :


 Times / Expenses

Questions :

Times are calculated when created or modified (excluding wording) according to the rules below. If these rules change, the lines are not recalculated automatically, you must use « Tools > Recalculation of times / new rates », paying close attention to the desired recalculation scope.

Tempolia screenshot showing the scope of time and new rate recalculation
The scope of time and new rate recalculation.

* The cost prices and selling prices of collaborators (PR COL and PV COL) defined for the valuation of time can be used at your convenience:

  • either the current rates of the Collaborator file (Remuneration tab: you can manually enter the Collaborator Sale Price and the Collaborator Cost Price or enter the information for "Remuneration" and "Time" then tick "Automatic calculation of the PR Col" to calculate the cost price automatically);
  • either the historical rates, kept or entered in advance. When modifying the file of a collaborator, you can put an effective date, in order to feed this history. And you can also manually modify this history.
Tempolia screenshot showing the option choosing between collaborator record rates and historical rates
The option choosing between collaborator record rates and historical rates.

This time valuation mode (which refers to the collaborator file or to the history) is managed on the « Configuration > General options » page, "Time entry" tab.

If necessary, specific collaborator selling prices (PV COL) per matter can be entered on the « Collaborators > Collaborator selling price per matter » page. When a specific rate per matter has been entered, it is retained in priority over the standard rate (current or historical COL PV) for the valuation of budgeted or spent time for this collaborator and this matter.

Tempolia screenshot showing the collaborator sale price by matter table
The collaborator sale price by matter table.

Consequently, if the sale price of a timeline is not what you want:

  • Check if there is a sale price specific to the timeline deal,
  • Failing this: check in « Configuration > General options » that the use of rate history is activated or not,
  • Failing this: recalculate the valuation of this line with « Tools > Recalculation of times / new rates ».

* Billable tasks valued by quantity have a value defined according to the "PV Quantity" multiplied by the quantity entered in a time line. 
If needed, specific quantity selling prices (PVQ) per job can be entered on the « Configuration > Task selling prices per job » page.

Quantity-based time allows you to measure the amount of work produced on a task. The employee can enter how many production units were completed during this time (e.g., 12 pay slips, 3 tax returns, 1 DSN, etc.). This allows you to bill for quantities produced rather than time.

To configure a task as billable by quantity, go to the « Configuration > Billable Task Codes » page and check "Billable by Quantity." You can specify a "Quantity PV" used by default to calculate the value of the production entered; You can also go to the « Configuration > Sales Prices per Job » page, which allows you to enter sales prices based on quantities specific to each job.

Tempolia screenshot showing quantity task sale prices by matter
Quantity task sale prices by matter.

The "Quantity" column is only displayed if access rights allow it on the "Collaborators > Login and Collaborator Rights" page.

Quantities can be entered at the same time as a time entry, or in a separate entry, and can also be imported from a CSV file. You can also automatically retrieve production from the Silae payroll software API.

Tempolia screenshot showing the Silae import page used to retrieve social payroll production
The Silae import page used to retrieve social payroll production.

The « Employees > Rate and remuneration history » page contains lines that were created either:

  • manually directly through this page,
  • or when, on the "Employees" page, in an employee record under the "Remuneration" tab, an effective date is entered. The employee’s cost price and sales price are then historized on that effective date. See the message at the bottom of this tab: "NB: enter an effective date to historize a CP / SP change". The effective date is not stored in the employee record; it is only used to insert this information into the history on a one-off basis.
Tempolia screenshot showing the collaborator rate and compensation history
The collaborator rate and compensation history.

If an employee has no history, the best approach is to use this second process by entering an effective date.
For old periods whose past rate evolution you want to complete, you can complete the history by clicking New on the « Employees > Rate and remuneration history » page.

Tempolia screenshot: Sale price history by collaborator and matter.
Sale price history by collaborator and matter.

Tempolia offers a calculation method for employees’ hourly cost prices:
Employee CP = [Annual cost Salary + Charges + Expenses / (annual presence time x Percentage of billable time) ]
This is not the only possible method, and you can manually enter hourly cost prices in employee records if you prefer to calculate them independently.

Tempolia screenshot: The collaborator rate and cost price history.
The collaborator rate and cost price history.

Annual presence time is typically 1,607 hours for a person working 35 hours per week. Depending on your approach, the percentage of billable time may be 100% if you want to value all time, or less if you want to exclude non-productive time and allocate its cost over productive hours.

Tempolia screenshot: The rate and remuneration history gives context for calculating hourly cost price.
The rate and remuneration history gives context for calculating hourly cost price.

In « Configuration > General options », “Time and expense control” tab, when you check the box “Possible locking of time lines by collaborators with “approval rights”, this has the effect of:

  • add an “Approved” column in the list of times and expenses,
  • add an “approved” checkbox in the time and expense editing form,
  • add an “Approve” button above the list of times and expenses,
  • add an additional setting in Collaborators > Login and collaborator rights.
Tempolia screenshot: The control options that enable time and expense approval.
The control options that enable time and expense approval.

You can give this or that employee the right of approval (and the administrator also has this right), which allows you to approve times and expenses:

  • either by editing a time or expense line, and checking “Approved”
  • either by selecting N lines and clicking on the "Approve" button above the table => this allows you to approve all the times from such and such a date.
Tempolia screenshot: Approval rights in collaborator access.
Approval rights in collaborator access.

When a line is approved, it can no longer be modified or deleted by a person who does not have approval rights. This person can, however, make other additional entries that may have been forgotten.

Tempolia screenshot: Time lines used for approval control.
Time lines used for approval control.

In “Configuration > Activities” and “Configuration > Billable task codes”, activities and billable tasks can be associated with each other, to limit entry to certain tasks based on the activity you are doing for that affair. You can [Ctrl] + click to associate multiple activities and tasks together.

Tempolia screenshot: The billable task codes that control suggestions during time entry.
The billable task codes that control suggestions during time entry.
  • Either you do not link any activity to any task, and all tasks are selectable when entering time.
Tempolia screenshot: Task selection in time entry.
Task selection in time entry.
  • Either you link them together, and then your configuration must be complete, each activity being linked to N tasks. And when a collaborator enters time, he chooses a case which is associated with a given activity, and this activity then limits the list of selectable tasks.

In the time entry label, you have two possibilities to transmit a text internally and a label to justify to the customer:

Tempolia screenshot: The time entry area where client wording and internal notes can be separated.
The time entry area where client wording and internal notes can be separated.
  • customer text // internal text: We remove any comments which are after a double slash and concern only internal matters
  • internal text # customer text: After the number sign #, we can have a specific wording for the client, and in this case we do not take what is before => it is the opposite of what we do with //
Tempolia screenshot: The time detail table lets you check internal labels before rebilling.
The time detail table lets you check internal labels before rebilling.

Tempolia offers several time-entry modes to adapt to each employee’s working habits:

  • "Actual agenda": the graphical agenda provides a visual interface for recording hours; this is the most widely used mode, about 55% of entries.
  • "Detailed time spent" allows line-by-line entry, with grouped modifications and duplications, representing about 40% of entries.
  • "Monthly time entry" lets you enter time in cells of a large table with one column per day. Each row represents a client, a matter and a task, and you can also choose whether a label is present on each row.
  • Timers, either general at the very top of the screen or by matter on the "actual work by matter" page, are available to record time in real time.
Tempolia screenshot: The time entry screen, the starting point for activity analysis.
The time entry screen, the starting point for activity analysis.

Time can be entered in various formats: hours / minutes, decimal format, or consecutive working days. Tasks are fully configurable, and details or comments can be added for each entry.

Time valuation is a core feature for profitability analysis. Tempolia calculates the cost price to determine actual margin compared with the amount invoiced, and a theoretical sales price to assess bonus / loss. The theoretical sales price can be adjusted specifically for each client, allowing tailored pricing.

Tempolia screenshot: Time detail table for activity analysis.
Time detail table for activity analysis.

The collected data are centralized in client and matter records, where statistics tabs show key indicators such as bonus / loss and margin, and provide an overview with distribution charts.

For deeper analysis, Tempolia provides many reports and printouts exportable in HTML format, for PDF printing, or CSV format, for Excel processing. These reports include activity controls by employee, annually, monthly or weekly, details of actual work, and an aged balance for collections monitoring.

Tempolia screenshot: Activity report based on time entries.
Activity report based on time entries.

To manage your mileage expense entries, you can make several settings:

Tempolia screenshot: The expense codes that carry mileage allowance settings.
The expense codes that carry mileage allowance settings.
  • Configure the expense codes that will be used in the “Configuration > Expense codes” menu. For a thermal vehicle with a fiscal power of 5HP, you can choose IK5 or KM5 as the expense code, and IKE5 or KME5 for an electric vehicle. You can pre-fill the unit PR and the unit PV. It is in fact possible to re-invoice the customer for a PV value different from the employee's reimbursement PR value.
  • You can optionally configure the distance in km for a return trip to a customer, in the « Clients / Matters > Clients » menu by editing a customer file in the “Configurable characteristics” tab. This will automatically pre-populate the quantity when entering mileage charges on a customer, and this pre-populated amount can be changed if necessary.
  • Other optional setting: in « Employees > Employees » by editing a collaborator file in the “Configurable characteristics” tab, you can fill in the “Kilom Indem. Code” field. which will allow the correct code to be preselected when entering the expenses of the employee concerned and thus avoid any entry errors.

Once the settings have been made, you can enter mileage expenses in the « Time / Expenses > Details of expenses incurred » menu with the New button. The mileage must be entered in the “Quantity” box.

Tempolia screenshot: Expense entry lines for mileage expenses.
Expense entry lines for mileage expenses.

There is only one supporting document that can be attached for an expense line entry.
If each supporting document is a separate expense, you should normally create a line per separate expense, so one per supporting document.

Tempolia screenshot: The expense line and its receipt, to create separately for each distinct expense.
The expense line and its receipt, to create separately for each distinct expense.

It is also possible to:

  • scan several documents together in a single PDF and attach it,
  • or take a single photo of several documents placed next to each other (but in this case and the previous one, the OCR can only recognize one of the supporting documents transmitted).
  • make a zip file of your multiple supporting documents and attach the zip file (which prevents the OCR from working: the content of this zip file will not be subject to automatic text detection)
Tempolia screenshot: The expense list gives a quick check of lines and attached receipts.
The expense list gives a quick check of lines and attached receipts.

As a preamble: to correctly value your time by quantity according to rates specific to certain clients, you can define rates by quantity on the « Configuration > Sales price of tasks per project » page.
This then allows Tempolia to value your pay slips with the correct unit rate.
When you create new matters with bulk matter creation, you can keep the same rates or make increases.
And you can also modify these prices occasionally by modifying them directly.

Tempolia screenshot: The import area used to match production, quantities, and time.
The import area used to match production, quantities, and time.

In Tools > Import, you can import "past times" by downloading a CSV file (you will have previously saved your Excel file in CSV or txt format).
By selecting "past times" as the import type, you will have to drag your column names which will have appeared on the left to our boxes in the database on the right.
The boxes in blue are mandatory: client, case, collaborator, date, task code, and quantity.
Once the match is made, you save your configuration (green button) which will allow you to reload these matches in the future, and you launch the import with the blue button at the bottom of the form: first there will be a verification anomalies, and then an import.

Tempolia screenshot: Quantity task prices after import setup.
Quantity task prices after import setup.

You can automatically retrieve payroll production from the Silae payroll software as part of the Enterprise offer.

Tempolia screenshot showing the Silae import page and its social production mappings
The Silae import page and its social production mappings.

Regarding the Silae API, you can subscribe to their REST API for firms. You must contact Silae to obtain your API login credentials and send them to us so we can integrate them into our system. Note: access to their API may be billed by Silae separately, but according to our information the firm API is not billed for our use, namely level 1 according to their codification. For information, Silae API documentation is available at https://silae-api.document360.io/docs

On our side, we call their API features to retrieve the production of your payroll department, in order to know what you want to invoice, typically payslips issued, entries and exits. Then we match this with the tasks you have defined in Tempolia and for which you have configured your sales rates.

During import, matching Silae files with Tempolia clients is done:

  • automatically if the client code in Tempolia is identical to the file code in Silae
  • through the "SILAE Code" field. This field is filled in the "Customizable characteristics" tab of Tempolia client records to indicate a specific file code in Silae. It can be filled manually or by importing a two-column CSV file: client code in Tempolia and file code in Silae.
Tempolia screenshot: Quantity task prices for Silae import.
Quantity task prices for Silae import.

To perform the import:
Go to « Tools > Import Silae payroll production » and enter the date range for which you want to retrieve Silae production, as well as an employee to whom the created lines will be fictitiously attached.

Tempolia screenshot: Sales codes used by Silae import.
Sales codes used by Silae import.

Tempolia provides a powerful feature for managing time entries on the « Time / Expenses > Detailed time spent » page: bulk modification of multiple rows. This feature lets you act on hundreds of rows at once, saving significant time and greatly improving usability. You can correct assignments, for example if many rows were wrongly assigned to a matter, standardize labels, or reclassify time after entry errors.

Tempolia screenshot: The detailed time table, used for grouped corrections and reclassification.
The detailed time table, used for grouped corrections and reclassification.

This capability is generalized across the software interface and is designed to be very fast, running in a fraction of a second even for more than 1,000 rows. The ability to select several time entries and edit or delete them in bulk is a key usability improvement. This flexibility ensures that time and profitability analyses remain accurate, even after major corrections.

Tempolia screenshot: Time entry screen used before bulk correction.
Time entry screen used before bulk correction.