Invoice Reconciliation: How to Reconcile Invoices in QuickBooks Online and Xero

Invoice reconciliation is the check that every supplier invoice in your books is real, recorded once at the right amount, and matched to the payment that settled it. To reconcile invoices you compare three things for each supplier: the invoice, your ledger and the payment, then fix whatever does not agree.

Most guides on this topic assume a purchasing department, purchase orders and a warehouse that signs for deliveries. Most small businesses and the bookkeepers who work for them have none of that. This guide shows the method that works without purchase orders, walks through the same steps in QuickBooks Online and in Xero, and works one supplier's month through with real numbers: a duplicate, a short payment, a credit note and a partial payment. See the 90 second demo if you would rather watch the collection half first.

Table of contents

1. What it is: the two jobs the phrase covers, and what counts as reconciled
2. What you need first: invoices, credit notes, statements and payments, and why collecting them takes the longest
3. The steps: seven steps that work without purchase orders, plus a free checklist PDF
4. 2-way, 3-way and no PO: what the matching terms mean and what small businesses use instead
5. In QuickBooks Online: five native steps, from the bills list to the aging report
6. In Xero: the same five steps, in Xero's own screens
7. Worked example: one supplier's statement against your books, line by line
8. Common discrepancies: a table of what goes wrong, why, and the fix
9. For firms: running the same check across many clients' books
10. What to automate: the steps software handles well, and the ones that stay with a person
11. Bank reconciliation: how the two checks differ and why you need both
12. How often: weekly, monthly, or by supplier volume
13. 3-way match: the textbook control, in plain terms
14. Without a PO: what replaces the purchase order as evidence

Skim for the section you need, or read it through once.

What is invoice reconciliation?

Invoice reconciliation means checking that each supplier invoice in your books matches what you agreed to buy and actually received, that it was recorded once at the correct amount, and that the payment against it is right. It has two halves: matching the bill to the purchase, and matching bills to payments. When both agree for every supplier, the payables balance in your books is one you can trust.

Two halves, one goal: a payables balance you can trust.

The phrase gets used for two different jobs, and most confusion about it comes from mixing them up.

Matching the bill to the purchase. Before you accept a bill, you check that it describes something you actually ordered and received, at the price you agreed. In a large company this is the purchase order and goods receipt check. In a small business it is usually lighter: the quote, the email where you agreed the price, the delivery note, the contract, or simply last month's bill from the same supplier.

Matching bills to payments. After the bill is recorded, you check that each payment you made is attached to the right bill, for the right amount, and that nothing is open that should be paid or paid that should be open. This half is where duplicates, short payments and forgotten credit notes show up.

"Reconciled" means both halves agree for a supplier and period, and any difference has a written reason. It does not mean every bill is paid. A bill that is correct, recorded once and not yet due is reconciled. A bill that is paid twice is not, even though your books may show it as settled.

The rest of this guide treats invoice reconciliation as the accounts payable job: bills you receive from suppliers. The same logic applies to sales invoices you send, matched against customer payments, but the documents and the screens are different.

What do you need before you reconcile invoices?

You need every supplier invoice and credit note for the period, a statement from each supplier you buy from regularly, a list of the payments you made by bank, card and check, and a view of the bills recorded in QuickBooks Online or Xero. Gathering the invoices is the slow part, because they arrive in several inboxes, as forwards, as portal downloads and on paper, and each missing one turns into a gap later.

Collection is step zero, and it is where the time goes.

Here is the full list, with what each one is for.

Every invoice for the period. Not just the ones already in your accounting file. The point of the exercise is to catch the invoice that never got recorded, so you need the source documents, not the ledger's copy of them.

Credit notes. Suppliers issue credit notes for returns, damaged goods and pricing errors, and they are easy to miss because they do not ask for money. An unrecorded credit note means you overpay.

Supplier statements. A statement lists every invoice, credit and payment the supplier has on your account, with a running balance. It is the one document that shows the relationship from the other side, which is why it catches things your own records cannot. Ask for one from your largest and most frequent suppliers, or download it from their portal.

