AiStaffo

Fixing inter-branch stock transfer mismatches between two sites

Stock photo: warehouse shelves cardboard boxes
Photo: Ayrat / Pexels

A transfer mismatch happens when the quantity the sending branch dispatched does not match what the receiving branch counted. The fix has three parts. First, match every dispatch note to a receipt record, line by line, with a fixed deadline for the receiving count. Second, flag any difference by type: shortage, overage, damage or wrong item. Third, send a scheduled reminder to the receiving branch until the count is in or the difference is written off. A spreadsheet can do the matching for a small operation. A transfer order in an inventory system, plus a rule that chases open items automatically, does the same job for larger networks. The automated part handles the matching and the reminders. A person still decides what to write off, investigate or claim from a carrier.

In short

  • Give each transfer one reference number and match the dispatch record to the receipt line by line.
  • Set a deadline for the receiving count and send reminders until it is in, then escalate.
  • Classify every gap as shortage, overage, damage or wrong item so each goes to the right person.
  • Automation handles matching and chasing; a person still decides on write-offs, carrier claims and any staff matter.
  • For a very small network with few transfers, a shared spreadsheet with a weekly review may be the better choice.

What the mismatch usually means

Most transfer mismatches are not theft. They come from timing and process. Stock leaves Branch A on Monday, the van arrives on Wednesday, and the receiving clerk counts on Friday after two other deliveries have been put away. If nobody has a record of what is in transit, the two branches end the week with different numbers for the same goods.

Four causes account for most gaps. The first is a dispatch note that was never matched to a receipt. The second is a partial receipt, where a line was keyed as received in full. The third is damage that was never recorded, so the item silently drops out of the count. The fourth is a wrong item or wrong size that got put away as the item on the note. Each one looks identical on a stock report unless someone compares the two documents.

Inventory-loss research points the same way. Appriss Retail's 2026 Total Retail Loss Benchmark Report, which covers 2025, attributes about 21 percent of the $90 billion in total shrink to inventory errors, and names distribution-centre mispicks and transfer errors as a source. The report covers retail in general, not your business, so treat the share as a sign of where to look rather than a forecast for your branches.

What the mismatch costs

No public study gives one dollar or pound figure per transfer that fits every business, so the honest way to price the problem is with your own numbers. Three cost lines matter.

The first is the stock itself. A short shipment of goods bought at a known cost is a direct loss if it cannot be found or recovered from a carrier. The second is lost sales. If the receiving branch believes it has stock and does not, a customer order goes unfilled, or the branch sells a substitute at a lower margin. The third is staff time. Someone has to find the dispatch note, call the other branch, recount the shelf and update the record. That work repeats for every open transfer.

A worked example shows the arithmetic. Suppose 40 units leave a branch at a landed cost of 12 each, and 15 of them never reach the shelf. The direct loss is 180 in your currency. Add two hours of a branch clerk's time across three phone calls and a recount, and the true cost is the stock plus the hours. Across a network that moves hundreds of transfers a month, a small error rate in each one adds up. The free audit measures your actual transfer volume and error rate, which is the figure that matters for your business.

The manual way and the automated way

The table below compares how a typical branch network handles this work today with a setup that matches records automatically. The automated column describes what the system is built to do. It does not promise a particular result for your business.

StepManual wayAutomated way
Recording the dispatchPaper or PDF dispatch note, emailed or photographedTransfer order created in the inventory system, status set to in transit at dispatch
Recording the receiptReceiving clerk writes counts on a sheet, someone types them laterReceiving branch enters counts against the transfer order, or scans a delivery note with OCR to pre-fill them
Finding differencesSomeone compares two documents line by line, often at month endThe system compares each line when the receipt is saved and lists every difference
Chasing the countPhone calls or messages when someone remembersReminders sent on a fixed schedule to the receiving branch until the count is in
Classifying the gapNotes in an email threadEach difference tagged as shortage, overage, damage or wrong item, then routed to a named person
DecisionOwner finds out at stock countPerson reviews the exception list and decides: investigate, claim, or adjust

