AI USE CASES YOU CAN REUSE.English edition · Individuals, independents, small businesses
Spotted on the web

Rebill Clients Each Month for Payroll from the Payroll Provider's Invoices

Every month, the managing partner of Roads Expertise Comptable rebills clients for payslips produced by two payroll providers, and the rate and number of payslips vary from one client to the next. Claude turned those invoices, along with his handwritten instructions, into a rebilling spreadsheet that he reviews before entering anything.

The result to aim for

1. A table with client code, number of payslips, billable lines, rate applied, total excluding VAT and the rule used.

What was done

Pablo Goffinet of OSERIA described the work on October 9, 2026, drawing on recorded sessions with the firm: about 150 client files, all on Pennylane, and around fifty invoices prepared by hand each month. On September 24, the first version of the spreadsheet applied one rule wrongly, because payslips entered by default were not handled the way the accountant wanted. He corrected it by voice, and the second version recognized the firm's own internal file without being told. His estimate: "a good two hours a month, easily." His method: keep an intermediate Excel file as a checkpoint before anything is entered. On October 9, during a different check, his review caught an unpaid invoice that Claude had wrongly classed as a discrepancy. The separate Axiome case by the same author covers email drafts. No client names are published.

Before you start

Tool cited by the source: Claude. Gather the information the prompt asks for. Strip confidential data that is not needed and check your tool’s access terms. Features and plans can change.

The method, in three steps.

  1. Gather the context

    Gather the information described in the prompt.

  2. Adapt the prompt

    Copy the prompt below, replace the bracketed items, then paste it into Claude.

  3. Reread before using

    Reread the result, correct it if needed and keep the final decision. Caveats are detailed below.

Your starting point.

Replace the bracketed items, then adapt the proposal to your situation. This prompt is written by the iadujour desk It is not a quotation from the source.

The prompt to customise
Act as a rebilling assistant for an accounting firm. Each month I rebill my clients for payslips produced by my payroll providers, and I want a table to review before I create a single invoice. Do not create invoices and do not touch any software.

Context:
- Payroll provider invoices: [paste the breakdown per client, e.g. client C-014: 12 payslips, 2 new hires, 1 leaver]
- My rules per client: [paste the rate and the exceptions, e.g. C-014: €28 excl. VAT per payslip, new hires and leavers billed separately]
- Last month's instructions: [copy the handwritten notes, e.g. "C-022: do not rebill zero-value payslips", or leave blank]
- Known special cases: [e.g. payslips entered by default, dormant client, the firm's internal file, or leave blank]

Before pasting, I replace client and employee names with codes and remove salary amounts.

Deliverable:
1. A table with client code, number of payslips, billable lines, rate applied, total excluding VAT and the rule used.
2. A "to check" column for every line where my rule is missing, ambiguous or contradicted by the provider's invoice.
3. Changes from last month: new client, missing client, sharp rise or drop in volume.
4. The questions to ask me before I enter the invoices.

Rules:
- Do not invent any rate. Without a written rule, the line stays "to check".
- Do not merge two clients and do not guess a missing code.
- If a code matches the firm's internal file, flag it instead of billing it.
- I review the table, then I enter the invoices myself.

What deserves your attention

Payroll invoices name clients and sometimes employees. Use only a tool the firm has approved under a known contract, and keep access tokens out of the conversation. Review the spreadsheet before any invoice goes out. Professional secrecy applies.
Origin of the case. Use described publicly by OSERIA — Roads Expertise Comptable (9 October 2026).
Proof level: Testimony published by an identified source. Source checked on 16 November 2026. Use described by the source and verified by our editors. Original summary written by iadujour.fr: figures and claims are the source’s; the prompt is a desk proposal, not a quotation.

Useful skills

Official skills on the same task, paired by the desk: they are not part of the described case.

  • Create and analyze Excel spreadsheetsAnthropic · Serves as soon as a spreadsheet file is the main deliverable: open, read, edit or correct a `.xlsx`, `.xlsm`, `.xltx`, `.csv` or `.tsv` (columns, formulas, formatting, graphics, cleaning), create a binder, or convert between tabular formats.
TO GO FURTHER

Other ideas to put to work.

The whole Accounting & finance theme
Accounting & finance

Prepare a small business for electronic invoicing

Take stock of invoice flows and tools, and prepare questions for your accountant before electronic invoicing becomes mandatory between businesses.

Tool: Le ChatType: Practical case
Accounting & finance

Set up an agent in an accounting firm's production software

An eight-person accounting firm deployed “Nia”, an agent installed on an internal server and connected by API to its production software, to handle repetitive tasks.

Tool: Nia (agent maison)Type: Spotted
Accounting & finance

Answer travel policy questions around the clock in English and French

The Public Service Commission of Canada deployed a Copilot Studio agent: emails to the travel mailbox fell by 90%, complex questions went from 5 days to 10 to 30 seconds, and an approximately CAD $120,000 position was avoided.

Tool: Microsoft 365 Copilot Chat / Copilot StudioType: Spotted
DISCUSSION

Comments.

A field note, a question, a precision on this use case? Comments are reviewed before publication.

Published comments

Loading comments…

    Leave a comment

    Moderation charter. Every comment is reviewed before publication. We refuse hate speech, insulting or discriminatory language, advertising, spam and promotional links, off-topic posts and other people’s personal data.