5 prompts to check your invoices before they double up
One Housecall Pro reviewer on Trustpilot wrote that separating the invoices from the customer list "makes double invoicing very possible." That is one reviewer's report, not a verdict on the software. But when invoices and customers sit in separate lists, you're checking by eye. These five prompts do the cross-check for you, from two exports.
This is a check. The assistant reads and reports. It changes nothing in your records, and neither do you until you've read its list and said yes.
What you need
Two exports you pull yourself: your invoices, and your customer list. If you track estimates, export those too.
Claude or ChatGPT.
A decision about what to share first. Delete columns you don't need (phone numbers, addresses, emails, card details) before you paste or upload. Keep the customer name or ID, the job, the invoice or estimate number, the date, the amount and the status.
The AI only sees what you give it. A missing row in your export is a missing row in its answer.
Prompt 1: Check the files first
I'm uploading invoices and customers (and estimates, if I include them). Before you compare anything, tell me the columns in each file, which column links an invoice to a customer, how many rows each file has, and anything blank or inconsistent. Don't guess.
Prompt 2: Open invoices
List every invoice that is unpaid or partly paid, grouped by customer, oldest first. Show the invoice number, job, date and amount. Add up the open total per customer.
Prompt 3: Same job, more than one invoice
List every customer who has two or more invoices for the same job or description, or with the same amount, or dated within 7 days of each other. Show the invoice numbers, dates and amounts. Mark each "likely double" or "could be legitimate" and say why.
Prompt 4: Estimates never invoiced
List every estimate that has no matching invoice for the same customer and job. Show the estimate number, customer, date and amount. If you can't tell whether an invoice matches, list it as unclear.
Prompt 5: One list to work through
From everything above, give me one short list: likely doubles first, then estimates never invoiced, then open balances. For each line, say what I should check in my invoicing tool. This is a check only. Don't contact anyone, and don't change, void or refund anything. If you think a record should change, tell me which one and wait for me to say yes.
The mistake to avoid
Don't treat a clean answer as proof. If a draft invoice or an old customer didn't make it into your export, the check passes and the double goes out anyway. Export everything for the period, drafts included, and open each "likely double" in your invoicing tool before you void, refund or credit anything.