The manual way is cheap to start and works when the network has two or three branches and a handful of transfers a week. It breaks as volume grows, because the matching depends on someone remembering to do it.

How to automate it, step by step

The steps below assume you already have a stock system, even a basic one. If you do not, start with step one on a shared spreadsheet and move to a system later.

  1. Give every transfer one reference number. Use the same number on the dispatch note, the transfer record and the receipt. Without a shared reference, nothing can be matched automatically.
  2. Create the transfer as an in-transit record at dispatch. In NetSuite, for example, a transfer order moves the quantity out of the source location when it is fulfilled and holds it as in transit until the destination receives it. Oracle's NetSuite help documentation describes this two-stage flow, and a receipt must be entered at the destination before the stock counts there.
  3. Require the receiving branch to enter a count against the transfer reference within a set time, for example by the end of the next working day. Set the deadline in the rule, not in someone's memory.
  4. Use OCR for paper notes. Where a branch still receives paper delivery notes, a document-reading tool can pull the line items and quantities into the receipt form. The clerk checks the extracted numbers before saving. OCR reads printed text well and handwritten text less reliably, so check handwriting by hand.
  5. Automate the comparison. Each receipt line is compared with the dispatch line. Any difference, including a short or over count, creates an exception with the transfer reference, item, both quantities and the two branch names.
  6. Send scheduled reminders through the channel the receiving branch actually uses. Email works everywhere. In many markets, WhatsApp is the faster channel for branch staff. Under Meta's WhatsApp Business Platform, messages that start a conversation outside an open customer service window must use a pre-approved template. Meta's documentation describes these as the only message type allowed in that case. The On-Premises API was sunset on October 23, 2025, so new builds should use the Cloud API. Templates need approval before first use, and unverified accounts face lower template limits, so plan the approval time in advance.
  7. Use a language model to draft the chase message and summarise the open list for the owner. The model writes the wording from the exception data. It should not decide whether stock is missing. That decision belongs to a person.
  8. Send a daily or weekly digest of open transfers older than the agreed deadline to the operations head. Escalate by a rule, for example any gap over a set value goes to the owner the same day.

Connecting these steps depends on the tools you already have. A stock system with transfer orders and a receipt step covers most of the work. Accounting software such as Tally, Zoho Books or QuickBooks can receive the adjustment entries, but the link between the stock system and the ledger needs checking with whoever keeps your books.

What breaks and how to prevent it

The most common failure is a branch that never enters the receipt. The system then shows stock in transit forever, and the report looks like a loss when it is really a missing count. The prevention is the deadline and the daily digest. Make the open list visible to a named manager.

The second failure is a receipt entered in full when only part of the goods arrived. Some systems do not allow partial lines to be received, as NetSuite's documentation notes for transfer order lines, so the branch must either receive the whole line or the team must split the transfer. Decide the rule before go-live, not during the first dispute.

The third failure is bad matching caused by unit mismatches. One branch counts cases, the other counts units. Lock the unit of measure for each item across branches before any matching runs. Otherwise every line shows a false gap.

The fourth is over-reminding. A branch that receives six automatic messages a day stops reading them. Limit reminders to one or two per open item, then escalate to a person.

The fifth is a damage record that nobody closes. A damaged item should have its own status, a photo or note, and an owner. Otherwise damage gets counted as a shortage and the wrong person chases it. Automation can route damage to the right person. It cannot inspect the goods, and a photo does not prove the cause of damage. Someone on site still has to judge it.

Finally, carriers. If a delivery was short or damaged in transit, the claim is made to the carrier under its own terms, and the window for filing may be short. Automation can flag the exception on the day it appears so the claim is filed in time. It does not know the carrier's terms, which you should check with the carrier or your logistics contact.

When not to automate

