Schedule C Expenses from Bank Statements: A Guide

TL;DR If you're a US sole proprietor or single-member LLC owner reporting on Schedule C, your bank and credit card statements are usually the backbone of your income and expense figures. Convert a full year of statements for every account that has business activity, check each statement's balances, remove transfers and card payments so nothing is counted twice, separate personal items, and categorise business transactions to categories that map to Schedule C's expense lines. Then total by category with a pivot table and compare gross receipts with any 1099 forms you received. Keep receipts for business expenses; a bank line shows you paid, not what you bought. This is general information, not tax advice.

Every spring, plenty of freelancers, consultants, gig workers and small business owners face the same job: work out a year of business income and expenses for Schedule C (Form 1040), usually from a pile of bank and credit card statements. If you didn't keep books during the year, the statements are the most complete record you have.

This guide walks through turning those statements into Schedule C totals: which statements to gather, how to convert and check them, how to avoid double counting, how to map categories to the form's lines, a worked example, and the checks to run before you hand numbers to your tax preparer or enter them into software.

Important: this article is general information about organising records, not tax advice. Whether an expense is deductible, and how much, depends on your circumstances and current IRS rules. Line numbers and categories below reflect the general structure of Schedule C; always check the current year's form and instructions, and consult a tax professional for anything you're unsure about.

What Schedule C needs from you

Schedule C reports the profit or loss from a business you operate as a sole proprietor. At a high level it asks for:

• Gross receipts or sales, the business income you received.
• Returns and allowances and cost of goods sold, if you sell products.
• Expenses, grouped into named lines such as advertising, car and truck expenses, contract labour, insurance, legal and professional services, office expense, rent or lease, repairs and maintenance, supplies, taxes and licences, travel, deductible meals, utilities, wages, and other expenses.
• Separate sections for things like vehicle information, home office, and other expenses itemised by type.

Your bank statements can't fill in everything. Depreciation of equipment, the home office calculation and vehicle mileage, for example, need other records. But for most service businesses, the bulk of income and ordinary expenses can be built from statements.

Step 1: gather every relevant statement

List every account that touched business money during the year:

• Business checking and savings accounts.
• Personal accounts, if any business income or expenses went through them.
• Business and personal credit cards used for business purchases.
• Payment platforms such as PayPal, Stripe, Square or Venmo, if clients paid you through them.

Download all twelve monthly statements for each, covering the tax year. If you need older statements than your online banking provides, our guide to getting old bank statements explains the options.

Step 2: convert and check every statement

Convert each statement into rows with Date, Description, Amount and Account columns. SheetStatement reads the PDFs and checks that each statement's opening balance plus transactions equals its closing balance, so you know no rows are missing. The free plan covers 3 pages a month; for a full year of several accounts, a paid plan at $9, $19 or $39 a month is usually more practical, and you can cancel after tax season.

Two checks matter here:

1. Each statement balances. Opening plus transactions equals closing.
2. The months chain. Each month's closing balance equals the next month's opening balance. A break means a missing or duplicated statement.

Stack all months and accounts into one table. Our guide to combining multiple bank statements in Excel shows how to keep a Source file column so every row is traceable.

Step 3: remove transfers and card payments

This is the step that prevents the most common Schedule C error from statements: counting the same money twice.

Tag these rows as Transfer and exclude them from income and expenses:

• Moves between your own accounts, such as business checking to business savings.
• Credit card payments from checking. The purchases on the card are the expenses; the payment just settles them.
• Payment platform transfers to your bank, such as a PayPal or Stripe payout. If you're counting income from the platform's own records, the payout to the bank is a transfer. If you're counting income from the bank deposits instead, then don't also count it from the platform. Pick one source per income stream.
• Owner contributions and draws: money you move from personal to business or back. These aren't income or expenses.

A quick check is to total all rows tagged Transfer across all accounts. If you've included both sides of every internal transfer, the total should be close to zero. A large non-zero figure means one side is missing, or an outside payment was mislabelled.

Step 4: separate personal from business

If any account mixes personal and business activity, add a Business? column and decide each row. Some principles:

• Business expenses generally need to be ordinary and necessary for your business. Personal living costs aren't business expenses, even if paid from a business account.
• Mixed-use items, such as a phone or internet plan used for both, may be partly deductible. Record the full amount, note the business percentage you'll use, and keep your reasoning.
• Personal income, like a refund from a shop or a transfer from a family member, isn't business income even if it lands in a business account.

Our guide to separating personal and business transactions suggests a tagging system that works well with this.

Step 5: categorise to Schedule C lines

Now add a Category column and use category names that map cleanly to the form. A starting set:

Different preparers map some items differently. Software subscriptions, for example, are sometimes placed under office expense and sometimes listed under other expenses. Ask your preparer how they want things grouped, and keep your categories consistent.

To speed up categorising, use a keyword lookup on descriptions. Our guide to Excel formulas for categorising transactions shows the pattern, and our guide to categorising business expenses from bank statements covers judgement calls.

Meals and vehicles need extra care. Business meals are generally only partly deductible, and vehicle expenses can be claimed in different ways (for example actual expenses or a standard mileage rate), each with its own record-keeping requirements. Record the amounts from your statements, but discuss the treatment with your preparer.

Step 6: total with a pivot table

Insert a pivot table from your combined table, with:

• Filters: Business? = Yes, Category ≠ Transfer.
• Rows: Category.
• Values: Sum of Amount.

That gives a total per Schedule C category. Income appears as a positive total and expenses as negatives. Our guide to bank statement pivot tables in Excel explains the setup, and our guide to SUMIFS by month shows a formula-based alternative.

A worked example

