Expense Report: Jordan Lee, Chicago Client Workshop (Acme Corp), Project A-112, Mar 4–7, 2025

Summary

9 receipts covering 2025-02-26 to 2025-03-07 (plus 1 undated), with a grand total of 1,447.41 USD. All receipts are in USD, your home currency, so no conversion was needed.

Note: Rows 4 and 5 look like the same Uber ride. If Row 5 is removed, the grand total is 1,405.26 USD.

Needs Your Attention

• Row 1, United Airlines: issued 2025-02-26, which is before the trip dates (Mar 4–7). Booking flights in advance is common. Confirm that your report allows pre-trip purchases, or adjust the report range.
• Row 4, Uber: $42.15 with no itemized receipt or payment method. This breaks the rule "Itemized receipt required for anything over $25." Attach the Uber trip receipt from the app or email.
• Row 5, Uber: possible duplicate of Row 4 (same vendor, amount, date, and route). Delete it if it's the same ride. If there really were two rides, attach both receipts.
• Row 6, Gibsons Bar & Steakhouse: 2 glasses of Cabernet ($36.00). This breaks the rule "Alcohol not reimbursable." Remove the alcohol, and its share of tax and tip, from the claimed amount.
• Row 6, Gibsons Bar & Steakhouse: the tip is $30.00, which is 21.7% of the $138.00 subtotal. This breaks the rule "Tips max 20% of subtotal." The maximum allowed tip is $27.60, so $2.40 is over the cap.
• Row 6, Gibsons Bar & Steakhouse: total Meals for 2025-03-05 are $182.14. This breaks the rule "Meals max $75 per day per person." The receipt shows two entrées, so this may have been 2 diners. If so, list the attendees. If it was a client meal, consider recategorizing it as Client Entertainment if your company allows that.
• Row 7, Staples: $64.87 total with items listed but no item prices. This breaks the rule "Itemized receipt required for anything over $25." Attach the full itemized receipt. The payment method is also missing.
• Row 8, Taxi: $51.00 cash with no taxi company name and no itemized receipt. This breaks the rule "Itemized receipt required for anything over $25." Attach the taxi receipt, or follow your company's process for missing receipts.
• Row 9, Walgreens: no date on the receipt. Add the date before submitting. The payment method is also missing.

Expense Report CSV

Row,Date,Vendor,Description,Category,Subtotal,Tax,Tip,Total,Currency,Payment Method,Flag,Notes
1,2025-02-26,United Airlines,ORD round trip economy airfare,Airfare,312.40,48.60,,361.00,USD,Mastercard 8812,DATE,"Confirmation KX7P2Q; Tax column = taxes & fees; issued before trip dates"
2,2025-03-04,Hilton Garden Inn Chicago Downtown,"Hotel, 3 nights (Mar 4-7)",Lodging,567.00,98.37,,665.37,USD,Visa 4421,,"3 nights @ 189.00; dated by arrival, departure 2025-03-07"
3,2025-03-04,Blue Bottle Coffee,2 lattes,Meals,11.50,0.98,2.00,14.48,USD,Visa 4421,,Year inferred as 2025; tip 17.4%
4,2025-03-04,Uber,Ride ORD to hotel,Ground Transport,,,,42.15,USD,,POLICY,No itemized receipt for amount over $25; payment method not shown
5,2025-03-04,Uber,Ride ORD to hotel,Ground Transport,,,,42.15,USD,,DUPLICATE?,Matches Row 4 exactly; likely pasted twice
6,2025-03-05,Gibsons Bar & Steakhouse,"Dinner: ribeye, salmon, 2 glasses wine",Meals,138.00,14.14,30.00,182.14,USD,Visa 4421,POLICY,"Alcohol 36.00 not reimbursable; tip 21.7% exceeds 20% cap (max 27.60); over $75/day meal limit; 2 entrees, so attendees may be needed"
7,2025-03-06,Staples,"Poster board, markers, presentation clicker",Office Supplies,,,,64.87,USD,,POLICY,Total includes tax; no item prices (itemized receipt required over $25); payment method not shown
8,2025-03-07,Taxi,Taxi hotel to ORD,Ground Transport,,,,51.00,USD,Cash,POLICY,Year inferred as 2025; no taxi company name; no itemized receipt for amount over $25
9,,Walgreens,Phone charger,Phone & Internet,21.99,2.26,,24.25,USD,,MISSING,No date on receipt; payment method not shown

Assumptions

• Date format: read as US month/day (e.g., 03/04 = March 4), which matches the Mar 4–7 trip.
• Missing years: the year 2025 was inferred for Blue Bottle (03/04) and the taxi (03/07) from the trip dates.
• Hotel date: the hotel is dated by its arrival date (2025-03-04). The full stay was Mar 4–7.
• United "Taxes & fees": placed in the Tax column, with the fare as the Subtotal.
• Walgreens category: the phone charger was categorized as Phone & Internet. Office Supplies or Other could also fit.
• Gibsons category: kept as Meals because the receipt doesn't say whether this was a client meal.
• Staples: "incl tax" means the $64.87 is the total only. Subtotal and tax were left blank rather than split.
• Taxi vendor: recorded as "Taxi" because no company name was given.
• No OCR corrections were needed. All itemized receipts add up correctly, with no math mismatches.
• Payment methods: recorded only as shown. They were left blank where the receipt didn't list one.

Double-check flagged rows against your original receipts before submitting.

Made by a Donkley AI worker. AI can make mistakes; please review before you rely on it.