How to Recover Fuel and Per Diem Overspend After Quarterly Review
Construction finance teams discover travel costs spiraling out of control during quarterly close. Here's how to track field expenses, flag overspend, and recover costs before the next billing cycle.
Andrew Grosser
June 10, 2026 • 11 min read
How to Recover Fuel and Per Diem Overspend After Quarterly Review
Construction finance teams discover travel costs spiraling out of control during quarterly close. Here's how to track field expenses, flag overspend, and recover costs before the next billing cycle.
Your quarterly review spreadsheet just revealed a $47,000 fuel overspend across three active road construction jobs. The per diem line item shows $18,200 more than budgeted. Your superintendent swears the crews stayed within guidelines. The receipts arrived in mixed formats—photos texted from gas stations, handwritten hotel invoices, scanned PDFs with coffee-stained corners. Now you have 14 days to reconcile expenses, identify recoverable costs, and prevent the same bleed next quarter.
This scenario hits construction finance teams every 90 days. Field crews submit expenses weeks after they occur. Office managers piece together paper trails across multiple job sites. By the time quarterly close arrives, the damage is done—and the window to recover costs from clients or adjust crew behavior is closing fast.
Sourcetable's AI data analyst is free to try. Sign up here.
Why Fuel and Per Diem Overspend Surfaces During Quarterly Reviews
Construction companies typically discover travel cost overruns 45 to 90 days after expenses occur. The delay stems from how field expenses flow into accounting systems. Crew members submit receipts weekly or biweekly. Office managers enter data manually into spreadsheets or accounting software. Month-end close focuses on payroll and major vendor invoices. Small-ticket items like fuel receipts and hotel stays accumulate in a backlog.
Quarterly reviews force a comprehensive expense audit. Finance teams compare actual spending against job budgets, original estimates, and client contracts. This is when patterns emerge: a pipeline crew consistently exceeding per diem limits, fuel costs on a highway project running 35% over budget, hotel stays billed at rates higher than the approved tier.
| Expense Category | Typical Discovery Lag | Common Overspend Range |
|---|---|---|
| Fuel receipts | 30-60 days | 15-40% over budget |
| Per diem / meals | 45-75 days | 20-50% over approved rates |
| Hotel lodging | 30-90 days | 25-60% above contracted rates |
| Equipment rental | 15-45 days | 10-30% over estimate |
The problem compounds when expenses span multiple cost codes, job sites, or billing cycles. A foreman might charge fuel to Job 2401 one week and Job 2403 the next, even though both jobs share the same client and should roll up to a single contract budget. Per diem gets split between travel days and work days. Hotel invoices arrive with incidental charges (parking, meals, Wi-Fi) that weren't part of the original lodging estimate.
The Manual Method: Reconciling Field Expenses in Excel
Most construction office managers reconcile quarterly expenses using a multi-step Excel process. Here's the standard workflow that takes 12 to 20 hours per quarter for a company running 5 to 10 active jobs:
Step 1: Gather all expense documentation
- Collect fuel receipts from crew members (text messages, email attachments, paper receipts)
- Download hotel invoices from corporate travel accounts
- Export per diem submissions from timekeeping systems or paper logs
- Pull equipment rental invoices from vendor portals
- Retrieve subcontractor expense reimbursements from email threads
Step 2: Standardize data format
- Manually enter receipt data into Excel: date, vendor, amount, job number, expense type
- Convert images to text (or type totals from photos)
- Standardize date formats (receipts use MM/DD/YYYY, accounting uses YYYY-MM-DD)
- Normalize vendor names (Shell vs Shell Oil vs Shell Station #4401)
- Assign cost codes to each line item
Step 3: Build pivot tables and summaries
- Create pivot table: Job Number × Expense Type × Month
- Calculate totals by job, by crew, by expense category
- Compare actual spending to original budget estimates
- Flag line items exceeding budget thresholds (typically 10-15% over)
Step 4: Identify recoverable costs
- Review client contracts for reimbursable expense clauses
- Match expense dates to billable project phases
- Separate personal charges from business expenses (crew member bought lunch for family on travel day)
- Calculate markup on reimbursable expenses (typically 10-20% admin fee)
Step 5: Generate recovery invoices
- Group recoverable expenses by client and billing period
- Attach supporting documentation (scanned receipts, mileage logs)
- Submit supplemental invoices to clients within contract terms (usually 30-60 days from expense date)
- Track approval and payment in accounts receivable aging report
This process assumes clean data. In reality, 30% to 50% of field receipts have issues: missing dates, illegible totals, unclear job assignments, duplicate submissions, or personal expenses mixed with business charges. Each problem requires detective work—calling crew members, cross-referencing timesheets, checking GPS logs from fleet tracking systems.
The Excel reconciliation also fails to catch systemic problems until months of overspend accumulate. You discover in April that a crew has been fueling personal vehicles on the company card since January. You find in July that hotel bookings consistently exceed the $120/night contract limit because the booking system defaults to a higher tier. By the time you identify the pattern, you've absorbed $15,000 to $30,000 in non-recoverable costs.
Calculating Recoverable Fuel Costs: The Formula Approach
Fuel overspend recovery requires separating legitimate job-related fuel from personal use, inefficient routing, and unauthorized vehicle charges. The standard calculation compares actual fuel consumption against an estimated baseline derived from project mileage, equipment hours, and fleet fuel efficiency.
Baseline Fuel Budget Formula:
Expected Fuel Cost = (Total Job Miles ÷ Vehicle MPG × Fuel Price) + (Equipment Hours × Gallons per Hour × Fuel Price)
For a road construction project with 2,400 estimated miles of crew travel, using trucks averaging 14 MPG, at $3.85/gallon diesel, plus 320 hours of excavator operation consuming 6 gallons/hour:
Vehicle Fuel = (2,400 miles ÷ 14 MPG) × $3.85 = 171.4 gallons × $3.85 = $659.89
Equipment Fuel = 320 hours × 6 gal/hr × $3.85 = 1,920 gallons × $3.85 = $7,392.00
Total Baseline Budget = $659.89 + $7,392.00 = $8,051.89
If actual fuel expenses total $11,240, the overspend is $3,188.11 (39.6% over budget). Now you investigate causes: Were additional miles driven due to change orders? Did equipment run longer than estimated? Are receipts from unauthorized vehicles appearing in the job file?
| Fuel Expense Type | Recoverable from Client | Example |
|---|---|---|
| Fuel for equipment on billable hours | Yes (100%) | Excavator ran 340 hours vs 320 budgeted due to site conditions |
| Crew vehicle mileage for change orders | Yes (with documentation) | Additional 480 miles to revised work zone |
| Fuel during mobilization/demobilization | Depends on contract | Moving equipment to/from job site |
| Inefficient routing (crew error) | No | Foreman drove 80 extra miles due to wrong turn |
| Personal vehicle fuel on company card | No (recover from employee) | Crew member fueled personal truck on Saturday |
| Fuel price increases mid-project | Depends on contract escalation clause | Diesel rose from $3.85 to $4.20/gallon |
Construction contracts typically allow fuel cost recovery for scope changes, unforeseen conditions, and client-directed work extensions. You need contemporaneous documentation: change order approvals, daily logs showing extended equipment hours, GPS mileage reports proving additional travel. Without this paper trail, clients reject supplemental fuel invoices even when the overspend is legitimate.
Per Diem Recovery: Separating Allowable from Excessive Charges
Per diem rates for construction crews follow IRS guidelines, union agreements, or company policy—whichever is most restrictive. The 2026 standard per diem for meals and incidentals ranges from $59 to $79 per day depending on location, with lodging reimbursed separately at actual cost or a capped rate.
Overspend occurs when crew members exceed daily limits, claim per diem for non-travel days, or submit duplicate meal reimbursements. A pipeline crew working 60 miles from the shop might claim full per diem when company policy only allows it for jobs over 100 miles. A foreman might expense a $95 steak dinner when the daily meal allowance is $68.
Per Diem Overspend Calculation Example:
A highway paving crew of 6 workers on a 45-day project. Contract allows $68/day meals + $120/night lodging for jobs over 75 miles from headquarters. Actual job site is 82 miles away.
Budgeted Per Diem = 6 crew × 45 days × $68 = $18,360
Budgeted Lodging = 6 crew × 45 nights × $120 = $32,400
Total Travel Budget = $18,360 + $32,400 = $50,760
Quarterly review reveals actual expenses: $24,850 in meal reimbursements and $38,200 in hotel charges. Total actual: $63,050. Overspend: $12,290 (24.2%).
Investigation reveals:
- $3,200 in meal expenses on weekends when crew was not working (non-recoverable, policy violation)
- $4,800 in hotel charges above $120/night—crew booked $145-$165/night rooms (non-recoverable unless approved)
- $2,100 in duplicate meal submissions—crew claimed per diem AND submitted restaurant receipts (non-recoverable, requires payroll deduction)
- $2,190 in legitimate overspend due to project extension (10 extra days approved by client in change order—recoverable)
You can recover $2,190 from the client by submitting a supplemental invoice tied to the approved change order. The remaining $10,100 requires internal action: payroll deductions for policy violations, revised booking procedures to enforce hotel rate caps, and updated expense submission rules to prevent duplicate claims.
How Sourcetable Automates Post-Quarterly Expense Recovery
Sourcetable's AI eliminates the 12-20 hour manual reconciliation process by connecting directly to your expense data sources, standardizing formats automatically, and flagging overspend in real time. You upload fuel receipts, hotel invoices, per diem logs, and equipment rental statements—or connect Sourcetable to your accounting system, fleet management software, and corporate travel portal.
The AI understands construction expense categories without training. It recognizes fuel receipts from photos, extracts totals from scanned PDFs, assigns expenses to job numbers based on date and crew, and separates recoverable costs from policy violations. What took 12 hours in Excel happens in 8 minutes.
Sourcetable workflow for quarterly expense recovery:
- Connect your data: Upload expense files (CSV, PDF, images) or link accounting software, fleet tracking, and travel booking systems
- Ask the AI: "Show me fuel and per diem expenses by job for Q1 2026, flag anything over budget"
- AI analyzes: Sourcetable pulls all expense records, groups by job number and expense type, compares to budgets, highlights overspend
- Drill into anomalies: "Why is Job 2403 fuel 38% over budget?" AI shows: 340 equipment hours vs 280 budgeted, plus 6 weekend fuel charges
- Identify recoverable costs: "Which fuel overspend is recoverable from the client?" AI cross-references change orders, finds $4,200 tied to approved scope increase
- Generate recovery invoice: "Create a supplemental invoice for recoverable Job 2403 expenses" AI produces itemized invoice with supporting documentation
The AI also builds automated alerts for future quarters. Set a rule: "Notify me when any job's fuel spending exceeds 15% of budget." Sourcetable monitors expenses daily and flags problems within 48 hours of receipt submission—not 90 days later during quarterly close.
For per diem analysis, Sourcetable compares crew submissions against contract terms, IRS rates, and company policy simultaneously. It detects duplicate claims by matching dates, amounts, and crew members across multiple data sources. It flags hotel bookings above approved rates and calculates the excess automatically. It separates travel days from work days using project calendars and timesheets.
Building a Real-Time Expense Tracking System
The quarterly overspend problem disappears when you track field expenses weekly instead of waiting 90 days. Real-time tracking requires three components: immediate data capture, automated categorization, and weekly variance reports.
| Day of Week | Action | Time Required (Manual) | Time Required (Sourcetable) |
|---|---|---|---|
| Monday | Collect previous week's receipts from crews | 30 minutes | 0 minutes (crews text photos directly to system) |
| Tuesday | Enter receipt data into expense spreadsheet | 2 hours | 0 minutes (AI extracts data automatically) |
| Wednesday | Categorize expenses by job and cost code | 1 hour | 0 minutes (AI assigns based on date and crew) |
| Thursday | Compare week's expenses to budget | 45 minutes | 5 minutes (ask AI for variance report) |
| Friday | Flag overspend and investigate anomalies | 1.5 hours | 10 minutes (AI highlights issues with context) |
Manual weekly tracking takes 5 hours and 45 minutes per week (23 hours per month, 69 hours per quarter). Most construction companies can't sustain this workload, so they batch expenses monthly or quarterly. Sourcetable reduces weekly tracking to 15 minutes: 5 minutes to review the AI-generated variance report, 10 minutes to investigate flagged items and take corrective action.
Real-time visibility prevents overspend from accumulating. When you discover on Thursday that a crew exceeded fuel budget by $840 last week, you can intervene immediately: investigate the cause, adjust crew behavior, or document legitimate scope changes while details are fresh. When you wait 90 days, the crew doesn't remember why they drove an extra 200 miles, the foreman has moved to a different project, and you have no recourse except to absorb the loss.
Preventing Future Overspend: Policy and Process Changes
Recovering costs after quarterly review addresses the symptom. Preventing overspend requires process changes that catch problems before they compound. Construction companies that reduce travel expense variance by 60% to 80% implement these six controls:
1. Pre-approved fuel and lodging budgets by job
Calculate expected fuel and per diem costs during project estimating. Load budgets into expense tracking system. Require crew approval for any expense exceeding 10% of weekly budget. Sourcetable can generate these budgets automatically from project plans and historical data.
2. Corporate fuel cards with job-level restrictions
Issue fuel cards that only work at approved vendor stations. Link cards to specific job numbers in the fleet management system. Block weekend and after-hours purchases unless crew is on documented travel. Sourcetable integrates with fleet card providers to import transactions and flag policy violations within 24 hours.
3. Hotel booking through managed travel portal
Require all lodging reservations through a corporate travel system with rate caps by market. Block direct bookings that exceed approved tiers. Sourcetable connects to travel portals and compares actual bookings to contract rates, flagging exceptions before checkout.
4. Daily per diem submission with photo verification
Require crews to submit meal receipts daily via text message or mobile app. AI extracts totals and dates, assigns to correct job, flags duplicate submissions. Crew members get immediate feedback if a submission violates policy ("Your $92 dinner exceeds the $68 daily limit. Resubmit with personal portion removed.").
5. GPS mileage validation
Compare fuel receipt locations and volumes to GPS tracking data from fleet vehicles. Flag discrepancies: fuel purchased 40 miles from job site, fuel volume exceeding tank capacity, multiple fill-ups within 2 hours. Sourcetable can cross-reference fleet GPS logs with fuel card transactions automatically.
6. Weekly expense variance meetings
Review AI-generated variance reports every Friday. Investigate any job exceeding weekly fuel or per diem budget. Document legitimate reasons (scope changes, weather delays, equipment breakdowns) and flag policy violations for immediate correction. This 15-minute weekly meeting prevents $10,000+ quarterly surprises.
These controls shift expense management from reactive (discovering problems 90 days later) to proactive (catching issues within 48 hours). The ROI is substantial: a construction company running $8M in annual revenue with $600K in travel expenses can reduce overspend from 25% ($150K loss) to 5% ($30K loss), recovering $120K per year.
Case Study: Pipeline Contractor Recovers $68K in Q1 2026
A pipeline subcontractor with 40 field employees working across 8 active jobs discovered $127,000 in fuel and per diem overspend during Q1 2026 quarterly close. The office manager spent 18 hours reconciling 1,247 expense receipts in Excel. She identified $68,400 in recoverable costs but had only 12 days remaining to submit supplemental invoices under contract terms.
The problem breakdown:
- $82,300 fuel overspend: Equipment ran 340 hours over estimate due to rocky soil conditions (recoverable); crews fueled personal vehicles on weekends (non-recoverable); diesel prices rose 18% mid-quarter (partially recoverable under escalation clause)
- $44,700 per diem overspend: Project extended 22 days due to weather delays (recoverable); crews claimed meals on non-travel days (non-recoverable); hotel bookings exceeded $135/night cap (non-recoverable)
The office manager used Sourcetable to complete the analysis in 90 minutes instead of 18 hours. She uploaded all Q1 expense files (fuel receipts, hotel invoices, per diem logs, equipment hour reports, change orders, and weather logs). She asked the AI: "Show me all fuel and per diem expenses by job for Q1, compare to budgets, identify recoverable costs based on change orders and contract terms."
| Expense Category | Total Overspend | Recoverable from Clients | Policy Violations (Employee Payback) | Non-Recoverable (Company Absorbs) |
|---|---|---|---|---|
| Fuel - Equipment | $58,200 | $52,400 | $0 | $5,800 |
| Fuel - Vehicles | $24,100 | $8,600 | $6,200 | $9,300 |
| Per Diem - Meals | $26,800 | $5,100 | $12,400 | $9,300 |
| Lodging | $17,900 | $2,300 | $0 | $15,600 |
| Total | $127,000 | $68,400 | $18,600 | $40,000 |
The AI generated itemized supplemental invoices for each client, attached supporting documentation (change orders, equipment hour logs, weather reports), and calculated markup (15% admin fee on reimbursable expenses). The office manager submitted invoices within the 12-day deadline. Clients approved $64,200 (93.9% of claimed amount) within 45 days.
For the $18,600 in policy violations, Sourcetable identified the specific crew members, dates, and amounts. The company implemented payroll deductions spread over 8 pay periods. For the $40,000 non-recoverable loss, the analysis revealed systemic issues: inadequate hotel booking controls and lack of fuel price escalation clauses in two contracts. Management implemented pre-approved hotel portals and revised contract templates for future projects.
The company now runs weekly expense variance reports in Sourcetable. Q2 2026 fuel and per diem overspend dropped to $18,200 (85.7% reduction), with 92% of legitimate overspend recovered within 30 days instead of 90.
Common Pitfalls in Expense Recovery After Quarterly Review
Construction companies attempting post-quarterly expense recovery make five recurring mistakes that reduce recovery rates from 70-80% to 30-40%:
1. Missing contract deadlines for supplemental invoicing
Most construction contracts allow reimbursable expense claims within 30 to 60 days of the expense date—not 90 days after quarterly close. If you discover recoverable fuel costs in April that occurred in January, you're already 90+ days past the expense date. Clients reject late claims even when legitimate. Solution: Track expenses weekly, flag recoverable costs within 7 days, submit supplemental invoices monthly.
2. Insufficient documentation for scope changes
Clients approve expense recovery when you prove the overspend resulted from their actions: change orders, site condition changes, schedule extensions. If you claim $12,000 in additional fuel due to equipment running 180 extra hours, you need daily logs showing the hours, field reports explaining why (rock excavation vs estimated soil), and client signatures acknowledging the condition. Without contemporaneous documentation, clients dispute the claim. Solution: Document scope changes daily, not quarterly.
3. Mixing recoverable and non-recoverable costs in a single invoice
If you submit a supplemental invoice for $28,000 in fuel overspend, but $6,000 of that is weekend personal vehicle charges, the client rejects the entire invoice and requests a detailed breakdown. Now you're in a dispute that delays payment 60 to 90 days. Solution: Separate recoverable costs from policy violations before invoicing. Only bill clients for legitimate, documented expenses.
4. Failing to enforce payroll deductions for policy violations
When crew members violate expense policies (personal fuel charges, excessive meals, unauthorized hotel upgrades), many companies absorb the cost to avoid employee conflict. This signals that policies are optional, and violations increase over time. A $2,400 policy violation in Q1 becomes $8,200 in Q2 and $15,600 in Q3. Solution: Implement immediate payroll deductions for documented violations. Consistent enforcement reduces repeat violations by 70% to 90%.
5. Not analyzing root causes of systemic overspend
Recovering $40,000 in Q1 overspend doesn't prevent $40,000 in Q2 overspend if you don't fix the underlying process failures. If hotel costs consistently exceed budget because your booking system defaults to higher-tier properties, recovering the Q1 overspend is a band-aid. Solution: Use quarterly reviews to identify systemic issues (inadequate budgets, missing contract clauses, poor booking controls) and implement process changes before the next quarter.
Integrating Expense Tracking with Project Management Systems
Field expense tracking becomes dramatically more accurate when connected to project management data: crew assignments, equipment schedules, job site locations, change orders, and weather logs. Sourcetable integrates with construction project management platforms, accounting systems, fleet management software, and corporate travel portals to create a unified expense tracking environment.
Key integrations for construction expense management:
- Accounting systems: QuickBooks, Sage 100 Contractor, Foundation, Viewpoint—import job budgets, cost codes, and invoice data
- Project management: Procore, Buildertrend, CoConstruct—sync crew schedules, change orders, daily logs, and equipment hours
- Fleet management: Geotab, Samsara, Verizon Connect—pull GPS mileage, fuel card transactions, and vehicle assignments
- Travel booking: Concur, TravelPerk, corporate hotel portals—import lodging reservations and actual charges
- Time tracking: ExakTime, Clockshark, Busybusy—match per diem claims to actual work days and travel status
When these systems connect, Sourcetable's AI can answer complex questions instantly: "Show me all fuel expenses for crews assigned to Job 2405 during the week of March 15-21, compare to budgeted mileage based on GPS logs, flag any receipts from locations more than 20 miles from the job site." This level of analysis is impossible in Excel and takes 2-3 hours manually. Sourcetable delivers the answer in 30 seconds.
The AI also detects inconsistencies across systems: a crew member claims per diem for March 18, but the time tracking system shows they clocked in at the main office (not a travel day). Equipment hours logged on Job 2407 total 280 for the month, but fuel receipts suggest 340 hours based on consumption rates. A hotel invoice charges Job 2410, but crew schedules show no one assigned to that job during the stay dates.
How long does quarterly expense reconciliation typically take for construction companies?
What percentage of fuel and per diem overspend is typically recoverable from clients?
How quickly should I submit supplemental invoices for recoverable expenses?
What's the most common cause of fuel overspend on construction projects?
How do I prevent crews from claiming per diem on non-travel days?
Can Sourcetable integrate with my existing construction accounting software?
What should I do when a crew consistently exceeds fuel budgets?
How do I calculate the ROI of real-time expense tracking?
What documentation do I need to recover fuel costs from scope changes?
How often should I review expense variance reports?
Track Construction Expenses in Real Time
Stop discovering overspend 90 days too late.
Sources
References and data sources used in this article
- Construction Financial Management Association (CFMA) - Field Expense Benchmarking Study 2025
- IRS Publication 463 - Travel, Gift, and Car Expenses (2026 revision)
- Associated General Contractors of America (AGC) - Standard Contract Terms for Reimbursable Expenses
- National Association of Home Builders (NAHB) - Construction Cost Control Best Practices 2025
- Fleet Management Institute - Fuel Consumption Benchmarks for Construction Equipment 2026