Invoices and documents

Three-way matching in Sage 50: what's built in, what isn't, and how to automate the gap

By · Published

Sage 50 has no built-in invoice capture and no native three-way matching of purchase orders, goods received and supplier invoices. Sage 200 has purchase order matching built in. To automate the gap in Sage 50 you can add a capture tool, upgrade to Sage 200, or build a matching process that checks each invoice against the order and the delivery and holds any mismatch for a person.

It is the 28th. Julie has a tray of supplier invoices on her left and Sage 50 open on her right. She takes the top one, a PDF she printed this morning, and types it in: supplier, invoice number, date, nine lines, VAT. Then she finds the purchase order in Sage and walks to the warehouse for the delivery note, because the invoice says ten cases and she has a feeling nine came. It was nine. She writes “short, query” across the invoice and drops it in a second tray. The next one has no order number at all. The first tray is still two inches deep, the supplier statements are due, and the month has to close by Friday.

Julie is made up. The tray is not.

Key facts

  • Sage 50 has no built-in OCR or invoice capture, so nothing in it reads a supplier invoice for you (AccountingWEB).
  • Sage 50 has no native purchase order matching; Sage 200 has two-way and three-way matching built in (Pulsify).
  • Sage 50 has no web API, a way for one program to talk to another over the internet. Data reaches it through Sage Data Objects, import files or third-party connectors (Hyperext, Sage KB).
  • Xero and QuickBooks Online have built-in receipt capture that handles simple invoices; neither replaces matching against orders and deliveries.
  • A matching process can be automated around Sage 50 so that a person only sees the invoices that disagree with the order or the delivery.

What is three-way matching?

Three-way matching is checking a supplier’s invoice against two other documents before you pay it: the purchase order you raised, and the goods-received record that says what actually arrived. Two-way matching checks the invoice against the purchase order only. Julie did the three-way kind when she found the order in Sage and then walked to the warehouse.

Document What it says Who produced it
Purchase order What you agreed to buy, at what price You, before the goods were sent
Goods-received note (GRN) or delivery note What arrived, and when Your warehouse, on the day
Supplier invoice What the supplier wants paying for The supplier, often days later

The point is to pay only for goods you ordered, that arrived, at the price you agreed. For a merchant or wholesaler buying hundreds of lines a month, that is where margin leaks: a price increase nobody agreed, a short delivery invoiced in full, a case invoiced as ten when nine arrived.

What does Sage 50 do out of the box?

Sage 50 records the documents. It does not compare them for you. Julie does that.

If your edition includes purchase order processing, you can raise a purchase order, book goods in against it and turn the order into a purchase invoice. Sage 50 will not read a PDF invoice from an email. It will not check each invoice line against the order and the delivery, hold the ones that disagree, or send an invoice to the right person for approval. As one adviser put it on AccountingWEB when asked whether Sage 50 can capture invoices: “Sage 50 itself? No. There’s no built-in OCR or invoice capture” (AccountingWEB). Native purchase order matching is a Sage 200 feature, and third parties fill the gap for Sage 50 (Pulsify).

Sage 50 also has no web API, so another program cannot simply send it an invoice. Anything that posts invoices into it uses Sage Data Objects, which is Sage’s own toolkit for developers, or the import tools, or an established connector. We set the routes out on the Sage 50 systems page and in Sage 50 has no API: four ways to connect it.

Where does manual matching go wrong?

In the gaps between documents and in the month-end rush. Julie’s tray will contain most of these:

  • Invoice before goods. The invoice arrives, the delivery has not. Julie either posts it unchecked or leaves it in a tray, where it is forgotten.
  • Part deliveries. One order, three deliveries, two invoices. Matching lines by hand across all five documents is where quantities slip.
  • Price differences. The supplier’s list went up; the order was at the old price. Unless someone checks every line, the new price goes through.
  • Unit of measure. Ordered in cases, delivered in cases, invoiced in units, or the other way round.
  • Duplicates. The same invoice arrives by email and by post, or is re-sent with a new date and gets posted twice.
  • No PO number on the invoice. Julie hunts for the order by supplier and amount, and on a bad day picks the wrong one.
  • Approval by walking around. Invoices over a limit need a manager’s initials, and the manager is on site.