Payments. Your bank and card statements for the period, plus any checks written. Reconciling invoices is about which bill each payment settled, so you need to see every outgoing payment to a supplier.

Your recorded bills. The bills list in QuickBooks Online or Xero for the period, with paid and unpaid status.

The reason collection deserves its own heading is that it is where the hours go. Invoices land in the owner's inbox, the office manager's inbox, an old accounts address, a supplier portal and the mail. A bookkeeper often spends more time asking "do you have the Tallowmere invoice from the 10th?" than matching anything. One intake point, a single address or folder where every bill ends up, makes every later step faster.

How do you reconcile invoices?

Pick the period and the suppliers, gather every invoice, credit note and statement, and check each invoice against what you ordered. Then confirm each one is recorded once with the right amount and tax, match each payment to its bill, and compare each supplier's statement balance to the balance in your books. Fix and note every difference before you sign off the period.

Seven steps, and none of them needs a purchase order.

1. Set the period and the supplier list. Pick the dates, usually last month, and list every supplier with activity in that window. Pull the list from your accounting file so you do not rely on memory.
2. Gather the documents. Every invoice, credit note and statement for those suppliers, in one folder. Note anything you know is missing and ask for it now, not at step six.
3. Check each invoice against what you agreed to buy. Without a purchase order, use whatever evidence you have: the quote, the email that agreed the price, the delivery note or packing slip, the contract, or last month's bill for a recurring service. You are looking for prices that changed, quantities you did not receive and charges nobody approved.
4. Check each invoice against your books. Is it recorded? Is it recorded once? Are the supplier, invoice number, date, amount, tax and account right? This is where a forwarded copy entered as a second bill gets caught. Our guide on how to catch duplicate invoices covers this check in depth.
5. Match payments to bills. For every payment to a supplier, find the bill it settled. Watch for one payment that covers several bills, a payment that covers part of a bill, and a payment that does not match any bill at all.
6. Compare the supplier's statement to your balance. The statement balance and your balance for that supplier should agree, allowing for timing: a payment you sent on the 30th that the supplier recorded on the 2nd. Every other difference is a discrepancy to explain.
7. Fix, note and sign off. Correct what is wrong, record the reason for every adjustment, and mark the supplier as reconciled for the period. A one-line note now saves an hour of archaeology at year end.

Download the invoice reconciliation checklist (PDF): this checklist, the QuickBooks Online and Xero step for each check side by side, and a discrepancy log to fill in. Or download it as a Claude skill. To use the skill, upload the zip under Skills in Claude's settings, then ask Claude to "reconcile a supplier". It asks for the ledger, supplier and period, works through the checks, and ends with a reconciliation record. It never changes anything in your books.

Here is the checklist we use for each supplier:

• Period and supplier named
• All invoices and credit notes for the period collected
• Statement received, or noted as not available
• Each invoice checked against the quote, email, delivery note or prior bill
• Each invoice recorded once, with the right number, date, amount, tax and account
• Each credit note recorded and applied to a bill
• Each payment matched to the bill or bills it settled
• Statement balance agrees with book balance, or the difference is explained
• Every adjustment has a written reason
• Supplier marked reconciled, with the date and your initials

2-way vs 3-way matching, and what to do without purchase orders

Two-way matching compares the invoice with the purchase order. Three-way matching adds a third document, the receiving record, to prove the goods arrived. Both assume a purchase order exists. Most small businesses never raise one, so they reconcile against the evidence they do have, which is the quote or email, the delivery note, the supplier's history and the supplier's statement.

Use the evidence you already have.

The purchase order exists to answer one question before a bill is paid: did we agree to this? A small business answers the same question with different paper. A quote you accepted by email is an agreement on price. A delivery note or packing slip you signed is a receiving record. Last month's bill from the same supplier tells you what normal looks like, so a price that jumped stands out.

