How do I track business vehicle expenses in my accounting software?

What must the records keep separate for each IRS method?

The IRS's Tax Topic 510 addresses self-employed car expenses deducted on Schedule C or Schedule F and names two ways to figure them: the standard mileage rate method and the actual expense method. For a car used for both business and personal purposes, Topic 510 allows only the cost of its business use. Under the actual expense method it counts gas, oil, repairs, tires, insurance, registration fees, licenses, and depreciation or lease payments, attributable to the share of total miles driven that are business miles.

Topic 510 allows the standard mileage rate only for a car you own or lease, and only if you do not operate five or more cars at the same time, as in a fleet operation, and the car's past depreciation claims do not rule it out (Topic 510 lists them; the preparer confirms). Publication 463 does not count cars used at different times as operated at the same time. For a car you own, Topic 510 requires the standard rate to be chosen in the first year the car is available for use in the business; for a leased car, choosing it binds the entire lease period, including renewals.

These IRS rules are written for self-employed people filing Schedule C or F. If the business is a partnership or corporation, confirm with its preparer which methods and records its return needs; the actual-cost structure below serves either way. What the records must keep separately identifiable depends on the method they must support:

The design has to be in place before the period starts. Publication 463 advises recording the elements of an expense or of a business use at or near the time, and a vehicle label or a trip is hard to reconstruct months later. The Schedule C instructions also require information on the use of the vehicle whenever car and truck expenses are claimed, including, where that information goes on Part IV, a statement for each additional vehicle, so each vehicle's use must be identifiable from the first entry. Under the actual expense method, Topic 510 has you determine what it actually costs to operate the car by dividing its expenses between business and personal use, so each vehicle's costs must be identifiable too.

How many vehicle accounts are worth carrying?

Account-level separation comes in three levels:

What decides the level is the method the records must support, the number of vehicles, and how central vehicles are to the business: a delivery or trades business that watches cost per vehicle needs the set, while an office with one car for errands may not. This set serves either method:

• Vehicle fuel and oil
• Vehicle repairs, maintenance and tires
• Vehicle insurance
• Vehicle registration and licenses
• Vehicle personal property taxes
• Vehicle garage rent
• Parking and tolls
• Vehicle lease payments
• Vehicle loan interest
• Vehicle depreciation

Keep personal property taxes out of registration and licenses, because the standard-rate row needs them on their own, and tag depreciation to its vehicle like any other vehicle cost. On the balance sheet, add a liability account for each vehicle loan, plus the vehicle asset account that capital items are routed to, and its accumulated depreciation account.

Do not open "Fuel – Van 1", "Fuel – Van 2" and so on. The chart grows by a full set of accounts for every vehicle added, and comparing vehicles means reassembling accounts by hand. One account per cost type, with the vehicle on a tracking dimension, gives the same comparison from one report.

How is each cost tagged to its vehicle?

Create one value per vehicle in the software's tracking dimension, named with the unit number or plate that the mileage log also uses, plus one value such as "Fleet – shared" for costs that genuinely cover every vehicle. Review what lands there each period and move anything that belongs to one vehicle to that vehicle. A blank then always means missed, never shared.

In QuickBooks Online, Intuit's class-tracking article describes classes as meaningful segments of the company and makes them available on QuickBooks Online Plus or Advanced. With the setting "One to each row in transaction", that article has the class entered in each row's Class column, so one invoice covering two vans can put each row on its own van. Intuit's "Turn on class tracking" article offers a setting that warns when a transaction has no class; turn it on so a transaction with no class is flagged, and rely on the period-end check to catch missed rows. On plans without classes, Intuit's expense-entry article shows a Tags field for labelling each expense; confirm your plan can report by tag before relying on tags for per-vehicle cost. The same article has one Tags field per expense, filled in before the category details, so with tags record a multi-vehicle invoice as one transaction per vehicle.

In Zoho Books, Zoho's reporting-tags page (undated) says reporting tags can be added only to line items in transactions and that reports can be filtered by tag, so each line carries its own vehicle. The same page says reporting tags are available only on certain Zoho Books plans; check yours before relying on them for per-vehicle cost.

With several vehicles, every entry needs two decisions, the account and the vehicle, and both are made when the entry is made. Nobody can reliably assign last March's fuel to a van in December.

How is a payment that mixes financing and cost recorded?

OpenStax's chapter on long-term liabilities explains that loan payments are typically composed of both principal and interest, and that the principal paid reduces what the borrower owes the lender. Split each vehicle loan payment at entry:

• The principal goes to the vehicle loan liability account, reducing the balance owed.
• The interest goes to Vehicle loan interest, tagged to the vehicle.

Take each payment's split from the lender's statement or amortization schedule. In QuickBooks Online, Intuit's line-of-credit article shows the same mechanics for a borrowing: split the payment between principal and interest in the category details.

Posting the whole payment to a vehicle expense account overstates expense by the principal every month and leaves the loan balance overstated, or missing entirely if the loan was never recorded when the vehicle arrived. The error repeats until the loan account is reconciled to the lender's statement. Recording a vehicle bought with a loan is a separate question; until it is done, the principal has no liability account to go to.

A lease payment is recorded according to how the lease has been classified, which is decided separately. If it is treated as a rental, the payment posts whole to Vehicle lease payments, which the Schedule C instructions keep apart from running costs. If it is treated as effectively a purchase, it is not a rental payment and does not post whole to Vehicle lease payments; record it as that classification directs. If a loan or lease payment also bundles insurance, maintenance or a service plan, split that part to its running-cost account at entry.

Where does vehicle spending that is not a running cost go?

