Corporate Expense Reimbursement Logs

This dataset provides a detailed, structured log of corporate expense reimbursement requests, including employee and approver details, expense categorization, payment methods, and audit flags. Designed for audit automation and fraud detection, it enables granular analysis of spending patterns, policy compliance, and exception handling across departments and projects.

  • opened 10 times
  • last updated 22 Jul 2025
  • by GoMask
The brief that made it

Automated audit and compliance monitoring of employee expenses

Sample rows

preview · 8 of 200 rows · all 22 columns
reimbursement_idstringexpense_categorystringexpense_amountfloatis_flagged_for_auditbooleandepartmentstringemployee_idstringemployee_namestringexpense_datedatesubmission_datedateapproval_datedatecurrencystringpayment_methodstringvendor_namestringvendor_citystringvendor_countrystringreceipt_attachedbooleanapprover_idstringapprover_namestringapproval_statusstringproject_codestringexpense_descriptionstringrejection_reasonstring
RMB-00001Travel487.5falseSalesE-1001Samuel L. Miller2024-03-122024-03-132024-03-15USDCorporate CardDelta AirlinesHoustonUSAtrueM-2002Therese YoungApprovedPRJ2024AFlight to client meeting in Houston, United States.blank
RMB-00002Office Supplies79.95falseEngineeringE-1002Linda Zhang2024-03-072024-03-082024-03-09USDCorporate CardBest BuySan DiegoUSAtrueM-2004Peter NovakApprovedENG2024Purchase of USB-C adapters for team laptops.blank
RMB-00003Entertainment213.8falseMarketingE-1003Jean-Luc Moreau2024-03-152024-03-172024-03-19EURCorporate CardLe GourmetParisFrancetrueM-2003Anna SchmidtApprovedMKT2024BClient dinner at Le Gourmet, Paris.blank
RMB-00004Meals56.2falseFinanceE-1004Priya Nair2024-02-282024-03-01blankINRPersonal CardBarbeque NationMumbaiIndiafalseM-2005Rakesh MenonPendingblankTeam lunch after quarterly review meeting.blank
RMB-00005Training120falseHRE-1005Fatima Al Zahra2024-02-102024-02-122024-02-13AEDBank TransferUdemyDubaiUAEtrueM-2006Khalid SheikhApprovedHR2024Registration for online HR compliance course.blank
RMB-00006Office Supplies349.99falseProcurementE-1006Lucas Fernandes2024-01-202024-01-222024-01-24BRLBank TransferPapelaria CentralSao PauloBraziltrueM-2007Maria SilvaApprovedPRC2024Bulk paper purchase for Q1 procurement.blank
RMB-00007Other85falseITE-1007Yusuf Ibrahim2024-03-032024-03-032024-03-04USDCorporate CardNordVPNMiamiUSAtrueM-2008John GrieveApprovedblankVPN subscription renewal for remote staff.blank
RMB-00008Entertainment405.6trueLegalE-1008Sophia Rossi2024-02-152024-02-162024-02-17GBPPersonal CardThe IvyLondonUKtrueM-2009David ClarkeApprovedLEGAL24Client entertainment at The Ivy, London.blank

What the 200 rows show

from the 200-row sample

Entertainment (expense category) stands out: 25 of its 28 rows have is_flagged_for_audit = true, against 16 of 171 for the rest.

  • 21%is_flagged_for_audit = true
  • 95.6median expense_amount
  • 4approval statuses
  • 5payment methods
  • 16currencies
  • 24vendor countries
Is flagged for audit rate by expense_categoryis_flagged_for_audit = true
0%50%100%20%Travel5 of 254%Meals1 of 274%Offic…2 of 4589%Enter…25 of …0%Train…0 of 2717%Other8 of 47
expense_amount199 rows, in bands of 250
075150143377451000201,2502,500expense_amount →

Median 95.6, from 0.02 to 2,500.

department199 rows with a value · 1 left blank
  1. Engineering29
  2. Sales28
  3. Finance24
  4. Marketing19
  5. Procurement19
  6. R&D19
  7. IT17
  8. Legal17
  9. HR15
  10. Logistics12
22 columns by typefrom the column list below
  • string 16
  • float 1
  • date 3
  • boolean 2

Columns

