Nostro and internal reconciliation, breaks and their investigation, and settlement finality.
3 questions in Banking & Financial Services.
Keep the event timestamp, the accounting date and the value date as three separate attributes, assign the accounting date at posting from a stated rule over rail and calendar, and close a period by locking it and snapshotting what it contained rather than by pausing the flow.
You classify the break before chasing it, because most differences are timing rather than error: match in layers from exact reference down to grouped and tolerance matching, age what remains, and remember that your ledger being updated is not the same event as settlement becoming final and irrevocable.
The net settlement figure is never the sum of your postings, so the control is a bridge rather than an equality - gross transactions, then fees, chargebacks, timing differences and currency conversion, each as its own explained line. Anything left over is the break, and it must be small enough to investigate.