Expense claims
Monthly expense claims from a fictional consultancy, with UK-style dates.
What's messy
- Dates written day/month/year
- Some claims not approved
Columns
| Column | Type | Note |
|---|---|---|
| ClaimID | text | |
| Employee | text | |
| Category | text | |
| Amount | decimal | |
| ClaimDate | text (dd/mm/yyyy) | Convert with en-GB |
| Approved | text | Yes/No |
Try these
- Convert ClaimDate with en-GB
- Total approved spend by category
- Rank claims per employee
How to approach it
Start by setting ClaimDate with Change Type → Using Locale and English (United Kingdom), because the dates are written day first. A plain type change on a machine set to US English reads 05/03/2026 as May 3 and fails on any day above 12. Change Amount to a decimal number and keep Approved as text until you decide how to treat it: filtering to Yes before grouping gives approved spend only, while keeping both values lets you show what is still pending. Then group by Category and sum Amount for a spend summary, and rank each employee's claims to practise grouping with nested tables.
Preview (first 8 rows)
| ClaimID | Employee | Category | Amount | ClaimDate | Approved |
|---|---|---|---|---|---|
| C-0001 | Idris Novak | Software | 12.71 | 13/05/2026 | Yes |
| C-0002 | Jun Okafor | Training | 156.54 | 23/02/2026 | No |
| C-0003 | Omar Kowal | Lodging | 64.68 | 03/02/2026 | No |
| C-0004 | Dmitri Novak | Lodging | 266.39 | 18/05/2026 | Yes |
| C-0005 | Goran Mensah | Training | 333.41 | 10/06/2026 | No |
| C-0006 | Idris Ito | Travel | 196.92 | 07/04/2026 | No |
| C-0007 | Carmen Silva | Training | 433.29 | 18/06/2026 | Yes |
| C-0008 | Esi Brandt | Meals | 38.56 | 18/03/2026 | Yes |
All data is fictional. CSV cells that could be read as spreadsheet formulas are prefixed with an apostrophe.