What is Closed Through Date in Transaction Matching?

The Closed Through Date for a reconciliation is the end date of the most recent period in which this reconciliation is closed.

Note:

If you are using either the Account Analysis with Transaction Matching or the Balance Comparison with Transaction Matching formats, you may cause reconciliations to reopen if you import transactions with an accounting date that is less than the Closed Through Date.

Here is an example of a Closed Through Date:

Table 9-6 Closed Through Date Example

Period Start Date End Date Period Status Reconciliation Status
Feb 22 01-Feb-22 28-Feb-22 Locked Closed
Mar 22 01-Mar-22 31-Mar-22 Closed Closed
Apr 22 01-Apr-22 30-Apr-22 Open Closed
May 22 01-May-22 31-May-22 Open Open

Consider the Mar 22, Apr 22, and May 22 periods. The Closed Through Date of a reconciliation is 30-Apr-22. This is the end date of the Apr 22 period, which is the most recent period in which the reconciliation is closed.

The March 22 period is closed and the April 22 period is open. However, the status of the reconciliation is closed in both periods. Assume that you import transactions for a particular reconciliation, with an accounting date of 16-Mar-2022, both the March 22 and April 22 reconciliations would reopen.