Reconciling and tying out
A post succeeding means the provider accepted it. It does not prove the two systems still agree.
Reconciliation is the check that they do.
What is compared
For a document, two figures side by side:
- Our total — what Yessort believes was posted.
- The provider total — what the provider currently holds.
The difference between them is what needs explaining. Where the provider's own figure has moved away from what was originally posted, that is recorded as provider total drift.
Why they diverge
Almost always because something changed on the provider's side after Yessort posted it. Someone edited the invoice in the accounting system, applied a credit, or adjusted a line.
That is not necessarily wrong — an accountant correcting something may be entirely right. What matters is that the difference is visible rather than silently absorbed.
Drift is the more interesting figure
A difference tells you the two do not match now. Drift tells you the provider's copy has moved since it was posted, which points at an edit made there rather than at anything Yessort did.
If you are trying to work out which side changed, that is the column to read first.
Not a failure
Nothing broke. The post went through and the document exists.
This distinguishes it from the other two queues: an entry that could not be built is held, one that was sent and rejected is a failed post, and one that posted fine but no longer agrees is a reconciliation exception. Three different situations, three different fixes — see the three queues.
Working through them
The question for each is which side is right.
The provider is right — someone made a correction there deliberately. Note it and move on.
Yessort is right — the provider's copy was changed in error, and it needs correcting there.
Neither is quite right — usually a mapping problem, sending things somewhere they do not belong. Worth checking before resolving row by row, since one wrong mapping produces many rows.
Where the whole thing sits
Reconciliation compares your records against the provider's. It does not check that money arrived — that is a gateway payout, a separate job against the bank.