Open Unmatched Items for Bank Account Reconciliations [v26.1] 

Starting from version 26.1, customers who begin using Account Reconciliation mid-year can load historical unmatched items from prior periods into their first active reconciliation period. This ensures the reconciliation equation balances from day one.

Prerequisite: Load open unmatched items before starting the reconciliation process for your first active period. This step is required to ensure that historical unmatched items are available for matching.

Open unmatched items are supported on both the GL side and the Support side of bank account reconciliations:

• GL Side (Book Side): Items recorded in the GL but not yet reflected in the bank statement.
• Support Side (Statement Side): Items appearing in the bank statement but not yet recorded in the GL.

This section covers all operations for open unmatched items on the GL side of the reconciliation.

Note: For Enterprise users, the + and Upload buttons on the GL side are available in the first active period only, during the Preparation stage.

Adding GL Items via Bulk Upload

1. Navigate to the Reconciliation Details page for the account.
2. On the GL side, click the Upload button (↑).
3. Click Download Template to download the CSV template.
4. Populate the template with the historical GL-side unmatched items.

5. Click Upload and select the completed CSV file.

   The system validates all required fields. If any row fails validation, the entire file is rejected and an error message displays.

6. The successfully uploaded items appear in the GL side of the Unmatched tab.

Note: The uploaded CSV file is saved as an attachment. The system detects duplicate files based on file content—if an identical file already exists, a message displays indicating the file already exists. File deletion is permitted only during the Preparation stage. Deleting an uploaded file removes all associated items, including both matched and unmatched items.

Adding GL Items Manually

1. Navigate to the Reconciliation Details page for the account.
2. On the GL side, click Add Opening Carryover GL Line (+). The system displays the Add GL Line dialog.

3. Enter the following fields:

   Field	Description
   Date *	The date of the unmatched transaction.
   Amount *	The transaction amount. Currency displays next to the field.
   Description *	A description of the unmatched item (max 255 characters).
   Trading Partner	The trading partner associated with the transaction (optional).

4. Click Add Line.

   The item appears immediately in the GL side of the Unmatched tab.

   The system automatically triggers the matching engine to evaluate the new item against existing transactions.

Editing GL Items

Edit is available only for manually added GL items during the Preparation stage.

1. Locate the manually added item on the GL side of the Unmatched tab.
2. Click Edit (pencil icon) on the item row. The system displays the edit dialog with the current field values.
3. Update the fields as needed.
4. Click Add Line.

Note: Bulk uploaded and ERP-sourced items do not have the Edit option.

Note: If an edit causes a previously matched item to become unmatched, the match is broken and the item returns to the Unmatched list. Edit is not available in future periods.

Deleting GL Items

Delete is available only for manually added GL items during the Preparation stage.

1. Locate the manually added item on the GL side of the Unmatched tab.
2. Click Delete (trash icon) on the item row.
3. Confirm the deletion.

Note: Deleting an item that was previously matched breaks the match and the counterpart item returns to the Unmatched list. Delete is not available in future periods.

Adding Comments to GL Items

1. Locate the item on the GL side of the Unmatched tab.
2. Click Comment (comment icon) on the item row. The system displays the comment dialog.
3. Enter the comment text.
4. Click Submit.

Comments carry forward with the item to subsequent periods and are recorded in the audit trail.

Support Side: Open Unmatched Items

The + and Upload buttons on the Support side are available in the first active period only, during the Preparation stage.

Adding Support Side Items via Bulk Upload

1. Navigate to the Reconciliation Details page for the account.
2. On the Support side, click the Upload button (↑).
3. Click Download Template to download the CSV template.
4. Populate the template with the historical bank-side unmatched items.

5. Click Upload and select the completed CSV file.

   The system validates all required fields. If any row fails validation, the entire file is rejected and an error message displays.

6. Successfully uploaded items appear in the Support side of the Unmatched tab.

Note: The uploaded CSV file is saved as an attachment. The system detects duplicate files based on file content—if an identical file already exists, a message displays indicating the file already exists. File deletion is permitted only during the Preparation stage.

Adding Support Side Items Manually

1. Navigate to the Reconciliation Details page for the account.

2. On the Support side, click Add Opening Carryover Support Line (+).

   The system displays the Add Statement Line dialog.

3. Enter the following fields:

   Field	Description
   Date *	The date of the unmatched transaction.
   Amount *	The transaction amount. Currency displays next to the field.
   Description *	A description of the unmatched item (max 255 characters).
   Trading Partner	The trading partner associated with the transaction (optional).

4. Click Add Line.

   The item appears immediately in the Support side of the Unmatched tab.

   The system automatically triggers the matching engine to evaluate the new item against existing transactions.

Editing Support Side Items

Edit is available only for manually added Support side items during the Preparation stage.

1. Locate the manually added item on the Support side of the Unmatched tab.
2. Click Edit (pencil icon) on the item row. The system displays the edit dialog with the current field values.
3. Update the fields as needed.
4. Click Add Line.

Note: Bulk uploaded items do not have the Edit option.

Note: If an edit causes a previously matched item to become unmatched, the match is broken and the item returns to the Unmatched list. Edit is not available in future periods.

Deleting Support Side Items

Delete is available only for manually added Support side items during the Preparation stage.

1. Locate the manually added item on the Support side of the Unmatched tab.
2. Click Delete (trash icon) on the item row.
3. Confirm the deletion.

Note: Deleting an item that was previously matched breaks the match and the counterpart item returns to the Unmatched list. Delete is not available in future periods.

Adding Comments to Support Side Items

1. Locate the item on the Support side of the Unmatched tab.
2. Click Comment (comment icon) on the item row. The system displays the comment dialog.
3. Enter the comment text.
4. Click Submit.

Note: Open unmatched items that are not matched in the current period carry forward automatically to subsequent periods until matched. In future periods, items are read-only—Edit and Delete are not available, but comments can still be added. Items continue to participate in automatic matching each period.