Expected Payment Reconciliation

Learn how expected payments are reconciled

How the matching engine works

To achieve high accuracy and minimize incorrect reconciliations, Expected Payments will only reconcile to the transaction if all of the defined attributes are matched. If you specify a counterparty on the expected payment, it must have a linked external account or virtual accounts for it to be considered for matching – otherwise, it will be ignored and not used for matching.

When multiple Expected Payments match the details of a transaction, they won't be automatically reconciled. Instead, these exceptions will be flagged for manual reconciliation to ensure accuracy.

Example matches

ACH transaction:

Wire transaction:

Which fields are most useful for matching?

While we recommend providing as much detail as possible when creating an expected payment, some fields are more helpful than others when it comes to matching to a transaction. The utility of the different fields can vary by use case. In the case of a Capital Call for example, investors may send wire payments for the same amount over the same time period – reducing the utility of the amount and date ranges. But the statement description field could be very helpful in that case if clear instructions are provided to (and followed by) the counterparty.

Amount or Amount Range
If known ahead of time, specifying the exact amount of the expected payment is helpful for matching. However, certain variables such as fees, taxes, and even currency fluctuations can alter the amount you expect to receive. In that case, it’s best to specify the amount range (amount_lower_bound - amount_upper_bound) that you expect the payment to fall within. This built-in flexibility can be very useful when it comes to matching bank transactions where the exact amount may vary.

Expected Date or Date Range
Even payments with strict due dates can be late. Specifying a date range for an expected payment is a great way to build in fault tolerance for payments that arrive later than expected. If a given payment doesn’t have a due date, then you may want to specify a generous date range to increase the likelihood of a match.

Statement Description
The statement description field is a free form text field, allowing it to be both unique and specific. This provides a great opportunity for matching expected payments to transactions. However, it requires an exact match – meaning the string, or sequence of characters, must be identical. Therefore, it’s helpful to give clear and specific instructions to your counterparty, such as providing their full name or a unique identifier in the appropriate field of the payment (i.e., OBI field for Wire payments).