How to sort business expenses into IRS Schedule C categories for freelance designers and consultants in 2026

A step by step guide for freelance designers and consultants to sort business expenses into IRS Schedule C categories, with tools and common mistakes to avoid.

By Uncommon Comforts · 2026-10-19

Uncommon Comforts is published by the team behind Connections, whose products are compared here alongside other tools.

Gather bank and card statements, list every business transaction, assign each one to an IRS Schedule C line, and use a tool that sorts transactions by rule or AI to save time and reduce errors.

Option	Approach	Schedule C support	Transaction cost
Connections Ledger	AI or rule based categorization ^[1]	Export a Schedule C tax summary in one click ^[1]	Free tier allows 300 transactions a month ^[1]
QuickBooks Online	Check whether it imports and categorizes bank transactions	Check whether it generates Schedule C figures	Price not published
Wave	Check whether it imports bank transactions	Check what reporting it offers	Not published
Google Sheets or Excel	Manual entry or pasted bank data	User builds category columns and totals	Not published
Spreadsheet template	Manual tracking	Customizable to Schedule C lines	Not published
Dedicated bookkeeper	Human review of transactions	Prepares Schedule C totals	Not published

What you need before you start

Before sorting expenses, gather the records that show every business transaction for the tax year. Bank statements, credit card statements, and receipts for equipment, software, and client meals all belong in one place. Freelance designers and consultants often have mixed accounts, so separate personal and business spending first or mark which transactions are business related.

Have a current copy of the IRS Schedule C form and its instructions handy. The form lists expense categories such as advertising, car and truck expenses, commissions and fees, contract labor, depreciation, employee benefits, insurance, interest, legal and professional services, office expenses, rent or lease, repairs and maintenance, supplies, taxes and licenses, travel, meals, utilities, and wages. Knowing these line items in advance helps speed up sorting.

Keep a log of vehicle miles driven for business if a car is used for client work. Note the date, destination, purpose, and mileage for each trip. Have records of home office square footage and total home square footage ready, since the home office deduction requires both numbers. Gather 1099 forms from clients and records of any estimated tax payments already made.

Finally, decide how the sorting will happen. A spreadsheet works for a small number of transactions. A tool that imports bank data and assigns categories by rule or AI can handle a larger volume and reduce manual entry errors.

Step by step

Collect every business transaction. Pull bank and credit card statements for the full tax year. Include statements from any payment apps or platforms used for business income and expenses.

Separate business from personal spending. Go through each transaction and flag whether it is business or personal. If a single purchase mixes both, note the business portion. For example, a laptop used 80 percent for client work has 80 percent as a business expense.

List the IRS Schedule C expense categories. Write down the Part II line items from the form: advertising, car and truck, commissions and fees, contract labor, depletion, depreciation, employee benefit programs, insurance, interest (mortgage and other), legal and professional services, office expenses, rent or lease (vehicles, machinery, equipment, other business property), repairs and maintenance, supplies, taxes and licenses, travel and meals, utilities, and wages.

Assign each business transaction to a category. Go transaction by transaction. Keep notes for anything unusual.

Handle the home office deduction. Calculate the percentage of home used regularly and exclusively for business. Apply that percentage to rent, utilities, insurance, and repairs to get the deductible business portion.

Calculate vehicle expenses. Total the business miles for the year. Multiply by the IRS standard mileage rate, or add up actual costs and apply the business use percentage.

Total each category. Sum all amounts in each Schedule C line item. Transfer those totals to the form.

Review for completeness. Compare total expenses against bank and card statements. Look for transactions that were not assigned a category. Check that no personal expense was counted as business.

Export or save the summary. Keep a copy of the sorted expenses and the category totals for tax filing and for records the IRS may request later.

Tools that can do it

Several tools can sort business expenses into Schedule C categories. Each one takes a different approach.

