Automating supplier invoice entry in QuickBooks

In a project-based SME, a supplier invoice is not just something to pay. Someone opens the email, downloads the PDF, finds the purchase order, checks the price, picks the job, enters the bill in QuickBooks and files the document. Six steps, times dozens of invoices a week.

None of it is hard. It is slow, it interrupts everything else and it always runs late, so the true cost of a job only shows up at month end once the pile is cleared. That is exactly the kind of work an AI agent can take on without taking control away from accounting.

Credit where it is due. QuickBooks Online lets you forward receipts and bills by email. According to Intuit Canada’s help centre, each user sets up an address ending in @assist.intuit.com. QuickBooks reads the image, extracts the date, amount, supplier and, where relevant, the last four digits of the credit card, then creates a transaction for review under Receipts.

Intuit sets a few conditions: PDF, JPEG, JPG, GIF or PNG files, one receipt per file and attachments between 46 KB and 20 MB. For a business with a modest invoice volume and no job costing, this feature is often enough. Start there.

Reading the header is only the start. The time goes into everything after it.

An AI agent is not a data-entry bot copying boxes. It is a program that reads, reasons about what it read and prepares an action. It follows written instructions and stops where you told it to.

It reads the inbox. The agent watches the addresses where invoices arrive. It recognizes an invoice even when the file name is useless, and splits a PDF that holds several.

It matches the job. The agent compares PO numbers, addresses and descriptions with your open jobs. When the link is clear, it makes it. When it is unsure, it says so and suggests the two likeliest jobs.

It prepares the bill for QuickBooks. Supplier, date, due date, lines, taxes and job, with the PDF attached. The bill goes in through the QuickBooks API, not through copy and paste.

Accounting approves. Nothing is posted without sign-off. The bookkeeper sees the invoice, the proposed job and any flagged gaps, then approves, fixes or rejects. The work shifts from typing to checking.

Les Industries Romy, a manufacturing SME in Granby, received supplier invoices by email and keyed them in by hand. Labour and material costs were not tracked by job, so nobody could see the total spend on a job in progress.

Today the agent reads the invoices that arrive by email, matches them to the right job and prepares them for QuickBooks. Accounting reviews and approves instead of typing. By management’s estimate, time spent on this work went from 12 hours to 1 hour a week. Job costing now builds up as the work happens rather than at month end.

That figure is management’s estimate, based on watching its own teams. It has not yet been measured over a full year. The full story is in the Romy case study.

Not every invoice looks the same, and that is where you find out what an agent is worth. A credit note has to reverse part of a bill already entered. A partial delivery arrives with an invoice covering only half the order. An American supplier bills in US dollars. One PDF bundles material for two different jobs.

A good agent does not guess in those cases. It recognizes the situation, prepares what it can and asks the right person, with the documents in front of them. Accounting decides once, then the rule is written down for next time. Over the weeks the list of exceptions gets shorter without ever disappearing, and that is normal: part of bookkeeping remains a matter of judgment.

Automating entry does not mean automating payment. A few simple rules keep the business in charge.

Invoices reveal a lot: your suppliers, your prices, your margins and your clients’ names. At Romy, the agent runs on a server in the shop. No client data leaves the company, and accounting entries go through the QuickBooks API. That is what we mean by sovereign AI.

The same approach works with other software. If your books live in an ERP, our agents also connect to Business Central and Acumatica. For manufacturers, the Manufacturing page shows the workflows we automate, supplier invoices included.

Take one month of invoices and count. How many do you get? How long does each one take? How many arrive without a PO number? Those three numbers tell you whether automation is worth it and where the agent will earn its keep.

Part of the work may be funded: our Funding page covers the programs available in Quebec. And if you want to see the flow run on your own invoices, get in touch.