Free Expense Tracking Template for Small Business
Every dollar you fail to track is a dollar you cannot deduct. This printable expense log gives you a simple, structured way to record every business purchase with the details the IRS requires. Use it alongside your accounting software — or on its own if you are just getting started. For a complete breakdown of expense categories, see our expense categories guide.
Get this template as Excel + Google Sheets
We'll email you a formatted spreadsheet with auto-calculating totals and category summaries.
Expense Log Template
Print this table and use one sheet per month, or copy the format into a spreadsheet. The 10 sample rows below show how to fill it out.
| Date | Vendor | Description | Category | Amount | Payment Method | Receipt? |
|---|---|---|---|---|---|---|
| 01/03 | Staples | Printer paper, ink cartridges | Office Supplies | $84.50 | Business Visa | Y |
| 01/05 | Zoom | Monthly Pro subscription | Software | $15.99 | Business Visa | Y |
| 01/08 | Shell Gas Station | Fuel for client site visit (42 mi) | Vehicle / Mileage | $38.20 | Business Debit | Y |
| 01/10 | WeWork | January co-working membership | Rent / Lease | $350.00 | ACH Transfer | Y |
| 01/12 | Facebook Ads | Lead generation campaign — Jan | Advertising | $200.00 | Business Visa | Y |
| 01/14 | USPS | Priority mail — contract to client | Postage & Shipping | $9.45 | Cash | Y |
| 01/17 | Adobe | Creative Cloud annual plan (monthly) | Software | $59.99 | Business Visa | Y |
| 01/20 | Hilton Garden Inn | 1-night hotel — conference travel | Travel | $189.00 | Business Amex | Y |
| 01/22 | Panera Bread | Lunch meeting with potential client | Meals (50%) | $32.60 | Business Visa | Y |
| 01/28 | Jane Smith, CPA | Q4 bookkeeping review | Professional Services | $450.00 | Check #1042 | Y |
IRS Expense Category Quick Reference
Use these standard categories to align your expense tracking with Schedule C line items. This makes tax prep significantly faster.
| Category | Schedule C Line | Common Examples |
|---|---|---|
| Advertising | Line 8 | Google Ads, Facebook Ads, business cards, signs, SEO |
| Vehicle Expenses | Line 9 | Mileage (70¢/mi), gas, insurance, repairs, parking |
| Contractor Payments | Line 11 | Freelancers, subcontractors, VAs paid $600+ |
| Insurance | Line 15 | Liability, E&O, workers' comp, property |
| Interest | Line 16a | Business loan interest, credit card interest |
| Legal & Professional | Line 17 | Attorney fees, CPA fees, bookkeeping |
| Office Expenses | Line 18 | Supplies, postage, small equipment under $200 |
| Rent | Line 20b | Office rent, co-working, equipment leases |
| Repairs | Line 21 | Equipment repair, office maintenance |
| Supplies | Line 22 | Paper, ink, cleaning supplies, packaging |
| Taxes & Licenses | Line 23 | Business licenses, state filing fees, payroll taxes |
| Travel | Line 24a | Airfare, hotels, rental cars, baggage fees |
| Meals | Line 24b | Business meals (50% deductible), client dinners |
| Utilities | Line 25 | Phone, internet, electric for separate office |
| Wages | Line 26 | Employee salaries, bonuses, commissions |
| Other Expenses | Line 27a | Software, education, dues, bank fees, gifts |
Monthly Expense Summary Template
At the end of each month, total your expenses by category. This gives you a quick snapshot of where your money is going.
| Category | Week 1 | Week 2 | Week 3 | Week 4 | Monthly Total |
|---|---|---|---|---|---|
| Advertising | $____ | $____ | $____ | $____ | $____ |
| Vehicle / Mileage | $____ | $____ | $____ | $____ | $____ |
| Contractor Payments | $____ | $____ | $____ | $____ | $____ |
| Insurance | $____ | $____ | $____ | $____ | $____ |
| Office / Supplies | $____ | $____ | $____ | $____ | $____ |
| Professional Services | $____ | $____ | $____ | $____ | $____ |
| Rent / Lease | $____ | $____ | $____ | $____ | $____ |
| Software | $____ | $____ | $____ | $____ | $____ |
| Travel & Meals | $____ | $____ | $____ | $____ | $____ |
| Other | $____ | $____ | $____ | $____ | $____ |
| TOTAL | $____ | $____ | $____ | $____ | $____ |
8 Expense Tracking Best Practices
- Record expenses the same day. The longer you wait, the more likely you are to forget details or lose receipts. Make it a daily 2-minute habit.
- Keep every receipt. The IRS requires documentation for all deductions. Use a receipt scanning app (Dext, Shoeboxed, or your accounting software's built-in scanner) to go paperless.
- Use consistent categories. Stick to the same categories all year. Changing categories mid-year makes reports unreliable and tax prep harder.
- Separate personal and business expenses. Never put personal expenses on your business card. If you accidentally do, categorize it as an owner's draw immediately.
- Track cash expenses too. Cash payments are easy to forget. Keep a petty cash log and replenish from your business account so there is a paper trail.
- Note the business purpose. For meals and travel, write down who you met, what you discussed, and the business reason. The IRS requires this for audit protection.
- Reconcile weekly. Match your expense log against your bank and credit card feeds every week. Catching errors early prevents month-end headaches.
- Review monthly totals. Compare each month to the prior month and the same month last year. Sudden spikes or drops usually mean something needs attention.
Disclaimer: This template is for informational purposes only and does not constitute tax or financial advice. Consult a qualified professional for guidance specific to your situation. Last updated March 2026.
Stop chasing receipts
BookkeepingFlow automatically captures, categorizes, and stores every expense so you never lose a deduction.
No credit card required. We'll notify you when we launch.