A freelance web designer has a business checking account and a credit card used for business. After converting, checking and tagging a full year, the pivot table shows:

Transfers excluded: card payments totalling $9,870.00 from checking to the card, and $22,000.00 of owner draws to the designer's personal account. Neither is an expense.

Before handing this over, the designer runs some checks:

Income check. Two clients paid through a payment platform, which issued a form reporting gross payments. The designer compares the form's total with platform income in the spreadsheet. The platform figure is gross, before fees; the bank received the net. Because the spreadsheet counts income from the bank deposits, the designer adds back the platform fees: the deposits plus the fees equal the form's gross figure, and the fees appear as an expense under platform and payment fees. Our guide to reconciling 1099-K forms to bank deposits walks through this.

Contractor check. The $6,500 to contractors came from three people. The designer lists payments by payee to see whether any information returns may be required, then checks the current filing rules and thresholds with their preparer, because those rules have changed in recent years.

Receipts check. For the larger expenses, the designer confirms there's a receipt or invoice. The bank line proves payment; the receipt shows what was bought and that it was for the business.

The result is a clean set of category totals, each traceable to individual rows, each row traceable to a statement.

A sanity check on the totals

Once the pivot table is done, a couple of quick tests catch big errors before anyone else sees the numbers.

Does the profit make sense? In the example, income less refunds is $67,800.00 and the listed expenses total $16,425.00, leaving $51,375.00 before any items that don't come from statements, such as depreciation or a home office. It's also before any limits that apply to particular categories, such as the partial deduction for business meals, so the figure on the return will differ. Treat this number as a reasonableness check on your data, not as your taxable profit. Compare that with what you'd expect from your invoices and your own sense of the year. If the result looks far too high or too low, the usual causes are a missing account, transfers counted as income or expenses, or personal spending left in.

Do the deposits add up? Total all deposits into the business accounts for the year. Then subtract transfers in, owner contributions, loan proceeds and refunds from suppliers. What's left should be close to your gross receipts. A large gap means something is miscategorised.

Are any months missing? Pivot by month as well as category. A month with no income or no regular expenses, such as software subscriptions, may mean a statement wasn't converted.

If you sell products

Product sellers have an extra layer: cost of goods sold. Purchases of stock and materials appear in your statements, but the cost of goods sold for the year also depends on inventory at the start and end of the year, which no bank statement shows. Categorise stock purchases separately from supplies, keep your inventory counts, and work through the cost of goods sold section with your preparer.

Marketplace sellers should also check whether income should be recorded gross, with marketplace fees as expenses, rather than as the net deposits that arrive in the bank. For marketplace-specific reconciliations, see our guides to Shopify payouts and Amazon seller payouts.

What statements can't tell you

Some Schedule C items need records that don't exist on a bank statement:

• Vehicle use: business mileage logs, and the dates and purposes of trips.
• Home office: the size of the space used for business and the total home size, plus household costs if you use actual expenses.
• Equipment: purchase dates and costs for depreciation or other write-off methods.
• Cash payments: anything paid in cash won't show as a separate line, only as an ATM withdrawal, so keep receipts.

Gather these alongside your spreadsheet so your preparer has everything in one place.

Common mistakes

Counting card payments as expenses. They're transfers. The card purchases are the expenses.

Counting payouts and platform income twice. Choose one source for each income stream.

Including owner draws as expenses. Money you pay yourself as a sole proprietor isn't a business expense.

Treating loan proceeds as income or loan repayments as expenses. Borrowed money isn't income, and repaying principal isn't an expense. Interest on a business loan may be deductible; ask your preparer.

Using calendar months from the wrong year. If statements straddle December and January, filter by transaction date for the tax year.

Relying on bank descriptions alone. A description like "ONLINE PURCHASE" doesn't show what was bought. Keep receipts.

When to involve a professional

A spreadsheet built from statements is an excellent starting point and saves a preparer a lot of time, which can also reduce their fee. But some situations call for professional advice: large equipment purchases, a home office, vehicle use, inventory, hiring people, income from several states, or anything you're unsure is deductible. Bring your categorised spreadsheet, the totals, and the original statements. Our guide to bank statements for tax preparation has more on what preparers usually want.

Next year, keep it simpler

If this year involved a lot of untangling, a few habits help:

• Use one account and one card only for business.
• Convert and categorise statements monthly rather than once a year. Our guide to bookkeeping catch-up from months of statements has a routine.
• Save receipts as you go, named by date and amount.
• Note the business purpose for meals and travel at the time.

Start with your statements

Upload a year of bank and card statement PDFs to SheetStatement, check every balance, and export one combined spreadsheet ready for categorising. The free plan covers 3 pages a month; Starter, Pro and Business plans are $9, $19 and $39 a month.

FAQ

Can I use bank statements to fill in Schedule C?

Bank and card statements are often the main source for income and expense totals, but they should be supported by receipts and invoices, and some items need other records.

How do I avoid counting expenses twice?

Tag credit card payments, transfers between your own accounts and platform payouts as transfers, and exclude them from totals. Count card purchases as the expenses.

Are owner draws deductible?

For a sole proprietor, money you take out for yourself is not a business expense. It's excluded from Schedule C expenses.

Which Schedule C line do software subscriptions go on?

It varies by preparer; some use office expense, others list them under other expenses. Ask your preparer and be consistent.

What if my 1099 form doesn't match my bank deposits?

Forms often report gross amounts while your bank receives net payouts after fees. Reconcile the difference and record the fees as expenses.

Is this tax advice?

No. It's general information about organising records. Check current IRS instructions and consult a tax professional.

How much does SheetStatement cost?

The free plan includes 3 pages a month. Paid plans are Starter at $9 a month, Pro at $19 and Business at $39.