(PFC) Additional Data Rules
This page provides a reference library of default and custom Data Rules for each AI Account Reconciliations Anomaly Detector. Each section includes the out-of-the-box default rule along with alternative custom rules that address common tuning scenarios — such as adjusting statistical thresholds, targeting specific document types, separating anomalies by direction, or applying stricter/looser flagging criteria.
These rules are written in Data Rule Syntax (DRS) and are intended as starting points that can be adapted to fit your organization's workflow and risk tolerance. For guidance on when and how to modify these rules, see the Data Rule Tuning Guide. For a deeper understanding of the underlying statistics (P-Value, Z-Score, Rolling Z-Score, etc.), refer to the Statistics Overview.
none
Sign Difference
Sign Difference identifies instances where the sign (positive or negative) of a reconciliation’s balance is different than prior periods.
- Applicable Rec Statuses: InProcess, Prepared, BalanceChanged, AutoPrepared
- Lookback Periods: 12
Default Rule
Default Warning760
Data Rule Name: SignDiffWarning
Data Rule Description: The balance’s sign differs from the most frequently occurring sign in the previous periods.
DRS:
RULE
[SignDifference].[BalanceSignDifferentFromMode] = True
FLAG 'Warning'
Custom Rules
Add Activity Threshold to Sign Difference Warrning760
Data Rule Name: SignDiffActivityOver4000Warning
Data Rule Description: The balance’s sign differs from the most frequently occurring sign in the previous periods and the Activity is over $4,000.
DRS:
RULE
[SignDifference].[BalanceSignDifferentFromMode] = True AND
[RecBalance].[BalancePctChgAbs] > 4000
FLAG 'Warning'
Use Proper Sign When Assigned and Mode Otherwise760
Data Rule Name: SignDiffProperSignWarning
Data Rule Description: The balance’s sign differs from the most frequently occurring sign in the previous periods.
DRS:
RULE
[SignDifference].[IsProperSignAssigned] = True
[SignDifference].[BalanceSignDifferentFromAssignedProperSign] = True
FLAG 'Warning'
Data Rule Name: SignDiffModeWarning
Data Rule Description: The balance’s sign differs from the most frequently occurring sign in the previous periods.
DRS:
RULE
[SignDifference].[IsProperSignAssigned] = False
[SignDifference].[BalanceSignDifferentFromMode] = True
FLAG 'Warning'
Warning With 4 Lookback Periods760
Data Rule Name: SignDiff4PeriodsWarning
Data Rule Description: The balance’s sign differs from the most frequently occurring sign in the previous periods and there at least four historical periods.
DRS:
RULE
[SignDifference].[BalanceSignDifferentFromMode] = True AND
[SignDifference].[NumberOfLookbackPeriods] >= 4
FLAG 'Warning'
R-Doc Sparsity
R-Doc Sparsity checks how often “R-Docs” (supporting documents at the reconciliation‐level) are consistently attached to reconciliations period over period.
- Applicable Rec Statuses: InProcess, Prepared, BalanceChanged, Rejected
- Lookback Periods: 18
Default Rule
Default Warning760
Data Rule Name: RDocSparsityWarning
Data Rule Description: The past three periods had an R-Doc attached, but the current period does not.
DRS:
RULE
[RDocSparsity].[HasRDoc] = False AND
[RDocSparsity].[Prior3RDocUsagePct] = 100
FLAG 'Warning'
Custom Rules
Accepts Any Document Type Warning760
Data Rule Name: RDocSparsityNoDocWarning
Data Rule Description: The past three periods had an R-Doc attached, but the current period does not have any supporting documentation.
DRS:
RULE
[Default_RDocSparsity].[HasRDoc] = False AND
[Default_TDocSparsity].[HasTDoc] = False AND
[Default_SDocSparsity].[HasSDoc] = False AND
[Default_IDocSparsity].[IItemsPctWithIDoc] < 100 AND
[Default_RDocSparsity].[Prior3RDocUsagePct] = 100
FLAG 'Warning'
Six Prior Periods had R-Doc Attached Warning760
Data Rule Name: RDocSparsity6PeriodsWarning
Data Rule Description: The past six periods had an R-Doc attached, but the current period does not.
DRS:
RULE
[RDocSparsity].[HasRDoc] = False AND
[RDocSparsity].[Prior6RDocUsagePct] = 100
FLAG 'Warning'
I-Doc Sparsity
Evaluates how consistently “I-Docs” (supporting documentation for manual or “I-Item” entries) are attached to a reconciliation over time. The default rule tracks each period’s percentage of I-Items that have an accompanying I-Doc and flags sudden decreases, suggesting insufficient or missing documentation compared to typical patterns.
- Applicable Rec Statuses: InProcess, Prepared, BalanceChanged, Rejected
- Lookback Periods: 12
Default Rule
Default Warning760
Data Rule Name: IDocSparsityWarning
Data Rule Description: The percent of I-Items with I-Docs attached has decreased compared to historical patterns.
DRS:
RULE
[IDocSparsity].[IItemCount] > 0 AND
[IDocSparsity].[PValue] < 0.05
FLAG 'Warning'
Custom Rules
Accepts any Document Type760
Data Rule Name: IDocSparsityNoDocWarning
Data Rule Description: The percent of I-Items with I-Docs attached has decreased compared to historical patterns and the current period does not have any other types of supporting documentation.
DRS:
RULE
[Default_IDocSparsity].[IItemCount] > 0 AND
[Default_IDocSparsity].[PValue] < 0.05 AND
[Default_RDocSparsity].[HasRDoc] = False AND
[Default_TDocSparsity].[HasTDoc] = False AND
[Default_SDocSparsity].[HasSDoc] = False
FLAG 'Warning'
Strict Warning760
Data Rule Name: IDocSparsityStrictWarning
Data Rule Description: The percent of I-Items with I-Docs attached has decreased compared to historical patterns.
DRS:
RULE
[IDocSparsity].[IItemCount] > 0 AND
[IDocSparsity].[PValue] < 0.01
FLAG 'Warning'
Loose Warning760
Data Rule Name: IDocSparsityLooseWarning
Data Rule Description: The percent of I-Items with I-Docs attached has decreased compared to historical patterns.
DRS:
RULE
[IDocSparsity].[IItemCount] > 0 AND
[IDocSparsity].[PValue] < 0.10
FLAG 'Warning'
Warning Recent Decrease760
Data Rule Name: IDocSparsityRecentDecreaseWarning
Data Rule Description: The percent of I-Items with I-Docs attached has decreased recently compared to historical patterns.
DRS:
RULE
[IDocSparsity].[IItemCount] > 0 AND
[IDocSparsity].[PValue] < 0.05 AND
[IDocSparsity].[RollingZScore] < -1.645
FLAG 'Warning'
Aged Item Commentary
Aged Item Commentary uses the set Aging Periods to bucket aging items on a reconciliation. For each aging bucket, the monitor tracks if there are items without comments. Using the default rules, the monitor checks if there are any items beyond the third aging period without comments. For example, if the aging periods are set to 0, 31, 61, 91, and 121 days, the monitor will evaluate whether items aged 61–90 days, 91–120 days, and 121+ days have comments.
- Applicable Rec Statuses: InProcess, Prepared, BalanceChanged, Rejected
- Lookback Periods: 12
- Note: This rule is based on the AgingPeriods and the column names gets created based on the values in that table.
Default Rule
Default Warning Example (Will update with Ratio)760
Data Rule Name: AgedItemCommentaryWarning61
Data Rule Description: The reconciliation has items aged over 61 days, and the percent of those items without comments has increased from the previous period.
DRS:
RULE
[AgedItemCommentary].[HasAgedItems61] = True AND
[AgedItemCommentary].[PctNoComment61Diff] > 0
FLAG 'Warning'
Custom Rules
Strict Flag Recs Without Any Aged Item Commentary760
Data Rule Name: AgedItemNoCommentaryWarning61
Data Rule Description: The reconciliation has items aged over 61 days and at least one of the aged items does not have a comment.
DRS:
RULE
[AgedItemCommentary].[HasAgedItems61] = True AND
[AgedItemCommentary].[Aged61NoComment] = True
FLAG 'Warning'
Set Minimum Percentage of Aged Items With Commentary760
Data Rule Name: AgedItemCommentary80PercentWarning61
Data Rule Description: The reconciliation has items aged over 61 days, and less than 80% of items aged have comments.
DRS:
RULE
[AgedItemCommentary].[HasAgedItems61] = True AND
[AgedItemCommentary].[PctNoComment61Current] < 80
FLAG 'Warning'
Rec Detail Text Field Length
The Reconciliation Detail Text Field Length detector compares the text on a reconciliation in the current period to its historical values. The detector gathers statistics to determine whether a decrease has occurred, which may indicate that preparers are not providing sufficient information on their detail items. It analyzes the ItemName, ItemComment, Ref1, and Ref2 fields to make this determination. The detector collects statistics on both the total length of text on a reconciliation for each period and the average length of text per detail item on a reconciliation.
- Applicable Rec Statuses: InProcess, Prepared, BalanceChanged, Rejected
- Lookback Periods: 12
Default Rule
Default Warning760
Data Rule Name: RecDetailTextLenWarning
Data Rule Description: The average character count of reconciliation detail items has decreased compared to historical periods.
DRS:
RULE
[RecDetailTextFieldLength].[AvgCharCountPValue] < 0.025 AND
[RecDetailTextFieldLength].[AvgCharCountPctChgPrevPeriod] < 0
FLAG 'Warning'
Custom Rules
Looser Warning Rule760
Data Rule Name: RecDetailTextLenLooseWarning
Data Rule Description: The average character count of reconciliation detail items has decreased compared to historical periods.
DRS:
RULE
[RecDetailTextFieldLength].[AvgCharCountPValue] < 0.05 AND
[RecDetailTextFieldLength].[AvgCharCountPctChgPrevPeriod] < 0
FLAG 'Warning'
Stricter Warning Rule760
Data Rule Name: RecDetailTextLenStrictWarning
Data Rule Description: The average character count of reconciliation detail items has decreased compared to historical periods.
DRS:
RULE
[RecDetailTextFieldLength].[AvgCharCountPValue] < 0.01 AND
[RecDetailTextFieldLength].[AvgCharCountPctChgPrevPeriod] < 0
FLAG 'Warning'
Warning Rule Recent Trend 760
Data Rule Name: RecDetailTextLenRecentWarning
Data Rule Description: The average character count of reconciliation detail items has decreased recently compared to historical periods.
DRS:
RULE
[RecDetailTextFieldLength].[AvgCharCountPValue] < 0.025 AND
[RecDetailTextFieldLength].[AvgCharCountPctChgPrevPeriod] < 0 AND
[RecDetailTextFieldLength].[AvgCharCountRollingZScore] < -1.645
FLAG 'Warning'
Info AvgChartCount < 50760
Data Rule Name: RecDetailTextLenAvgCharInfo
Data Rule Description: The average character count of the reconciliation’s detail items is under 50 characters.
DRS:
RULE
[RecDetailTextFieldLength].[AvgCharCount] < 50
FLAG 'Info'
Repetitive Rejections (Warning, Info)
Repetitive Rejections detects when a reconciliation is rejected multiple times over a span of periods or within a single cycle.
- Applicable Rec Statuses: InProcess, Prepared, BalanceChanged, Rejected
- Lookback Periods: 12
Default Rule
Default Warning760
Data Rule Name: RepetitiveRejectionsWarning
Data Rule Description: The reconciliation was rejected at least once in the current period, has a historical rejection rate of at least 50%, and includes at least four prior periods.
DRS:
RULE
[RepetitiveRejections].[RejectedInCurrentPeriod] = True AND
[RepetitiveRejections].[LookbackPctOfPeriodsWithARejection] >= 50 AND
[RepetitiveRejections].[NumberOfLookbackPeriods] >= 4
FLAG 'Warning'
Default Info760
Data Rule Name: RepetitiveRejectionsInfo
Data Rule Description: The reconciliation was not rejected in the current period, has a historical rejection rate of at least 50%, and includes at least four prior periods.
DRS:
RULE
[RepetitiveRejections].[RejectedInCurrentPeriod] = False AND
[RepetitiveRejections].[LookbackPctOfPeriodsWithARejection] >= 50 AND
[RepetitiveRejections].[NumberOfLookbackPeriods] >= 4
FLAG 'Info'
Custom Rules
Stricter Warning760
Data Rule Name: RepetitiveRejectionsStrictWarning
Data Rule Description: The reconciliation was rejected at least once in the current period, has a historical rejection rate of at least 70%, and includes at least four prior periods.
DRS:
RULE
[RepetitiveRejections].[RejectedInCurrentPeriod] = True AND
[RepetitiveRejections].[LookbackPctOfPeriodsWithARejection] >= 70 AND
[RepetitiveRejections].[NumberOfLookbackPeriods] >= 4
FLAG 'Warning'
Looser Warning760
Data Rule Name: RepetitiveRejectionsLooseWarning
Data Rule Description: The reconciliation was rejected at least once in the current period, has a historical rejection rate of at least 35%, and includes at least four prior periods.
DRS:
RULE
[RepetitiveRejections].[RejectedInCurrentPeriod] = True AND
[RepetitiveRejections].[LookbackPctOfPeriodsWithARejection] >= 35 AND
[RepetitiveRejections].[NumberOfLookbackPeriods] >= 4
FLAG 'Warning'
Stricter Info760
Data Rule Name: RepetitiveRejectionsStrictInfo
Data Rule Description: The reconciliation was not rejected in the current period, has a historical rejection rate of at least 70%, and includes at least four prior periods.
DRS:
RULE
[RepetitiveRejections].[RejectedInCurrentPeriod] = False AND
[RepetitiveRejections].[LookbackPctOfPeriodsWithARejection] >= 70 AND
[RepetitiveRejections].[NumberOfLookbackPeriods] >= 4
FLAG 'Info'
Looser Info760
Data Rule Name: RepetitiveRejectionsLooseInfo
Data Rule Description: The reconciliation was not rejected in the current period, has a historical rejection rate of at least 30%, and includes at least four prior periods.
DRS:
RULE
[RepetitiveRejections].[RejectedInCurrentPeriod] = False AND
[RepetitiveRejections].[LookbackPctOfPeriodsWithARejection] >= 35 AND
[RepetitiveRejections].[NumberOfLookbackPeriods] >= 4
FLAG 'Info'
Rec Balance
Compares the current periods reconciliation’s balance to prior periods as set by the number of lookback periods. The detector collects various statistics on the reconciliation’s balance that can be used to identify if the current period’s balance increased or decreased by an abnormal amount compared to prior periods.
- Applicable Rec Statuses: InProcess, Prepared, BalanceChanged, AutoPrepared
- Lookback Periods: 12
Default Rule
Default Warning760
Data Rule Name: RecBalanceIncreaseWarning
Data Rule Description: The current period’s Balance increased compared to its historical values.
DRS:
RULE
[RecBalance].[PValue] < 0.01 AND
[RecBalance].[ZScore] > 2.576 AND
[RecBalance.[RollingZScore] > 2.576
FLAG 'Warning'
Data Rule Name: RecBalanceDecreaseWarning
Data Rule Description: The current period’s Balance decreased compared to its historical values.
DRS:
RULE
[RecBalance].[PValue] < 0.01 AND
[RecBalance].[ZScore] < -2.576 AND
[RecBalance.[RollingZScore] < -2.576
FLAG 'Warning'
Custom Rules
Warning Strict760
Data Rule Name: RecBalanceIncreaseStrictWarning
Data Rule Description: The current period’s Balance increased compared to its historical values.
DRS:
RULE
[RecBalance].[PValue] < 0.001 AND
[RecBalance].[ZScore] > 3.291 AND
[RecBalance.[RollingZScore] > 3.291
FLAG 'Warning'
Data Rule Name: RecBalanceDecreaseStrictWarning
Data Rule Description: The current period’s Balance decreased compared to its historical values.
DRS:
RULE
[RecBalance].[PValue] < 0.001 AND
[RecBalance].[ZScore] < -3.291 AND
[RecBalance.[RollingZScore] < -3.291
FLAG 'Warning'
Warning Medium760
Data Rule Name: RecBalanceIncreaseMediumWarning
Data Rule Description: The current period’s Balance increased compared to its historical values.
DRS:
RULE
[RecBalance].[PValue] < 0.025 AND
[RecBalance].[ZScore] > 2.24 AND
[RecBalance.[RollingZScore] > 2.24
FLAG 'Warning'
Data Rule Name: RecBalanceDecreaseMediumWarning
Data Rule Description: The current period’s Balance decreased compared to its historical values.
DRS:
RULE
[RecBalance].[PValue] < 0.025 AND
[RecBalance].[ZScore] < -2.24 AND
[RecBalance.[RollingZScore] < -2.24
FLAG 'Warning'
Warning Loose760
Data Rule Name: RecBalanceIncreaseLooseWarning
Data Rule Description: The current period’s Balance increased compared to its historical values.
DRS:
RULE
[RecBalance].[PValue] < 0.05 AND
[RecBalance].[ZScore] > 1.960 AND
[RecBalance.[RollingZScore] > 1.960
FLAG 'Warning'
Data Rule Name: RecBalanceDecreaseLooseWarning
Data Rule Description: The current period’s Balance decreased compared to its historical values.
DRS:
RULE
[RecBalance].[PValue] < 0.05 AND
[RecBalance].[ZScore] < -1.960 AND
[RecBalance.[RollingZScore] < -1.960
FLAG 'Warning'
Num I-Items
Focuses on the count of “I-Items” (manual adjustments). It tracks how consistently these items appear, calling out any changes from prior usage.
- Applicable Rec Statuses: InProcess, Prepared, BalanceChanged, Rejected
- Lookback Periods: 12
Default Rule
Default Warning760
Data Rule Name: NumIItemsIncreaseWarning
Data Rule Description: The number of I-Items increased compared to its historical usage.
DRS:
RULE
[NumIItems].[PValue] < 0.05 AND
[NumIItems].[RollingZScore] > 1.96 AND
[NumIItems].[IItemCountDiff] > 0
FLAG 'Warning'
Data Rule Name: NumIItemsDecreaseWarning
Data Rule Description: The number of I-Items decreased compared to its historical usage.
DRS:
RULE
[NumIItems].[PValue] < 0.05 AND
[NumIItems].[RollingZScore] < -1.96 AND
[NumIItems].[IItemCountDiff] < 0 AND
[NumIItems].[IItemCount] > 0
FLAG 'Warning'
Custom Rules
Strict Warning760
Data Rule Name: NumIItemsIncreaseStrictWarning
Data Rule Description: The number of I-Items increased compared to its historical usage.
DRS:
RULE
[NumIItems].[PValue] < 0.01 AND
[NumIItems].[RollingZScore] > 2.576 AND
[NumIItems].[IItemCountDiff] > 0 AND
[NumIItems].[IItemCount] > 0
FLAG 'Warning'
Data Rule Name: NumIItemsDecreaseStrictWarning
Data Rule Description: The number of I-Items decreased compared to its historical usage.
DRS:
RULE
[NumIItems].[PValue] < 0.01 AND
[NumIItems].[RollingZScore] < -2.576 AND
[NumIItems].[IItemCountDiff] < 0 AND
[NumIItems].[IItemCount] > 0
FLAG 'Warning'
Loose Warning760
Data Rule Name: NumIItemsIncreaseLooseWarning
Data Rule Description: The number of I-Items increased compared to its historical usage.
DRS:
RULE
[NumIItems].[PValue] < 0.10 AND
[NumIItems].[RollingZScore] > 1.645 AND
[NumIItems].[IItemCountDiff] > 0 AND
[NumIItems].[IItemCount] > 0
FLAG 'Warning'
Data Rule Name: NumIItemsDecreaseLooseWarning
Data Rule Description: The number of I-Items decreased compared to its historical usage.
DRS:
RULE
[NumIItems].[PValue] < 0.10 AND
[NumIItems].[RollingZScore] < -1.645 AND
[NumIItems].[IItemCountDiff] < 0 AND
[NumIItems].[IItemCount] > 0
FLAG 'Warning'
Number of Reconciliation Detail Items
Monitors how many individual detail items are included in each reconciliation period over period. It flags reconciliations that change compared to the number of detail items in historical periods.
- Applicable Rec Statuses: InProcess, Prepared, BaalnceChanged, Rejected
- Lookback Periods: 12
Default Rule
Default Warning760
Data Rule Name: NumRecDetailItemsIncreaseWarning
Data Rule Description: The number of Reconciliation Detail Items increased compared to its historical usage.
DRS:
RULE
[NumRecDetailItems].[PValue] < 0.05 AND
[NumRecDetailItems].[RollingZScore] > 1.96 AND
[NumRecDetailItems].[ItemCountDiff] > 0
FLAG 'Warning'
Data Rule Name: NumRecDetailItemsDecreaseWarning
Data Rule Description: The number of Reconciliation Detail Items decreased compared to its historical usage.
DRS:
RULE
[NumRecDetailItems].[PValue] < 0.05 AND
[NumRecDetailItems].[RollingZScore] < -1.96 AND
[NumRecDetailItems].[ItemCountDiff] < 0 AND
[NumRecDetailItems].[ItemCount] > 0
FLAG 'Warning'
Custom Rules
Strict Warning760
Data Rule Name: NumRecDetailItemsIncreaseStrictWarning
Data Rule Description: The number of Reconciliation Detail Items increased compared to its historical usage.
DRS:
RULE
[NumRecDetailItems].[PValue] < 0.01 AND
[NumRecDetailItems].[RollingZScore] > 2.576 AND
[NumRecDetailItems].[ItemCountDiff] > 0 AND
[NumRecDetailItems].[ItemCount] > 0
FLAG 'Warning'
Data Rule Name: NumRecDetailItemsDecreaseStrictWarning
Data Rule Description: The number of Reconciliation Detail Items decreased compared to its historical usage.
DRS:
RULE
[NumRecDetailItems].[PValue] < 0.01 AND
[NumRecDetailItems].[RollingZScore] < -2.576 AND
[NumRecDetailItems].[ItemCountDiff] < 0 AND
[NumRecDetailItems].[ItemCount] > 0
FLAG 'Warning'
Loose Warning760
Data Rule Name: NumRecDetailItemsIncreaseLooseWarning
Data Rule Description: The number of Reconciliation Detail Items increased compared to its historical usage.
DRS:
RULE
[NumRecDetailItems].[PValue] < 0.10 AND
[NumRecDetailItems].[RollingZScore] > 1.645 AND
[NumRecDetailItems].[ItemCountDiff] > 0 AND
[NumRecDetailItems].[ItemCount] > 0
FLAG 'Warning'
Data Rule Name: NumRecDetailItemsDecreaseLooseWarning
Data Rule Description: The number of Reconciliation Detail Items decreased compared to its historical usage.
DRS:
RULE
[NumRecDetailItems].[PValue] < 0.10 AND
[NumRecDetailItems].[RollingZScore] < -1.645 AND
[NumRecDetailItems].[ItemCountDiff] < 0 AND
[NumRecDetailItems].[ItemCount] > 0
FLAG 'Warning'
Check Balance I-Items
Evaluates if a reconciliation has both a B-Item and an I-Item attached as detail items. The goal of this detector is to flag reconciliations that have a Balance Check attached but have had a manual adjustment.
- Applicable Rec Statuses: InProcess, Prepared, BalanceChanged, Rejected
- Lookback Periods: 1
Default Rule
Default Warning760
Data Rule Name: CheckBalanceIItemsWarning
Data Rule Description: The reconciliation has I-Items and Balance Check Items attached.
DRS:
RULE
[CheckBalanceIItems].[IItemCount] > 0 AND
[CheckBalanceIItems].[BItemCount] > 0
FLAG 'Warning'
Custom Rules
Warning Large Increase Number of Manual Items760
Data Rule Name: CheckBalanceManyIItemsWarning
Data Rule Description: The reconciliation has 3 or more I-Items and Balance Check Items attached.
DRS:
RULE
[CheckBalanceIItems].[IItemCount] > 2 AND
[CheckBalanceIItems].[BItemCount] > 0
FLAG 'Warning'
Aging Changes (Info)
The Aging Changes Anomaly Detector reviews if the change in aging items in the current period deviates from historical trends. This monitor detects if the reconciliations detail items collectively have increased or decreased. The default rules include an increase and a decrease rule, so users can toggle one off if they only care about a change in one direction.
- Applicable Rec Statuses: InProcess, Prepared, BalanceChanged, Rejected
- Lookback Periods: 12
Default Rule
Default Info760
Data Rule Name: AgingChangesIncreaseInfo
Data Rule Description: The change in average aging days has increased compared to historical patterns.
DRS:
RULE
[AgingChanges].[PValue] < 0.05 AND
[AgingChanges].[ZScore] > 0 AND
[AgingChanges].[AvgAgingDaysDeltaPrevPeriod] > 0
FLAG 'Info'
Data Rule Name: AgingChangesDecreaseInfo
Data Rule Description: The change in average aging days has decreased compared to historical patterns.
DRS:
RULE
[AgingChanges].[PValue] < 0.05 AND
[AgingChanges].[ZScore] < 0 AND
[AgingChanges].[AvgAgingDaysDeltaPrevPeriod] < 0 AND
[AgingChanges].[NumItems] > 0
FLAG 'Info'
Custom Rules
Strict Info760
Data Rule Name: AgingChangesIncreaseStrictInfo
Data Rule Description: The change in average aging days has increased compared to historical patterns.
DRS:
RULE
[AgingChanges].[PValue] < 0.01 AND
[AgingChanges].[ZScore] > 0 AND
[AgingChanges].[AvgAgingDaysDeltaPrevPeriod] > 0 AND
[AgingChanges].[NumItems] > 0
FLAG 'Info'
Data Rule Name: AgingChangesDecreaseStrictInfo
Data Rule Description: The change in average aging days has decreased compared to historical patterns.
DRS:
RULE
[AgingChanges].[PValue] < 0.01 AND
[AgingChanges].[ZScore] < 0 AND
[AgingChanges].[AvgAgingDaysDeltaPrevPeriod] < 0 AND
[AgingChanges].[NumItems] > 0
FLAG 'Info'
Loose Info760
Data Rule Name: AgingChangesIncreaseLooseInfo
Data Rule Description: The change in average aging days has increased compared to historical patterns.
DRS:
RULE
[AgingChanges].[PValue] < 0.10 AND
[AgingChanges].[ZScore] > 0 AND
[AgingChanges].[AvgAgingDaysDeltaPrevPeriod] > 0 AND
[AgingChanges].[NumItems] > 0
FLAG 'Info'
Data Rule Name: AgingChangesDecreaseLooseInfo
Data Rule Description: The change in average aging days has decreased compared to historical patterns.
DRS:
RULE
[AgingChanges].[PValue] < 0.10 AND
[AgingChanges].[ZScore] < 0 AND
[AgingChanges].[AvgAgingDaysDeltaPrevPeriod] < 0 AND
[AgingChanges].[NumItems] > 0
FLAG 'Info'
Manual Auto Rec Ratio
This detector checks if a reconciliation has an auto rec rule attached to it and identifies whether in the prior lookback periods, if the reconciliation auto prepared or auto approved.
- Applicable Rec Statuses: InProcess, Prepared
- Lookback Periods: 10
Default Rule
Default Warning Auto Prepare760
Data Rule Name: ManualAutoPrepareWarning
Data Rule Description: The reconciliation did not auto-prepare in the current period, although it auto-prepared in 80% of prior periods and there are at least five prior periods.
DRS:
RULE
[ManualAutoRecRatio].[PrepareOnly] = True AND
[ManualAutoRecRatio].[AutoPrepared] = False AND
[ManualAutoRecRatio].[LookbackPctAuto] >= 80 AND
[ManualAutoRecRatio].[NumberOfLookbackPeriods] >= 5
FLAG 'Warning'
Default Warning Auto Approve760
Data Rule Name: ManualAutoApproveWarning
Data Rule Description: The reconciliation did not auto-approve in the current period, although it auto-approves in 80% of prior periods and there are at least five prior periods.
DRS:
RULE
[ManualAutoRecRatio].[PrepareOnly] = False AND
[ManualAutoRecRatio].[AutoApproved] = False AND
[ManualAutoRecRatio].[LookbackPctAuto] >= 80 AND
[ManualAutoRecRatio].[NumberOfLookbackPeriods] >= 5
FLAG 'Warning'
Custom Rules
Loose Auto Prepare Warning760
Data Rule Name: ManualAutoPrepareLooseWarning
Data Rule Description: The reconciliation did not auto-prepare in the current period, although it auto-prepared in 60% of prior periods and there are at least five prior periods.
DRS:
RULE
[ManualAutoRecRatio].[PrepareOnly] = True AND
[ManualAutoRecRatio].[AutoPrepared] = False AND
[ManualAutoRecRatio].[LookbackPctAuto] >= 60 AND
[ManualAutoRecRatio].[NumberOfLookbackPeriods] >= 5
FLAG 'Warning'
Loose Auto Approve Warning760
Data Rule Name: ManualAutoApproveLooseWarning
Data Rule Description: The reconciliation did not auto-approve in the current period, although it auto-approves in 60% of prior periods and there are at least five prior periods.
DRS:
RULE
[ManualAutoRecRatio].[PrepareOnly] = False AND
[ManualAutoRecRatio].[AutoApproved] = False AND
[ManualAutoRecRatio].[LookbackPctAuto] >= 60 AND
[ManualAutoRecRatio].[NumberOfLookbackPeriods] >= 5
FLAG 'Warning'
4 Consecutive Periods Auto Period Warning760
Data Rule Name: 5ConsecutiveManualAutoPrepareWarning
Data Rule Description: The reconciliation did not auto-prepare in the current period, but it has auto-approved in at least five of the immediately preceding periods.
DRS:
RULE
[ManualAutoRecRatio].[PrepareOnly] = True AND
[ManualAutoRecRatio].[AutoPrepared] = False AND
[ManualAutoRecRatio].[LookbackConsecutiveAuto] >= 5
FLAG 'Warning'
4 Consecutive Periods Auto Approved Warning760
Data Rule Name: 5ConsecutiveManualAutoApproveWarning
Data Rule Description: The reconciliation did not auto-approve in the current period, but it has auto-approved in at least five of the immediately preceding periods.
DRS:
RULE
[ManualAutoRecRatio].[PrepareOnly] = False AND
[ManualAutoRecRatio].[AutoApproved] = False AND
[ManualAutoRecRatio].[LookbackConsecutiveAuto] >= 5
FLAG 'Warning'
Number of Approvers
Looks for changes in the number of approvers required for a reconciliation. It flags reconciliations that have swings in the number of approvers during the current period compared to prior periods.
- Applicable Rec Statuses: Prepared, AutoPrepared
- Lookback Periods: 1
Default Rule
Default Warning760
Data Rule Name: NumApproversWarning
Data Rule Description: Compared to the prior period, the number of required approvers dropped by at least one.
DRS:
RULE
[NumberOfApprovers].[ApproverDiff] <= -1
FLAG 'Warning'
Custom Rules
Strict Warning760
Data Rule Name: NumApproversStrictWarning
Data Rule Description: Compared to the prior period, the number of required approvers dropped by at least one.
DRS:
RULE
[NumberOfApprovers].[ApproverDiff] <= -2
FLAG 'Warning'
T-Doc Sparsity
T-Doc Sparsity checks how often “T-Docs” (supporting documents at the reconciliation‐level) are consistently attached to reconciliations period over period.
- Applicable Rec Statuses: InProcess, Prepared, BalanceChanged, Rejected
- Lookback Periods: 18
Default Rule
Default Warning760
Data Rule Name: TDocSparsityWarning
Data Rule Description: The past three periods had a T-Doc attached, but the current period does not.
DRS:
RULE
[TDocSparsity].[HasTDoc] = False AND
[TDocSparsity].[Prior3TDocUsagePct] = 100
FLAG 'Warning'
Custom Rules
Accepts Any Document Type Warning760
Data Rule Name: TDocSparsityNoDocWarning
Data Rule Description: The past three periods had a T-Doc attached, but the current period does not have any supporting documentation.
DRS:
RULE
[Default_TDocSparsity].[HasTDoc] = False AND
[Default_RDocSparsity].[HasRDoc] = False AND
[Default_SDocSparsity].[HasSDoc] = False AND
[Default_IDocSparsity].[IItemsPctWithIDoc] < 100 AND
[Default_TDocSparsity].[Prior3TDocUsagePct] = 100
FLAG 'Warning'
Six Prior Periods had a T-Doc Attached Warning760
Data Rule Name: TDocSparsity6PeriodsWarning
Data Rule Description: The past six periods had an T-Doc attached, but the current period does not.
DRS:
RULE
[TDocSparsity].[HasTDoc] = False AND
[TDocSparsity].[Prior6TDocUsagePct] = 100
FLAG 'Warning'
S-Doc Sparsity
S-Doc Sparsity checks how often “S-Docs” (supporting documents at the reconciliation‐level) are consistently attached to reconciliations period over period.
- Applicable Rec Statuses: InProcess, Prepared, BalanceChanged, Rejected
- Lookback Periods: 18
Default Rule
Default Warning760
Data Rule Name: SDocSparsityWarning
Data Rule Description: The past three periods had an S-Doc attached, but the current period does not.
DRS:
RULE
[SDocSparsity].[HasSDoc] = False AND
[SDocSparsity].[Prior3SDocUsagePct] = 100
FLAG 'Warning'
Custom Rules
Accepts Any Document Type Warning760
Data Rule Name: SDocSparsityNoDocWarning
Data Rule Description: The past three periods had a S-Doc attached, but the current period does not have any supporting documentation.
DRS:
RULE
[Default_SDocSparsity].[HasSDoc] = False AND
[Default_TDocSparsity].[HasTDoc] = False AND
[Default_RDocSparsity].[HasRDoc] = False AND
[Default_IDocSparsity].[IItemsPctWithIDoc] < 100 AND
[Default_TDocSparsity].[Prior3SDocUsagePct] = 100
FLAG 'Warning'
Six Prior Periods had a S-Doc Attached Warning760
Data Rule Name: SDocSparsity6PeriodsWarning
Data Rule Description: The past six periods had an S-Doc attached, but the current period does not.
DRS:
RULE
[SDocSparsity].[HasSDoc] = False AND
[SDocSparsity].[Prior6SDocUsagePct] = 100
FLAG 'Warning'
Risk Level Fluctuations
Fluctuating Risk Levels check if the current assigned risk rating is different from prior periods. It detects large or erratic swing in the risk levels assigned to reconciliation.
- Applicable Rec Statuses: InProcess, BalanceChanged, Rejected, Prepared, AutoPrepared
- Lookback Periods: 3
Default Rule
Default Warning760
Data Rule Name: RiskLevelFluctuationsWarning
Data Rule Description: The risk level changed from the prior period.
DRS:
RULE
[RiskLevelFluctuations].[RiskChangeFromPriorPeriodAbs] >= 1
FLAG 'Warning'
Custom Rules
Strict Warning760
Data Rule Name: RiskLevelFluctuationsStrictWarning
Data Rule Description: The risk level had a large swing from the prior period (i.e., high to low or low to high).
DRS:
RULE
[RiskLevelFluctuations].[RiskChangeFromPriorPeriodAbs] >= 2
FLAG 'Warning'