Spreadsheet for Tax Preparation: Self-Employed Setup

Quick Answer: A self-employed tax spreadsheet is a list of every business transaction from your bank and card statements, each tagged with the IRS Schedule C line it relates to, plus a totals tab that sums each line for the year. Set up an Income tab, an Expenses tab with a Line column and a business-use percentage, and a Lines tab that totals them with SUMIFS. Your preparer gets numbers by line, backed by statements.

Tax time is easier when the numbers already match the form. For sole proprietors and single-member LLCs that form is usually Schedule C, which the IRS describes as the place to report income or loss from a business you operated or a profession you practiced as a sole proprietor. Key your spreadsheet to its line numbers and a year of statements becomes a page of totals.

This guide covers organizing records; it is not tax advice, and your preparer decides how each amount is reported.

Which Schedule C lines should the spreadsheet use?

The IRS's Instructions for Schedule C name each line. Put these on a tab called Lines, with the line number in column A and the label in column B:

The instructions also cover lines this list skips, such as depreciation (13), wages (26), the home office line (30) and the cost of goods sold section in Part III. Add those if they apply. Items that land on line 27b get described individually in Part V, so give them a short description column.

What does the Expenses tab look like?

The IRS's list of records to keep for expenses includes canceled checks or other proof of payment, account statements, credit card statements and invoices. Column H is where you note which of those backs each row.

What does the Income tab look like?

Keep income on its own tab with: Received date, Payer, Amount, Line (1, 2 or 6), Form (1099-NEC, 1099-K or none) and Source. When your 1099 forms arrive in January, a pivot or SUMIFS by Payer shows whether each payer's total matches their form. Deposits that aren't income, such as transfers from savings or a loan, belong on a separate list so they never reach line 1.

How do you total each line?

On Lines, add column C for the total. For expense lines:

=SUMIFS(Expenses!$F:$F, Expenses!$D:$D, $A2, Expenses!$A:$A, ">="&DATE(2026,1,1), Expenses!$A:$A, "<="&DATE(2026,12,31))

For income lines, the same with the Income tab's amount and line columns. Line numbers like 16b and 24a are text, so format column A on both tabs as text to keep the match reliable.

Then add two checks:

• Uncoded rows: =COUNTIFS(Expenses!$C:$C, ">0", Expenses!$D:$D, "") should be zero.
• Coverage: total of column C on Expenses minus total of column F shows how much you marked as personal. If that number surprises you, look at the Biz % column.

How do you fill it from your statements?

Work account by account, a quarter at a time if you pay estimated taxes, or once a year if you don't.

1. Collect every statement for the year for each business account and card, plus any personal card you used for business.
2. Turn the statements into rows. A bank CSV export is fine when available. For PDFs, QuickBankConvert produces one row per transaction with date, description and signed amount; the free account covers three statements a month, and the pricing page lists larger plans for a full year at once.
3. Paste money-out rows into Expenses and money-in rows into Income, with the Source filled.
4. Assign lines. Sorting by Payee lets you code every charge from the same vendor in one pass.
5. Remove or zero out personal rows from mixed accounts by setting Biz % to 0.
6. Tick off the Proof column as you match receipts.

Our deduction categories guide explains how common statement rows are usually categorized, and the freelancer 1099 guide covers matching income to forms.

Which items need records beyond the bank statement?

Some lines depend on information no statement contains:

• Car and truck expenses need a mileage log showing dates, destinations and business purpose; fuel charges alone don't show business use.
• Meals and travel need the business purpose and who attended or why you travelled.
• Home office needs the size of the space and the home's total costs.
• Equipment needs the purchase date and cost, because it may be depreciated rather than deducted at once.

Keep these on extra tabs in the same file, so everything your preparer needs is in one place.

What if you have a UK sole trader or non-US setup?

The structure transfers; the line list doesn't. A sole trader in the UK would replace the Lines tab with the expense boxes on the self-employment pages of the Self Assessment return, and someone in another country with that country's business income form. Keep the same columns, Total, Biz %, Business amount, What for, Proof and Source, because every tax authority asks the same underlying questions: what was it, how much was business, and how can you prove it.

Currency matters too. If you are paid in more than one currency, add an Original amount and Currency column, and record the converted amount as it landed in your bank, since that is what the statement proves.

What do you hand to your preparer?

• The Lines tab with totals.
• The Income and Expenses detail, so they can test any line.
• The year's statements as PDFs, named by account and month.
• Receipts for larger items, and the mileage and home office tabs.

Keep the spreadsheet with the return; the IRS's record retention guidance sets the general period at three years from filing, longer in some cases. For a small business with more moving parts, see small business tax prep from bank statements.

Related guides

• Bank statement deduction categories
• Freelancer tax prep and 1099s
• Small business spreadsheet for income and expenses