DocuClipper logo
Back to blog

How to Fill Out Schedule C From Your Bank Statements (Line-by-Line Map)

By DocuClipper Editorial Team, Financial document automation specialists
8 min read

No bookkeeping software? You can build Schedule C straight from your bank and credit card statements: total your business income, map every expense to its Schedule C line, and leave out the transactions that do not belong.

You can fill out Schedule C directly from your bank and credit card statements. Put the year's transactions into one spreadsheet, label each business expense with its Schedule C line, total your business income for line 1, and leave out everything that is not business income or a deductible expense. The line map below shows where common transactions go.

This guide is for sole proprietors and single-member LLCs that file Schedule C. It is general information, not tax advice; a preparer can confirm anything specific to your situation.

While you are here

Extract every transaction from any bank PDF

Upload a statement from any bank and DocuClipper returns a clean table with dates, amounts, descriptions, and running balance intact. No reformatting before you can reconcile or import.

What Schedule C needs from your statements

Part of Schedule CWhat it needsWhere it comes from
Part I, line 1Gross receiptsBusiness deposits, plus card and payment-app sales
Part I, line 2Returns and allowancesRefunds you gave customers
Part II, lines 8 to 27bExpenses by categoryBusiness payments from bank and card statements
Part IIICost of goods soldInventory and materials purchases, if you sell products
Part VItemized "other expenses"Anything that fits no line in Part II

Step 1: Get the whole year into one spreadsheet

Collect statements for every account that business money passed through: business checking, credit cards, PayPal, Venmo, Square or Stripe, and any personal account you used for the business.

Typing them in is slow and error-prone, so convert them. A bank statement converter such as DocuClipper turns PDF and scanned statements into Excel or CSV and checks each statement against its printed opening and closing balances, so a missing page or misread amount is flagged before it reaches your tax return. Combine every account into one sheet with columns for date, description, amount, account and Schedule C line.

Step 2: Remove what does not belong on Schedule C

Before categorizing anything, mark these so they stay out:

  • Transfers between your own accounts. Moving money from checking to savings, or paying your business credit card from checking, is neither income nor expense. Count the card's purchases, not the payment to the card.
  • Loan proceeds and loan principal payments. Only the interest is deductible (line 16b).
  • Owner draws and personal spending. Money you take out for yourself is not a business expense.
  • Federal and state income tax payments, including estimated taxes. These are paid on your Form 1040, not deducted on Schedule C.
  • Your own health insurance and retirement contributions. These are generally deducted on Schedule 1, not Schedule C.
  • Equipment and other assets that last more than a year. These are usually depreciated or expensed under section 179 on line 13 (Form 4562), not deducted as supplies.

Step 3: Map every business expense to its line

LineCategoryTypical transactions
8AdvertisingGoogle or Meta ads, website ads, printed flyers, sponsorships
9Car and truck expensesBusiness share of gas, repairs, insurance, or the standard mileage rate (choose one method)
10Commissions and feesSales commissions, marketplace and platform fees (Etsy, Amazon, Upwork)
11Contract laborPayments to freelancers and contractors (you may owe them a 1099-NEC)
13Depreciation and section 179Computers, equipment, furniture and vehicles (via Form 4562)
15Insurance (other than health)Liability, professional, business property insurance
16bInterest (other)Interest on business loans and business credit cards
17Legal and professional servicesAccountant, attorney and bookkeeper fees
18Office expensePostage, small office items, office software that is not a subscription you list elsewhere
20a / 20bRent or lease20a vehicles, machinery and equipment; 20b office or other business property
21Repairs and maintenanceRepairs to business equipment and property
22SuppliesMaterials and supplies used up in the business
23Taxes and licensesBusiness licenses, permits, sales tax you paid, the employer share of payroll taxes
24aTravelAirfare, hotels and transport for overnight business travel
24bDeductible mealsBusiness meals, generally 50% of the cost
25UtilitiesBusiness phone and internet, utilities for business property
26WagesEmployee wages (not payments to yourself or contractors)
27bOther expensesSoftware subscriptions, bank and card processing fees, education, dues; itemize in Part V
30Business use of homeHome office, figured on Form 8829 or with the simplified method

