Employee Spending
Spending controls aren't always sophisticated enough to prevent or detect unauthorized transactions in a timely manner. Whether it's P-Cards or Travel & Entertainment expenses, the sooner suspicious expenses can be detected, the sooner they can be resolved.
PCards and Travel & Entertainment
-
PCard Split Purchases
The temptation to split a purchase into two transactions to circumvent PCard approval controls poses a perennial challenge. Additionally, two employees may collude by each claiming one of the purchases.
This is easily addressed in Analyzer by (1) isolating the below-the-limit transactions by extracting them to a file, (2) extracting these records to a second, identical file, (3) executing a many-to-many Join between the two files with the employee number and vendor ID as the key fields, and (4) filtering for pairs of transactions that add up to an amount over the employee's limit.
Additional filters can be invoked to specify pairs of transactions within x days of each other. -
Cardholders with Excessive Declined/Disputed Transactions
Card processors can provide data files containing declined and disputed transactions by employee cardholders. Analyzer's enhanced Summarize command can identify employees with high rates of declines and disputes.
-
Terminated Employees & Active Cards
Suspicious transactions frequently occur in the period just before and after employees are terminated. Controls don't always result in timely invalidation of employee PCards, but prompt identification of such transactions is straightforward with Analyzer.
A direct connection to Concur and other databases makes it possible to continuously compare employee transactions and termination dates. -
Multiple Cards per Employee
With an automated download from the enterprise application, issued cards can be scanned with the Duplicates command to identify employees with more than one active card.
-
Stale Claims
Analyzing the T&E transaction date with the Age command will identify claims that are more than 30 days older than the report date.
Additional Popular Analytics Tests
No two organizations are identical, but the vast majority consider many of the same tests. Learn more about these popular analytics tests

Striving for Data Analytics Excellence
Presented by ATCO
Learn how ATCO evolved its Internal Audit practice through embedding Data Analytics within its Audit Shop.

Analytics by Industry
See how we help data professionals in your industry.
Request Trial