Expense Reports

This dataset provides a comprehensive record of employee expense submissions, including detailed information on receipts, categories, approval workflows, and reimbursement tracking. It enables finance teams to efficiently audit expenses, manage approvals, and monitor reimbursement processes for compliance and budget control. The dataset is ideal for financial analysis, policy enforcement, and operational transparency.

  • opened 10 times
  • last updated 29 Oct 2025
  • by GoMask
The brief that made it

Automated expense auditing and compliance monitoring

Sample rows

preview · 8 of 200 rows · all 19 columns
expense_idstringreimbursement_statusstringamountfloatdepartmentstringemployee_idstringemployee_namestringexpense_datedatesubmission_datedatetimecategorystringcurrencystringdescriptionstringreceipt_numberstringapproval_statusstringapprover_idstringapproval_datedatetimereimbursement_datedatereimbursement_referencestringproject_codestringreceipt_urlstring
EXP-10001Paid1250.34EngineeringE23456Alice Simmons2024-03-122024-03-13T10:23:41TravelUSDFlight ticket for conference in SFRCPT-75123ApprovedE334212024-03-14T15:56:122024-03-18REIM-98231PROJ-ENG-CT2024https://receipts.company.com/RCPT-75123.jpg
EXP-10002Paid78.55FinanceE17643Jayden Patel2024-05-022024-05-02T18:27:11Office SuppliesEURPrinter ink cartridges for Q2RCPT-35218ApprovedE221542024-05-03T10:09:442024-05-08REIM-20452PROJ-FIN-SS2024https://receipts.company.com/RCPT-35218.jpg
EXP-10003Not Submitted45.2blankE29832Helena Munch2024-04-052024-04-05T09:12:00MealsGBPClient lunch meeting on April 5blankPendingblankblankblankblankPROJ-CSM-APR24blank
EXP-10004Processing23000ProcurementE10293Rafael Costa2024-02-232024-02-24T14:10:55OtherBRLBulk purchase for new hardwareRCPT-91124ApprovedE174322024-02-26T11:55:36blankblankPROJ-PRC-HW2024https://receipts.company.com/RCPT-91124.jpg
EXP-10005Paid120.99ITE39821Maya Singh2024-06-012024-06-02T15:48:17Office SuppliesINRUSB drives for IT teamRCPT-41782ApprovedE302112024-06-03T13:25:582024-06-07REIM-08127PROJ-IT-BACKUP24https://receipts.company.com/RCPT-41782.jpg
EXP-10006Submitted32.5OperationsE20451Wei Zhang2024-05-152024-05-15T17:20:10TransportationCNYTaxi fare to client siteblankReturnedE334212024-05-16T09:01:47blankblankblankblank
EXP-10007Not Submitted92SalesE13984Samuel Lee2024-06-052024-06-06T08:32:20MealsUSDTeam dinner with prospectsRCPT-81672Pendingblankblankblankblankblankblank
EXP-10008Paid54.75DesignE35764Lucia Caruso2023-11-122023-11-13T13:45:22Office SuppliesEURSketch pads for design teamRCPT-56213ApprovedE221542023-11-14T09:22:092023-11-18REIM-70316PROJ-DSN-NOV23https://receipts.company.com/RCPT-56213.jpg

What the 200 rows show

from the 200-row sample

Processing (reimbursement status) stands out: mean amount is 96,496, against 694.2 for the rest.

  • 120.0median amount
  • 4approval statuses
  • 7categories
  • 12currencies
Mean amount by reimbursement_status200 rows
050k100k56.7Not Su…40 rows86.0Submit…8 rows96,496Proces…22 rows1,079Paid111 rows45.0Failed19 rows
amount200 rows, in bands of 50k
01002001934000000030250k500kamount →

Median 120.0, from 9.9 to 500,000.

department195 rows with a value · 5 left blank
  1. Engineering40
  2. Finance21
  3. Operations21
  4. IT18
  5. Design18
  6. Procurement17
  7. Product15
  8. Sales12
  9. Marketing10
  10. Legal9
19 columns by typefrom the column list below
  • string 14
  • float 1
  • date 2
  • datetime 2

Columns

19 columns in three groups
blueprint · 19 columns
columntypedescriptionexample
Text 14 columns
expense_idstringUnique identifier for each expense report submissionuniqueEXP-10001
employee_idstringUnique identifier for the employee submitting the expenseE23456
employee_namestringFull name of the employee submitting the expenseAlice Simmons
departmentstringDepartment of the employee submitting the expense12 departments · optionalEngineering
categorystringExpense category (e.g., Travel, Meals, Office Supplies)7 valuesTravel
currencystringCurrency code for the expense amount (e.g., USD, EUR)12 currenciesUSD
descriptionstringDetailed description or notes about the expenseoptionalUSB drives for IT team
receipt_numberstringReference number or identifier for the attached receiptoptionalRCPT-75123
receipt_urlstringURL or file path to the digital receipt image or documentoptionalhttps://receipts.company.…
approval_statusstringCurrent approval status of the expense reportPending · Approved · Rejected · ReturnedApproved
approver_idstringUnique identifier for the manager or finance team member who approved/rejected the expenseoptionalE33421
reimbursement_statusstringCurrent reimbursement status for the expenseNot Submitted · Submitted · Processing · Paid · FailedPaid
reimbursement_referencestringReference number or transaction ID for the reimbursement paymentoptionalREIM-98231
project_codestringCode or identifier for the project related to the expense, if applicableoptionalPROJ-ENG-CT2024
Numbers 1 column
amountfloatTotal amount of the expense0.01 or more1250.34
Dates and times 4 columns
expense_datedateDate when the expense was incurred2024-03-12
submission_datedatetimeDate and time when the expense report was submitted2024-03-13T10:23:41
approval_datedatetimeDate and time when the expense was approved or rejectedoptional2024-03-14T15:56:12
reimbursement_datedateDate when the reimbursement was paid to the employeeoptional2024-03-18

Use it for

  • median amount120.0200 rowsmean amount by reimbu…56.7Not …86.0Subm…96.5kProc…1.1kPaid

    A finance dashboard

    Amount by reimbursement_status and a breakdown of department. Excel, Power BI or Tableau.

  • Why do the 22 Processing rows have a mean amount of 96,496?

    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 expenses with employee_id, employee_name and department to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 19 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 rows19 columns
Yours1,000 rows19 columns

blueprint · expense-reports

Behind this dataset

Same schema. As many rows as you need.

These 200 rows came out of a blueprint — 19 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
  • Expense date before submission date
  • Categories: travel, meals, supplies, etc
  • Receipts required for amounts over threshold
  • Approval workflow: submitted, approved, rejected
  • Reimbursement processed after approval
Rows
Open the blueprint in Data Factory

1 credit per row. New accounts start with 25 free credits.

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

More in Finance

Browse all
Also in FinanceFinance Expense Approval WorkflowCredit Card Fraud DetectionDigital Wallet Transaction DatasetAll 1,954 datasets

What should your data show?

Preview 20 rows free
No signup. No card.