Analyze·Intermediate·Playground·20 min·Updated Sep 30, 2026

Reconcile an expense report against receipts

Scenario

Finance flagged one expense claim that doesn't match its receipt.

Mission

Find the mismatched claim and the exact dollar difference.

Start Files

ClaimIDCategoryClaimedAmount
EXP-201Software220
EXP-202Software293
EXP-203Travel298
EXP-204Meals334
EXP-205Travel371
Preview — first 5 rows of expense-claims.csv

Your task

  1. Join the expense claims file with the receipts file on Claim ID.
  2. Compare the claimed amount to the receipted amount for every row.
  3. Identify the one claim that doesn't match and calculate the exact difference.

Prompt idea:

I have an expense claims file and a receipts file, both with a ClaimID column. Join them and tell me which claim's amount doesn't match its receipt, and by how much.

Check Your Result

Which claim ID doesn't match the amount on its receipt?

Need a hint?

Join the two files on ClaimID and compare ClaimedAmount to ReceiptAmount — only one row differs.

Reveal Solution

The solution files contain the completed challenge. Review the approach to see if you missed any edge cases.

Related Workflows

WORK WITH LIMINALS

Make AI useful for your team.

Get practical help with AI consulting or ask about training courses for your team.