The supplier's statement does the job a purchase order system does at the end of the chain. It shows every invoice the supplier believes you owe, which lets you spot an invoice you never received, and every payment they recorded, which lets you spot one that went astray.

So the practical version of matching for a business without POs has three checks: is the price what we agreed, did we receive what is billed, and does the supplier's statement agree with our books? If you can answer all three for each supplier, you have done the job a 3-way match does, with the documents you actually keep.

How to reconcile invoices in QuickBooks Online

If you came here to reconcile a bank or credit card account in QuickBooks, that is a different job, covered in the difference between invoice reconciliation and bank reconciliation.

In QuickBooks Online, invoice reconciliation uses five native features: the Bills list to review what is recorded, the duplicate bill number warning, vendor credits applied through Pay bills, bank transaction matching to mark bills paid, and the A/P Aging Detail and Unpaid Bills reports to compare against a supplier's statement. Each step below has its Xero twin in the next section.

Five steps, all built in.

1. Review the bills. Open the bills list and filter to the period and supplier. Each bill shows as unpaid or paid. Check the supplier, number, date, amount and account on each one against the source invoice. Intuit's guide to entering bills and recording bill payments shows where each field lives.

2. Catch duplicates on entry. Under Account and Settings, Advanced, there is an option to warn you when a bill number has already been used for that vendor. It only compares within one vendor, so a bill recorded under two spellings of the same supplier still gets through.

3. Apply credits. Record a supplier credit note as a vendor credit, then apply it when you pay the bill: in Pay bills, the vendor's open credit appears in the credit applied column and reduces what you pay. Intuit's community answer on applying a vendor credit walks through it.

4. Match payments to bills. In Bank transactions, QuickBooks suggests matches between downloaded bank lines and open bills, and matching one marks the bill paid. Intuit notes that a match is not suggested when bank fees or discounts change the total, or when the bill falls more than 90 days before or 20 days after the bank line (Intuit, match your bank and credit card transactions). Those are exactly the short and partial payments worth a closer look.

5. Compare against the statement. Run A/P Aging Detail or Unpaid Bills for the supplier, as of the statement date, and tick it off line by line against their statement. The Vendor Balance Detail report shows every bill, credit and payment behind the balance.

How to reconcile invoices in Xero

If you came here to reconcile a bank account in Xero, that is a different job, covered in the difference between invoice reconciliation and bank reconciliation.

In Xero, invoice reconciliation uses the same five steps: the bills list by status, Xero's duplicate bill review, credit notes allocated to bills, bank reconciliation with suggested matches and Find and Match to mark bills paid, and the Aged Payables reports compared against a supplier's statement. Each step mirrors the QuickBooks Online section above.

Same five steps, Xero's screens.

1. Review the bills. Open the bills list. Xero splits bills by status: draft, awaiting approval, awaiting payment and paid. Filter to the period and supplier, and check each bill's contact, reference, date, amount and account against the source invoice. A draft does not change what you owe, which makes it a natural place to check a bill before it counts.

2. Catch duplicates on entry. Xero compares the contact, reference and amount of bills and credit notes and flags potential duplicates for review on the bills pages (Xero Central, review duplicate bills or credit notes). Bills created from the same repeating template are not compared with each other.

3. Apply credits. Record a supplier credit note as a bill credit note, then allocate it to the bill it relates to. The bill's balance due drops by the credit, and the credit stops floating on the supplier's account.

4. Match payments to bills. In bank reconciliation, Xero suggests matches between statement lines and bills awaiting payment, and reconciling one records the payment. When the suggestion is wrong or missing, Find and Match lets you match one statement line with several bills and account for bank fees or other adjustments (Xero Central, find transactions to match to bank statement lines).

5. Compare against the statement. Run the Aged Payables Detail report for the supplier, as of the statement date, and tick it off line by line against their statement. The supplier's contact record also lists every bill, credit note and payment behind the balance.

Where the two differ is the starting point. In Xero a bill can wait as a draft before it affects what you owe. In QuickBooks Online a saved bill is open in accounts payable straight away, unless an approval workflow on your plan holds it. Both reach the same reconciled result.

