Find records missing between connected systems

What this means for your practice

Compare the results expected over an agreed period with what actually arrived. A green availability indicator shows a different thing from a complete transfer of the required work.

Questions to take to your supplier

Remove a fictional event from a test transfer set and run the comparison. Does the gap appear with enough detail for its owner to investigate? Agree how resolved differences are recorded. Availability and complete handover answer different questions and both may matter to the practice.

Agree the working process

Define the period and the expected records to compare, with stable references that both sides can explain. Availability checks show whether systems respond; this comparison asks whether the work expected in a period actually reached its destination. Agree how late arrivals, repeated events and authorised exclusions are handled so ordinary differences do not create a permanently noisy list. Ask the supplier to remove one fictional transfer from a test set and show how the gap is identified. Then resolve it and confirm the evidence remains connected to the original item.

Give uncertain matches an owner rather than forcing a count to balance through assumptions. The receiving team should be able to understand which items need review and why. Keep the comparison method current when new sources or event types are added. During reporting, distinguish unresolved gaps from reviewed differences with an accepted explanation. That makes the result useful for prioritising work instead of presenting every mismatch as equally urgent.

How to check the result

Count unmatched events awaiting a documented resolution.