None of these is a Sage 50 problem. They are what happens when one person compares three documents from three sources by eye, and they explain why the UK Business Forums has a long-running thread on purchase invoice automation software. Xero’s research with Lonergan found that 45% of small businesses spend at least four hours a month managing accounts payable, the bills they owe suppliers (Xero); for a business matching hundreds of invoices it will be far more.

What does matching by hand cost?

It costs Julie’s hours and a slower month end. Every number in this paragraph is an assumption, so swap in your own. Say Julie handles 100 supplier invoices a week and each takes 6 minutes to type in, match and file. That is 100 × 6 ÷ 60 × 48 working weeks, or 480 hours a year. At an assumed £20 an hour for what Julie costs to employ, that is £9,600 a year.

The formula comes from how to calculate the ROI of automation. ROI is return on investment, what you get back for what you spend. The ROI calculator runs it on your own counts. Automation hands hours back as time, not cash. For Julie that time first buys a month end that closes sooner, because invoices are matched as they arrive and not saved for the last week. Count the price differences you catch separately, once you have a few months of data.

What are the options for automating it?

There are three, and they suit different businesses.

Option What it does Fits when Does not fit when
Capture tool (for example AutoEntry, which Sage owns, or another add-on) Reads invoices from a mailbox or scan, picks out supplier, totals and VAT, posts to Sage 50 You raise few purchase orders; approval is simple; the problem is typing, not matching You need every line checked against orders and deliveries, agreed limits on differences, or information from other systems
Upgrade to Sage 200 Built-in two-way and three-way purchase order matching, plus an API so other programs can talk to it You are outgrowing Sage 50 for other reasons too: users, stock, reporting You are upgrading only to get matching; the cost and disruption of moving outweigh the matching problem
Bespoke matching that holds mismatches for a person Reads invoices, matches each line to the purchase order and goods-received note wherever they live, posts the ones that agree, holds the ones that do not Hundreds of invoices a month, many different suppliers, several approvers, records in more than one system A handful of purchase orders a week; a capture tool and a quick check is enough

Our honest advice is to use built-in capture or a capture tool if either solves your problem, and an automation audit will say so. Xero and QuickBooks Online include receipt capture. Sage 50 does not, which is why the add-on market exists. If Julie’s only trouble were the typing, a capture tool would do. Her trouble is the walk to the warehouse.

On accuracy, PaperLess, writing on AccountingWEB, argues that capture at 85% accuracy with validation, meaning a check on what the software read, beats capture at 95% with none (AccountingWEB). We agree. What matters is whether someone catches the invoices the software reads wrong before anything is posted.

How does bespoke matching work?

It follows the steps Julie follows on a good day, written down and run on every invoice.

  1. Collect. Invoices arrive in a mailbox or scanner folder the system watches. It keeps the original alongside everything that follows.
  2. Read. The system reads the supplier, invoice number, date, PO reference, lines, quantities, unit prices, VAT and totals. Where it is unsure of a figure it marks it and does not guess.
  3. Find the order. By PO number where the invoice quotes one. Otherwise by supplier, amount and date, with Julie confirming any that could be one of two.
  4. Find the delivery. The goods-received note or booked-in quantities for that order, from Sage 50 or from wherever your warehouse records them.
  5. Compare line by line. Quantity invoiced against quantity received; price invoiced against price ordered. A tolerance is how small a difference you will let through, such as a small price difference or a rounding difference. Your finance lead agrees the tolerances and we write them into the agreement for the job. They are your numbers, not ours.
  6. Decide. An invoice that agrees within tolerance is posted to Sage 50 by a route Sage supports, or waits for approval if it is above a value limit you set. Anything else is held for Julie with the reason: “invoiced 10, received 9”, “price £4.20 ordered, £4.55 invoiced”, “no GRN yet”, “possible duplicate of INV-20417”.
  7. Keep a record. Every invoice, every match result, every decision and who made it.

