If you have matched transactions with small, medium, or large differences in amount, you can create a support match item. The Match Rules form helps you set up rules that define the value for these differences. This item is used to record the difference in the amount. 

The support and support match capabilites are not supported for new customers.

You can create two support types for reconciliation: support item and support match item. The support item reflects the total sum of all selected transactions. For matched items that have a variance, the support match item uses the variance of the match result.

You can only create support matches for transactions that have a difference. If a matched transaction has no difference, you can't generate a support match for it.

  1. Select Matching from the navigation pane.
  2. In the Match Group dialog, select a match group from the dropdown.
    The Transaction Matching opens with the selected Match Group.
  3. Select the Datasets you want to work with.
    Your application administrator defines which datasets are available for each Match Group.
  4. After selecting the datasets, all related transactions display by default. Use the filter options to narrow the results and show only relevant transactions.

The Matching user interface remembers your last selections, so they'll be restored the next time you open it.

Access to the Matching interface and its features depends on your role-based security settings.
Some users may not have access to the module or may be restricted from using certain features.

To create support match items:

  1. Within the Global Filters section, select Matched for Match Status, All for Match Type, and type in a minimum and maximum variance, such as 0.01.
  2. Then, select Filter at the top of the section to apply the selected filters.
  3. Select Filter Data next to Dataset to filter transactions.
  4. From the filter dialog, select relevant filters and Apply.
    For example, select Trans_Date, then Between and choose August 31, 2022 and October 01, 2022 to view all transactions in September 2022.
  5. Select Select Fields to choose which fields or columns you want to view.
  6. Select a transaction from the dataset, then Support Match from the toolbar. 
  7. Type and select the appropriate fields, then OK.

The Match Support dialog also enables you to include attachments such as invoices, bank statements, and more.

Support optionsDescription
Supporting ItemName for the supporting item.
DescriptionA short description of the supporting item.
The character limit is 256​. This field is optional.
Reconciliation GroupA list of prefilled reconciliation groups available for use in matching use cases.
AccountName of the account.
This varies depending on the Reconciliation Group you select. 
EntityA prefilled list of your organization's entity.
Start Date

The start date period for which the supporting item is applicable.

  • You can't select a start date that falls within a closed period. The start date of each new supporting item needs to be after the end date of the previous one.
    For example, if the previous item ends on March 20, 2023, the next one can't start before April 1, 2023.
  • None of the selected transactions should have a supporting item in that period.
  • If a transaction is already linked to a closed item, you can only associate it again if the start date doesn't fall within the period of another item.
End Date

The end date period for which the supporting item is applicable.
This field is optional.

  • If no end date is selected, the supporting item will continue indefinitely.
  • If the period is set to close, you can change the end date as long as it's within the closed month or any period after.
Supporting Item SubtypeSupporting item subtypes are business-defined. This data is used for reporting and dashboarding purposes and varies depending on the Entity selected.
This field is optional.
Item ClassThe item class is business-defined. ‌By default, there are four item classes: Explanatory, Required Adjustment, Subledger Adjustment, and Timing. This data is used for reporting and dashboarding purposes.
This field is optional.
DatasetDisplays the datasets selected for the supporting item.
Subtotal

Displays the total amount of the selected transactions from each dataset:

  • Absolute: The absolute value of the sum of all transactions. Sometimes, transactions in the General Ledger may have the same amount but opposite signs.
  • Reverse: The reverse amount of the sum of all the transactions. Reverse amount matching is similar to absolute value matching but applies when the transaction amount in the source is the opposite of the corresponding General Ledger entry.
  • Natural: The total amount of all transactions, with a one-to-one match to the General Ledger data when the items are related.
AmountThe total amount of the sum of all transactions in a dataset, or the sum of all transactions from the datasets.
NotesWrite notes to add clarity to the supporting item.
The maximum number of characters allowed is 256.
AttachmentInclude a document, such as invoices, bank statements, and other files, to the supporting item.
You can attach only one file. If more files are required, use a ZIP file containing all the attachments.

You've now created support match items. Transactions with support match items are distinguished by their icons.

IconFunction
Transactions with supporting items that have an end date.
Transactions with supporting items that don't have an end date.
Transactions with support match items that have an end date.
Transactions with support match items that don't have an end date.