Create Rule Sets for Matching Transactions
- Use theSet Up Journal Line Matchingtask to select a matching type.
- Security: These domains in the Financial Accounting functional area:
- Set Up: Matching Rule Set
- Access: Matching Rule Set (Segmented)
You can create a rule set consisting of different matching rules to match transactions on journal lines automatically. You can set up matching rules to match:
- One journal line to another.
- One journal line to many journal lines.
- Many journal lines to 1 journal line.
- Many to many journal lines.
- Access theCreate Matching Rule SetorEdit Matching Rule Settask.You can’t change the matching type for a rule set once it’s created.
- Complete the initiation screen:
Option Description NameEnter a unique name for the matching rule set.DescriptionEnter a description that provides more detail about the purpose and function of the matching rule set.Matching TypeSelectJournal Line.InactiveSelect to inactivate the rule set. - For each matching rule, complete theRule Informationsection:
Option Description OrderEnter a number 1 through 50 for the order of the rule. Workday evaluates and processes the rules in the order you specify.Place the most specific rules before rules that require less precision in the match. That way, when Workday identifies more granular matches first, it removes the matched journal lines from future consideration.NameEnter a unique name to help you identify the rule.Matching MethodSelect whether the rule matches journal lines one-to-one, one-to-many, many-to-one, or many-to-many.InactiveSelect to inactivate the rule. Workday won’t apply this rule when you trigger a matching run. - Complete theFilter Criteriasection.Specify filter criteria to reduce the number of transaction lines to match from Source 1 to Source 2.When you select:
- The same worktag type for both sources, Workday applies the filters as OR conditions. Example: When you select 2 cost centers.
- Different worktag types for each source, Workday applies the filters as AND conditions. Example: When you select a cost center for one source and a custom worktag for the second source.
Option Description Journal SourcesSelect journal sources to filter by.WorktagsSelect worktags to filter by.External Reference IDEnter an external reference ID to filter by. The external reference IDs must match this value exactly.Line MemoEnter a line memo to filter by. The memos must match this value exactly. - Complete theMatch Onsection.For more precise matching, you can specify multiple criteria for each ledger account. ClickAdd Rowto add more match-on criteria.
Option Description Source 1 Source 2Select more granular attributes to match on, such asLedger/Budget Debit Amount.When you create a matching rule forLedger/Budget Debit Amount,Ledger/Budget Credit Amount,Transaction Debit Amount, orTransaction Credit Amount, you can specify a tolerance threshold to match transactions whose amounts differ slightly. Specify the tolerance threshold using theTolerance Amount,Tolerance Percentage, andItem Tolerancefields in theOperatorcolumn.When you create a matching rule forAccounting Date, you can specify a range of days before and after the accounting date within which Workday can match transactions. Set this range of days using theWithin Number of Daysfield in theOperatorcolumn.When a primary balancing worktag is enabled in your tenant, add the primary balancing worktag as a match-on criterion for tolerance-based matching rules. Optional balancing worktags aren't required. Workday populates worktags you add as match-on criteria on the resulting transaction matching write-off operational transaction and journal lines.Workday automatically populates any worktags that you add as match-on criteria to the resulting transaction matching write-off operational transaction and journal lines.Tolerance AmountDisplays when you selectLedger/Budget Debit Amount,Ledger/Budget Credit Amount,Transaction Debit Amount, orTransaction Credit Amountas sources.Select this option to enable Workday to match transactions whose amounts differ by a specified amount.Example: When you select this option and enter1.5in theItem Tolerancefield, Workday can match a journal line that has the amount 250.00 with another journal line that has an amount between 248.50 and 251.50.Tolerance PercentageDisplays when you selectLedger/Budget Debit Amount,Ledger/Budget Credit Amount,Transaction Debit Amount, orTransaction Credit Amountas sources.Select to enable Workday to match transactions whose amounts differ by a specified percentage.Example: When you select this option and enter1.5in theItem Tolerancefield, Workday can match a journal line that has the amount 250.00 with another that has an amount between 246.25 and 253.75.Item ToleranceDisplays when you selectLedger/Budget Debit Amount,Ledger/Budget Credit Amount,Transaction Debit Amount, orTransaction Credit Amountas sources.This field combines with theTolerance AmountorTolerance Percentageoptions.Enter the tolerance threshold Workday can accept when matching transactions. You can enter a number with up to 4 decimal places.Within Number of DaysDisplays when you selectAccounting Dateas a source.Enter a number to specify how many days before or after the accounting date Workday can match transactions. You can enter a maximum of365.Example: When you enter2in this field, Workday can match a journal line that has the accounting date 11/05/2026 with another that has an accounting date between 11/03/2026 and 11/07/2026.Write-off Ledger accountSelect a ledger account from the same account set to assign any write-off that results from matched transactions. - Complete theMatching Optionssection:
Option Description Include Blank Values for Line Memo, Worktags, External Reference IDSelect this check box to include blank values for line memos, worktags, and external reference IDs in the matching criteria.Workday automatically excludes the options from theMatch Oncriteria. - ClickAddto add more matching rules to the rule set.
When you run automatic transaction matching, Workday uses the rules in the matching rule set to match transaction lines.
To view the defined matching rule sets and the number of rules within each set, you can access the
Maintain Matching Rule Sets
task. You can then drill down to view these details for each rule in the set:
- Matching method.
- Rule order.
- Whether the rule is currently active.