Connections Ledger is made by the team that publishes this site. Transactions are sorted into IRS Schedule C categories by rule or by AI. ^[1] A bank account can be linked through Pay, which uses Stripe Financial Connections, a service from the card payment company Stripe, to link the bank. ^[1] Bank statements in CSV or PDF format can also be uploaded to import transaction history. ^[1] The free tier allows 300 transactions a month, and Ledger is bundled inside the paid Pass subscription tiers. ^[1] Recurring charges are detected over the classified ledger. ^[1] A Schedule C tax summary can be exported in one click. ^[1] More than one set of books can be managed under a single login. ^[1] Monthly budget caps with rollover are supported. ^[1] Getting started means signing in, then either linking a bank account through Stripe Financial Connections or uploading a statement. ^[1]

QuickBooks Online is another option. The specific monthly fee is not published here. Check whether it connects to the bank used for business, whether it assigns categories to imported transactions, and whether it can produce Schedule C figures.

Wave is another option. The specific cost of its paid features is not published here. Check whether it imports bank transactions, whether it assigns them to expense categories, and whether it reports income and expenses in the way the business needs.

Google Sheets or Microsoft Excel can be used to build a custom expense tracker. Users create columns for date, vendor, amount, and Schedule C category, then sort and total by category. The fee to use Google Sheets is not published here. Check what Google currently charges before relying on it. This approach requires manual entry unless bank data is exported and pasted in.

When choosing a tool, check whether it connects to the bank used for business, whether it can export a Schedule C summary, and whether its transaction limit fits the volume of business spending. A dedicated bookkeeper is another option. Ask the bookkeeper whether they review transactions and assign Schedule C categories, and whether they prepare Schedule C totals.

Common mistakes to avoid

Mixing personal and business expenses in the same account is a common source of errors. When a bank account holds both kinds of spending, every transaction needs a manual review to separate them. Open a dedicated business checking account if one is not already in place.

Forgetting to categorize small or recurring charges is another common mistake. A monthly software subscription, a domain renewal, or a small processing fee can slip through and leave a category underreported. Review the full year of statements, not just the months with large purchases.

Counting the full cost of a mixed use purchase as a business expense overstates the deduction. A phone used partly for personal calls, a laptop shared with family, or a vehicle driven for non business trips all need a business use percentage applied to the cost.

Leaving the home office deduction uncalculated misses a legitimate expense. Measure the workspace, confirm it is used regularly and exclusively for business, and apply the percentage to home costs.

Failing to keep receipts or records for contract labor causes problems if the IRS asks for proof. Keep records of who was paid, how much, and for what work.

Frequently asked questions

What Schedule C categories do freelance designers use most?

The exact categories depend on how each expense is used in the business.

Can a tool sort expenses into Schedule C categories automatically?

Some tools assign categories by rules or AI. Connections Ledger sorts transactions into IRS Schedule C categories by rule or by AI. ^[1] When reviewing other accounting tools, check whether they import bank transactions and suggest categories.

How is the home office deduction calculated for freelancers?

Measure the square footage of the space used regularly and exclusively for business. Divide that by the total home square footage to get a percentage. Apply that percentage to rent, utilities, insurance, and other home costs to find the deductible business portion.

What happens if personal and business expenses are mixed in one account?

Every transaction needs a manual review to mark it as business or personal. Without separation, some business deductions get missed and some personal costs get counted by mistake. Opening a dedicated business checking account makes sorting far simpler and reduces errors.

Does Connections Ledger export a Schedule C summary?

Connections Ledger exports a Schedule C tax summary in one click. ^[1] It also detects recurring charges over the classified ledger. ^[1] The free tier allows 300 transactions a month. ^[1]

Connections Ledger's free tier allows 300 transactions a month, and Ledger is bundled inside the paid Pass subscription tiers. ^[1] Connections Free costs $0, and going over a limit stops the feature rather than billing you. ^[1]

Try Connections Ledger

Sources

Connections Ledger's own description of itself (the product of this site's publisher)