Business Expense Tracker Spreadsheet: Categories, Receipts, Billable Costs and Tax-Time Totals
Set up a business expense tracker in Excel or Google Sheets: columns, categories mapped to Schedule C lines, receipt tracking, mixed-use and partly deductible costs, billable expenses, monthly and year-to-date summaries, and a worked example.
Quick answer: a business expense tracker is a single table where every business purchase gets one row: date, vendor, description, category, amount, payment method, whether you have the receipt, the business-use percentage and whether the cost is billable to a client. A summary sheet totals spending by category and month with SUMIFS, flags missing receipts and unbilled client costs, and produces year-to-date totals you can hand to your tax preparer.
This guide focuses on tracking expenses. If you want one workbook for income and expenses together, see the bookkeeping template for Excel. Categories below follow the expense lines a US sole proprietor reports on Schedule C; tax treatment depends on your situation, so confirm deductibility with a tax professional. Figures in the example are illustrative.
Why a dedicated expense tracker helps
- Deductions you can prove: each expense is linked to a receipt and a business purpose.
- Fewer surprises at tax time: totals by category are ready at year end, not reconstructed from bank statements in April.
- Money back from clients: billable expenses (materials, travel for a client project) are flagged until they appear on an invoice.
- Spending visibility: subscriptions, ads and contractor costs often grow quietly; a monthly view makes them visible.
Step 1: The expense table
Convert your range to a table (Ctrl+T) and name it Expenses:
| Column | Field | Input or formula |
|---|---|---|
| A | Date | Date of purchase |
| B | Vendor | Dropdown or free text |
| C | Description / business purpose | “Flight to Denver, client workshop (Acme)” |
| D | Category | Dropdown from the category list |
| E | Amount | Total paid, including sales tax |
| F | Payment method | Business card, business checking, personal card, cash |
| G | Business use % | 100% unless the item is mixed-use |
| H | Business amount | =ROUND([@Amount]*[@[Business use %]],2) |
| I | Receipt | Yes / No, plus the file name or link |
| J | Billable to client | Client name, or blank |
| K | Invoiced on | Invoice number once billed |
| L | Month | =EOMONTH([@Date],-1)+1 |
| M | Year | =YEAR([@Date]) |
Name receipt files with the date, vendor and amount (for example 2026-10-14_Delta_318.00.pdf) and keep them in one folder per year. If you paid with a personal card, note it: those expenses may need to be reimbursed to you or recorded as an owner contribution, depending on how your business is set up.
Step 2: Categories that match your tax return
Using the same categories as your tax form saves a lot of sorting later. A practical list for a small US business:
| Category | Typical examples | Notes |
|---|---|---|
| Advertising | Online ads, printed flyers, sponsorships | |
| Car and truck expenses | Business mileage or actual vehicle costs | Keep a mileage log |
| Commissions and fees | Marketplace fees, payment processing | |
| Contract labor | Freelancers and independent contractors | May trigger information returns |
| Insurance | Liability, business property | |
| Legal and professional services | Accountant, attorney | |
| Office expense | Postage, small office items | |
| Rent or lease | Office, equipment rental | |
| Repairs and maintenance | Equipment repairs | |
| Supplies | Materials and supplies used up in the business | |
| Taxes and licenses | Business licenses, certain taxes | |
| Travel | Airfare, lodging away from home | |
| Meals | Business meals | Generally only partly deductible |
| Utilities | Phone, internet (business share) | Use the business-use % |
| Software and subscriptions | SaaS tools, cloud storage | Usually reported under other expenses |
| Equipment | Computers, machinery | May need to be depreciated rather than expensed |
Keep the list on a separate Lists sheet and point the dropdown in column D to it. Add a column next to each category with the tax-form line, so your year-end summary can be grouped by line with one SUMIFS.
Step 3: Mixed-use and partly deductible costs
Two kinds of expenses need more than a single number:
- Mixed-use costs, such as a phone plan used 60% for business: enter the full bill in Amount and 60% in Business use %. Column H then carries the business portion. Write down how you estimated the percentage.
- Partly deductible costs, such as business meals, which are generally limited to 50% for federal tax purposes: track the full business amount, then add a column Deductible % with a lookup from the category list, and
=ROUND([@[Business amount]]*[@[Deductible %]],2)as an estimated deductible amount.
Rules change and have exceptions, so treat these columns as an estimate and let your tax professional make the final call.
Step 4: Monthly and year-to-date summary
On a Summary sheet, categories run down column A and months across row 4 (B4 = 1/1/2026, C4 = 2/1/2026, and so on):
- Category by month:
=SUMIFS(Expenses[Business amount],Expenses[Category],$A5,Expenses[Month],B$4) - Year to date:
=SUMIFS(Expenses[Business amount],Expenses[Category],$A5,Expenses[Year],$B$1) - Share of total:
=IFERROR(N5/SUM($N$5:$N$20),""), where N is the year-to-date column - Change vs last month:
=IFERROR(C5/B5-1,"")
To compare spending with revenue and see profit, carry these totals into a profit and loss statement template.
Example: one month for a two-person design studio
| Date | Vendor / purpose | Category | Amount | Business % | Business amount |
|---|---|---|---|---|---|
| Oct 2 | Design software and cloud storage | Software and subscriptions | $186.00 | 100% | $186.00 |
| Oct 5 | Social media ads | Advertising | $450.00 | 100% | $450.00 |
| Oct 8 | Printer paper and ink | Office expense | $72.40 | 100% | $72.40 |
| Oct 12 | Freelance illustrator, Acme project | Contract labor | $1,200.00 | 100% | $1,200.00 |
| Oct 14 | Flight and hotel, Acme workshop | Travel | $730.00 | 100% | $730.00 |
| Oct 15 | Lunch with Acme team | Meals | $96.00 | 100% | $96.00 |
| Oct 31 | Phone plan | Utilities | $120.00 | 60% | $72.00 |
| Total business amount | $2,806.40 | ||||
Check: 186 + 450 + 72.40 + 1,200 + 730 + 96 + 72 = $2,806.40. If meals are 50% deductible, the estimated deductible total is $2,806.40 − $48.00 = $2,758.40. If the contract agreement lets the studio bill the illustrator and travel to Acme, $1,930.00 is billable and should appear on the next invoice.
Step 5: Receipts and billable-cost checks
Add three control numbers at the top of the Summary sheet:
- Missing receipts this year:
=COUNTIFS(Expenses[Receipt],"No",Expenses[Year],$B$1) - Billable but not yet invoiced:
=SUMIFS(Expenses[Business amount],Expenses[Billable to client],"<>",Expenses[Invoiced on],"") - Paid with personal funds:
=SUMIFS(Expenses[Amount],Expenses[Payment method],"Personal card")+SUMIFS(Expenses[Amount],Expenses[Payment method],"Cash")
When you bill a client for expenses, add the invoice number in column K so the cost drops out of the “not yet invoiced” total. The invoice template in Excel uses the same tracking logic for payments received.
A 15-minute monthly routine
- Export or open your business bank and card statements for the month.
- Make sure every charge has a row in the tracker, and every row matches a charge (or a cash receipt).
- Attach or file any missing receipts; add a short business purpose where it is missing.
- Bill any open client expenses.
- Glance at the category summary: anything noticeably higher than last month deserves a second look.
Keeping records organized also matters after the year ends; the IRS explains how long to keep different records in its recordkeeping guidance, and your tax preparer can tell you what applies to you.
Common mistakes
- Mixing personal and business purchases on the same card without marking them.
- No business purpose in the description: “Amazon $63” says nothing a year later.
- Expensing large equipment without checking whether it must be depreciated.
- Typing categories by hand: “Software” and “software ” end up as two totals.
- Forgetting small recurring charges that never appear on a receipt you keep, like bank or processing fees.
FAQ
Can I use Google Sheets for this?
Yes. SUMIFS, COUNTIFS, EOMONTH and dropdowns all work, and you can upload receipt images to Google Drive and paste the link in the Receipt column.
Should I track expenses by date paid or date of the bill?
Most small businesses that report on a cash basis record expenses when they are paid. If you use the accrual method, record them when they are incurred. Pick one approach and use it consistently.
When should I switch to accounting software?
When you have many transactions, employees, inventory, or need bank feeds and payroll. The categories you set up here make the move easier, because they become your chart of accounts.
More guides: Bookkeeping & Income Tracking.