FlowsBook a callSign inCreate free accountSign up
Workflows by industry

How due diligence teams check a retail chain's store list against the map

Verify a retail chain store list before a deal: find each branch on the map, flag closed or missing ones, and spot branches the seller left out.

Part of the guide Workflow automation

By the xMap team · · 5 min read

To verify a retail chain store list, check it in both directions. First look up every branch the seller lists and confirm it exists, trades under that name and is open. Then search the cities where the chain operates for every place carrying its brand and see which ones are missing from the list. Branches that cannot be found, branches shown as closed, and branches the list leaves out are the three findings that matter, and each one is a question for the seller before signing.

This is for transaction advisers, private equity deal teams, lenders and corporate development staff buying or financing a chain of shops, restaurants, clinics or gyms. It covers why store lists drift from reality, the two-way check, a made-up example, what trips people up, and a flow that runs the check in an hour rather than a week of phone calls.

Why store lists drift

A data room store list is usually exported from a finance or property system. It is rarely wrong on purpose, but it is often out of date. Typical gaps:

  • Branches that closed in the last quarter but still carry a lease or a cost centre.
  • Branches that moved down the street and kept the old address in the system.
  • Franchised or licensed sites that trade under the brand but are not owned, and are therefore not on the list.
  • Pop-ups and concessions inside department stores, counted by some teams and not others.
  • Branches that opened recently and have not reached the finance system yet.

Each of these changes the value of the business, its revenue per site or its exposure to leases.

The two-way check

From the list to the map

For every branch on the list, search online maps for the brand name at that address. A branch that is found, open and well rated is confirmed. A branch found but marked as closed, found under a different name, or not found at all goes on the exceptions list. Map business scan does this search live, one place at a time, and returns the address, phone, website, rating and whether the place is open.

From the map to the list

Then search each city the chain trades in for places of its kind carrying its brand. Nearby places can keep only places whose brand or name has the chain's name, and say whether each belongs to a chain. Any branch it finds that does not match a line of the list is a site the seller has not mentioned.

An example, made up

Suppose a lender is financing the purchase of a chain of 84 bakeries across three cities in Spain and Portugal. The seller's list has 84 lines. In this invented case the check finds:

  • 76 branches confirmed, open, at the listed address.
  • 3 branches marked as closed on the map, all in the same city.
  • 2 branches found at a nearby address, suggesting they moved.
  • 3 branches not found at all.
  • 5 places trading under the brand that are not on the list, which turn out to be franchised sites.

The lender's questions to the seller write themselves: are the three closed sites still under lease, and are the franchised sites part of the deal, its revenue, or neither?

What trips people up

  • Short or common names. A one-word brand can match an unrelated business. Check every match whose address differs from the list.
  • Addresses typed differently. Abbreviations, unit numbers and old street names stop exact matching. Match on position as well as text.
  • Trusting a status without its date. A place shown as closed can be closed for refurbishment. Treat closed as a question, not a fact.
  • Searching too narrowly. A brand's franchised sites often sit outside the cities in the seller's list. Search the regions around them too.
  • Running it once. Repeat the check just before completion: a deal can take months, and branches open and close in the meantime.

Running the check in xMap Flows

Two short flows do the two directions, and an AI employee writes up the exceptions. The same flows can keep watching the portfolio after the deal closes.

  1. My data: the seller's store list, uploaded as a table; rows without positions are placed from their address and city when imported.
  2. Map business scan: around each incoming place, looking for each place itself, so each line gets the business found there, its status and its rating. It looks up to 100 places a run, so split a longer list into parts.
  3. Branch: confirmed branches one way; closed, renamed or not found the other.
  4. On a second flow, Area of interest with the chain's cities, then Nearby places for the chain's kind of place, keeping only its brand.
  5. Match with my table: compare those places with the seller's list by website, phone or name, and keep only the ones not found.
  6. xMap LLM, on the whole list: a short exceptions memo grouped by finding, with the questions to put to the seller.
  7. Email to the deal team with the memo, the exceptions table and a map, and a CSV of every line checked.

The deal team gets the confirmed branches as a file and only reads the exceptions, which is where the work is. After completion, swap the second flow's Match with my table for What changed on a monthly schedule, and the portfolio team hears when a branch closes or its rating falls.

Questions

Can this prove a branch is trading profitably?

No. It confirms that a branch exists, carries the brand and is shown as open, with its rating. Trading figures come from the seller.

How do I treat franchised branches?

List them separately. They trade under the brand but may sit outside the deal; ask the seller how each is treated in revenue and contracts.

What if the store list has no coordinates?

Upload it with addresses and cities. Rows are placed from their address when the table is imported, and the lookups use those positions.

How long does the check take?

For a list of a hundred or so branches, the lookups run in one flow and the memo arrives the same hour. Reading and chasing the exceptions takes longer.

Templates that do this

Read next

More on workflows by industry · Every article · Templates

Put it to work

An AI employee in xMap Flows does this on live data, on its own timetable. Start from a template or describe it in plain words.