Trucking Expenses Spreadsheet for Owner-Operators

Quick Answer: A trucking expenses spreadsheet needs four tabs: Expenses (every fuel, repair, toll, insurance and permit cost from your fuel-card and bank statements), Revenue (each load and settlement), a Per Diem log of days on the road, and a Summary that totals each category by month with SUMIFS. Fill it weekly from your statements and it's ready when your tax preparer asks.

An owner-operator's trucking expenses spreadsheet is a running record of every cost of keeping the truck on the road, grouped into categories that match how your accountant will report them. Most of the rows already exist on your fuel-card and business bank statements, so the job is getting them into the sheet weekly, tagging each one, and keeping the receipts and logs a statement can't replace.

This guide sets out a layout that works for one truck and a handful of loads a week. It describes records, not tax treatment: which costs are deductible, and how, is for your tax preparer.

The four tabs

Keep all expenses in one long tab rather than a sheet per month. One table is easier to filter, sort and total, and a monthly view is just a formula away.

Which expense categories do truckers track?

Use the same category names every time; a typo creates a new category and breaks your totals. A data-validation dropdown on the Category column prevents that. A starting list:

• Fuel: diesel and DEF. Record gallons too if you'll need them for fuel tax reporting.
• Repairs and maintenance: shop invoices, oil changes, parts.
• Tires: often worth separating from repairs because they're large and lumpy.
• Tolls and scales.
• Insurance: primary liability, physical damage, cargo, bobtail.
• Truck payment or lease: keep principal and interest apart if your loan statement shows them separately.
• Permits, licences and registration: including the heavy highway vehicle use tax. The IRS explains that Form 2290 is used to figure and pay the tax on highway motor vehicles with a taxable gross weight of 55,000 pounds or more.
• Communications and ELD: phone, data plan, electronic logging device subscription.
• Parking and truck washes.
• Load boards and dispatch fees.
• Factoring fees, if a factoring company advances your invoices.
• Office and professional: bookkeeping, tax preparation, software.

Sole proprietors report business income and expenses on Schedule C. Ask your preparer which of your categories map to which lines; then add a "Schedule C line" column to your category list so the year-end totals drop straight onto their worksheet.

How do you fill the sheet from fuel-card and bank statements?

Fuel is the biggest and most frequent cost, and it's almost all on the fuel card. Everything else is mostly on the business bank account or business credit card. So the weekly routine is:

1. Fuel card. Download the week's transactions from the fuel card portal. If it gives you a CSV, paste the rows into Expenses. If it only issues PDF statements, QuickBankConvert converts the statement into spreadsheet rows (date, merchant, amount) that paste straight in.
2. Business bank and card. Do the same with the business checking statement and any business credit card. Our guide to tracking business expenses from bank statements covers the general method.
3. Tag each row with a Category and, if you run more than one truck, a Unit.
4. Delete transfers between your own accounts, such as paying the business card from checking. Otherwise you count the same spending twice.
5. Add cash purchases by hand from receipts: scale tickets, lumper fees paid in cash, parking.
6. Match receipts. Write the receipt file name or number in the Receipt column.

Keeping one business account and one business card, separate from personal spending, makes every step shorter. Mixed accounts mean sorting personal groceries out of fuel stops every week.

Why keep receipts when the statement shows the charge?

A statement proves you paid a vendor a certain amount on a certain date. It doesn't say what you bought: a truck-stop charge could be diesel, a meal or a pair of gloves. The IRS's Publication 583 lists account statements among the supporting documents for expenses, alongside canceled checks, credit card sales slips and invoices, and says supporting documents should show the amount paid and that it was for a business expense. For repairs, parts and anything over a few dollars that isn't plainly fuel, the receipt or invoice is what shows the business purpose.

Snap a photo of each receipt with your phone the day you get it and name it by date and vendor. Faded thermal paper in a door pocket is the most common gap at tax time.

Tracking per diem days

Meals on the road are handled differently from other expenses. Publication 463 describes a special standard meal allowance for people in the transportation industry, defined as work that directly involves moving people or goods by truck (among other modes) and regularly requires travel away from home. It also says that if you're subject to the Department of Transportation's hours-of-service limits, the percentage of meal expenses you can deduct is 80% rather than the usual 50%.

None of that requires meal receipts in your spreadsheet. What it requires is an accurate log of days away. In the Per Diem tab, record each day you're away from your tax home, where you started and stopped, and whether it was a departure or return day; Pub 463 explains that the first and last days of a trip are prorated. Your tax preparer applies the rates; your job is the days.

Pub 463 also notes that once you choose the special transportation rate for a trip, you use it for all trips that year. That's a decision for your preparer, but it's another reason to keep the log complete.

Building the Summary tab

In the Summary tab, list your categories down column A and months across row 1 (as the first day of each month, formatted to show the month name). Then use SUMIFS, which Microsoft's SUMIFS reference describes as adding values that meet multiple criteria. With Expenses dates in column A, categories in C and amounts in D:

=SUMIFS(Expenses!$D:$D, Expenses!$C:$C, $A2, Expenses!$A:$A, ">="&B$1, Expenses!$A:$A, "<"&EDATE(B$1,1))

Fill it across and down. Add a row for revenue from the Revenue tab, and a final row for revenue minus expenses, and you have a monthly operating picture. Fuel as a share of revenue, month by month, is the number most owner-operators watch.

Bookkeeping for a trucking company beyond the spreadsheet

A spreadsheet stays workable for a single truck. Signs you've outgrown it: several trucks or drivers, factoring with reserves to track, or invoices that need ageing. At that point bookkeeping software with a proper chart of accounts is the better home, and our small business bookkeeping guide covers the move. Your statement history comes with you: converted to CSV, it imports into most bookkeeping software, and QuickBankConvert's paid plans add QBO output for QuickBooks (see pricing).

If you also drive for apps or deliver on the side, keep that income on a separate tab; our guide to rideshare tax prep from bank statements works the same way.

Related guides

• Self-employed tax spreadsheet
• Track business expenses from bank statements
• Rideshare driver tax prep from bank statements
• Bookkeeping for small business