Bank Statements for Schedule C: How to Prepare a Year of Business Transactions
Schedule C is where a US sole proprietor reports business income and expenses. Your bank and card statements are the quickest source for those numbers: download the whole year, convert each statement to a spreadsheet, then give every transaction a category and total each one.
Not tax advice. This guide is about getting your bank transactions into a usable shape for US filing. What you can claim depends on your situation: check the official guidance linked here or ask a tax professional. See our disclaimer.
What Schedule C is for
The IRS describes Schedule C (Form 1040) as the form used to “report income or loss from a business you operated or a profession you practiced as a sole proprietor” (IRS: About Schedule C). It asks for your gross receipts and your business expenses by category, so you need a total for each one.
What the IRS expects you to keep
The IRS lists supporting documents such as sales slips, paid bills, invoices, receipts, deposit slips and canceled checks, and for expenses it mentions account statements and credit card statements alongside receipts (IRS: What kind of records should I keep). Records should show the payee, the amount, proof of payment, the date and what was bought.
A bank statement shows the payee, amount and date, but not always what you bought. That’s why the spreadsheet below has an Evidence column for the receipt or invoice.
Step 1: Download the full year
- For each business checking account, savings account and business credit card, download January to December. Most banks offer CSV for recent months and PDF statements for older ones.
- If you pay business costs from a personal card, download that card too: you’ll mark only the business lines.
- Keep the original PDF statements as well. The spreadsheet is your working file; the bank’s statements are the record.
Step 2: Convert every statement into one spreadsheet
- CSV or OFX downloads: convert to Excel with OFX to Excel, or tidy a CSV with Bank statement to QuickBooks (choose Excel as the output).
- PDF statements: PDF bank statement to Excel; card statements: Credit card statement to Excel.
- Then join the months into one sheet with Combine CSV and Excel files, which also drops duplicate rows where downloads overlap.
Everything runs in your browser, so a year of statements never leaves your computer.
Step 3: Categorize and total
Add these columns next to each transaction:
| Column | What to put there |
|---|---|
| Date, Description, Amount | Straight from the converted statement |
| Business? | Yes, No or Part (for mixed personal and business spending) |
| Category | The income or expense line it belongs to on the form |
| Evidence | Where the receipt or invoice is (file name, folder or note) |
Name your categories after the expense lines on Schedule C, so the totals transfer directly. A pivot table (or SUMIFS) by category then gives one figure per line. Transfers between your own accounts and owner draws aren’t business expenses: mark them so they’re left out.
Step 4: Check before you file
- Total deposits for the year, less transfers and loans, should be close to the gross receipts you report.
- Each account’s opening and closing balance should match the January and December statements.
- Any expense without a receipt is worth a second look before you claim it.
If you use QuickBooks, import the converted files instead and categorize there: see importing bank transactions into QuickBooks Online. To prove a year of statements is complete, a bank reconciliation in Excel takes a few minutes per account.
Frequently asked questions
Can I use bank statements for Schedule C?
They are the easiest source for your income and expense totals, and the IRS lists account and credit card statements among the records that support expenses. Keep receipts and invoices too, because a statement doesn’t always show what was bought.
How do I turn PDF bank statements into a spreadsheet?
Use a PDF bank statement converter to extract the transaction table to Excel, then combine the months into one sheet and add category columns.
Should transfers between my accounts be counted?
No. Moving money between your own accounts isn’t income or an expense. Mark transfers so they are left out of your totals.