The worst time to organize your business expenses is in March when your accountant is asking for them. The best time is all year long, ten minutes at a time.
A business expense tracker in Google Sheets takes about 20 minutes to set up and roughly 15 minutes per week to maintain. What you get: every deduction accounted for, tax season that takes hours instead of days, and a real-time view of where your money is actually going.
Why This Matters Beyond Tax Season
Expense tracking isn’t just a tax prep task. It’s how you answer:
- Am I spending more on [category] than last quarter?
- Is this expense actually worth what I’m paying?
- What are my total costs to run this business?
- What’s my actual profit margin?
Done right, your expense tracker becomes one of the most useful management tools in your business.
The IRS-Friendly Category System
The IRS uses specific categories on Schedule C (the small business tax form). Organizing your expenses to match these categories makes filing — or working with an accountant — significantly easier.
| Schedule C Category | What Goes Here |
|---|---|
| Advertising | Marketing, ads, printed materials, business cards |
| Car and truck | Business mileage, vehicle lease (business %) |
| Commissions and fees | Payments to contractors, referral fees |
| Contract labor | 1099 workers, freelancers |
| Depreciation | Equipment, vehicles, major assets |
| Insurance | Business liability, professional liability, property |
| Legal and professional | Accountant, attorney, consultants |
| Meals (50%) | Business meals (only 50% deductible) |
| Office expense | Supplies, printer ink, small equipment under $2,500 |
| Rent or lease | Office, warehouse, equipment rental |
| Repairs and maintenance | Equipment repairs, office maintenance |
| Supplies | Materials used in your business |
| Taxes and licenses | Business licenses, permits, payroll taxes |
| Travel | Airfare, hotel, car rental for business trips |
| Utilities | Business portion of phone, internet |
| Wages | W-2 employee wages |
| Other expenses | Anything that doesn’t fit above |
Map every expense you incur to one of these categories. When April comes, you’ll have your Schedule C essentially pre-populated.
Building the Tracker
Tab 1: Expense Log
Create these columns:
| Column | Description |
|---|---|
| Date | Transaction date |
| Description | What was purchased |
| Vendor | Who you paid |
| Category | IRS Schedule C category (use a dropdown) |
| Amount | Dollar amount |
| Payment Method | Card, check, cash, ACH |
| Receipt? | Y/N — for audit purposes |
| Notes | Deduction justification if needed |
Make Category a dropdown list: Data → Data Validation → List of items. Paste your category list. This prevents typos and keeps categories consistent for the summary formulas.
Tab 2: Monthly Summary
Pull totals by category automatically using SUMIF:
=SUMIF(Log!D:D, "Advertising", Log!E:E)
=SUMIF(Log!D:D, "Insurance", Log!E:E)Add a column for each month by wrapping this in an additional date filter, or just create a simple monthly total for now and add monthly breakdown once the habit is established.
Running total for the year: Sum the monthly totals. This gives you a Year-to-Date view of expenses by category.
Tab 3: Mileage Log
Business mileage is deductible at 67 cents per mile in 2024. Keep a running log:
| Column | Description |
|---|---|
| Date | Drive date |
| Starting location | Where you departed |
| Destination | Where you went |
| Business purpose | Meeting, delivery, supply run, etc. |
| Miles | Odometer end − odometer start |
| Rate | 0.67 |
| Deduction | =Miles × Rate |
Total at the bottom. This is the IRS-required format for mileage deductions.
The Weekly Maintenance Habit
Set aside 15 minutes every Monday morning (or Friday afternoon — wherever fits your routine). In those 15 minutes:
- Open your bank account and credit card statements from the past week
- Log every business transaction into the expense log
- Categorize each one
- Note any receipts you need to find and file
That’s it. Fifteen minutes per week prevents the March nightmare of trying to reconstruct a full year’s expenses from memory and bank statements.
Receipt storage: Take a photo of every receipt immediately. Store in a Google Drive folder organized by month, or use an app like Expensify or Receipt Bank. The IRS accepts digital images.
Expenses Most Small Business Owners Miss
Home office deduction: If you use part of your home exclusively for business, you can deduct a proportional share of rent/mortgage interest, utilities, and internet. Calculate the percentage as your office square footage ÷ total home square footage.
Phone and internet: The business-use percentage of your phone and internet bill is deductible. If you use your phone 60% for business, 60% of the bill is a deduction.
Software and subscriptions: Any tools you use for business — project management software, design tools, accounting software, email marketing platforms. All deductible.
Professional development: Books, courses, conferences directly related to your current business. Not for learning a completely new skill — for improving your current one.
Bank fees: Monthly account fees, wire transfer fees, and merchant processing fees on business accounts are deductible.
Startup costs: In your first year, you can deduct up to $5,000 of startup costs (legal fees, website, early marketing) with the rest amortized over 15 years.
What’s NOT Deductible (Common Mistakes)
Personal expenses run through the business account. If you pay a personal dinner on your business card and call it a “team meal,” that’s not deductible. Keeping business and personal expenses completely separate makes this issue go away.
50% meals rule. Business meals are only 50% deductible, not 100%. Your spreadsheet should track the full amount but your deduction is half. Flag these entries in your Notes column.
Your commute. Driving from home to your regular place of business is never deductible. Driving from your office to a client’s site is.
Personal clothing. Clothing is only deductible if it’s a required uniform or safety equipment that can’t be worn outside work. Regular business casual attire doesn’t qualify.
When to Move to Accounting Software
The spreadsheet approach works well up to around $200K in annual revenue or 50–100 transactions per month. After that, accounting software saves significant time.
Wave is free and imports bank transactions automatically — meaning you’re categorizing instead of typing. QuickBooks goes further with invoicing, payroll integration, and detailed reporting. Both connect directly to your bank so expenses are captured without manual entry.
The trigger for upgrading isn’t a revenue threshold — it’s when you’re spending more time on the spreadsheet than on actual work.
Frequently Asked Questions
Should I track business and personal expenses in the same spreadsheet? No. Keep a dedicated business spreadsheet and a dedicated business bank account. Mixing them creates confusion, makes taxes harder, and raises red flags if audited.
Do I need to keep every receipt? For expenses over $75, the IRS technically requires documentation. For smaller expenses, a bank statement record is usually sufficient. For any single expense over $250, keep the receipt. When in doubt, keep it.
How long should I keep expense records? Three years from the date you filed the return, minimum. Six years if you underreported income. Some accountants recommend seven years as a safe standard.
I’m behind on my tracking. How do I catch up? Block two hours, pull your bank and credit card statements for the months you’re behind, and log everything at once. It’s painful but doable. Going forward, the 15-minute weekly habit prevents this from recurring.
Can I use the same tracker for multiple years? Yes — duplicate the tab for each new year, or just rename and clear the data. Keep previous years archived (never delete them; they’re your tax records).
5 Google Sheets Every Small Business Needs
Cash flow, P&L, mileage log, invoice tracker, and payroll — all free.
No spam. Unsubscribe any time.