{
"Expenses": [
{
"ID": "b65455e0-89d5-4910-82bf-cadfbf5c4126",
"ExpenseReportID": "fdf33884-af87-2891-a7d4-3e574ea6be88",
"FirstName": "Jack",
"LastName": "Certi",
"Email": "jcerti@certify.com",
"EmployeeID": "jcerti001",
"DepartmentName": "General",
"DepartmentCode": "01",
"ExpenseType": "Lodging",
"ExpenseCategory": "Lodging",
"ExpenseCategoryGLCode": "03",
"Amount": 192.93,
"Billable": false,
"Reimbursable": true,
"ReimAmount": 191.96,
"SubmittedAmount": 0,
"ConvertedAmount": 0,
"ConvertedReimAmount": 0,
"ExchangeRate": 1,
"ExpenseDate": "2016-05-03",
"PostingDate": "",
"LodgingCheckInDate": "2016-05-01",
"LodgingCheckOutDate": "2016-05-03",
"RentalPickUpDate": "",
"RentalDropOffDate": "",
"Vendor": "Mountain View Hotel",
"Location": "Mountain View, CA",
"TravelFrom": "",
"TravelTo": "",
"MileageFrom": "",
"MileageTo": "",
"MileageUnits": "0.0",
"ExpenseReportName": "Business Trip May 2016",
"ExpenseReportApprovalCode": 52,
"Status": "Completed",
"LastAction": "Approved",
"ProcessedDate": "2016-05-30",
"Processed": true,
"Currency": "USD",
"SubmittedCurrency": "",
"ConvertedCurrency": "",
"Reason": "Hotel Stay",
"VATAmount": 0,
"HSTAmount": 0,
"PSTAmount": 0,
"ExpenseTextGLD1Label": "Text GLD Expense",
"ExpenseTextGLD1": "business",
"ExpenseTextGLD2Label": "Numbers Only GLD",
"ExpenseTextGLD2": "123",
"ExpenseReportGLD1Label": "Food",
"ExpenseReportGLD1Name": "Apples and Oranges",
"ExpenseReportGLD1Code": "A123",
"ReceiptImageLink": "{unique receipt image url}",
"ReceiptID": "",
"PaymentCardName": "Company Visa",
"CCLast": "0005",
"CCTransactionID": "000008806037561_20160503_192.93",
"ExpenseCategoryID": "a326e9a2-a2ab-4eda-b924-234d8fe146c2",
"TrueProcessedDate": "2016-06-01",
"Inquiries": [
{
"RequestorID": "c3b8ab6f-7378-4991-96c5-876d7a8d208c"
"RequestorFirstName": "Steve"
"RequestorLastName": "Manager"
"RequestorEmail": "SteveManager@Company.com"
"RequestDate": "2023-05-08"
"Inquiry": "Please update to the correct expense category"
"Response": "Done!"
"ResponseDate": "2023-05-09"
}
],
"Notes": [
{
"SubmitterID": "02102f72-0ac2-4472-b98a-77800f780f99"
"SubmitterFirstName": "Steve"
"SubmitterLastName": "Manager"
"SubmitterEmail": "SteveManager@Company.com"
"Date": "2023-06-07"
"Note": "Corrected expense category"
"Flagged": "False"
}
],
"MealAttendees": "",
"DetailedMealAttendees": []
},
{
"ID": "e373a213-1dd3-4e3d-83b7-786bd9a5e201",
"ExpenseReportID": "9b7146b0-3e92-4745-babf-8bda8973238a",
"FirstName": "Robbie",
"LastName": "The Robot",
"Email": "rrobot@certify.com",
"EmployeeID": "rrobot002",
"DepartmentName": "Marketing",
"DepartmentCode": "02",
"ExpenseType": "Meals",
"ExpenseCategory": "New Hire Lunch",
"ExpenseCategoryGLCode": "01",
"Amount": 150,
"Billable": false,
"Reimbursable": false,
"ReimAmount": 0,
"SubmittedAmount": 0,
"ConvertedAmount": 0,
"ConvertedReimAmount": 0,
"ExchangeRate": 1,
"ExpenseDate": "2016-06-22",
"PostingDate": "",
"LodgingCheckInDate": "",
"LodgingCheckOutDate": "",
"RentalPickUpDate": "",
"RentalDropOffDate": "",
"Vendor": "Bingas",
"Location": "Mountain View, CA",
"TravelFrom": "",
"TravelTo": "",
"MileageFrom": "",
"MileageTo": "",
"MileageUnits": 0,
"ProcessedDate": "2016-06-22",
"Processed": true,
"Currency": "USD",
"SubmittedCurrency": "",
"ConvertedCurrency": "",
"Reason": "Airfare",
"VATAmount": 0,
"HSTAmount": 0,
"PSTAmount": 0,
"ExpenseTextGLD1Label": "Text GLD Expense",
"ExpenseTextGLD1": "Marketing Convention",
"ExpenseTextGLD2Label": "Numbers Only GLD",
"ExpenseReportGLD1Label": "Food",
"ExpenseReportGLD1Name": "Surf and Turf",
"ExpenseReportGLD1Code": "st001",
"ReceiptImageLink": "{unique receipt image url}",
"ReceiptID": "",
"PaymentCardName": "Company Mastercard",
"CCLast": "0005",
"CCTransactionID": "000008806037561_20160622_150.00",
"ExpenseCategoryID": "a336e9a2-a2ab-4eda-b924-234d8fe146c2",
"TrueProcessedDate": "2016-06-22",
"Inquiries": [],
"Notes": [],
"MealAttendees": "",
"DetailedMealAttendees": [
{
"FirstName": "Robbie"
"LastName": "The Robot"
"Title": ""
"Company": ""
"Relation": "Self"
}
{
"FirstName": "Steve"
"LastName": "Manager"
"Title": "Manager"
"Company": "TheCompany"
"Relation": "Employee"
}
{
"FirstName": "John"
"LastName": "NewHire"
"Title": "Employee"
"Company": "TheCompany"
"Relation": "Employee"
}
]
}
]
}
<Expenses>
<Expense>
<ID>b65455e0-89d5-4910-82bf-cadfbf5c4126</ID>
<ExpenseReportID>fdf33884-af87-2891-a7d4-3e574ea6be88</ExpenseReportID>
<FirstName>Jack</FirstName>
<LastName>Certi</LastName>
<Email>jcerti@certify.com</Email>
<EmployeeID>jcerti001</EmployeeID>
<DepartmentName>General</DepartmentName>
<DepartmentCode>01</DepartmentCode>
<ExpenseType>Lodging</ExpenseType>
<ExpenseCategory>Lodging</ExpenseCategory>
<ExpenseCategoryGLCode>03</ExpenseCategoryGLCode>
<Amount>192.93</Amount>
<Billable>false</Billable>
<Reimbursable>true</Reimbursable>
<ReimAmount>191.96</ReimAmount>
<SubmittedAmount>0</SubmittedAmount>
<ConvertedAmount>0</ConvertedAmount>
<ConvertedReimAmount>0</ConvertedReimAmount>
<ExchangeRate>1</ExchangeRate>
<ExpenseDate>2016-05-03</ExpenseDate>
<PostingDate />
<LodgingCheckInDate>2016-05-01</LodgingCheckInDate>
<LodgingCheckOutDate>2016-05-03</LodgingCheckOutDate>
<RentalPickUpDate />
<RentalDropOffDate />
<Vendor>Mountain View Hotel</Vendor>
<Location>Mountain View, CA</Location>
<TravelFrom />
<TravelTo />
<MileageFrom />
<MileageTo />
<MileageUnits>0.0</MileageUnits>
<ExpenseReportName>Business Trip May 2016</ExpenseReportName>
<ExpenseReportApprovalCode>52</ExpenseReportApprovalCode>
<Status>Completed</Status>
<LastAction>Approved</LastAction>
<ProcessedDate>2016-05-30</ProcessedDate>
<Processed>true</Processed>
<Currency>USD</Currency>
<SubmittedCurrency />
<ConvertedCurrency />
<Reason>Hotel Stay</Reason>
<VATAmount>0</VATAmount>
<HSTAmount>0</HSTAmount>
<PSTAmount>0</PSTAmount>
<ExpenseTextGLD1Label>Text GLD Expense</ExpenseTextGLD1Label>
<ExpenseTextGLD1>business</ExpenseTextGLD1>
<ExpenseTextGLD2Label>Numbers Only GLD</ExpenseTextGLD2Label>
<ExpenseTextGLD2>123</ExpenseTextGLD2>
<ExpenseReportGLD1Label>Food</ExpenseReportGLD1Label>
<ExpenseReportGLD1Name>Apples and Oranges</ExpenseReportGLD1Name>
<ExpenseReportGLD1Code>A123</ExpenseReportGLD1Code>
<ReceiptImageLink>{unique receipt image url}</ReceiptImageLink>
<ReceiptID />
<PaymentCardName>Company Visa</PaymentCardName>
<CCLast>0005</CCLast>
<CCTransactionID>000008806037561_20160503_192.93</CCTransactionID>
<ExpenseCategoryID>a326e9a2-a2ab-4eda-b924-234d8fe146c2</ExpenseCategoryID>
<TrueProcessedDate>2016-06-01</TrueProcessedDate>
<Inquiries>
<Inquiry>
<RequestorID>48ac616e-410c-4abb-8fab-308a4db111f3</RequestorID>
<RequestorFirstName>Steve</RequestorFirstName>
<RequestorLastName>Manager</RequestorLastName>
<RequestorEmail>SteveManager@Company.com</RequestorEmail>
<RequestDate>2023-05-08</RequestDate>
<Inquiry>Please update to the correct expense category</Inquiry>
<Response>Done!</Response>
<ResponseDate>2023-05-09</ResponseDate>
</Inquiry>
</Inquiries>
<Notes>
<Note>
<SubmitterID>428871b6-b0d7-4f32-ac68-5ff86601eadb</SubmitterID>
<SubmitterFirstName>Steve</SubmitterFirstName>
<SubmitterLastName>Manager</SubmitterLastName>
<SubmitterEmail>SteveManager@Company.com</SubmitterEmail>
<Date>2023-06-07</Date>
<Note>Corrected expense category</Note>
<Flagged>False</Flagged>
</Note>
</Notes>
<MealAttendees />
<DetailedMealAttendees />
</Expense>
<Expense>
<ID>e373a213-1dd3-4e3d-83b7-786bd9a5e201</ID>
<ExpenseReportID>9b7146b0-3e92-4745-babf-8bda8973238a</ExpenseReportID>
<FirstName>Robbie</FirstName>
<LastName>The Robot</LastName>
<Email>rrobot@certify.com</Email>
<EmployeeID>rrobot002</EmployeeID>
<DepartmentName>Marketing</DepartmentName>
<DepartmentCode>02</DepartmentCode>
<ExpenseType>Meals</ExpenseType>
<ExpenseCategory>New Hire Lunch</ExpenseCategory>
<ExpenseCategoryGLCode>01</ExpenseCategoryGLCode>
<Amount>150</Amount>
<Billable>false</Billable>
<Reimbursable>false</Reimbursable>
<ReimAmount>0</ReimAmount>
<SubmittedAmount>0</SubmittedAmount>
<ConvertedAmount>0</ConvertedAmount>
<ConvertedReimAmount>0</ConvertedReimAmount>
<ExchangeRate>1</ExchangeRate>
<ExpenseDate>2016-06-22</ExpenseDate>
<PostingDate />
<LodgingCheckInDate />
<LodgingCheckOutDate />
<RentalPickUpDate />
<RentalDropOffDate />
<Vendor>Bingas</Vendor>
<Location>Mountain View, CA</Location>
<TravelFrom />
<TravelTo />
<MileageFrom />
<MileageTo />
<MileageUnits>0</MileageUnits>
<ProcessedDate>2016-06-22</ProcessedDate>
<Processed>true</Processed>
<Currency>USD</Currency>
<SubmittedCurrency />
<ConvertedCurrency />
<Reason>Airfare</Reason>
<VATAmount>0</VATAmount>
<HSTAmount>0</HSTAmount>
<PSTAmount>0</PSTAmount>
<ExpenseTextGLD1Label>Text GLD Expense</ExpenseTextGLD1Label>
<ExpenseTextGLD1>Marketing Convention</ExpenseTextGLD1>
<ExpenseTextGLD2Label>Numbers Only GLD</ExpenseTextGLD2Label>
<ExpenseReportGLD1Label>Food</ExpenseReportGLD1Label>
<ExpenseReportGLD1Name>Surf and Turf</ExpenseReportGLD1Name>
<ExpenseReportGLD1Code>st001</ExpenseReportGLD1Code>
<ReceiptImageLink>{unique receipt image url}</ReceiptImageLink>
<ReceiptID />
<PaymentCardName>Company Mastercard</PaymentCardName>
<CCLast>0005</CCLast>
<CCTransactionID>000008806037561_20160622_150.00</CCTransactionID>
<ExpenseCategoryID>a336e9a2-a2ab-4eda-b924-234d8fe146c2</ExpenseCategoryID>
<TrueProcessedDate>2016-06-22</TrueProcessedDate>
<Inquiries />
<Notes />
<MealAttendees />
<DetailedMealAttendees>
<MealAttendee>
<FirstName>Robbie</FirstName>
<LastName>The Robot</LastName>
<Title />
<Company />
<Relation>Self</Relation>
</MealAttendee>
<MealAttendee>
<FirstName>Steve</FirstName>
<LastName>Manager</LastName>
<Title>Manager</Title>
<Company>TheCompany</Company>
<Relation>Employee</Relation>
</MealAttendee>
<MealAttendee>
<FirstName>John</FirstName>
<LastName>NewHire</LastName>
<Title>Employee</Title>
<Company>TheCompany</Company>
<Relation>Employee</Relation>
</MealAttendee>
</DetailedMealAttendees>
</Expense>
</Expenses>