Owner Operator Bookkeeping Workbook, IFTA Fuel Tax Tracker, Cost Per Mile, Per Diem, Schedule C Trucking Excel Spreadsheet

An all-in-one bookkeeping workbook for owner-operators, hot-shot and box-truck drivers who run their own authority. Log loads, fuel, miles by state, expenses, maintenance and per diem days, and see profit per mile, your IFTA quarter worksheet, Schedule C totals and what to set aside for each IRS estimated-tax period. One purchase, no subscription.

What is included

- Dashboard: revenue, expenses, net profit, cost per mile, profit per mile, IFTA result for the chosen quarter, maintenance alerts, charts

- Loads sheet: revenue, rate per loaded mile and per total mile, variable profit, fixed-cost share, target-per-mile check

- Fuel and Trips logs feeding an IFTA quarterly worksheet for 57 jurisdictions with missing-rate warnings (rate table is yours to update every quarter: no rates are pre-filled)

- Maintenance log with OVERDUE and Due soon alerts from your odometer and dates

- Per diem tracker with editable full-day, partial-day and deductible-share settings

- Schedule C map: every expense category tied to a Schedule C line, with year totals, gross receipts and net profit

- Quarterly estimated-tax set-aside for the four IRS periods with due dates

- Start Here sheet, a worked Sample tab, a fully filled example workbook, and a printable PDF guide with a blank paper log

File types: Excel workbook (.xlsx; formulas use only common functions so it also opens in Google Sheets and LibreOffice, with minor formatting differences) plus a filled-in example workbook and a printable PDF quick-start guide with a blank paper log. Nothing is locked: edit anything.

How to use: open the workbook, read the "Start Here" sheet, type into the yellow cells, and the grey formula cells and the Dashboard update by themselves. The "Sample" tab and the example workbook show real-looking numbers so you can see how it works.

Instant download: you receive the files right after purchase. Nothing is shipped.

IFTA rates, per diem amounts and Schedule C line numbers change over time: you enter and confirm them each period. This is a bookkeeping and worksheet tool; it does not file your IFTA return or your taxes.

Designed by a seller. Template and tools only. Not tax, legal, filing or financial advice. Rates, rules and due dates change and differ by state: check the official source or a qualified professional. Created with AI assistance and checked with automated tests.