Schedule Matching Run
- Create a matching rule set.
- Use theSet Up Journal Line Matchingtask to select a matching type.
- Security:Process: Account Certification – Create Auto Matchdomain in the Financial Accounting functional area.
You can schedule a matching run to apply the matching rule sets to match transactions.
Workday limits each match to contain a maximum of 99,999 journal lines.
- Access theSchedule Matching Runtask.
- Select aRun Frequency.
- ForMatching Run Type, selectJournal Line.
- Enter aRequest Nameto provide more visibility for the matching run.Workday appends a date and time stamp on each request name when you process the matching run.
- As you complete theRun Criteria, consider:
Option Description CompanyYou can select multiple companies or company hierarchies.Ledger AccountYou can select multiple ledger accounts, ledger account summaries, or alternate accounts.Alternate ledger account option only displays values for companies with alternate accounts defined.Include All Open ItemsIncludes all nonmatched journal lines in the selectedFiscal Yearup to theJob Run Date.Fiscal YearYou can select a maximum of 2 fiscal years.Fiscal PeriodYou can select more than 1 fiscal period.This option isn’t available when you selectInclude All Open Items.Use Job Run Date for As Of Effective DateAs Of Effective DateSelect an effective date to specify which version of any selected company hierarchies or ledger account summaries you want to run the job for. Workday uses the version of the hierarchy or ledger account summary that was in effect on the selected date.Workday doesn't use the effective date to determine which journal lines to retrieve.Matching Rule SetSelect a matching rule set for which you want to match transactions.You can only select rule sets using the matching type selected in theSet Up Transaction Matchingtask.
Workday uses the matching rules in the selected rule set to match transactions on journal lines.
Workday assigns a unique
Match ID
to matched journal lines. The match ID serves as the link between them, grouping the journal lines together as a reconciled set. Workday also assigns a Match Type
to the journal lines. For automated rule-based matching, this will typically be Rule Based - Ledger Amount
or Rule Based - Transaction Amount
. The specific type depends on your configuration on the Set Up Journal Line Matching
task.When Workday matches journal lines using a tolerance-based rule, it creates an instance of a Transaction Matching Write-Off operational transaction and journal to balance the open item match. Workday creates one operational transaction and journal per match, regardless of the number of journal lines being matched.
Workday populates one of these match types on the resulting match ID:
- Rule Based Tolerance Matching - Ledger Amountwhen you’ve set up journal line matching based on ledger amount.
- Rule Based Tolerance Matching - Transaction Amountwhen you’ve set up journal line matching based on transaction amount.
- Tolerance Match - Automaticon write-off journal lines when your tenant is configured to always reverse operational journals and you unmatch an existing match.
Workday also matches ambiguous transactions when more than one journal line is a viable match. Example: When you have one debit line with the amount 100 and two credit lines with the amount 100.
Workday matches ambiguous transactions as follows:
- Workday first creates exact matches from the debit and credit journal lines that meet the matching rule criteria.
- When there are multiple viable matches, Workday selects the journal line that has the closest accounting date. If potential matches share the same accounting date, Workday selects the journal line with the closest time of creation.
- Workday then evaluates any tolerance-based matching rules you configured and selects the first available match within the tolerance amount. For tolerance-based rules using the accounting date, Workday calculates the tolerance window from the accounting date of the debit-side journal line.
- When there are multiple viable matches within the tolerance amount, Workday applies the same prioritization of accounting date, then time of creation.
To minimize write-off amounts on tolerance-based matches, Workday evaluates and matches journal lines with the smallest amounts first, then proceeds to larger amounts.
On the
Match Statistics
grid, you can click Matches
to view details of all the matches in the matching run.