Lines 12 (depletion), 14 (employee benefit programs), 16a (mortgage interest on business property), 19 (pension and profit-sharing plans for employees) and 27a (energy efficient commercial buildings) apply to fewer businesses. For more category examples, see 50 common business expense categories.

Mixed-use costs. For a phone, internet or car used partly for personal purposes, deduct only the business share and keep a note of how you worked it out.

Put it into practice

Manual copy-paste is where errors begin

Split rows, drifting balances, missed transactions: they all trace back to re-keying. DocuClipper preserves the bank's layout so debits, credits, and totals tie out the first time.

Step 4: Total your income and check it against your 1099s

Gross receipts on line 1 are all the money your business took in, whether or not you received a 1099 for it.

  1. Total the business deposits you marked as income: customer payments, sales, and payouts from payment apps and marketplaces.
  2. Compare against every 1099-NEC and 1099-K you received. A 1099-K reports the gross amount, before platform fees and refunds, so report the gross on line 1, refunds on line 2, and the fees as an expense (line 10 or 27b). See how to reconcile a 1099-K that doesn't match your deposits.
  3. If a 1099 does not appear in your deposits, find out why before you file: the money may have landed in an account you missed.

Step 5: Total each line

In Excel or Google Sheets, a pivot table with Schedule C line as rows and amount as values gives you every number on the form in one view. Review the biggest items in each line against receipts or invoices; a bank line shows you paid, not what you bought.

Then enter the totals on Schedule C, or hand the sheet to your preparer. Net profit on line 31 also drives self-employment tax on Schedule SE.

If you are doing this for past years

The process is the same for each year, one year at a time. If you have unfiled years, also pull your IRS Wage and Income Transcripts to see which 1099s the IRS has on file; see how to rebuild your books from bank statements. If you want accounting software for it, see the best catch-up bookkeeping software.

How DocuClipper helps

DocuClipper converts a year of bank, credit card and payment statements into one spreadsheet, scanned statements included, and checks every statement against its printed balances. It categorizes transactions automatically, and you can use your own category list, including Schedule C lines, so the pivot table is nearly done when the file arrives. See also how to compile and categorize transactions for your accountant.

FAQ

Can I fill out Schedule C using only bank statements?

Yes, bank and credit card statements give you most of what Schedule C needs: business income from deposits and expenses from payments. Keep receipts or invoices for larger expenses, because a bank line shows that you paid but not what you bought.

Do transfers between my accounts count as income on Schedule C?

No. Transfers between your own accounts, loan proceeds and refunds are not income. Leave them out of gross receipts, and keep the matching statement entries in case you need to show where the money came from.

Where do software subscriptions go on Schedule C?

Most preparers put software subscriptions under other expenses, itemized in Part V and totaled on line 27b. Some use office expense on line 18. Pick one and use it consistently.

Are credit card payments a business expense?

The payment to the card is not. The individual business purchases on the card are, each on its own Schedule C line, plus any interest on the card as line 16b.

What if my 1099-K is higher than my deposits?

A 1099-K reports gross payments before fees, refunds and chargebacks. Report the gross amount on line 1, refunds on line 2, and platform fees as an expense, so the form reconciles with the 1099-K.

Do I need bookkeeping software to file Schedule C?

No. A spreadsheet with one row per transaction and a Schedule C line column is enough for many sole proprietors. Software helps if you will keep the books all year or have a lot of transactions.

Written by the DocuClipper editorial team. Last updated October 29, 2026. General information, not tax advice.

Next step

Upload your first statement free

No credit card required. See extracted transactions in seconds, then export to Excel, CSV, or QBO when you're ready to scale.

Try DocuClipper free

Automate your financial document workflows

Extract data from bank statements, invoices, and receipts with 99.9% accuracy. Export to Excel, QuickBooks, or Xero in seconds.

Start free trial14-day free trial · No credit card required