Description
A pre-formatted spreadsheet to track all your weekly expenses by category. Simply enter your expenses each day, and the spreadsheet automatically calculates your totals, cost per mile, and expense breakdown.
What’s Included
Sheet 1: Weekly Expense Entry
- Daily expense entry rows
- Pre-configured expense categories
- Running totals by category
- Weekly summary section
Sheet 2: Monthly Summary
- Automatic roll-up from weekly entries
- Month-over-month comparison
- Category breakdown chart
- CPM calculation
Sheet 3: Category Reference
- Complete list of expense categories
- IRS deduction notes
- Tips for each category
Expense Categories Included
Fixed Costs:
- Truck Payment
- Insurance (Liability, Cargo, Physical Damage)
- Permits & Licenses
- Health Insurance
- Phone/Communication
- ELD/Software Subscriptions
- Parking/Storage
Variable Costs:
- Fuel
- DEF
- Maintenance
- Repairs
- Tires
- Tolls
- Scales
- Food/Per Diem
- Lodging
- Lumper Fees
- Truck Wash
- Parking (Road)
- Other
How to Use
- Download the file (Excel or Google Sheets)
- Enter your weekly miles in the designated cell
- Log expenses daily in the appropriate category row
- Review weekly totals calculated automatically
- Check your CPM at the bottom of each week
- Transfer to monthly summary at end of each week
Preview
┌─────────────────────────────────────────────────────────────────┐
│ WEEKLY EXPENSE TRACKER │
│ Week of: __/__/____ │
├─────────────────────────────────────────────────────────────────┤
│ Miles This Week: [ ] │
├──────────────┬──────┬──────┬──────┬──────┬──────┬──────┬───────┤
│ EXPENSE │ MON │ TUE │ WED │ THU │ FRI │ SAT │ TOTAL │
├──────────────┼──────┼──────┼──────┼──────┼──────┼──────┼───────┤
│ Fuel │ │ │ │ │ │ │ $0.00 │
│ DEF │ │ │ │ │ │ │ $0.00 │
│ Tolls │ │ │ │ │ │ │ $0.00 │
│ Scales │ │ │ │ │ │ │ $0.00 │
│ Parking │ │ │ │ │ │ │ $0.00 │
│ Food │ │ │ │ │ │ │ $0.00 │
│ Maintenance │ │ │ │ │ │ │ $0.00 │
│ Truck Wash │ │ │ │ │ │ │ $0.00 │
│ Other │ │ │ │ │ │ │ $0.00 │
├──────────────┴──────┴──────┴──────┴──────┴──────┴──────┼───────┤
│ WEEKLY VARIABLE TOTAL: │ $0.00 │
├────────────────────────────────────────────────────────┼───────┤
│ WEEKLY FIXED (prorated): │ $0.00 │
├────────────────────────────────────────────────────────┼───────┤
│ TOTAL WEEKLY EXPENSE: │ $0.00 │
├────────────────────────────────────────────────────────┼───────┤
│ COST PER MILE: │ $0.00 │
└────────────────────────────────────────────────────────┴───────┘Excel Formulas Included
=SUM(B5:G5)— Row totals=SUM(H5:H15)— Category totals=H20/B2— CPM calculation=H5/SUM($H$5:$H$15)— Percentage breakdown- Conditional formatting for high expenses
Tips for Success
- Enter expenses daily — Don’t wait until end of week
- Keep receipts — Take photos and store digitally
- Be consistent — Use the same categories each week
- Review weekly — Catch unusual expenses early
- Compare weeks — Look for trends over time
Compatible With
- Microsoft Excel 2016+
- Google Sheets
- LibreOffice Calc
- Apple Numbers
For automatic expense tracking that calculates your CPM in real-time, download the RigProfit app.