You are validating a daily transaction report for a shared service that processes vendor payments across multiple regions. The system's automated count shows 1,250 transactions processed, but the manual log you maintain separately shows 1,287. How would you investigate the discrepancy and identify the root cause?
Why This Is Asked
ING's online assessments and business panels test analytical rigor. This question simulates a real shared-services scenario where inconsistent reports must be reconciled quickly. It evaluates logical problem-solving, attention to detail, and the ability to handle ambiguity, core for roles in Analytics, Risk, or Finance.
General Approach
First, verify the manual log's accuracy: re-check counts for obvious errors, like missed or duplicated entries, and ensure the period covers the same time window. Second, compare transaction IDs or reference numbers line by line if feasible, or use data comparison tools (e.g., Excel VLOOKUP). Third, check for system filters (e.g., processed vs. settled) that might exclude certain transactions. Fourth, consult the team to see if any manual adjustments or batch updates occurred. Finally, if discrepancies persist, trace a sample of mismatched transactions to source documents to determine whether the system or log is correct. Communicate findings clearly, proposing corrections and process improvements to prevent recurrence. Avoid jumping to conclusions; methodically rule out each possible cause.
Sample STAR Answer▾
Attempt Your Answer
Write your own answer, then get instant AI feedback graded against:
- •STAR Structure
- •Specificity & Numbers
- •Ownership Language
- •PH Workplace Context
Log in to get AI feedback on your answer.
Log In