A $24 parking receipt lost in a coat pocket is not much. Fifty of them across a year, plus a hotel bill nobody filed and a client dinner booked to the wrong category, add up to deductions a sole proprietor either cannot claim or cannot defend. This free small business expense spreadsheet template is built to stop that: one log for every purchase, a dropdown of categories that map to the lines on IRS Schedule C, a monthly summary that totals itself with SUMIFS formulas, and a dashboard with charts.
It is written for US sole proprietors and single-member LLC owners who file Schedule C with Form 1040. Tax figures were checked against IRS pages in October 2026.
Four Sheets Mapped to Schedule C Lines 8 to 30
- The workbook has four sheets: Expenses, Categories, Monthly Summary and Dashboard. You only ever type on the first one.
- Categories follow the 2025 Schedule C, from line 8 (advertising) to line 30 (business use of home), so year-end totals drop straight onto the form.
- Keep a receipt for every lodging bill and for any travel, meal or gift expense of $75 or more.
- The business mileage rate is 72.5 cents for January to June 2026 and 76 cents from 1 July 2026, so log the date of every trip.
- Most records must be kept for three years after filing, employment tax records for four, and some for six or seven.
What the Expense Spreadsheet Template Contains
Most free expense templates are a single grid with a “Category” column you fill in by hand. By March, “Software”, “software” and “Subscriptions” are three categories, none matching a tax line. This one separates data from reporting.
| Sheet | What it does | Do you type here? |
|---|---|---|
| Expenses | A 1,000-row Excel table: date, vendor, description, category and payment method (dropdowns), amount, tax, receipt (Yes/No), notes. Two grey columns add the Schedule C line and an estimated deductible amount. | Yes |
| Categories | 25 categories with the matching Schedule C line, a plain-English note on what belongs there, and a deductible share (100% for most, 50% for meals, 0% for personal). | Only to rename or add a category |
| Monthly Summary | SUMIFS totals for every category by month, plus rows for estimated deductible spend, tax paid, number of entries and missing receipts. | Only the year cell |
| Dashboard | Year totals, average monthly spend, the largest category, personal spending to repay, and two charts (spend by month and by category). | No |
It ships with 15 example rows from a fictional one-person design studio to show how each kind of entry should look.
Setting Up the Template Before Your First Entry
- Save a copy for the tax year: name it something like “Expenses 2026”. One file per year makes retention simple.
- Clear the sample rows: select columns A to I on the Expenses sheet from row 5 to row 19 and press Delete. Columns J and K hold formulas; leave them.
- Set the year: type it in the yellow cell on the Monthly Summary sheet.
- Trim the category list: a consultant with no staff can delete Wages, Employee benefit programs and Pension and profit-sharing plans from the Categories sheet. If you rename a category, rename it in old rows too, or they drop out of the totals.
- Edit the payment methods: the list includes “Personal card (reimburse)” on purpose.
Amounts are entered as the total you paid, including any sales tax, GST or VAT. The tax column is for owners who reclaim tax or want to see how much went to it. Number formats carry no currency symbol.
Schedule C Expense Categories Behind the Dropdown
The category list mirrors Part II of the 2025 Instructions for Schedule C, the latest full set the IRS has published for a filed tax year. Two lines are left out because few small businesses touch them: line 12 (depletion, for oil, gas and timber) and line 27a (the energy efficient commercial buildings deduction).
| Template category | Schedule C line | Typical entries |
|---|---|---|
| Advertising | 8 | Search and social ads, flyers, sponsorships |
| Car and truck expenses | 9 | Mileage at the standard rate, or actual costs; parking and tolls |
| Commissions and fees | 10 | Marketplace and platform fees, sales commissions |
| Contract labor | 11 | Freelancers and subcontractors who are not employees |
| Depreciation and section 179 | 13 | Laptops, cameras, furniture, vehicles |
| Employee benefit programs | 14 | Benefit plans for staff, excluding pensions |
| Insurance (other than health) | 15 | Liability, professional indemnity, business property |
| Interest: mortgage / other | 16a / 16b | Form 1098 mortgage interest; loan and card interest |
| Legal and professional services | 17 | Accountant, tax preparer, lawyer, bookkeeper |
| Office expense | 18 | Postage, ink, paper, small office items |
| Pension and profit-sharing plans | 19 | Contributions for employees |
| Rent: vehicles, machinery, equipment / other property | 20a / 20b | Leased equipment; office, coworking desk, storage |
| Repairs and maintenance | 21 | Fixes that keep property working |
| Supplies | 22 | Materials used up in the work |
| Taxes and licenses | 23 | Business licences, state filing fees, employer payroll taxes |
| Travel / Meals (business) | 24a / 24b | Airfare and hotels away from home; client meals |
| Utilities | 25 | Business phone, internet, power for business premises |
| Wages | 26 | Employee pay |
| Other expenses (Part V) | 27b, itemised on line 48 | Software subscriptions, bank fees, trade dues, training |
| Business use of home | 30 | Home office, regular and exclusive use |
| Inventory and cost of goods | Part III | Stock bought for resale, direct materials |
| Personal (not deductible) | None | Personal spending that slipped onto the business card |
The Ordinary and Necessary Test
A category is only a label. Whether the cost is deductible depends on the IRS test that every business expense must pass. The IRS defines an ordinary expense as one that is common and accepted in your trade or business, and a necessary expense as one that is helpful and appropriate for it. Necessary does not mean indispensable. A design studio’s font licence passes easily. A family holiday booked through the business account fails, whatever category you pick.
That is why the Description column asks for “what and why”. “Dinner, Ristorante Cielo” tells an auditor nothing. “Dinner with client (3 people), project scope” ties the bill to income-producing work. Meals carry an extra rule: Schedule C line 24b takes only the deductible part, which is generally 50% of the cost. Enter the full bill in the log and let the Est. deductible column halve it; the $128.50 sample dinner shows as $64.25.
Big equipment purchases are the other trap. The sample $1,249 laptop sits under Depreciation and section 179 with a note to ask a preparer: whether it is written off this year or spread over several depends on elections made on Form 4562.
Receipts the IRS Expects for Business Expenses
The IRS lists what a supporting document should show for any expense: the payee, the amount, proof of payment, the date and a description showing it was for business. Acceptable proof includes cancelled cheques or electronic transfer records, cash register receipts, account statements, credit card slips and invoices, and the IRS notes that you may need more than one of them to cover everything. Electronic records face the same requirements as paper, so a legible phone photo in a dated folder works.
Travel, meals and gifts have a stricter rule. Under Treasury Decision 8864, documentary evidence such as a receipt is required for every lodging expense while travelling away from home and for any other such expense of $75 or more. Below $75, a contemporaneous log entry with the amount, date, place and business purpose can stand in for the receipt. That is the logic behind the template’s conditional formatting: the Receipt saved? cell turns red when it says “No” on an amount of $75 or more or on a Travel row.
- Name receipts to match the log: “2026-02-13 Lakeside Hotel 389.00.pdf” can be found in seconds by sorting a folder.
- Write on meal receipts: who attended and what was discussed. The sample row says “Wrote attendees on receipt” for that reason.
How Long to Keep Expense Records Under IRS Rules
The retention periods come from the period of limitations, the window in which the IRS can assess more tax or you can claim a refund. The IRS points owners to Publication 583, Starting a Business and Keeping Records, for the full recordkeeping guide and summarises the periods on its record retention page (rules as of October 2026).
| Situation | Keep records for |
|---|---|
| Standard case | 3 years |
| You file a refund claim after filing the return | 3 years from filing or 2 years from paying the tax, whichever is later |
| Deduction for bad debt or worthless securities | 7 years |
| Income not reported that exceeds 25% of the gross income shown | 6 years |
| No return filed, or a fraudulent return | Indefinitely |
| Employment tax records | At least 4 years after the tax is due or paid, whichever is later |
| Records for property (equipment, vehicles, buildings) | Until the limitations period ends for the year you dispose of it |
The property rule is the one people forget. The spreadsheet row for that $1,249 laptop, and its receipt, have to survive until three years after the return for the year you sell or scrap it, which could be a decade away. Copy asset purchases into a separate “fixed assets” file that never gets archived.
Logging Mileage and a Home Office in the Spreadsheet
Mileage changed mid-year in 2026. The IRS set the business standard mileage rate at 72.5 cents per mile from 1 January 2026, then raised it to 76 cents per mile from 1 July 2026 under Announcement 2026-11, according to the Journal of Accountancy. For 2025 returns the rate was 70 cents. Because the rate depends on the date of the trip, add one row per month (or per trip) under Car and truck expenses rather than one annual total.
A worked example for a consultant who drives 1,800 business miles in the first half of 2026 and 2,100 in the second, with $86 of parking and tolls:
| Period | Business miles | Rate | Deduction |
|---|---|---|---|
| 1 Jan to 30 Jun 2026 | 1,800 | $0.725 | $1,305.00 |
| 1 Jul to 31 Dec 2026 | 2,100 | $0.76 | $1,596.00 |
| Parking and tolls | Actual cost | $86.00 | |
| Line 9 total | 3,900 | $2,987.00 |
Parking and tolls are added on top of the standard rate, the Schedule C instructions say, but you cannot also deduct fuel, repairs, insurance or depreciation for that vehicle. So on the standard rate, keep petrol receipts out of the log. Record trips (date, route, purpose, miles) in a notebook or app and enter the monthly result.
For a home office, the simplified method in the 2025 instructions allows $5 per square foot of space used regularly and exclusively for business, capped at 300 square feet. A 200 sq ft spare room gives $1,000; the ceiling is $1,500. Enter it as a single year-end row under Business use of home (line 30). On the regular Form 8829 method, keep household bills out of the other categories so nothing is counted twice.
Reading the Monthly Summary and Dashboard
Each cell in the summary grid is one SUMIFS formula with three conditions: the Category column matches the row, the Date column is on or after the first of the month, and the Date column is before the first of the next month (worked out with EDATE).
The month headers are real dates built from the year cell, which is why changing one number re-points the whole sheet. Five check rows sit underneath. In the sample data, total spend is $5,493.38 and the estimated deductible figure is $5,364.93; the $128.55 gap is the $64.25 non-deductible half of the client dinner plus $64.20 of personal groceries. If that gap grows, something personal is creeping into the books.
The Dashboard pulls the headline numbers and draws two bar charts. “Average per active month” divides the year’s spend by the months that have any spending, so a quiet August does not drag it down. It plugs straight into our break-even calculator as your fixed monthly costs. Freelancers can also use the freelance hourly rate calculator to check that their rate covers overheads.
Using the Expense Template in Google Sheets
Google Sheets reads the .xlsx file directly. Per Google’s import help page:
- Open a blank spreadsheet in Google Sheets.
- Click File, then Import, and upload small-business-expense-tracker.xlsx (it must not be password protected).
- Choose Replace spreadsheet to bring in all four sheets, or Create new spreadsheet to open them in a new file.
- Click Import. The SUMIFS, VLOOKUP and EDATE formulas all exist in Sheets and recalculate on their own.
The CSV version holds only the expense log, as plain values. Use it to load history into accounting software, or add rows to an existing sheet with the Append rows to current sheet option and a comma separator. After importing, check the Category dropdown under Data, then Data validation, and redraw any chart that looks off with Insert, then Chart.
A Monthly Close Routine for a One-Person Business
Most owners batch their entries, and a fixed monthly close catches what the batch misses. Pick a date, say the third working day, and repeat the same steps.
- Download statements: every business bank account, card and payment wallet for the month just ended.
- Tick off each outgoing payment: every debit on the statement should match a row in the log. Add what is missing.
- Clear the red cells: filter Receipt saved? to “No” and find or request each receipt above $75.
- Settle personal items: the Dashboard’s “Personal spend to repay” figure tells you how much to move from your personal account back to the business, or how much the business owes you for “Personal card (reimburse)” rows.
- Read the month column: compare it with the previous month. A sudden jump in Other expenses usually means a subscription renewed annually or a free trial converted.
- Back up: save the workbook and the receipt folder to a second location.
Pair it with an income record. Our free invoice generator numbers and dates invoices, and owners who outgrow a spreadsheet can compare dedicated options in our roundup of QuickBooks Solopreneur alternatives for 1099 contractors.
Expense Tracking Mistakes That Cost Deductions
- Mixing accounts: the IRS notes that a business checking account is usually the main source of entries in your books. Personal purchases on the business card make reconciling harder, so the template gives them their own category.
- Logging fuel and mileage together: under the standard mileage rate, fuel is already priced in. Pick one method per vehicle.
- Booking meals at 100%: the log should show the full bill; the return should show the deductible half.
- Typing categories freehand: anything not in the dropdown is ignored by SUMIFS and vanishes from the totals. Pasting data can overwrite the dropdown, so check after pasting.
- Treating contractors as one line: keep each freelancer’s name in the Vendor column. Filtering by vendor at year end shows who may need an information return.
- Deleting old files too early: property records and anything tied to a bad debt claim outlive the usual three years.
More guides on running the numbers for a small business sit in our Finance section.
Expense Spreadsheet Questions
How Do I Make an Expense Spreadsheet for a Small Business?
Use one row per expense with date, vendor, description, category, payment method and amount, restrict the category to a fixed list, and total it by month with SUMIFS.
What Expense Categories Should a Small Business Use?
For a US sole proprietor, the Part II lines of Schedule C are the simplest choice: advertising, car and truck, contract labor, insurance, legal and professional, office expense, rent, supplies, travel, meals, utilities and so on, with other costs listed in Part V.
Do I Need Receipts for Expenses Under $75?
For travel, meal and gift expenses under $75, other than lodging, a timely record of amount, date, place and business purpose can replace the receipt. You still need proof of what you paid, such as a card statement.
What Is the IRS Mileage Rate for 2026?
72.5 cents per business mile from 1 January to 30 June 2026, and 76 cents from 1 July 2026.
This article is for information and education only and is not investment, tax or financial advice. Figures were checked on 30 October 2026; confirm current details with the official source or a registered adviser before acting.
IRS Schedule C Instructions, Recordkeeping Rules and Mileage Notices
- IRS: Instructions for Schedule C (Form 1040), 2025
- IRS: What kind of records should I keep
- IRS: How long should I keep records?
- IRS: About Form 2106 (definition of ordinary and necessary expenses)
- IRS: 2026 business standard mileage rate set at 72.5 cents per mile
- Journal of Accountancy: IRS raises standard mileage rates for remainder of 2026
- Federal Register: T.D. 8864, Substantiation of Business Expenses
- Google Docs Editors Help: Import data sets and spreadsheets
