Bank CSV Guide
Free Self-Employed Expense Spreadsheet Template (2026)
If you're self-employed and filing Schedule C, you need your expenses organized by IRS category. Most people reach for Excel or Google Sheets. The problem? Starting from scratch means figuring out which columns you need, what the IRS categories are, and how to structure everything so your accountant can use it. Here's a template that handles the structure so you can focus on the actual categorization.
Key Takeaways
- The template uses six columns: Date, Description, Amount, Category (Schedule C line), Business/Personal flag, and Notes. That's everything you need for tax filing.
- Schedule C has 20 expense categories (Lines 8 through 27a). The template pre-populates the category dropdown with all 20 so you don't have to memorize IRS line numbers.
- A typical self-employed person has 500 to 1,500 transactions per year. Even with a good template, manual categorization takes 3 to 8 hours depending on volume.
- The spreadsheet approach works, but it's slow. The biggest time sink isn't setting up the template; it's deciding the correct category for each of your 800+ transactions.
What the Template Includes
The spreadsheet has six columns. Each one serves a specific purpose for tax filing:
Column A: Date (MM/DD/YYYY)
The transaction date from your bank statement. Use a consistent format so you can sort and filter by date range.
Column B: Description
The merchant name or transaction description. This comes directly from your bank CSV export. You can clean it up or leave it as is.
Column C: Amount
Negative for expenses, positive for income. This matches the convention most banks use in their CSV exports.
Column D: Category (Schedule C Line)
A dropdown with all 20 Schedule C expense categories pre-populated. Pick the correct IRS line for each business transaction.
Column E: Business/Personal (B or P)
Flag each transaction as business or personal. This is the first pass you'll make through the data. Everything marked “P” gets ignored at tax time.
Column F: Notes
Optional, but useful. Document the business purpose of ambiguous expenses here. If the IRS ever asks why you deducted a $200 dinner, “Client dinner with Acme Corp, discussed Q3 project scope” is a much better answer than a blank stare.
Schedule C Categories in the Dropdown
These are the 20 expense categories from IRS Schedule C (Form 1040). The template includes all of them in the Column D dropdown:
Line 8: Advertising
Line 9: Car and truck expenses
Line 10: Commissions and fees
Line 11: Contract labor
Line 13: Depreciation
Line 14: Employee benefit programs
Line 15: Insurance
Line 16a: Mortgage interest
Line 16b: Other interest
Line 17: Legal and professional services
Line 18: Office expense
Line 19: Pension/profit-sharing plans
Line 20a: Rent (vehicles, machinery)
Line 20b: Rent (other business property)
Line 21: Repairs and maintenance
Line 22: Supplies
Line 23: Taxes and licenses
Line 24a: Travel
Line 24b: Meals (50%)
Line 25: Utilities
Line 27a: Other expenses
How to Use It
Six steps from raw bank data to a finished, categorized spreadsheet ready for tax filing.
Step 1: Download your bank and credit card transactions as CSV files
Log into each bank account and credit card, and export your transactions for the tax year. Most banks let you download as CSV from their transaction history page. If you're not sure how, see our guide to downloading bank statement CSVs.
Step 2: Paste your transactions into the template
Open the template and paste your transactions into the Date, Description, and Amount columns (Columns A, B, and C). Leave Columns D, E, and F empty for now. Those are the ones you'll fill in manually.
Step 3: Flag each transaction as Business or Personal
Go row by row through Column E, marking each transaction as B (business) or P (personal). This is the fastest pass because most transactions are obviously one or the other. Your mortgage payment? Personal. Your Adobe Creative Cloud subscription? Business. The ambiguous ones can wait.
Step 4: Assign Schedule C categories to business transactions
For every transaction you marked as B, pick the correct Schedule C category from the dropdown in Column D. This is the slower pass. You'll need to know which IRS line each expense belongs on. The dropdown saves you from memorizing line numbers, but you still need to make the judgment call on each transaction.
Step 5: Add notes for anything that needs context
Use Column F to document the business purpose of any expense that isn't self-explanatory. For example: “Client lunch with Jane Smith, discussed website redesign project” for a meal, or “70% business use” for a phone bill. These notes protect you if the IRS asks questions.
Step 6: Filter and check your totals
Filter Column E to show only “B” transactions. Then use a SUMIF formula (or pivot table) to total the amounts by Schedule C category. These totals are what go on your Schedule C. Double-check anything that looks unusually high or low.
Common Categorization Questions
These are the questions that come up most often when people are working through the spreadsheet row by row.
Where does my phone bill go?
If you have a dedicated business phone line, it goes on Line 25 (Utilities). If you use your personal phone for business, deduct only the business-use percentage and put it on Line 27a (Other expenses). Note the percentage in the Notes column.
What about software subscriptions?
Most software subscriptions go on Line 18 (Office Expense). This covers tools like Google Workspace, Microsoft 365, project management software, and accounting tools. Specialized industry software (e.g., CAD software for an engineer, editing software for a photographer) can go on Line 27a (Other expenses) if you prefer to itemize them separately.
How do I handle mixed-use expenses?
Deduct only the business percentage. For example, if your internet bill is $80/month and you use it 60% for business, deduct $48/month. Record the full amount in Column C, note the business percentage in Column F, and adjust the amount you report on Schedule C accordingly.
What if I don't know the category?
Check our Schedule C expense categories guide for a detailed breakdown of what goes on each line. When in doubt, Line 27a (Other expenses) is a catch-all, but use it sparingly. The IRS prefers expenses in specific categories when one fits.
The Honest Math on Manual Categorization
The template saves you from setting up the spreadsheet. It doesn't save you from the actual work.
Here's what the process actually looks like in terms of time, for a self-employed person with about 800 transactions across all accounts for the year:
Step 1: Business/personal flag
About 5 seconds per transaction. At 800 transactions, that's roughly 1 hour. Most transactions are obviously personal or obviously business, so this pass moves fairly quickly.
Step 2: Schedule C category assignment
About 15 seconds per business transaction. If roughly 300 of your 800 transactions are business-related, that's around 1.25 hours. This step is slower because you need to think about which IRS line each expense belongs on.
Step 3: Review and fix mistakes
About 30 minutes to scan your totals, spot anything that looks wrong, and correct miscategorized transactions. You'll find some.
Total: 3 to 4 hours for a clean, categorized spreadsheet. That's the best case.
If you're catching up on a full year you didn't track, and descriptions like “AMZN MKTP US*2K7X9” don't ring any bells, double it.
Or skip the spreadsheet entirely.
Upload your bank and credit card CSVs to Categorize My Expenses. Every transaction gets categorized into the correct Schedule C line automatically. You review the results, adjust anything that needs fixing, and download a report. A fraction of the time instead of 4 hours. $39.
Disclaimer: This article is for educational purposes only and does not constitute tax, legal, or financial advice. Tax rules change, and individual situations vary. Consult a qualified tax professional for advice specific to your situation. Categorize My Expenses is a financial data organization tool. It is not a tax preparer and does not provide tax advice.
Related Guides
How to Categorize Bank Transactions in Excel for Taxes (2026)
A step-by-step guide to categorizing your bank and credit card transactions in Excel or Google Sheets for Schedule C. Includes formulas, category lists, and the honest time math.
Read moreSelf-Employed Tax Deductions Guide (2026)
Schedule C categories in plain English, commonly missed deductions by profession, partial deductions, record-keeping, and more.
Read moreCategorize My Expenses vs. Spreadsheets: Which Is Better? (2026)
Spreadsheets are free but take hours. Here's an honest comparison of manual spreadsheet tracking vs. automated categorization for self-employed tax prep.
Read moreSchedule C Expense Categories: A Line-by-Line Guide (2026)
The definitive reference for which expenses go on which Schedule C line. Every line from 8 to 27a explained with real transaction examples.
Read more