Corporate Expense Reimbursement Analysis
This dataset provides comprehensive records of corporate expense reimbursements, including employee, approver, payment, and vendor details. It is designed to streamline finance operations, enable robust policy compliance monitoring, and support advanced fraud detection analytics for organizations of any size.
Sample rows
preview · 8 of 200 rows · all 25 columns| reimbursement_idstring | approval_statusstring | expense_amountfloat | fraud_flagboolean | payment_methodstring | employee_idstring | employee_namestring | departmentstring | expense_datedate | submission_datedate | approval_datedate | expense_categorystring | currencystring | policy_compliance_flagboolean | approver_idstring | approver_namestring | payment_datedate | vendor_namestring | vendor_street_addressstring | vendor_citystring | vendor_statestring | vendor_postal_codestring | vendor_countrystring | expense_descriptionstring | rejection_reasonstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| RB2024010001 | Approved | 48.25 | false | Direct Deposit | EMP001 | Sarah Lin | Finance | 2024-01-05 | 2024-01-06 | 2024-01-08 | Meals | USD | true | MGR1001 | Carla Jimenez | 2024-01-10 | Midtown Cafe | 101 Main St | New York | NY | 10001 | USA | Client lunch at Midtown Cafe with finance team | blank |
| RB2024010002 | Approved | 325.99 | false | PayPal | EMP002 | Jonas Schmidt | Engineering | 2024-01-12 | 2024-01-13 | 2024-01-15 | Office Supplies | EUR | true | MGR1002 | Mohammed Rizvi | 2024-01-17 | TechShop AG | 45 Berliner Strasse | Berlin | BE | 10715 | Germany | Purchase of monitors and keyboards for development team | blank |
| RB2024010003 | Pending | 580.5 | false | blank | EMP003 | Maria Fernandes | Marketing | 2024-01-21 | 2024-01-22 | blank | Entertainment | BRL | false | MGR1003 | Lucas Oliveira | blank | Rio Arena | 200 Avenida Brasil | Rio de Janeiro | RJ | 22040-020 | Brazil | Tickets for product launch event at Rio Arena | blank |
| RB2024010004 | Approved | 1350.25 | false | Direct Deposit | EMP004 | Emily Chen | R&D | 2024-01-09 | 2024-01-10 | 2024-01-12 | Travel | JPY | true | MGR1004 | Naoko Sato | 2024-01-15 | ANA Airlines | 2-3-2 Haneda Airport | Tokyo | TK | 144-0041 | Japan | Flight to Tokyo for research symposium | blank |
| RB2024010005 | Approved | 41.75 | false | Direct Deposit | EMP005 | Samuel Okoro | Support | 2024-01-17 | 2024-01-18 | 2024-01-20 | Transportation | NGN | true | MGR1005 | Chinedu Umeh | 2024-01-23 | Lagos Taxi Co. | 58 Allen Avenue | Lagos | LA | 101001 | Nigeria | Taxi fare for client onsite support at Lagos office | blank |
| RB2024010006 | Submitted | 320 | false | blank | EMP006 | Olga Ivanova | Legal | 2024-01-11 | 2024-01-13 | blank | Other | RUB | true | MGR1006 | Andrey Petrov | blank | Moscow Translations | 12 Tverskaya St | Moscow | MOW | 125009 | Russia | Legal document translation for compliance review | blank |
| RB2024010007 | Approved | 405.5 | false | Check | EMP007 | David Martinez | Sales | 2024-01-22 | 2024-01-23 | 2024-01-26 | Travel | MXN | true | MGR1007 | Andrea Ruiz | 2024-01-30 | Gran Hotel Reforma | 120 Paseo de la Reforma | Mexico City | CDMX | 06500 | Mexico | Hotel stay for sales conference in Mexico City | blank |
| RB2024010008 | Approved | 5.45 | false | Direct Deposit | EMP008 | Kim Min-Jung | IT | 2024-01-27 | 2024-01-28 | 2024-01-30 | Transportation | KRW | true | MGR1008 | Soo-Young Park | 2024-02-02 | Seoul Metro | 1 Jongno-gu | Seoul | KR | 03154 | South Korea | Subway fare for attending IT training in Seoul | blank |
| RB2024010009 | Approved | 124.32 | false | Direct Deposit | EMP009 | John Williams | Finance | 2024-01-19 | 2024-01-20 | 2024-01-21 | Meals | USD | true | MGR1001 | Carla Jimenez | 2024-01-24 | The Capital Grill | 44 Wall St | New York | NY | 10005 | USA | Dinner with external auditors at The Capital Grill | blank |
| RB2024010010 | Submitted | 69.2 | false | blank | EMP010 | Priya Singh | HR | 2024-01-25 | 2024-01-27 | blank | Meals | SGD | true | MGR1009 | Wei Tan | blank | Curry House | 95 Orchard Rd | Singapore | SG | 238888 | Singapore | Team lunch for new employee orientation at Curry House | blank |
| RB2024010011 | Rejected | 9500 | true | blank | EMP011 | Jessica Adams | Executive | 2024-01-15 | 2024-01-16 | 2024-01-19 | Lodging | USD | false | MGR1010 | Victor Lee | blank | Grand Hyatt SF | 345 Stockton St | San Francisco | CA | 94108 | USA | Hotel suite for CEO at Grand Hyatt SF | Expense exceeds allowed maximum for lodging. |
| RB2024010012 | Approved | 118.7 | false | Direct Deposit | EMP012 | Anna Müller | Engineering | 2024-01-18 | 2024-01-20 | 2024-01-22 | Travel | EUR | true | MGR1002 | Mohammed Rizvi | 2024-01-25 | DB Bahn | Bahnhofplatz 1 | Munich | BY | 80335 | Germany | Train ticket for business trip to Munich | blank |
| RB2024010013 | Approved | 199.95 | false | Direct Deposit | EMP013 | Miguel Santos | Product | 2024-01-13 | 2024-01-14 | 2024-01-16 | Office Supplies | USD | true | MGR1011 | Erica Foster | 2024-01-19 | Staples | 352 Market St | San Francisco | CA | 94103 | USA | New mouse and ergonomic chair for product manager | blank |
| RB2024010014 | Approved | 32.8 | false | Other | EMP014 | Hiroshi Takeda | IT | 2024-01-23 | 2024-01-24 | 2024-01-26 | Meals | JPY | true | MGR1004 | Naoko Sato | 2024-01-29 | Tokyo Sushi | 10 Ginza | Tokyo | TK | 104-0061 | Japan | Lunch with IT consultants at Tokyo Sushi | blank |
| RB2024010015 | Approved | 18.1 | false | Direct Deposit | EMP015 | Wei Tan | HR | 2024-01-15 | 2024-01-17 | 2024-01-19 | Transportation | SGD | true | MGR1009 | Wei Tan | 2024-01-23 | Grab Holdings | 28 Cecil Street | Singapore | SG | 049705 | Singapore | Grab ride for offsite HR meeting | blank |
| RB2024010016 | Approved | 77.45 | false | PayPal | EMP016 | Mohammed Rizvi | Engineering | 2024-01-06 | 2024-01-08 | 2024-01-10 | Meals | GBP | true | MGR1012 | Sarah Lin | 2024-01-14 | The London Pub | 18 King St | London | ENG | SW1A 1AA | UK | Team dinner for sprint completion at The London Pub | blank |
| RB2024010017 | Pending | 32 | false | blank | EMP017 | Carla Jimenez | Operations | 2024-01-07 | 2024-01-08 | blank | Other | EUR | false | MGR1003 | Lucas Oliveira | blank | blank | blank | blank | blank | blank | blank | Lost taxi receipt for site visit in Madrid | blank |
| RB2024010018 | Rejected | 700 | false | blank | EMP018 | Lucas Oliveira | Marketing | 2024-01-29 | 2024-01-31 | 2024-02-02 | Entertainment | BRL | false | MGR1013 | Jessica Adams | blank | Samba Lounge | 330 Copacabana | Rio de Janeiro | RJ | 22060-001 | Brazil | Corporate event at Samba Lounge for product launch | Entertainment expenses exceed allowed limit. |
| RB2024010019 | Approved | 74.5 | false | Direct Deposit | EMP019 | Andrey Petrov | Legal | 2024-01-30 | 2024-01-31 | 2024-02-02 | Office Supplies | RUB | true | MGR1006 | Andrey Petrov | 2024-02-06 | Moscow Print | 27 Arbat St | Moscow | MOW | 119002 | Russia | Printing legal briefs for court hearing | blank |
| RB2024010020 | Rejected | 3000 | true | blank | EMP020 | Erica Foster | Executive | 2024-01-16 | 2024-01-17 | blank | Lodging | USD | false | MGR1013 | Jessica Adams | blank | The Ritz | 600 Stockton St | San Francisco | CA | 94108 | USA | Luxury suite for board member at The Ritz | Lodging cost not compliant with policy. |
What the 200 rows show
from the 200-row sampleRejected (approval status) stands out: 12 of its 25 rows have fraud_
- 6%fraud_
flag = true - 59.4median expense_
amount - 7expense categories
- 12departments
- 12currencies
- 13vendor countries
Rejected (approval status)'s mean expense_
Median 59.4, from 2.5 to 9,500.
- string 18
- float 1
- date 4
- boolean 2
Columns
25 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 18 columns | |||
reimbursement_id | string | Unique identifier for each expense reimbursement recordunique | RB2024010001 |
employee_id | string | Unique identifier for the employee submitting the reimbursement | EMP001 |
employee_name | string | Full name of the employee | Sarah Lin |
department | string | Department to which the employee belongs12 departments | Finance |
expense_category | string | Category of the expense (e.g., Travel, Meals, Office Supplies)7 values | Meals |
expense_description | string | Detailed description of the expense | Purchase of HDMI cables |
currency | string | Currency code for the expense amount (e.g., USD, EUR)12 currencies | USD |
approver_id | string | Unique identifier for the manager or approveroptional | MGR1001 |
approver_name | string | Full name of the manager or approveroptional | Carla Jimenez |
approval_status | string | Current status of the reimbursement (e.g., Submitted, Approved, Rejected, Pending)Submitted · Approved · Rejected · Pending | Approved |
rejection_reason | string | Reason for rejection if the reimbursement was not approvedoptional | Expense exceeds allowed m… |
payment_method | string | Method used for reimbursement payment (e.g., Direct Deposit, Check, PayPal)Direct Deposit · Check · PayPal · Other · optional | Direct Deposit |
vendor_name | string | Name of the vendor or merchant associated with the expense, if applicableoptional | Midtown Cafe |
vendor_street_address | string | Street address of the vendoroptional | 101 Main St |
vendor_city | string | City of the vendoroptional | New York |
vendor_state | string | State or province of the vendoroptional | NY |
vendor_postal_code | string | Postal code of the vendoroptional | 10001 |
vendor_country | string | Country of the vendoroptional | USA |
| Numbers 1 column | |||
expense_amount | float | Amount claimed for reimbursement0.01 or more | 48.25 |
| Dates and times 4 columns | |||
expense_date | date | Date when the expense was incurred | 2024-01-05 |
submission_date | date | Date when the reimbursement was submitted | 2024-01-06 |
approval_date | date | Date when the reimbursement was approved (if applicable)optional | 2024-01-08 |
payment_date | date | Date when the reimbursement was paid to the employeeoptional | 2024-01-10 |
| True or false 2 columns | |||
policy_compliance_flag | boolean | Indicates if the expense complies with company policy | true |
fraud_flag | boolean | Indicates if the expense is flagged for potential fraud | false |
Use it for
A finance dashboard
The fraud_
flag rate, expense_ amount by approval_ status and a breakdown of payment_ method. Excel, Power BI or Tableau. Why do 12 of 200 rows have fraud_
flag = true? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Reimbursements200RB202401000148.25ApprovedRB20240100119500RejectedRB20240100203000Rejected
A software demo
Believable reimbursements with employee_
id, employee_ name and department to fill a screen in front of a buyer.
blueprint · corporate-expense-reimbursement-analysis
Behind this dataset
Same schema. As many rows as you need.
These 200 rows came out of a blueprint — 25 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.
- Employee ID and expense details anonymized
- Approval status captured
- Expense type and amount tracked
- Policy violations flagged
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-analysis