OpenStax's section on capitalized costs versus expenses gives a vehicle example: a supercharger added to increase a car's horsepower is included as part of the vehicle asset. Anything decided to be capital posts to the vehicle asset account, tagged to its vehicle, never to running costs. When a large invoice arrives, get its treatment decided promptly, then post each line to its running-cost or asset account. The entry routes the decision; it does not make it. The expense-or-asset decision belongs to "Is this purchase a regular expense, or an asset I have to put on the balance sheet?", and the repair-or-improvement decision to a separate question.

How is the personal-use share kept visible?

Because Topic 510 allows only the business-use cost of a mixed-use car and measures it by business miles as a share of total miles, the records need every cost in full and, beside them, each vehicle's business miles and total miles. Post every cost in full, since the business-use share is not known until the year's miles are. At period end, that share from the mileage log goes on the per-vehicle sheet the preparer uses (see the join below), and the ledger keeps the gross costs with no entry for the personal share. Parking and tolls are the exception: Topic 510 allows those attributable to business use, so identify them trip by trip rather than by the mileage share.

Gross costs with nothing recording business and total miles assert a wholly business vehicle, and the split cannot be rebuilt later.

Ownership decides which costs enter the business ledger at all:

How does the mileage record join the cost accounts?

The accounting ledger holds money; the miles live in a trip log, whether an app, a paper log or a software mileage feature. What the trip log itself must contain, and the best way to keep it, are separate questions. Publication 463's advice to record a business use at or near the time applies to the log, so a mileage total typed in at year end is not a log. Zoho's mileage-expenses page (undated), for instance, describes an amount calculated from a distance; the trips behind that distance still need their own record.

At period end, join the two for each vehicle:

1. Run the per-vehicle cost report for the period.
2. From the log, total each vehicle's business miles and total miles under the same vehicle name the tracking dimension uses.
3. Set each vehicle's costs by account beside its miles; that sheet is what the preparer applies the chosen method to.
4. Add the shared value's total as a separate line, either with the basis used to spread it across vehicles, as the insurance in the example below was split by each van's premium, or marked unallocated for the preparer.

How should fuel-card transactions from a bank feed be coded?

Start with the mapping of cards to vehicles. A card issued to one vehicle and used for nothing else lets the card's account identify the vehicle. A card shared across vehicles or drivers does not, and nothing in the feed can.

In QuickBooks Online, Intuit's bank-rules article lets a rule be limited to one bank or credit card account, match on the description, bank text or amount, and apply a transaction type, category, tags and payee. A rule on a single-vehicle card can therefore set the fuel category, matched on fuel merchants so other purchases on the card are not coded as fuel, and, where vehicles are tags, the vehicle's tag. The same article says that with auto-add on, a rule posts matching downloaded transactions immediately. Leave that setting, Auto-post under "Automatically confirm transactions this rule applies to" in the Rules window, off for fuel-card rules, so no fuel transaction posts before someone confirms its vehicle.

In Zoho Books, Zoho's transaction-rules page (undated) builds a rule for a selected bank account and offers "Recognized Transactions" for categorizing manually or "Categorized Transactions" for letting Zoho Books categorize by the rule. Choose the manual option for fuel cards, and make sure each fuel-card expense carries its vehicle tag: Zoho's reporting-tags page adds tags to expenses through Associate Tags, under Reporting Tags at the bottom of the expense creation page.

For a shared card, the vehicle comes from the receipt or the driver's record, never from the merchant name or amount. Business parking and tolls go to Parking and tolls with the vehicle tag; mark personal ones in the memo so the preparer can leave them out. Review fuel lines weekly: each should carry a vehicle, and a vehicle whose fuel cost per mile jumps deserves a check against receipts.

How do receipts stay attached and findable?

In QuickBooks Online, Intuit's expense-entry article lets you add an attachment, such as a receipt, on the expense itself. Intuit's receipt-upload article describes an uploaded receipt becoming a transaction for review, which you then add to an account or match to an existing transaction; until that happens, the receipt is not on the entry. These attachment steps are for QuickBooks Online only. Three habits keep documents retrievable:

• Attach or match every vehicle receipt, and clear the review list, before closing the period.
• Attach a fleet invoice split across vehicles to every transaction that records part of it.
• Keep the vehicle's tag on the entry, so the document is reached from that vehicle's transactions.

What does one vehicle's month look like in the ledger?

Van 2, one of two vans, over one month on the accrual basis, with invented figures:

The fuel is identified by the single-vehicle card. The brake invoice had already been treated as a routine repair, so it posts to Vehicle repairs, maintenance and tires. The insurance payment covered both vans and was split between them using the insurer's premium for each. The loan payment was split between the obligation (557.60 off the balance owed) and the cost (92.40 of interest), using the lender's statement. Van 2's column in the per-vehicle report shows 734.00 of cost; the principal appears in no vehicle's cost, because it is not a cost.

How is the per-vehicle report produced and checked?

In QuickBooks Online, Intuit's reports-by-class article runs Profit and Loss by Class, which groups income, expenses and net income by class. In Zoho Books, Zoho's reporting-tags page (undated) lets reports be filtered by tag. Before relying on either, check completeness:

1. Reconcile every bank, card and fuel-card account for the period, then enter any vehicle costs paid personally (the Owner investments entry) and any unpaid bills.
2. Clear the bank-feed and receipt review lists.
3. For each vehicle account, compare its total on the ordinary profit and loss report with the sum of the individual vehicle columns or tag-filtered totals, leaving out the shared value. Report the shared total on its own line as cost not attributed to any vehicle; any further difference is cost never tagged, so find those entries and tag them.
4. Agree each loan account to the lender's statement, and each vehicle's interest to the lender's interest figure.
5. Join the result to each vehicle's miles.