---
title: "IT services: connecting timesheets to collections data"
canonical: https://www.billabex.com/en/blog/it-services-timesheet-collections-data/
lang: en
alternate: https://www.billabex.com/fr/blog/esn-suivi-activite-donnees-recouvrement.md
alternates:
  fr: https://www.billabex.com/fr/blog/esn-suivi-activite-donnees-recouvrement.md
  en: https://www.billabex.com/en/blog/it-services-timesheet-collections-data.md
  de: https://www.billabex.com/de/blog/it-dienstleister-taetigkeitsnachweis-und-forderungsdaten.md
  es: https://www.billabex.com/es/blog/consultora-it-que-datos-pasar-del-seguimiento-de-actividad-a-cobros.md
  it: https://www.billabex.com/it/blog/servizi-informatici-dati-attivita-e-recupero-crediti.md
  nl: https://www.billabex.com/nl/blog/it-dienstverlener-activiteitsgegevens-en-debiteurenbeheer.md
  pl: https://www.billabex.com/pl/blog/uslugi-it-dane-o-pracy-a-monitorowanie-naleznosci.md
  pt: https://www.billabex.com/pt/blog/servicos-informaticos-atividade-dados-cobrancas.md
updated: 2026-11-11
index: https://www.billabex.com/llms.txt
---

# IT services: connecting timesheets to collections data

The accounting team at a French IT services firm receives a short reply: “We cannot find the timesheet matching this invoice.” It contacts the account manager, who asks the consultant for a monthly export. The resulting spreadsheet includes several customers, internal comments and absences. After repeated forwarding, the correct period is still difficult to identify, and unnecessary employee information has reached several recipients.

The remedy does not necessarily require another application. It requires a precise connection between activity records, the invoice and approval evidence. Collections should be able to explain the amount requested without opening the employee’s entire file. This matters particularly for time-based assignments, where monthly billing depends on days, professional profiles and contractual rates. The discussion uses the French employment and invoicing context, including CNIL guidance.

## Start with the customer’s actual question

Someone processing payment usually needs to verify a limited combination: which entity ordered the work, which assignment was delivered, during which period, for what quantity and at what rate. They may also need the identity of the person who approved the service. These needs do not automatically justify access to every comment recorded by the consultant.

