Expense Reimbursement Records

This dataset provides a comprehensive record of employee expense reimbursement claims, including detailed claim information, approval workflow, policy compliance, and payment tracking. It enables finance teams to efficiently validate, audit, and analyze expense claims for policy adherence and financial reporting. The dataset is ideal for process optimization, fraud detection, and compliance monitoring.

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

Automated validation and processing of employee expense claims

Sample rows

preview · 8 of 60 rows · all 20 columns
claim_idstringpayment_methodstringamount_claimedfloatpolicy_compliancebooleanapprover_idstringemployee_idstringemployee_namestringdepartmentstringexpense_datedatesubmission_datedateexpense_categorystringexpense_descriptionstringcurrencystringamount_approvedfloatapproval_statusstringapproval_datedaterejection_reasonstringpayment_datedatereceipt_attachedbooleanproject_codestring
CLM-100001direct_deposit452.75trueAP-301E-2101Jessica MartinSales2024-01-152024-01-17travelFlight to client meeting in New YorkUSD452.75paid2024-01-20blank2024-01-23truePRJ-0021
CLM-100002blank68.5trueAP-312E-2102Mark LeeEngineering2024-02-092024-02-10mealsTeam lunch after project milestoneUSD68.5approved2024-02-12blankblanktrueblank
CLM-100003payroll120trueAP-304E-2103Priya DesaiMarketing2024-03-022024-03-04suppliesBranded pens for expo boothUSD115paid2024-03-06blank2024-03-10truePRJ-0042
CLM-100004blank87.3trueAP-301E-2104Samuel O'NeillFinance2024-01-222024-01-22mealsClient dinner at The GrillUSD80approved2024-01-23blankblanktruePRJ-0080
CLM-100005direct_deposit34.99trueAP-312E-2105Emily ZhangIT2024-02-152024-02-16suppliesLaptop charger replacementUSD34.99paid2024-02-18blank2024-02-22trueblank
CLM-100006check38trueAP-304E-2106Carlos HernandezSales2024-03-052024-03-06travelTaxi from airport to hotelUSD38paid2024-03-07blank2024-03-11trueblank
CLM-100007blank269trueAP-312E-2107Hannah KimCustomer Support2024-01-262024-01-28lodgingHotel stay for trainingUSD250approved2024-01-30blankblanktruePRJ-0022
CLM-100008blank210falseAP-301E-2108Oliver GreeneLegal2024-02-122024-02-13entertainmentClient tickets to theaterUSD0rejected2024-02-15Not within entertainment policy limitsblanktrueblank

What the 60 rows show

from the 60-row sample
  • 90%policy_compliance = true
  • 57.5median amount_claimed
  • 5approval statuses
  • 6expense categories
  • 7currencies
  • 9departments
payment_method18 rows by value
0488direct_depos…13%3check5%7payroll12%
amount_claimed60 rows, in bands of 50
015302915522211120250500amount_claimed →

Median 57.5, from 14.0 to 500.0.

approver_id52 rows with a value · 8 left blank
  1. AP-3019
  2. AP-3128
  3. AP-3048
  4. APR10024
  5. APR10054
  6. APR10074
  7. APR10083
  8. APR10093
  9. APR10032
  10. APR10102
20 columns by typefrom the column list below
  • string 12
  • float 2
  • date 4
  • boolean 2

Columns

20 columns in four groups
blueprint · 20 columns
columntypedescriptionexample
Text 12 columns
claim_idstringUnique identifier for each expense claimuniqueCLM-100001
employee_idstringUnique identifier for the employee submitting the claimE-2101
employee_namestringFull name of the employee submitting the claimJessica Martin
departmentstringDepartment of the employee submitting the claim9 departmentsSales
expense_categorystringCategory of the expense (e.g., travel, meals, lodging, supplies)6 valuestravel
expense_descriptionstringDetailed description of the expenseHotel stay for training
currencystringCurrency code of the claimed amount (ISO 4217 format, e.g., USD, EUR)7 currenciesUSD
approval_statusstringCurrent status of the claim (e.g., submitted, under_review, approved, rejected, paid)submitted · under_review · approved · rejected · paidpaid
approver_idstringUnique identifier of the person who approved or rejected the claimoptionalAP-301
rejection_reasonstringReason for rejection if the claim was not approvedoptionalNot within entertainment …
payment_methodstringMethod used for reimbursement payment (e.g., direct_deposit, check, payroll)direct_deposit · check · payroll · other · optionaldirect_deposit
project_codestringProject or cost center code associated with the expense, if applicableoptionalPRJ-0021
Numbers 2 columns
amount_claimedfloatTotal amount claimed for reimbursement0 or more452.75
amount_approvedfloatTotal amount approved for reimbursement after validation0 or more · optional452.75
Dates and times 4 columns
expense_datedateDate when the expense was incurred2024-01-15
submission_datedateDate when the expense claim was submitted2024-01-17
approval_datedateDate when the claim was approved or rejectedoptional2024-01-20
payment_datedateDate when the reimbursement was paid to the employeeoptional2024-01-23
True or false 2 columns
policy_compliancebooleanIndicates if the claim complies with company expense policytrue
receipt_attachedbooleanIndicates if a receipt or supporting document was attachedtrue

Use it for

  • policy complia…90%54 of 60 rowsmean amount claimed b…133.8direct…262.7check95.9payroll

    A finance dashboard

    The policy_compliance rate, amount_claimed by payment_method and a breakdown of approver_id. Excel, Power BI or Tableau.

  • Why do 54 of 60 rows have policy_compliance = true?

    A class exercise

    Hand out the rows and one question. Everyone works from the same 60 rows.

  • A software demo

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

Not quite right?

Make it yours.

Same 20 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 dataset60 rows20 columns
Yours1,000 rows20 columns

blueprint · expense-reimbursement-records

Behind this dataset

Same schema. As many rows as you need.

These 60 rows came out of a blueprint — 20 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
  • Receipts required for expenses >$25
  • Duplicate claims automatically flagged
  • Approval required for expenses >$500
  • Expenses audited quarterly for compliance
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
expense-reimbursement-records

More in Finance

Browse all
Also in FinanceCorporate Expense Reimbursement LogsCredit Card Fraud DetectionPersonal Finance Budgeting RecordsAll 1,966 datasets

What should your data show?

Preview 20 rows free
No signup. No card.