Automate supplier invoices into draft bills in QuickBooks Online or Xero

Money comes into an ecommerce brand through marketplace payouts. It goes out through supplier invoices: the manufacturer's invoice for a production run, the freight forwarder's bill weeks later, customs and duty, and the 3PL's monthly charges. Most of them arrive as PDFs in someone's inbox and get keyed into QuickBooks or Xero by hand, often without anyone checking them against the PO or the delivery. This recipe reads each invoice, checks it against what you ordered and what arrived, and leaves a draft bill for a person to approve. It is one page of our automation library.

Which checks decide whether an invoice becomes a draft bill?

This is the core of the build, and you can use it today as a checklist even if every invoice is still entered by hand. Each row is one check, the field it reads, and what the workflow does. "Draft" means a bill is created for approval. "Hold" means the invoice waits in a queue with the reason and both numbers shown. "Route" means a named person must decide before anything else happens.

Tolerances are your finance lead's call, set per supplier or per category. For example, a brand might allow a unit price up to 1% over the PO and no quantity over the receipt, while freight bills get a wider tolerance because rates move. These numbers are illustrative; choose your own and write them down, because the rules apply them exactly.

Invoices that pass every check become a draft bill. Those that fail one wait with a reason. Nothing is paid by the workflow.

How do two-way and three-way matching differ?

Two-way matching compares the invoice with the purchase order: right supplier, right items, right price. Three-way matching adds the receipt, so you only pay for what actually arrived. For inventory, three-way is the safer default. For services and freight there is nothing to receive, so two-way, plus a link to the shipment, is the norm.

The receiving record often lives outside the accounting file. In Shopify, the purchase orders guide says you create an inventory transfer for a PO to track shipments, receive inventory and add cost adjustments (checked October 13, 2026). With a 3PL, the receipt is their receiving report. Short, over and wrong-item receipts are where stock goes missing, which our 3PL reconciliation page covers from the inventory side; this recipe covers the bill.

What do QuickBooks Online and Xero already do on their own?

Both now capture bills from email, so check the built-in features before you build anything. What they do not do on their own is join each invoice line to the receipt in your warehouse or 3PL.

Hubdoc is another capture option: it lists QuickBooks Online and Xero and says it reads supplier names, amounts, invoice numbers and due dates to create transactions with the source document attached (checked October 13, 2026). If you have a handful of suppliers and no POs to match, these built-in tools are the better choice. Custom work earns its cost when invoices must be checked against POs and receipts that live in Shopify, a WMS or a 3PL portal.

Which tool should run it?

For a few suppliers with clean PDFs, Zapier, Make or n8n with an AI step can read the invoice and create a draft bill. Our Zapier vs Make vs n8n comparison covers how they differ. Once the match needs receipts from another system, per-supplier tolerances and a proper hold queue, custom code on your accounts is cleaner, and it can run on Ecomsellertool Growth OS. Through the APIs, the workflow writes a Xero bill as DRAFT or SUBMITTED so it waits for approval, and it creates a QuickBooks bill only after the checks pass, leaving approval to your workflow in QuickBooks.

What should stay with a person?

Approval and payment, always. The model only reads documents; it never decides that a price difference is fine. A person decides each held invoice with the supplier, sets up new suppliers, confirms any change of bank details by phone, and agrees with your accountant how freight, duty and 3PL charges are coded. Getting that coding right matters beyond the books: landed costs that land in the wrong place make contribution margin per SKU look better than it is.

What can go wrong, and how do you catch it?

Deciding where to start? Our post on what to automate first in ecommerce scores tasks on hours, the cost of a mistake, how rule-shaped they are and how many systems they touch. Supplier bills score well on rule shape when invoices are many and similar, and the revenue side is covered by our marketplace payouts recipe. If you also sell wholesale on net terms, the receivables side, chasing your own buyers' invoices, is our B2B invoice reminders recipe.

Who builds this for ecommerce brands?

Ecomsellertool builds finance and purchasing workflows like this on your own accounts. We have built software on Amazon's seller APIs since 2017 and shipped 50+ tools for 100+ teams. We start with your suppliers, your PO and receiving records and your accountant's chart of accounts, then build the reading, the match and the hold queue. Send a project brief below, or read how our workflow automation service works.

The building blocks are work we have shipped:

• Purchase orders checked against deliveries. For Amazelligence, a seller on Amazon, eBay and other marketplaces, we built purchase order management with its suppliers, with automated inventory reconciliation, notices for payments due, and alerts for discrepancies in inbound deliveries. That is rule-based automation we built, the same kind as the match here.
• Vendors, POs and warehouse stock in one system. For Ecomsherpa we built a warehouse management system that manages vendors, vendor SKUs, purchase orders and warehouse inventory, and calculates overhead costs and Amazon fees.

The POs this workflow matches against can come from our low-stock alerts and draft purchase orders recipe.

Get this workflow built