Journal Entry Risk-Scoring

JE Risk-Scoring

• 2020 Holidays

  Match(Posting_Date,`20200101`,20200120`,`20200217`,`20200625`,`20200703`,`20200907`,`20201012`,`20201111`,`20201126`,`20201225`)

• Weekends

  Match(CDOW(Posting_Date,3),"Sun","Sat")
  
  

• Keywords in Description

  ListFind("Keywords.txt")

• Same Account, Same Amount

  Duplicates ON Account Amount OTHER ALL TO …
  
  
  
  

• Seldom Used Accounts

  Classify ON Account TO Newfile_1 OPEN
  Extract Account IF COUNT1 <= 3 TO Newfile_2
  OPEN <source file>
  OPEN Newfile_2 SECONDARY
  Join PKEY Account FIELDS ALL SKEY Account WITH PRESORT SECSORT TO JEs_Seldom_Used_AC OPEN

• Large Credits to Revenue 5 Days Prior to Period-End

  (Assumption: Revenue Accounts Begin With "4")

  Extract RECORD IF Account = "4" AND Amount_CR <> 0 TO JE_Rev_Accts OPEN
  
  Statistics ON ABS(Amount_CR) STD Number 5
  
  Extract RECORD IF ABS(Amount) > AVERAGE1 + (2* STDDEV1) TO Large_CR_Rev_Accts

   

• Large Credits to Income Statement Non-Revenue Accounts

  (Assumption: Target accounts begin with "5","6", or "7")
  
  Extract RECORD IF Match(Account, "5","6", "7" ) AND Amount_CR <> 0 TO JE_NonRev_Accts OPEN
  Statistics ON ABS(Amount_CR) STD Number 5
  Extract RECORD IF ABS(Amount) > AVERAGE1 + (2* STDDEV1) TO Large_CR_NonRev_Accts

• Round Amounts

  Filter for all amounts with 0 cents:
  MOD(Amount,1) = 0

  For a more granular, materiality-based analysis, create a conditional computed field with a default value of Blanks(30):

  

  
  
  

• Prior-Year Entries Posted 5 Days After Year-End

  Between(Posting_Date,`20190101`,`20190106`) AND Period = "2018"

• Amounts Just Below Approval Threshold

  (Assumption: Threshold = $5000)
  
  Create a filter, adjusting the lower bound as necessary:
  Between(Amount,4999.99,4900)