Worked example: one supplier, one month

Here is one supplier's September, reconciled. Juniper Row Bakery buys boxes and cartons from Tallowmere Packaging. Both businesses are invented for this example. At the end of the month the bookkeeper has Tallowmere's statement and the bakery's own records, and they disagree by $1,040.

The statement says $1,370 is owed. The books say $2,410.

Work down it the way you would on a real file.

The duplicate. INV 2214 appears twice in the books and once on the statement. The second copy came from a colleague forwarding the email "just in case." Remove the extra bill, keep the one with the original PDF attached, and write a note saying why.

The credit note. Tallowmere issued CN 118 for $180 after a pallet of cartons arrived crushed. It went to an inbox nobody checks for bills. Record it as a vendor credit in QuickBooks Online or a credit note in Xero, and apply it to INV 2214, which leaves $680 open on that bill.

The short payment. The bakery paid $1,200 against a $1,240 invoice, assuming an early payment discount Tallowmere does not offer. Both sides agree $40 is still open, so it is not a difference between the books, but it is a decision: pay the $40, or ask Tallowmere to write it off. Either way, note it.

The partial payment. The $1,500 paid against INV 2229 was agreed with the supplier, and $650 is open on both sides. Nothing to fix.

After the two fixes the books show $40 + $680 + $650 = $1,370, which matches the statement. The supplier is reconciled for September. Book a demo on your own documents to see how bills and credit notes from a month like this one arrive in your books.

Common discrepancies and how to fix them

Most differences between an invoice, your books and a supplier's statement fall into a short list: a duplicate bill, a missing bill, a credit note never recorded, a short or partial payment, a payment applied to the wrong bill, an amount that differs because of tax or freight, and one supplier recorded under two names. Each has a usual cause and a standard fix.

Start with the duplicates and the credits.

Two habits prevent most of the list. First, one intake point for every bill, so nothing lands in a forgotten inbox and nothing arrives twice by two routes. Second, statements from your biggest suppliers every month, because the statement is the only document that shows a missing bill or a forgotten credit from the other side.

A difference you cannot explain after a reasonable look should be written down as unexplained and carried forward. Forcing it to zero hides the next one.

Reconciling invoices for several clients (for firms)

For a bookkeeping firm, invoice reconciliation is the same seven steps run in every client's file, so the work is mostly scheduling and chasing. Set a cadence per client by volume, keep one intake address per client so documents land in the right books, chase missing invoices and statements early in the month, and keep a reconciled date per supplier so you know where each file stands.

The method stays the same. The calendar is the hard part.

Cadence by volume. A client with three suppliers and a dozen bills a month can be reconciled monthly in one sitting. A client with forty suppliers is better done weekly for the busiest few and monthly for the rest. Matching the cadence to the volume keeps the end of the month from piling up.

One intake address per client. The worst firm version of the collection problem is a bill landing in the wrong client's books, or in the firm's own inbox with no client attached. A separate intake address or folder for each client keeps every document attached to the right file from the moment it arrives.

Chase early. Missing invoices and statements are the bottleneck. Asking on the first working day of the month, with a specific list ("we have no invoice from Tallowmere for the 10th"), gets better answers than a general reminder at the deadline.

Track a reconciled date per supplier. A simple sheet with client, supplier, last reconciled date and open questions tells anyone in the firm where each file stands. It also makes the month's review faster, because you start from the last clean point.

Invoice reconciliation is one line on a bigger list of what happens at the end of each period. Our month-end close checklist shows where it sits alongside the bank reconciliation, accruals and the review of payables and receivables.

Which parts can you automate?

The steps that automate well are the ones before the judgment: collecting invoices from every inbox, reading the vendor, number, dates, totals and tax, posting a bill to QuickBooks Online or Xero, and holding duplicates and anything doubtful for a person. Deciding whether a price is right, agreeing a short payment with a supplier and signing the period off stay with you.

Automate the gathering. Keep the judgment.

