IRS Schedule C · Form 1040
Free Schedule C Expense Categorizer for Sole Proprietors
Drop in a year of bank and credit card statements. This tool reads them, assigns each transaction to an IRS Schedule C (Form 1040) line, asks you about the merchants it could not place, and hands back a formatted Excel workbook. Everything runs inside your browser — no file is ever uploaded.
1 · Add your files
A full year is fine — add every monthly statement at once so duplicate charges can be spotted across accounts. Photographed receipts and scanned (image-only) PDFs need OCR, which the browser version does not include.
2 · Which category are these?
| Merchant | Txns | Total | Category |
|---|
Your answers are remembered in this browser only, so the same merchant is not asked about again next time. They are never sent anywhere.
3 · Summary
| IRS category | Schedule C line | Txns | Income | Expense | Deductible |
|---|
Files read
| File | Status | Txns | Notes |
|---|
The workbook has six sheets: Summary, All Transactions, Uncategorized, Needs Review, Income and Source Files. Work through Uncategorized and Needs Review by hand — those are the rows the tool would not guess at.
A clean category list is the start, not the end. Whether a cost is genuinely deductible, how much of a home office or vehicle counts, and what belongs on Form 4562 or 8829 all depend on your situation.
Have a CPA review your numbersHow to categorize bank statements for Schedule C (Form 1040)
Schedule C asks sole proprietors and single-member LLCs to report business income on Line 1 and to break expenses out across roughly twenty numbered lines. The work of preparing it is almost entirely sorting: taking a year of transactions and deciding which line each one belongs on. That is what this tool does.
- Download statements, don’t scan them. Export each month as a PDF or CSV from online banking. A downloaded PDF carries a text layer the tool can read; a photo or a scan does not.
- Add every account at once. Business checking, savings and each credit card together. Processing them in one pass lets duplicate charges be caught across accounts — a card payment showing on the bank statement is a transfer, not an expense, and counting it would double up the spending already itemised on the card statement.
- Answer the merchant questions. Anything that matches no rule is grouped by merchant and shown largest-first. Assign a category once and it is remembered for next time.
- Review what it flagged. The workbook’s Uncategorized and Needs Review sheets hold everything the tool would not decide on its own, including duplicates and low-confidence matches.
- Have it checked. Sorting is mechanical; deductibility is judgment. Mixed personal and business use, home office allocation and vehicle method all need a person who knows your situation.
What the tool deliberately will not guess
Some transactions cannot be read from a statement line, and guessing them would be worse than leaving them open. Cash withdrawals do not say where the money went. Person-to-person transfers — Zelle, Venmo, Cash App — could be rent, a subcontractor or paying back a friend. Deposits that are not clearly from a payment processor may or may not be business income; treating every deposit as revenue would overstate what you owe. All of these are put into their own buckets and flagged rather than filed.
Common Schedule C expense categories explained
These are the Part II lines the tool sorts into. Line numbers follow the current Schedule C (Form 1040).
| Line | Category | What belongs there |
|---|---|---|
| 8 | Advertising | Ads, printing, sponsorships, marketing software and SEO work. |
| 9 | Car and truck expenses | Fuel, repairs, tires, parking, tolls and registration. Choose either actual costs or the standard mileage rate — never both. |
| 10 | Commissions and fees | Payment processor fees, marketplace fees and sales commissions. |
| 11 | Contract labor | Payments to freelancers and subcontractors. Over $600 a year usually means filing Form 1099-NEC. |
| 13 | Depreciation and Section 179 | Equipment and vehicles written off over time. Requires Form 4562. |
| 14 | Employee benefit programs | Group health, dental and vision plans for employees. |
| 15 | Insurance (other than health) | Liability, property and professional insurance. Your own health premiums go on Schedule 1, not here. |
| 16b | Interest (other) | Interest on business loans, lines of credit and business credit cards. |
| 17 | Legal and professional services | Attorneys, accountants, bookkeeping and payroll platform fees. |
| 18 | Office expense | Office supplies, postage, shipping and printing. |
| 20a | Rent or lease — equipment | Vehicle, machinery and equipment rentals. |
| 20b | Rent or lease — property | Office, studio, warehouse and coworking rent. Home office rent belongs on Form 8829 instead. |
| 21 | Repairs and maintenance | Repairs, cleaning, pest control and IT support. |
| 22 | Supplies | Materials and consumables used in the work itself. |
| 23 | Taxes and licenses | Business licenses, permits and payroll taxes. Estimated income tax payments do NOT belong here. |
| 24a | Travel | Business trips away from home overnight: flights, hotels and ground transport. |
| 24b | Deductible meals | Business meals, generally 50% deductible. |
| 25 | Utilities | Electricity, gas, water, internet and phone for the business. |
| 26 | Wages | Wages paid to W-2 employees. Your own draw is not a wage. |
| 27a | Other expenses | Software subscriptions, bank fees, professional dues, training and business gifts. |
Three things people commonly get wrong: estimated income tax payments are not a Schedule C expense — they belong on Form 1040. Home office rent goes on Form 8829, not Line 20b. And your own draw is not a wage, however you paid yourself.
100% private, browser-based bank statement parser
Most online statement converters ask you to upload the file. That means handing a full year of account activity — balances, merchants, salary, everything — to a third party you know nothing about, and trusting their retention policy.
This one is built the other way round. The parsing engine, the IRS category rules and the Excel writer all run as JavaScript in your browser. Your statement is read from disk into your own tab’s memory, processed there and written back out as a download. The page makes no network requests after it loads: you can put the browser in airplane mode before choosing a file and everything still works. Nothing reaches quantumcpa.org, so there is nothing for us to store, leak or be asked to hand over.
Frequently asked questions
Is my bank statement data safe?
Your files never leave your computer. The tool reads and processes every statement inside your own browser using JavaScript — nothing is uploaded to our servers, nothing is stored, and closing the tab erases everything. Once the page has loaded you can disconnect from the internet and it will still work.
Which file formats are supported?
PDF bank and credit card statements, CSV exports, and Excel files (XLSX, XLSM, XLS). PDFs must have a real text layer, which is what banks produce when you download a statement from online banking. Scanned or photographed statements and receipt images need OCR, which this browser version does not include.
How do I know if an expense is 100% deductible?
The tool shows an IRS deductible percentage for every category and calculates the deductible amount for you — business meals, for example, are generally limited to 50%. What it cannot judge is whether a cost was genuinely for business at all, or how to split mixed personal and business use such as a home office or a vehicle. Those judgments need a person.
What happens to transactions it cannot categorize?
They are grouped by merchant and shown to you with a dropdown, largest amount first, so the most valuable decisions come first. Anything you leave blank stays in an Uncategorized sheet for manual review. The tool never guesses a category.
Does it remember my answers?
Yes. When you assign a category to a merchant, that rule is saved in your own browser so the same merchant is not asked about again next time. The rules stay on your device and are never sent anywhere.
Can I file my taxes with this?
No. This tool sorts transactions into categories and produces a workbook — it is a starting point for a conversation with your accountant, not a tax return and not tax advice. Review the Uncategorized and Needs Review sheets and confirm the figures with a CPA before filing.
Sorting a year of statements takes minutes. Knowing which of those costs will survive scrutiny takes a professional.
Talk to a CPA about your returnDisclaimer: This tool sorts transactions by matching keywords in their descriptions. It cannot tell a business expense from a personal one, cannot see intent, and will misfile anything worded unusually. Amounts, categories and totals are a starting point for a conversation with your accountant — not a tax return, not tax advice, and not a substitute for professional judgment. Verify every figure before filing.