Bank CSV Guide
How to Categorize Bank Transactions in Excel for Taxes (2026)
You downloaded your bank transactions as a CSV. Now you need to categorize every one for Schedule C. Here's how to do it in Excel or Google Sheets, step by step, including a few formulas that can speed things up.
Key Takeaways
- Add a Category column to your bank CSV and assign each business transaction a Schedule C line number. That single column is what your accountant or tax software needs.
- Excel formulas like IF and SEARCH can auto-tag common merchants (Amazon, Adobe, Uber), but you will still need to manually review 30 to 50% of transactions that don't match a known pattern.
- The average self-employed person has 500 to 1,500 transactions per year. At 10 to 15 seconds per transaction, manual categorization takes 2 to 6 hours.
- The biggest time sink is not tagging obvious expenses. It is researching ambiguous transactions: what was that $47.32 Amazon charge in July? Office supplies or a birthday gift?
Step 1: Set Up Your Spreadsheet
Open your CSV in Excel or Google Sheets. You should have at minimum three columns: Date, Description, and Amount. Some banks include extra columns like Balance, Check Number, or a generic Category. You can delete those for now.
Add three new columns to the right:
- •Category (the Schedule C line this transaction belongs to)
- •Business/Personal (B/P) (quick flag for filtering later)
- •Notes (for anything you need to remember: what the purchase was, which client it was for, etc.)
Freeze the header row so you can scroll without losing context. In Excel: View → Freeze Panes → Freeze Top Row. In Google Sheets: View → Freeze → 1 row.
Here's what your spreadsheet should look like:
Date | Description | Amount | Category | B/P | Notes
01/15/2025 | ADOBE *CREATIVE CLD | -54.99 | Office Expense (L18) | B | Design software
01/15/2025 | TARGET #1234 | -67.43 | | P |
01/16/2025 | AMZN MKTP US*2K7X9 | -23.87 | Supplies (L22) | B | Printer paper
Step 2: Learn the Schedule C Categories
Schedule C has specific lines for different expense types. You don't need to memorize all of them, but knowing the most common ones will save you a lot of time. Here's a quick reference:
Line 8: Advertising
Facebook ads, Google Ads, business cards, promotional materials.
Line 9: Car and truck expenses
Mileage, gas if using the actual method, parking for business.
Line 10: Commissions and fees
Platform fees from Upwork, Etsy, Stripe, PayPal.
Line 11: Contract labor
Payments to subcontractors, freelancers you hired.
Line 15: Insurance
Liability insurance, E&O insurance, business property insurance.
Line 17: Legal and professional
Accountant fees, legal consultations, tax prep software.
Line 18: Office expense
Software subscriptions, office supplies, postage, ink cartridges.
Line 20b: Rent
Coworking space membership, studio rent, storage unit for business.
Line 22: Supplies
Materials consumed in your business (printer paper, packaging, raw materials).
Line 24a: Travel
Flights, hotels, rental cars for business travel.
Line 24b: Meals
Business meals with clients or prospects (50% deductible).
Line 25: Utilities
Business phone line, internet (business-use portion).
Line 27a: Other expenses
Anything that doesn't fit the categories above. Bank fees, continuing education, professional memberships.
For the complete line-by-line breakdown, see our Schedule C expense categories guide.
Step 3: Tag the Easy Ones First
Don't start at row 1 and grind through every transaction in order. Instead, start with the ones you can identify immediately:
- •Recurring subscriptions. Adobe, Zoom, Canva, QuickBooks, Slack, Google Workspace. These show up every month with the same amount and the same description. Tag them all at once.
- •Regular vendors you recognize. Your coworking space, your insurance company, your accountant. Sort by description to group them together.
- •Obvious personal expenses. Groceries, restaurants where you ate alone, Netflix, gym membership. Mark these as “P” and move on.
This first pass usually handles 50 to 70% of your transactions in about 30 minutes.
Step 4: Use Formulas for Common Merchants
If you have hundreds of transactions, formulas can help you auto-tag the ones that match known patterns. Here's a useful approach using SEARCH and IF in Excel or Google Sheets.
Auto-tag known merchants:
=IF(ISNUMBER(SEARCH("ADOBE",B2)),"Office Expense (L18)",
IF(ISNUMBER(SEARCH("AMZN",B2)),"Check - Amazon",
IF(ISNUMBER(SEARCH("UBER",B2)),"Car/Travel (L9/L24a)",
"")))
Note the limitation: Amazon could be office supplies, business books, or a birthday gift. The formula flags it as “Check - Amazon” so you know to review it manually, but it can't decide the category for you.
Conditional formatting to highlight uncategorized rows:
Select your Category column, then apply a conditional formatting rule: if the cell is blank, highlight it in yellow. This gives you a visual count of how many transactions still need attention.
SUMIF to total amounts by category:
=SUMIF(D:D,"Office Expense (L18)",C:C)
This totals every transaction in column C where column D matches the category string. You'll use this later to get your Schedule C totals.
Step 5: Research the Ambiguous Transactions
This is where the real time goes. After your first pass and your formulas, you're left with the transactions that don't match any pattern and that you don't immediately recognize.
Cryptic merchant codes.
Banks use processing codes that don't look like the business name you know. Some common ones: SQ* means a Square payment (could be any small business), TST* means Toast (usually a restaurant), PAYPAL* followed by a name means a PayPal merchant. If you see a code you don't recognize, Google the first few characters plus “bank charge” and you'll usually find the answer.
Old transactions you don't remember.
A $47.32 charge from eight months ago with a truncated description. Was it business or personal? Check your email for a receipt or order confirmation around that date. Check the merchant's website to see what they sell. Look at the amount and date together: sometimes the combination jogs your memory.
Mixed-use purchases.
An Amazon order that was half business supplies and half personal items. A phone bill that's 60% business. A home internet bill you need to split. For these, you have two options: split the transaction into two rows with the business and personal portions separated, or note the business percentage in the Notes column and apply it when you calculate totals.
This step alone can take 1 to 3 hours for a full year of transactions.
Step 6: Calculate Totals by Category
Once every business transaction has a category, you need totals by Schedule C line. You have two options:
Option 1: SUMIF formulas. Create a summary section in a new sheet or below your data. For each category, use SUMIF:
=SUMIF(D:D,"Office Expense (L18)",C:C)
=SUMIF(D:D,"Advertising (L8)",C:C)
=SUMIF(D:D,"Supplies (L22)",C:C)
=SUMIF(D:D,"Car/Travel (L9)",C:C)
Option 2: Pivot table. In Excel, select your data range, go to Insert → PivotTable, put Category in Rows and Amount in Values. You'll get a clean breakdown in seconds. Google Sheets has the same feature under Insert → Pivot table.
These totals are what you (or your accountant) transfer to Schedule C. Each line number corresponds to a specific row on the form.
The Honest Time Math
Let's be real about how long this takes.
That's for one year, one or two accounts, done carefully. If you have three accounts and haven't tracked anything all year, you're looking at a full day.
The spreadsheet approach works. Thousands of freelancers do it this way every year. But if you're staring at row 200 wondering whether that $31.47 charge was a client lunch or groceries, know that there's a faster option.
Related guides that cover the steps before and after this one:
Same result. A fraction of the time.
Upload your bank CSV and get every transaction categorized into Schedule C lines automatically. The AI reads cryptic merchant codes, handles multi-account files, and flags mixed-use expenses for your review. Minutes instead of 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
Free Self-Employed Expense Spreadsheet Template (2026)
A free spreadsheet template with Schedule C categories pre-built. Paste your bank transactions, tag each one, and get totals by IRS category. Or skip the manual work entirely.
Read moreHow AI Categorizes Your Expenses for Taxes (2026)
Why bank statements say AMZN MKTP US instead of Amazon, how AI reads cryptic descriptions, and how automated tools map transactions to Schedule C categories.
Read moreHow to Clean Up Your Bank CSV for Tax Prep (2026)
Messy CSV exports with cryptic transaction descriptions? Here's how to clean, normalize, and categorize your bank data step by step.
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