Finance Expense Approval Workflow
This dataset provides a detailed record of business expense approval workflows, capturing every step from submission to audit review. It includes employee, expense, approval, and vendor details, enabling robust compliance monitoring, audit trails, and process automation for finance teams. Ideal for organizations seeking transparency and control over expense management.
Sample rows
preview · 8 of 200 rows · all 30 columns| expense_idstring | departmentstring | expense_amountfloat | policy_violation_flagboolean | address_countrystring | employee_idstring | employee_namestring | expense_datedate | submission_datedatetime | expense_typestring | currencystring | approval_statusstring | approver_idstring | approver_namestring | approval_datedatetime | approval_commentsstring | audit_flagboolean | audit_review_datedatetime | vendor_namestring | vendor_tax_idstring | receipt_numberstring | receipt_datedate | receipt_amountfloat | address_streetstring | address_citystring | address_statestring | address_postal_codestring | expense_descriptionstring | policy_violation_descriptionstring | audit_commentsstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| EXP2024-0001 | Marketing | 1250.54 | false | USA | E1001 | Jennifer Lee | 2024-03-14 | 2024-03-15T09:33:12 | travel | USD | approved | A101 | Mark Thompson | 2024-03-16T13:21:38 | Approved as per travel policy. | false | blank | Delta Airlines | 98-2345678 | TRAVEL-2024-001 | 2024-03-14 | 1250.54 | 2338 5th Ave | New York | NY | 10010 | Flight ticket for regional marketing conference. | blank | blank |
| EXP2024-0002 | IT | 420.99 | false | USA | E1002 | Samuel Rodriguez | 2024-02-24 | 2024-02-24T15:09:55 | office supplies | USD | approved | A103 | Linda Chang | 2024-02-25T10:42:33 | Necessary upgrade for team efficiency. | false | blank | Office Depot | 57-8765432 | OFFICE-2024-002 | 2024-02-24 | 420.99 | 472 Main Street | Chicago | IL | 60607 | Purchase of new wireless keyboards for IT team. | blank | blank |
| EXP2024-0003 | Research | 312 | false | India | E1003 | Priya Singh | 2024-04-03 | 2024-04-04T11:17:21 | training | INR | approved | A105 | Ramesh Patel | 2024-04-06T14:07:08 | Professional development approved. | false | blank | Coursera India | IN-234567890 | TRAINING-2024-003 | 2024-04-03 | 312 | 88 MG Road | Bangalore | Karnataka | 560042 | Online certification course for data analysis tools. | blank | blank |
| EXP2024-0004 | Legal | 385.8 | false | Italy | E1004 | Luca Moretti | 2024-01-19 | 2024-01-20T12:05:41 | entertainment | EUR | approved | A106 | Giulia Rossi | 2024-01-22T17:40:10 | Client engagement justified. | true | 2024-01-24T11:35:22 | Trattoria Milano | IT-0012345678 | ENT-2024-004 | 2024-01-19 | 385.8 | Via Roma 15 | Milan | Lombardy | 20122 | Client dinner at local Italian restaurant. | blank | Reviewed for compliance, no issues found. |
| EXP2024-0005 | Finance | 258 | false | China | E1005 | Chen Wei | 2024-05-02 | 2024-05-02T08:27:51 | meals | CNY | pending | blank | blank | blank | blank | false | blank | Beijing Bistro | CN-876543210 | MEALS-2024-005 | 2024-05-02 | 258 | 12 Haidian Road | Beijing | Beijing | 100080 | Team lunch with external auditors. | blank | blank |
| EXP2024-0006 | IT | 99.99 | false | USA | E1002 | Samuel Rodriguez | 2024-03-18 | 2024-03-18T16:12:10 | other | USD | approved | A103 | Linda Chang | 2024-03-19T11:40:02 | Renewal approved. | false | blank | Dropbox Inc. | 31-2549876 | OTHER-2024-006 | 2024-03-18 | 99.99 | 1800 Market St | San Francisco | CA | 94103 | Monthly subscription for cloud storage service. | blank | blank |
| EXP2024-0007 | Operations | 765.5 | false | Saudi Arabia | E1006 | Fatima Al-Farsi | 2024-02-12 | 2024-02-12T10:04:27 | office supplies | SAR | approved | A110 | Mohammed Al-Mutairi | 2024-02-13T09:16:55 | Stock replenishment approved. | true | 2024-02-15T12:45:33 | Riyadh Office Mart | SA-8765432101 | OFFICE-2024-007 | 2024-02-12 | 765.5 | 41 King Fahd Rd | Riyadh | Riyadh | 11564 | Bulk purchase of printer toner cartridges. | blank | Verified purchase volume and market price. |
| EXP2024-0008 | Sales | 115 | false | USA | E1007 | Robert Evans | 2024-04-10 | 2024-04-10T14:32:44 | meals | USD | approved | A101 | Mark Thompson | 2024-04-11T09:21:12 | Expense within allowable limit. | false | blank | Olive Garden | 33-1254789 | MEALS-2024-008 | 2024-04-10 | 115 | 3541 Pine St | Dallas | TX | 75204 | Business lunch with key client. | blank | blank |
| EXP2024-0009 | Marketing | 23.75 | false | USA | E1008 | Sophie Martin | 2024-03-22 | 2024-03-23T08:49:19 | travel | USD | approved | A101 | Mark Thompson | 2024-03-24T10:30:55 | Transportation expense approved. | false | blank | Uber | blank | TRAVEL-2024-009 | 2024-03-22 | 23.75 | 2500 Elm St | Austin | TX | 78701 | Uber ride to client event. | blank | blank |
| EXP2024-0010 | HR | 15 | false | USA | E1009 | Julia Baker | 2024-04-11 | 2024-04-11T12:05:38 | other | USD | pending | blank | blank | blank | blank | false | blank | SecureID Badges | 85-3458721 | OTHER-2024-010 | 2024-04-11 | 15 | 1042 Elmwood Ave | Miami | FL | 33101 | Employee badge replacement fee. | blank | blank |
| EXP2024-0011 | Operations | 89.95 | false | Saudi Arabia | E1010 | Ahmed Hassan | 2024-03-07 | 2024-03-08T10:30:22 | office supplies | SAR | approved | A110 | Mohammed Al-Mutairi | 2024-03-09T09:17:30 | Office supplies approved. | false | blank | Jeddah Stationery | SA-9876543210 | OFFICE-2024-011 | 2024-03-07 | 89.95 | 22 Corniche Rd | Jeddah | Makkah | 21532 | Purchase of desktop organizers for office. | blank | blank |
| EXP2024-0012 | Finance | 41.8 | false | Brazil | E1011 | Maria Oliveira | 2024-02-16 | 2024-02-17T09:48:03 | meals | BRL | approved | A112 | Carlos Silva | 2024-02-17T13:55:14 | Expense within business meal limits. | false | blank | Café Paulista | BR-234567891 | MEALS-2024-012 | 2024-02-16 | 41.8 | 180 Av. Paulista | São Paulo | SP | 01310-000 | Breakfast meeting with client at local cafe. | blank | blank |
| EXP2024-0013 | Legal | 670 | false | Italy | E1012 | Olga Ivanova | 2024-03-29 | 2024-03-30T16:12:42 | entertainment | EUR | approved | A106 | Giulia Rossi | 2024-04-01T10:01:11 | Networking event approved. | true | 2024-04-03T14:23:09 | Eventi Milano | IT-8765432109 | ENT-2024-013 | 2024-03-29 | 670 | Corso Como 8 | Milan | Lombardy | 20154 | Tickets for legal networking event. | blank | Checked vendor legitimacy and receipt. |
| EXP2024-0014 | Sales | 45.9 | false | USA | E1013 | James Carter | 2024-05-08 | 2024-05-08T09:13:05 | travel | USD | approved | A101 | Mark Thompson | 2024-05-09T10:10:23 | Transportation approved. | false | blank | Yellow Cab | blank | TRAVEL-2024-014 | 2024-05-08 | 45.9 | 200 Main St | Houston | TX | 77002 | Taxi fare to corporate meeting. | blank | blank |
| EXP2024-0015 | Marketing | 370 | false | USA | E1014 | Helen Kim | 2024-02-28 | 2024-03-01T10:30:16 | entertainment | USD | pending | blank | blank | blank | blank | false | blank | Bowlero | 45-1125678 | ENT-2024-015 | 2024-02-28 | 370 | 1111 Lane St | Los Angeles | CA | 90015 | Marketing team building bowling event. | blank | blank |
| EXP2024-0016 | HR | 480 | false | UK | E1015 | David Brown | 2024-05-01 | 2024-05-02T09:13:55 | training | GBP | approved | A109 | Emily Clarke | 2024-05-03T12:09:33 | Training aligns with HR objectives. | false | blank | Engage UK Ltd. | GB-132456789 | TRAINING-2024-016 | 2024-05-01 | 480 | 22 Oxford St | London | England | W1D 1NN | Workshop on employee engagement strategies. | blank | blank |
| EXP2024-0017 | Operations | 289.99 | false | USA | E1016 | Carlos Mendez | 2024-03-26 | 2024-03-26T15:43:09 | office supplies | USD | approved | A104 | Susan Miller | 2024-03-27T11:28:17 | Necessary for warehouse maintenance. | false | blank | CleanCo USA | 77-3456789 | OFFICE-2024-017 | 2024-03-26 | 289.99 | 321 Sunset Blvd | Phoenix | AZ | 85001 | Cleaning supplies for warehouse. | blank | blank |
| EXP2024-0018 | Finance | 540 | false | USA | E1017 | Samantha Wright | 2024-01-24 | 2024-01-25T10:25:07 | meals | USD | approved | A102 | John Williams | 2024-01-26T14:19:59 | Approved for partner relations. | true | 2024-01-28T12:11:33 | Steakhouse Prime | 93-4567891 | MEALS-2024-018 | 2024-01-24 | 540 | 800 River Rd | Boston | MA | 02110 | Dinner with investment partners. | blank | Checked meal policy compliance. |
| EXP2024-0019 | Research | 199.99 | false | Japan | E1018 | Tomoko Suzuki | 2024-03-12 | 2024-03-13T09:08:12 | training | JPY | approved | A108 | Hiroshi Tanaka | 2024-03-14T16:23:37 | Seminar relevant to research goals. | false | blank | AI Seminar Japan | JP-123456789 | TRAINING-2024-019 | 2024-03-12 | 199.99 | 3 Chome-1-1 Shibuya | Tokyo | Tokyo | 150-0002 | Enrollment for AI research seminar. | blank | blank |
| EXP2024-0020 | Marketing | 33.15 | false | USA | E1008 | Sophie Martin | 2024-01-30 | 2024-01-30T14:22:41 | travel | USD | approved | A101 | Mark Thompson | 2024-01-31T11:45:00 | Public transport expense approved. | false | blank | Amtrak | blank | TRAVEL-2024-020 | 2024-01-30 | 33.15 | 400 S Houston St | Dallas | TX | 75202 | Train ticket to client presentation. | blank | blank |
What the 200 rows show
from the 200-row sampleMarketing department stands out: mean expense_
- 3%policy_
violation_ flag = true - 189.9median expense_
amount - 5approval statuses
- 6expense types
- 17currencies
- 44approvers
Median 189.9, from 0.01 to 4,187.
- string 21
- float 2
- date 2
- datetime 3
- boolean 2
Columns
30 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 21 columns | |||
expense_id | string | Unique identifier for each expense requestunique | EXP2024-0001 |
employee_id | string | Unique identifier for the employee submitting the expense | E1001 |
employee_name | string | Full name of the employee submitting the expense | Jennifer Lee |
department | string | Department to which the employee belongs8 departments | Marketing |
expense_type | string | Type/category of the expense (e.g., travel, meals, office supplies)6 values | travel |
expense_description | string | Detailed description of the expense | Taxi fare to sales expo. |
currency | string | Currency code for the expense amount (e.g., USD, EUR) | USD |
approval_status | string | Current status of the expense approval workflowpending · approved · rejected · returned · cancelled | approved |
approver_id | string | Unique identifier for the primary approveroptional | A101 |
approver_name | string | Full name of the primary approveroptional | Mark Thompson |
approval_comments | string | Comments or notes provided by the approver during the approval processoptional | Renewal approved. |
policy_violation_description | string | Description of the policy violation, if anyoptional | Expense amount below allo… |
audit_comments | string | Comments or findings from the audit reviewoptional | Reviewed for compliance, … |
vendor_name | string | Name of the vendor or payee for the expenseoptional | Delta Airlines |
vendor_tax_id | string | Tax identification number of the vendoroptional | 98-2345678 |
receipt_number | string | Reference number for the expense receiptoptional | TRAVEL-2024-001 |
address_street | string | Street address of the vendor or service provideroptional | 2338 5th Ave |
address_city | string | City of the vendor or service provideroptional | New York |
address_state | string | State or province of the vendor or service provideroptional | NY |
address_postal_code | string | Postal code of the vendor or service provideroptional | 10010 |
address_country | string | Country of the vendor or service provideroptional | USA |
| Numbers 2 columns | |||
expense_amount | float | Total amount of the expense0.01 or more | 1250.54 |
receipt_amount | float | Amount shown on the receipt0.01 or more · optional | 1250.54 |
| Dates and times 5 columns | |||
expense_date | date | Date the expense was incurred | 2024-03-14 |
submission_date | datetime | Date and time the expense was submitted for approval | 2024-03-15T09:33:12 |
approval_date | datetime | Date and time when the expense was approved or rejectedoptional | 2024-03-16T13:21:38 |
audit_review_date | datetime | Date and time when the expense was reviewed by the audit teamoptional | 2024-01-24T11:35:22 |
receipt_date | date | Date on the expense receiptoptional | 2024-03-14 |
| True or false 2 columns | |||
policy_violation_flag | boolean | Indicates whether the expense violates any company policy | false |
audit_flag | boolean | Indicates if the expense is flagged for audit review | false |
Use it for
A finance dashboard
The policy_
violation_ flag rate, expense_ amount by department and a breakdown of address_ country. Excel, Power BI or Tableau. Why do the 26 Marketing rows have a mean expense_
amount of 1,295? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Expenses200EXP2024-00011250.54MarketingEXP2024-00420.01HREXP2024-004519.75Sales
A software demo
Believable expenses with employee_
id, employee_ name and department to fill a screen in front of a buyer.
blueprint · finance-expense-approval-workflow
Behind this dataset
Same schema. As many rows as you need.
These 200 rows came out of a blueprint — 30 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.
- Track approval levels per expense
- Include approval timestamps
- Segment by expense type
- Flag escalated cases
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
- finance-expense-approval-workflow