Stop retyping invoices: from PDFs to Excel, QuickBooks and Xero with Claude
- Published
- 18 November 2026
- Prices checked
- 15 November 2026
Point Claude Cowork at your invoice folder and it builds one Excel sheet, a row per invoice, with a column that flags wrong totals and duplicates. In QuickBooks, Claude can record the bills itself through the QuickBooks Labs connector. In Xero, its connector only reads, so Claude prepares Xero's own import file and the bills arrive as drafts.
The three videos at a glance
| What you end up with | What you need | The limit to know | |
|---|---|---|---|
| 1. PDFs to Excel | One Excel sheet, a row per invoice, with a Check column; it refreshes every weekday at 8 | Claude desktop app with Cowork, a folder of invoice PDFs | The scheduled run needs your computer on |
| 2. Into QuickBooks | New bills recorded in QuickBooks, the ones already there skipped | QuickBooks Online and the QuickBooks Labs connector | Beta, and for US companies only |
| 3. Into Xero | Draft bills in Xero with the supplier names Xero already has | Xero and its Claude connector | The connector can read your books but not change them |
Swipe the table sideways for all columns. Each video is about a minute. The steps, the prompt and the limits for each one are written out below, so you don't have to pause the video.
The series follows one pile of paper from start to finish. Episode 1 turns the PDFs into a sheet you can trust. Episodes 2 and 3 take that same sheet into your accounting software, so you only need the one that matches what you use.
Episode 1: invoice PDFs into one checked Excel sheet
Claude reads a folder of supplier invoices into one spreadsheet with formulas, flags the totals that don't add up, and repeats it every weekday morning.
What you get: a real Excel file, one row per invoice with the supplier, the invoice number, net, tax and total, plus a Check column. The check is a formula, so it still works when you fix a number by hand.
Steps
- Open the Claude desktop app and switch to Cowork.
- Choose the folder that holds the invoice PDFs.
- Paste the prompt below and send it.
- Open the sheet Claude saves and look only at the rows the Check column flags.
- In the same chat, ask Claude to run this every weekday at 8. It drafts a scheduled task with a name, a time and the instructions. Read it and click Schedule.
Read every PDF in this folder. One row per invoice. Check that net + tax = total and flag duplicate numbers. Save as Excel.
The Check column, if you want to write it yourself. Ask Claude for formulas instead of typed results, so the sheet keeps checking itself after you edit it. With net in column D, tax in E and total in F, these two do the job:
=IF(ABS(D2+E2-F2)>0.01,"Sum off","OK")
=IF(COUNTIFS(A:A,A2,B:B,B2)>1,"Duplicate","OK")
What to do with the flagged rows. A sum that's off is usually a line Claude missed on the PDF: a discount, a delivery charge or a second tax rate. Open that one PDF, fix the number in the sheet, and the check turns OK. A duplicate is most often the same invoice sent twice, for example as a reminder. Keep one row and delete the other before anything goes into your accounting software.
Episode 2: bills into QuickBooks without double entries
Claude looks for each invoice in QuickBooks first, records a bill only when it isn't there yet, and shows the list before anything is saved.
What you get: every OK row from your sheet recorded as a bill in QuickBooks, with the supplier, the invoice number and the amount, and nothing entered twice.
Steps
- In Claude, open Connectors, find QuickBooks Labs and click Connect. Sign in with your Intuit login.
- Attach or point Claude at the sheet from episode 1.
- Paste the prompt below.
- Read the list Claude shows you: new bills to record, and the ones it skipped because they're already in QuickBooks.
- If the list is right, tell Claude to go. Then open QuickBooks and look at the new bills.
For each OK row in invoices-oct.xlsx, find a bill from that supplier with that number. If there's none, record it. Show me the list before saving.
Why look first, then write. The same invoice often reaches you twice: once by email, once as a reminder, or once in last week's batch and again in this one. Checking QuickBooks for the supplier and invoice number before writing anything is what keeps your books free of double bills. If one of your suppliers reuses invoice numbers, add the amount to the check: "same supplier, same number and same amount".
Keep the last line of the prompt. "Show me the list before saving" is what turns Claude from a typist into an assistant you can check. It costs you a few seconds, and it's the moment you catch a wrong supplier before it becomes a bill.
Episode 3: Xero, where Claude can only read
Claude's Xero connector can't write, so Claude matches every supplier to its exact name in Xero and prepares Xero's own bill import file. The bills arrive as drafts.
What you get: the same bills in Xero as drafts, with each one under the supplier Xero already has, ready for you to approve.
Steps
- In Claude, open Connectors, find Xero and click Connect. Sign in to Xero and pick your organisation. Claude can now read your books, but it can't change them.
- Paste the prompt below, with the sheet from episode 1.
- Read Claude's answer: which supplier names already match Xero, and which ones it renamed to the name Xero has.
- In Xero, go to Bills to pay, open the arrow next to New bill and choose Import. Upload the file Claude made.
- Every bill arrives as a draft. Check them and approve.
Match each supplier in invoices-oct.xlsx to its exact contact name in Xero. Then put the OK rows in Xero's bill import file.
Why the exact name matters. Xero's import matches suppliers by their name. If the name in your file differs by one letter ("Northline" instead of "Northline Freight Ltd"), the import adds a second supplier instead of using the one you have, and your supplier list slowly fills with near-copies. That's the one job the read-only connector is perfect for: Claude reads your Xero contacts and writes the file with the names Xero already uses.
Use Xero's template. On the import screen Xero offers its bill template. Give it to Claude so the file has exactly the columns Xero expects. Lines that share an invoice number become one bill with several lines.
Then let the inbox do it. Each Xero organisation has its own bills email address, shown under Bills to pay. Supplier invoices forwarded there as PDF, JPG or PNG turn into draft bills without any file at all. You can ask your suppliers to send invoices there directly.
When this isn't the right setup
- A few invoices a month. Typing five bills is faster than setting any of this up.
- It must run when nobody's computer is on. The scheduled task in episode 1 runs on your machine. If the invoices arrive in a shared inbox and should be booked at night, that's a small app with its own server, not a Cowork task.
- Several people approve bills. Cowork works as you, in your accounts. Approval steps, roles and an audit trail for a team need an app built for that.
- Your books aren't in QuickBooks Online or Xero. The connectors in these videos are for those two. For other software, the sheet from episode 1 still saves you reading every PDF.
Questions people ask
- Which Claude plan do I need for this?
Cowork comes with the paid plans: Pro, Max, Ultra, Team and Enterprise. Pro starts at $17 a month billed yearly or $20 monthly (checked 15 November 2026 on claude.com/pricing). The QuickBooks and Xero connectors are added from Claude's connectors list.
- Can Claude enter bills into Xero directly?
Not through Xero's Claude connector: it reads your books and doesn't change them. Claude can prepare Xero's bill import file, and Xero creates the bills as drafts when you upload it. Forwarding invoices to your Xero bills email address also creates drafts.
- Does the QuickBooks part work outside the US?
Intuit's Claude connector is for US companies, and the bills feature is in the QuickBooks Labs beta. Outside the US, the sheet from episode 1 still saves you reading every PDF by hand.
- Is it safe to let Claude write to my books?
Keep a check before every write. In episode 2 the prompt makes Claude show the list before saving anything. In episode 3 every bill arrives in Xero as a draft, so nothing is paid until you approve it.
SOURCES
- 1.Schedule a task in Claude: create, review, Schedule; tasks that need this computer (support.claude.com) · checked 17 November 2026
- 2.Claude Cowork: plans that include it (claude.com) · checked 15 November 2026
- 3.Intuit QuickBooks Labs connector for Claude: bills and expenses, beta (claude.com) · checked 17 November 2026
- 4.Xero's connector for Claude: read-only, sign in and pick the organisation (xero.com) · checked 18 November 2026
- 5.Importing bills into Xero from CSV: they arrive as drafts (usked.com) · checked 18 November 2026
- 6.How to import bills into Xero (fastlane-global.com) · checked 18 November 2026
- 7.Xero ideas forum: bill imports match contacts by name (productideas.xero.com) · checked 18 November 2026
- 8.Xero bill import: separate template from sales invoices; rows with one invoice number form one bill (invoicedataextraction.com) · checked 18 November 2026
- 9.Emailing invoices to Xero's bills address (tailride.so) · checked 18 November 2026
Prices checked 15 November 2026 · on each vendor's own pricing page: Claude plans.
Drafted with Claude from our project records; checked and edited by Mark.