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.
Gather the context
Gather the information described in the prompt.
Adapt the prompt
Copy the prompt below, replace the bracketed items, then paste it into Claude.
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.
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
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.
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.