Generate invoices from a spreadsheet, one per customer
30 window-cleaning jobs became 11 numbered PDF invoices, one per customer.
A real run on 13 November 2026, on a Linux computer, using Claude Code with Opus, on a Claude plan. The waiting is sped up; it took 2 min 19 s in real time.
The short answer.
Mail merge makes one document per row, so a customer with three jobs would get three invoices. By hand: filter the job list by customer, copy their rows into an invoice template, set the number and total, and save as PDF; repeat for each customer. Stella (stella.sh) groups the jobs by customer, numbers the invoices, adds your business and bank details from the sheet and saves one PDF each, without sending anything.
Stella does this on Windows, Mac and Linux.
What happened.
11 invoices for 30 jobs (£1,158 in all) in about 2 minutes. Checked afterwards against an answer key written before the run: one invoice per customer, each with the right customer, all of their jobs and no one else's, the correct total, an invoice number, the business name and bank details; numbers INV-1041 to INV-1051 each used once; file names include the number; the spreadsheet unchanged.
The window-cleaning business, its customers and jobs are fictitious, made for this run. The work is sped up 7×.
How Stella does it.
- Finds the October jobs spreadsheet in Documents and reads both sheets: 30 jobs, and your business details on a separate “My details” sheet
- Groups the jobs by customer (11 customers, two to four jobs each) instead of making one invoice per row
- Makes one PDF per customer numbered INV-1041 to INV-1051, with your business name and address at the top, their jobs listed, the total due and your bank details for payment
- Saves them in a new “October 2026 invoices” folder with the number and customer in each file name, including awkward names like “Mr & Mrs Tran” and “Mrs J O'Hara”
- Flags entries worth a second look before sending: a possible double booking and two homes billed at the shop-front rate
The prompt.
My window cleaning jobs for October are in a spreadsheet in Documents. Make a PDF invoice for each customer, numbered from INV-1041, with my business details at the top, their jobs listed and the total due.
This is the exact prompt from the recording. If your files are somewhere else, say where.
Do it yourself.
Set up one invoice template
In Excel or Word, make an invoice with your business name, address and contact details at the top, a box for the customer, a table for date, job and price, a total, your payment terms and your bank details. Excel's File, New has invoice templates to start from.
Sort the jobs by customer
In the job list, select the data and choose Data, Sort by Customer, then Date. Each customer's jobs now sit together. A PivotTable (Insert, PivotTable, Customer in Rows, Price in Values) gives each customer's total to check against.
Fill the template for the first customer
Copy that customer's rows into the invoice table, type their name and address, set the invoice number (INV-1041) and today's date, and check the total adds up.
Save as PDF and repeat
File, Save As (or Export), choose PDF, and name it with the number and customer, such as
INV-1041 Ashcombe Dental Practice.pdf. Clear the rows, move to the next customer and the next number. Keep a list of which number went to whom.Check before you send
Add up the invoice totals and compare them with the sum of the price column. If they don't match, a job was missed or copied twice.
Where it stops.
- Stella makes the PDFs. It doesn't email them, send reminders or track who has paid.
- VAT is only added when you say so and give the rate. This run's business was “Not VAT registered”, so no VAT was shown.
- It invoices what's in the sheet. It flagged a likely double entry and two odd prices here but didn't change them; you decide.
- Customer names, addresses and prices go to the AI model you use in Stella. The PDFs are made on your computer.
- Recorded on Linux, where Stella made the PDFs with free Python tools it set up. On Windows or a Mac it works the same way; the PDFs open anywhere.
Questions.
Can mail merge make one invoice per customer?
Not easily. Mail merge makes one document per row, so a customer with three jobs gets three invoices. You'd need a summary sheet with one row per customer first, and job lines still won't list nicely. Grouping by customer is what Stella did here.
Where did Stella get my business details?
From the “My details” sheet in the same spreadsheet. If they're somewhere else, such as an old invoice, say where in the prompt.
Can I use my own invoice design?
Yes. Point Stella at a Word or Excel invoice you already use and ask it to fill that in for each customer. For one letter per row instead, see mail merge from Excel to Word.
Can it total what each customer owes across the month?
Yes, that's each invoice's total. For a summary sheet by customer or job type, see summarize a spreadsheet by category.
Is Stella free for this?
Yes. Free with the ChatGPT or Claude plan you already have. Sign in with your ChatGPT plan, or use your Claude plan through Claude Code, and this task costs nothing extra. New accounts also get a small free trial of Stella’s own models.
Can I control what Stella changes on my computer?
Yes. Stella works on Windows, Mac and Linux with your own files and shows each step in the chat, so you can watch it and stop it at any point. Tell it what it may not do, as the prompts on these pages do (“don't delete anything without asking”). In the Downloads recording it deleted nothing until it was told to go ahead. It also refuses commands that would wipe a whole disk, your home folder or system folders.
Checked against these sources on 13 November 2026.