Automation is not worth it for every network. If you move fewer than a few transfers a month between two sites, and the owner or one manager already checks every receipt by phone, a shared spreadsheet with a receipt column and a weekly review is enough. Adding a system and an approval flow can create more work than it removes.

Be cautious when stock records are poor to begin with. If the opening counts at each branch are wrong, the first months of automated matching will produce long exception lists that only reflect the old errors. Run one physical count at each branch first, then start matching.

Do not automate the decision to write off stock, to blame a named employee or to change a branch manager's targets based on transfer gaps. Those decisions need context that no list contains. If a gap points to possible theft by staff, the handling of that matter, including any investigation or disciplinary step, follows your own HR policy and the labour rules where you operate. Check those with a lawyer or your HR adviser before you act on the data.

What it typically takes

For a network with a working stock system and a few branches, the usual sequence is a short design session to agree on the reference number, the count deadline and the gap categories, followed by setup of the transfer flow and the exception list. The part that takes longest is not the software. It is getting every branch to enter receipts on time for two or three weeks until the habit holds.

Plan for the first month to be noisy. Expect a backlog of old transfers to clear, and expect the reminder schedule to need adjusting once you see which branches are slow. Template approval for WhatsApp, where used, adds days before the first message can go out. Time spent per week on chasing should drop once the exception list replaces the phone calls, but the free audit measures your current time so you can compare it with the same figures after setup.

This explains the general approach to stock transfer matching in plain terms. It is not legal, tax or accounting advice for your case, and the right treatment of transit losses in your books should be confirmed with your accountant.

How AiStaffo would automate this

AiStaffo would connect the stock system's transfer records, the dispatch notes and the receiving branch's count entries into one shared reference, so each transfer is matched line by line when the receipt is saved. Any difference is classified by type and sent to a named person, while the chase messages to the receiving branch go out on the agreed schedule through email or WhatsApp Business templates. A language model drafts those messages and produces the daily open-items digest from the exception data. The owner or operations head still decides what to investigate, write off or claim from a carrier. Book a free automation audit to measure your current transfer volume and gap rate before any setup.

Questions people ask

What is the most common reason two branches show different stock numbers?
Timing is the usual cause. Goods leave one branch and sit in transit, while the receiving branch counts after other deliveries have been put away, so the records disagree for a few days. Unrecorded partial receipts and damage that never gets logged are the next most common causes. Matching each dispatch note to a receipt line by line shows which of these is happening.
Can a spreadsheet handle inter-branch transfer matching?
Yes, for a small number of transfers. Use one shared reference number per transfer, a column for the dispatched quantity and a column for the received quantity, and a formula that flags any difference. The weakness is that someone must remember to update it and to chase the receiving branch. Once transfers become frequent, a stock system with transfer orders is easier to control.
Is WhatsApp a good channel for chasing a branch's stock count?
It can be, because branch staff often read WhatsApp faster than email. Under Meta's WhatsApp Business Platform, a message that starts a conversation outside an open customer service window must use an approved template. Templates need approval before first use, so plan that step early. Keep the reminders short and limit them to one or two per open item.
What does automation not do in transfer reconciliation?
It does not count the goods, inspect damage or decide the cause of a gap. A photo or a note does not prove why stock is missing. Automation finds the difference and routes it to a person. The decision to write off, claim from a carrier or take action against an employee stays with the owner or manager.
How long does it take to set up transfer matching?
The software setup is usually the shorter part. Agreeing the reference number, count deadline and gap categories comes first, then the transfer flow and exception list are configured. Most of the time goes to getting every branch to enter receipts on time for several weeks. The free audit estimates the time for your network.

Book a free automation audit

Thirty minutes. We look at one process you run every week and tell you exactly what an AI worker would take off your desk, and what it would not.

We use these details only to reply to this request and prepare your audit, and keep them for up to two years. We send no marketing unless you tick the box above. Privacy policy

stock transfersinventory reconciliationmulti branch operationstransfer ordersstock discrepancies