Look back at the seven steps. Steps 2 and 4, gathering every invoice and checking it is recorded once and correctly, take the most time and need the least judgment. Steps 3, 6 and 7, deciding whether a charge is right, talking to the supplier and signing off, need someone who knows the business. That is the line to draw.

DocStreamAI covers the first part for QuickBooks Online and Xero. It watches connected Gmail and Outlook inboxes and a per-organization forwarding address, and documents can be uploaded directly, so invoices end up in one place without anyone forwarding them. It reads the vendor, invoice number, dates, line items, tax and totals, matches each document to the vendors and categories already in your accounting file, and posts an approved invoice as an open bill in QuickBooks Online or a draft bill in Xero, with the original attached.

It also holds documents for a person when something looks wrong. An invoice that duplicates one already processed is held, even on the Automatic setting. So is an invoice with no due date, one where the subtotal plus tax does not equal the total, one addressed to a company that is not yours, and one where the categorization came back low confidence. A receipt that exactly matches a transaction already in your books is attached to that transaction, and no new expense is created.

What it does not do matters as much. It does not pay bills, so it cannot see a payment made twice. It does not reconcile your accounts or talk to your suppliers. The statement check and the sign off stay yours, and they get faster when the bills are already in the books. Estimate your own time saved with the calculator.

If you are comparing tools for this, our roundup of invoice reconciliation software sorts the options by the job each one does. And if you are unsure whether a document should be a bill or an expense in the first place, see our guide to bills vs expenses in QuickBooks and Xero.

What is the difference between invoice reconciliation and bank reconciliation?

Invoice reconciliation checks supplier bills: that each one is valid, recorded once at the right amount and matched to its payment, usually confirmed against the supplier's statement. Bank reconciliation checks your bank account: that every transaction on the bank statement is recorded in your books and the closing balances agree. One proves what you owe, the other proves what cash moved. Clean books need both.

They meet at the payment.

The overlap is the payment. A bill payment shows up in both checks: as the item that settles a bill, and as a line on the bank statement. That is why QuickBooks Online and Xero both let you match a bank line to an open bill. It is also why a bank account can reconcile perfectly while payables are wrong: a duplicate bill that was never paid does not touch the bank at all, so only an invoice reconciliation finds it.

How often should you reconcile invoices?

Most small businesses reconcile invoices monthly, alongside the bank reconciliation, because supplier statements usually arrive monthly. If you pay many bills each week, a short weekly check of new bills and payments catches duplicates before they are paid, with a full statement comparison at month end. Low-volume suppliers can be checked quarterly, as long as nothing is paid against an unchecked bill.

Match the rhythm to the volume.

The real rule is that the check should happen before money leaves for anything large or unusual. A monthly cycle is enough for most suppliers, but a $9,000 invoice from a new supplier deserves its own look before it is paid, whatever the calendar says.

What is a 3-way match?

A 3-way match is a check that compares three documents before a bill is paid: the purchase order that says what was ordered and at what price, the receiving record that says what actually arrived, and the supplier's invoice. If quantities and prices agree across all three, the bill is approved. If any one differs beyond a set tolerance, the bill is held until someone resolves it.

It answers three questions: ordered, received, billed.

In practice a 3-way match catches the classic short shipment: you ordered 200 cartons, 180 arrived and the invoice bills for 200. It needs purchase orders and a receiving step to work, which is why it suits businesses with stock and a warehouse more than a service business or a small shop.

Can you reconcile invoices without a purchase order?

Yes. Without purchase orders you reconcile against the evidence you do keep: the accepted quote or the email that agreed the price, the delivery note or packing slip, last month's bill for a recurring charge, and the supplier's statement. Check the price was agreed, the goods or service arrived, the bill is recorded once, and the statement balance matches your books.

Most small businesses already hold the evidence.

The one thing a purchase order adds is a record made before the invoice arrives. If you want some of that benefit without a purchasing system, keep accepted quotes and price agreements in the same place as the invoices, so the comparison in step 3 takes seconds instead of a search.