Business Expense Report Template

A free business expense log in CSV format, structured so the year-end totals map straight onto a Schedule C rather than needing to be re-sorted at filing time.

It includes a business-use percentage column, which is the field most templates omit and the one that matters for anything shared with personal life — your phone, your internet, your laptop.

Free download · CSV · no email required

Column headers for date, vendor, description, Schedule C category, amount, business-use percentage, deductible amount, and receipt status, with usage notes and two sample rows.

Download the CSV

What's in the template

Related calculators

Categorise as you go, not in April

The reason to put a Schedule C category on each row as you enter it is that the year-end total becomes a sum rather than a project. Sorting twelve months of undifferentiated transactions in April is the task most likely to be rushed, and rushing it is how deductions get missed.

Use the categories from the form itself — advertising, car and truck expenses, insurance, legal and professional services, office expense, supplies, utilities, and so on. Matching the form's own vocabulary means the totals transfer directly, and it also makes the conversation with a preparer considerably shorter.

The business-use percentage is what most templates miss

Very few self-employed expenses are 100% business. A phone plan you also use personally, home internet, a laptop that runs your accounts and your streaming — each is deductible only at its business share, and inventing a percentage after the fact is neither defensible nor accurate.

The template makes the split explicit: enter the full amount, enter the business-use percentage, and the deductible amount is the product. Recording your reasoning once, when the expense is fresh, is far easier than reconstructing it, and it gives you something to point at if the figure is ever questioned. A 60% business phone is a normal claim; a 100% business phone that is also your only phone is not.

What a deduction is actually worth to you

For a Schedule C filer, more than the equivalent deduction is worth to an employee. It reduces net profit, and net profit is the base for both income tax and self-employment tax, so a deducted dollar saves your marginal income-tax rate plus the 14.13% effective self-employment rate.

In the 12% bracket that is about 26 cents on the dollar. So $2,000 of small expenses you would otherwise have forgotten — software, supplies, a professional subscription, the business share of a phone bill — is worth around $520. That is the return on keeping this file up to date, and it is why the receipt column is worth using.

The ordinary and necessary test

The standard for deducting a business expense is that it is ordinary — common and accepted in your line of work — and necessary, meaning helpful and appropriate for it. That is a broader test than people assume and a narrower one than the internet suggests.

It does not stretch to "write off your whole life". A laptop you use for client work is deductible at its business share. Clothing is deductible only if it is unsuitable for everyday wear, which excludes almost everything. A meal is deductible when there is a business purpose and a business contact, at the limit the rules allow, and the person you had lunch with matters. When a claim requires an elaborate justification, that is usually the signal it does not hold.

Keep the receipt, and note that you did

The receipt-kept column exists so that gaps are visible while you can still do something about them. A charge on a bank statement shows an amount and a vendor; it does not show what was bought or why it was for the business, and for larger items that distinction is what substantiates the claim.

Photograph receipts as they arrive and store them in one folder named by year. It takes seconds and removes the single most common reason a legitimate deduction fails: not that it was ineligible, but that nothing was kept to show it happened.

Frequently asked questions

What expenses can a self-employed person deduct?

Anything ordinary and necessary for the business: business mileage, a home office used regularly and exclusively for work, software and subscriptions, equipment, supplies, professional insurance, accounting and legal fees, training relevant to your work, and the business-use share of phone and internet. Each reduces income tax and self-employment tax together, so a deducted dollar is worth about 26 cents in the 12% bracket.

How do I calculate business use percentage?

Estimate the share of the item's use that is genuinely for the business, and record how you arrived at it at the time. For a phone, that might be the proportion of usage or of hours; for a laptop, the split between business and personal work. Enter the full amount and the percentage in the template, and the deductible amount follows. Reconstructing the figure a year later is neither accurate nor easy to defend.

Do I need receipts for every business expense?

Keep them for everything you can. A bank statement shows an amount and a vendor but not what was purchased or why it was business-related, and that gap is what causes otherwise legitimate deductions to fail. Photographing receipts as they arrive and filing them by year takes seconds; the receipt column in this template exists so missing ones are visible before filing rather than after.

What Schedule C categories should I use?

The ones printed on the form: advertising, car and truck expenses, commissions and fees, insurance, interest, legal and professional services, office expense, rent or lease, repairs and maintenance, supplies, taxes and licences, travel, meals, utilities, and other expenses. Using the form's own vocabulary as you record each expense means the year-end totals transfer directly rather than needing to be re-sorted.

Can I deduct expenses if I made a loss?

If the activity is genuinely a business, yes — expenses are deducted against income and a resulting loss can generally offset other income, subject to the rules. If the IRS treats the activity as a hobby, you report the income but cannot deduct expenses against it, and the loss cannot offset your salary. The distinction turns on whether you run the activity with a genuine profit motive and in a businesslike way.

Sources

We prioritize primary sources for rules, formulas, rates, limits, and definitions. See our calculator methodology and editorial policy.