Nothing is paid without a person, and nothing outside tolerance goes into Sage 50 without one either. How held items, second attempts and duplicate checks behave in general is covered in What happens to an order the software can’t read?; invoices work the same way.

How much does it cost?

Reading supplier invoices into Sage 50 or Xero, with simple approval, is usually a quick win at £1,500 to £3,000. Three-way matching against orders and deliveries, with tolerances, approval by the right person and mismatches held for a person, is a business workflow at £3,000 to £7,500. Where the orders, deliveries and invoices live in different systems and need connecting first, the project moves towards the operations band. Keeping watch, and making changes when a supplier alters its invoice layout, comes under managed support at £150 to £1,500 a month. The pricing page has the detail.

What about data protection?

Supplier invoices carry bank details, VAT numbers and, for sole traders, names and addresses that are personal data under UK GDPR. We process them under a written data-processing agreement that names every service involved, including any cloud service that reads the invoices, and says where the data is held. Access is limited to the mailbox and the Sage company the job needs, through a dedicated login you create. Passwords are kept in a password vault built for the purpose, not in code or email. We keep originals in line with your existing policy for accounting records, and the system logs every action. We walk your accountant or IT contact through it before go-live.

What does Julie’s month end look like afterwards?

It is the 28th again and there is no tray. The invoices that agreed with the order and the delivery are already in Sage 50, each with its original attached. Julie’s screen lists the ones held, with the reason beside each. “Invoiced 10, received 9.” She does not walk to the warehouse, because the booked-in quantity is on the screen next to the invoice. She rings the supplier about the missing case, approves a price rise the buyer has confirmed, and rejects a duplicate. Then she starts on the supplier statements, sooner than she used to. How much sooner depends on your suppliers and your records.

What we would do

We would take a month of your real supplier invoices and the matching orders and deliveries, and count how many would have agreed first time, how many would have been held and why. The same count tells you in pounds what the typing and matching cost today. If a capture tool covers it, we say so. If not, the invoice and document automation service builds the reading, the matching and the held list, and agrees tolerances with your finance lead. It runs alongside your current method for an agreed period, and then we switch posting on. The glossary defines three-way matching, OCR and data-processing agreement.

Sources

Questions people ask

Does Sage 50 have OCR or invoice capture built in?

No. Sage 50 itself has no built-in OCR, the software that turns a scanned page into text, and no invoice capture. Capture comes from an add-on such as AutoEntry, which Sage owns, or from another third-party tool or a bespoke process. Any of those can read a supplier invoice and prepare it for posting; what they do about matching it to a purchase order and a delivery varies a great deal.

We only raise a few purchase orders a week. Is matching automation worth it for us?

Probably not as a bespoke build. At low volumes a capture tool with a quick manual check is usually enough, and the audit would say so. Matching automation earns its keep when invoices arrive in the hundreds each month, when several people are involved in approval, or when the order, delivery and invoice records live in different systems.

Can the matched invoice be posted into Sage 50 automatically?

Yes, by a route Sage supports. Sage 50 has no web API, meaning no built-in way for another program to talk to it over the internet. Posting goes through its import features, the Sage Data Objects developer toolkit or an established connector, depending on your edition and volumes. Better Systems Co. only posts invoices that agree with the order and the delivery within the limits you set; everything else waits for a person.

What happens to an invoice that arrives before the goods?

It is held, not posted. The system records that it found the purchase order but no goods-received record exists yet, and checks again when deliveries are booked in. If the goods still have not arrived after a period you set, it raises the invoice to a person. That is the same thing a careful purchase ledger clerk does today, without the pile on the desk.

Related guides

Find out what the typing is costing you

A 20-minute call. You tell us about your Sandra, your Dave or your Phil, and how the job gets done today. We tell you honestly whether automating it would pay, and what it would cost.