In its [9 July 2026 guidance on monitoring employees’ activity](https://www.cnil.fr/fr/controle-de-lactivite-des-personnes-employees), CNIL explains that data, retention and authorised recipients must follow the stated purpose. An additional use must not be concealed. Applied to invoice follow-up, this supports defining a limited commercial extract with clear recipients and an explicit purpose.

Begin with a real blocked invoice. Reconstruct the information needed to resolve it. If an assignment reference and an approved activity report answer the question, a complete HR export does not become stronger evidence simply because it contains more rows. Additional detail may instead create new questions and wider access without improving the payment decision.

## Establish a mapping people can understand

A [payment tracking spreadsheet](https://www.billabex.com/en/blog/tracking-client-payments-with-excel-download-our-free-template/) can initially act as the mapping register, provided access is controlled and references lead to approved records. The chain can remain clear even when separate systems are involved. Each invoice line should lead to the period and document explaining its quantity. Identifiers should survive a project being renamed or an account manager leaving. A person taking over the account must not depend on recognising an old folder name.

| Information transferred             | Commercial purpose                      | Detail normally excluded             |
| ----------------------------------- | --------------------------------------- | ------------------------------------ |
| Customer entity and order reference | Match the invoice to the buyer          | Consultant’s private contact details |
| Assignment identifier and period    | Retrieve the relevant activity report   | All the employee’s other assignments |
| Billed quantity and unit            | Explain days, half-days or hours        | Complete attendance history          |
| Applicable contractual rate         | Reconstruct the invoice line            | Salary or individual margin          |
| Approval status, date and author    | Identify acceptance or a pending action | HR assessments and medical details   |
| Evidence reference and version      | Supply the relevant supporting record   | Unidentified successive copies       |

This is an organisational proposal, not a universal legal list. A fixed-price assignment may rely on a deliverable and its acceptance without transmitting daily records. A time-based contract may require named activity reports. Where identity is necessary, appropriate access controls still apply: a legitimate need for a name does not create a need for everything associated with that person.

## Link the documents without merging their meanings

The [French Ministry of the Economy’s invoice guidance](https://www.economie.gouv.fr/entreprises/gerer-son-entreprise-au-quotidien/gerer-sa-comptabilite-et-ses-demarches/mentions-obligatoires-dune-facture-tout-savoir) covers description, quantity, unit price and the purchase order number where the buyer established one beforehand. An activity report supports the service. It does not replace the invoice or automatically correct an inaccurate invoice field.

Keep approval of the activity report separate from receipt of the invoice. An operational manager can approve the days while accounts payable has never received the financial document. Conversely, a portal can accept a technical upload without confirming the work. The [impact of electronic invoicing on collections](https://www.billabex.com/en/blog/mandatory-electronic-invoicing-impact-on-debt-collection/) does not remove this business distinction.

If evidence changes after billing, the record must explain what changed. Renaming a new file to match the old one and silently overwriting it makes a later disagreement harder to investigate. Retain an identifiable approved version and let the appropriate billing owner decide the financial treatment of a correction. Collections should not infer a credit or a new invoice merely from a changed spreadsheet.

## A missing day does not require an HR explanation

Consider a fictional assignment billed at €650 excluding VAT per day. The submitted report contains 18 days. The customer approves 17 and asks for an explanation of the remaining day. The calculation is €11,700 submitted, €11,050 approved and €650 to clarify, all excluding VAT. These are illustrative amounts, not observed prices or customer results.

The person following up payment needs the period, disputed line, approver and next action. They do not need to know whether an internal comment mentions an absence, a personal difficulty or a discussion with a manager. The assignment owner can provide an accurate commercial explanation: work allocated to another work package, an entry error or completed work that the customer has not recognised.

Do not automatically treat the 17 approved days as a payable partial invoice if the agreement or financial document requires further analysis. Record the acknowledged portion and refer the invoice for the correct treatment. The immediate objective is to make the disagreement precise and obtain a verifiable decision without disclosing personal details to accelerate a response.

## Give each category its own retention treatment

Commercial evidence and attendance logs do not necessarily have identical retention rules. [CNIL’s guidance on premises access and working hours](https://www.cnil.fr/fr/acces-locaux-controle-des-horaires-au-travail) distinguishes access logs, generally removed after 3 months, from certain working-time records that may remain in intermediate archives for up to 5 years. Those figures concern the systems described; they do not establish one universal retention period for billing evidence.

The practical consequence is that an invoice file should not depend indefinitely on a link to a technical log scheduled for deletion. Decide with the relevant owners what commercial proof must be retained, where, for how long and with which permissions. Presence at a customer’s premises does not, by itself, establish that a billed service meets its contractual requirements.

Separate everyday access from archiving as well. A completed matter may need to remain available for a justified purpose without being open to everyone handling current reminders. [Collections software security](https://www.billabex.com/en/blog/compliance-and-security-in-debt-recovery-software/) starts with choosing that access perimeter and ensuring the archive can be retrieved by the right person when a legitimate need arises.

## Test one complicated invoice from end to end

Before generalising the transfer, choose an invoice involving several consultants and a corrected period. Ask someone unfamiliar with the assignment to find the calculation, approval and expected contact. Then check that the same person cannot access HR details deliberately excluded from the file.

The exercise succeeds when that person can send a precise customer request and route the reply to the assignment owner without starting another scattered investigation. A large export does not demonstrate a working connection. The useful test is whether each billed line can be explained and its relevant support retrieved.

The [Billabex customer view](https://www.billabex.com/en/product/customer-view-360/) helps bring together the context needed for invoice follow-up. For an IT services firm, that context begins with a reliable relationship between assignment, period, approval and amount, maintained by the teams who understand the work.