22 columns in four groups
blueprint · 22 columns
columntypedescriptionexample
Text 16 columns
reimbursement_idstringUnique identifier for each reimbursement log entryuniqueRMB-00001
employee_idstringUnique identifier for the employee submitting the expenseE-1001
employee_namestringFull name of the employeeSamuel L. Miller
departmentstringDepartment to which the employee belongs10 departmentsSales
expense_categorystringCategory of the expense (e.g., Travel, Meals, Office Supplies)6 valuesTravel
expense_descriptionstringDetailed description of the expenseFlight to client meeting …
currencystringCurrency code for the expense (ISO 4217 format, e.g., USD, EUR)USD
payment_methodstringMethod used to pay for the expense (e.g., Corporate Card, Personal Card, Cash)5 valuesCorporate Card
vendor_namestringName of the vendor or merchant where the expense was incurredoptionalDelta Airlines
vendor_citystringCity where the vendor is locatedoptionalHouston
vendor_countrystringCountry where the vendor is locatedoptionalUSA
approver_idstringUnique identifier for the manager or approveroptionalM-2002
approver_namestringFull name of the manager or approveroptionalTherese Young
approval_statusstringCurrent status of the reimbursement requestPending · Approved · Rejected · ReturnedApproved
rejection_reasonstringReason for rejection if the request was not approvedoptionalReceipt missing for meal …
project_codestringCode of the project or cost center associated with the expenseoptionalPRJ2024A
Numbers 1 column
expense_amountfloatAmount requested for reimbursement0.01 or more487.5
Dates and times 3 columns
expense_datedateDate when the expense was incurred2024-03-12
submission_datedateDate when the reimbursement request was submitted2024-03-13
approval_datedateDate when the reimbursement was approved (if applicable)optional2024-03-15
True or false 2 columns
receipt_attachedbooleanIndicates if a receipt or supporting document is attachedtrue
is_flagged_for_auditbooleanIndicates if the expense is flagged for audit or further reviewoptionalfalse

15 SQL practice questions for the Corporate Expense Reimbursement Logs

Written for this data and checked against it: 12 SQL and 3 Power BI exercises from beginner to advanced. Try the first three free; the practice kit has all 15, a starter .sql file and an answer key with every expected result.

  1. 01BeginnerFreeSELECT · WHERE · ORDER BY · LIMIT

    Largest Approved Claims

    Return reimbursement_id, employee_name and expense_amount for the 10 largest claims with an approval_status of 'Approved'. Sort by expense_amount from highest to lowest, using reimbursement_id ascending to break ties.

    Tables: corporate_expense_reimbursement_logs · your result: 3 columns, 10 rows
  2. 02BeginnerFreeDISTINCT · WHERE · ORDER BY

    Distinct Payment Methods

    Return each distinct payment_method found in the log as a single column named payment_method. Exclude missing values and sort the results alphabetically.

    Tables: corporate_expense_reimbursement_logs · your result: 1 columns, 5 rows
  3. 03BeginnerFreeGROUP BY · COUNT

    Claims per Department

    Count the claims in each department. Return department and claim_count, excluding rows with no department. Order by claim_count descending, then department ascending.

    Tables: corporate_expense_reimbursement_logs · your result: 2 columns, 10 rows
  1. 04Average Amount by CategoryBeginner
  2. 05Flagged Claims by Status VisualPower BI
  3. 06Departments With Many Missing ReceiptsIntermediate
  4. 07Amount Size BucketsIntermediate
  5. 08Claims by MonthIntermediate
  6. 09Departments Above Overall AverageIntermediate
  7. 10Rejection Rate by DepartmentPower BI
  8. 11Rank Claims Within DepartmentAdvanced
  9. 12Days Since Employee's Previous ClaimAdvanced
  10. 13Running Monthly TotalAdvanced
  11. 14Category Share of Total SpendAdvanced
  12. 15Approver Amount AnomaliesPower BI

Get the practice kit: the full dataset, all 15 exercises, a starter .sql and the answer key. One-time $3.99.

Get the practice kit · $3.99

Use it for

  • is flagged for…21%41 of 199 rowsmean expense amount b…310.7Trav…57.1Meals155.7Offi…515.5Ente…

    A finance dashboard

    The is_flagged_for_audit rate, expense_amount by expense_category and a breakdown of department. Excel, Power BI or Tableau.

  • Why do 41 of 199 rows have is_flagged_for_audit = true?

    A root-cause class exercise

    Hand out the rows and one question. The answer is in the data, not in the brief.

  • A software demo

    Believable reimbursements with employee_id, employee_name and department to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 22 columns, your size and your rules. See 20 rows before you pay.

Preview 20 rows free

1,000 rows: $1.99 · 10,000: $12.99One-time. No subscription. All prices

This dataset200 rows22 columns
Yours1,000 rows22 columnsvendor_city: UK only

blueprint · corporate-expense-reimbursement-logs

Behind this dataset

Same schema. As many rows as you need.

These 200 rows came out of a blueprint — 22 columns with generation rules behind each one. Open it in Data Factory to retune a column, add your own, wire in foreign keys, and run it at the size you actually need.

Rules it was built with
  • Each record links employee, date, expense category, amount.
  • Approval status and reviewer included.
  • Flagged anomalies for policy violations.
  • Receipts (URL or file pointer) attached.
Rows
Open the blueprint in Data Factory

1 credit per row. Preview 20 rows free. Buy rows for the full run.

Exports
CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
Licence
yours to use, including commercially
API slug
corporate-expense-reimbursement-logs

More in Finance

Browse all
Also in FinanceFinance Expense Approval WorkflowBank Customer Segmentation DatasetBank Transaction Category ClassificationAll 1,966 datasets

What should your data show?

Preview 20 rows free
No signup. No card.