Free Business Expense
Category Template
15 IRS-aligned expense categories, Schedule C line numbers, and 50+ example transactions. Excel and CSV formats. Ready to use in 30 seconds.
Works with Excel, Google Sheets, QuickBooks, Xero, and FreshBooks
What's Inside the Template
Three sheets to cover your full expense tracking workflow:
Transactions Sheet
50+ pre-filled example rows across all 15 categories. Delete the examples and replace with your own transactions.
IRS Categories Reference
Every category mapped to its Schedule C line number, deductibility %, common examples, and IRS notes.
Annual Summary
Month-by-month grid for all 15 categories. Total each category across the year — ready to hand to your accountant.
All 15 Expense Categories
| Category | Deductible |
|---|---|
| Meals & Entertainment | 50% |
| Travel | 100% |
| Software & Subscriptions | 100% |
| Office Supplies | 100% |
| Advertising & Marketing | 100% |
| Professional Services | 100% |
| Utilities & Telecom | 100% |
| Vehicles & Transportation | Business % |
| Insurance | 100% |
| Education & Training | 100% |
| Equipment & Hardware | 100% (Sec 179) |
| Healthcare & Medical | 100% |
| Bank Fees & Finance | 100% |
| Home Office | Business % |
| Personal – Non-deductible | 0% |
How to Use This Template
Convert your credit card statements to Excel
Upload your credit card PDF statement to CreditCardToExcel.com. The AI extracts all transactions (date, merchant, amount, category) in about 30 seconds — no manual data entry. Download as Excel or CSV.
Paste transactions into the Transactions sheet
Copy the extracted transactions from CreditCardToExcel into the Transactions sheet. The Category column is pre-filled with the AI's auto-categorization — adjust any that need reclassification.
Review categories using the IRS Reference sheet
Check the IRS Categories Reference sheet to confirm each transaction is assigned to the right Schedule C line. Pay special attention to meals (50% only), vehicles (business % only), and home office (Form 8829).
Use SUMIF formulas to populate the Annual Summary
In the Annual Summary sheet, use SUMIF to total each category by month: =SUMIF(Transactions!D:D,"Meals & Entertainment",Transactions!C:C). By December, you'll have a complete annual expense breakdown ready for your accountant.
Pro tip: run this workflow monthly
The best time to categorize transactions is right after the statement closes — while you still remember what each charge was for. A 10-minute monthly review eliminates the year-end scramble. See our expense categorization guide for a deeper walkthrough.
Frequently Asked Questions
Is the template really free?
Yes — completely free. Download the Excel or CSV version with no signup, no email required, and no strings attached.
Can I use this template with Google Sheets?
Yes. Download the Excel (.xlsx) version and open it in Google Sheets, or download the CSV and import it via File > Import. All formulas and column structures work in Google Sheets.
How do I get my credit card transactions into the template?
Use CreditCardToExcel.com to convert your PDF statement to Excel in about 30 seconds. The AI extracts every transaction with date, merchant, amount, and category. Then paste those transactions into this template's Transactions sheet.
What's the difference between Schedule C line 18 (Office Expenses) and line 22 (Supplies)?
Line 18 (Office Expenses) covers items used in the office: paper, postage, printer ink, small office tools. Line 22 (Supplies) covers materials consumed in your business operations — raw materials for a trade, cleaning supplies for a service business, etc. When in doubt, Line 18 is the safer choice for typical office purchases.
Can I import this template into QuickBooks?
The CSV version can be imported into QuickBooks Online via Banking > Upload transactions. Map the Date, Description, and Amount columns during import. Category assignment happens in QuickBooks after import using your chart of accounts.
My credit card mixes personal and business expenses. How do I handle that?
The template includes a "Personal – Non-deductible" category. Assign personal transactions there. At year-end, only the deductible categories go on your Schedule C. If you use a personal card partly for business, you'll want to add a "Business %" column and calculate the deductible portion.
Related Resources
Credit Card Statement to Excel: The Complete Guide
Step-by-step guide to converting any credit card statement PDF to Excel.
How to Categorize Credit Card Expenses for Taxes
IRS Schedule C categories, common mistakes, and tools that automate it.
How to Track Business Credit Card Expenses
Monthly system for business expense tracking with multiple cards.
How to Import into QuickBooks
Import your categorized CSV directly into QuickBooks Online or Desktop.
Ready to fill the template?
Convert your credit card statement PDF to Excel in 30 seconds. Then paste those transactions straight into this template.