Schedule C Profit and Loss: How Freelancers Build One

Schedule C is the profit-and-loss language the IRS uses for sole proprietors, single-member LLCs taxed as sole proprietorships, and freelancers paid on 1099s. It asks what the business earned, what it spent, and what was left. Plenty of people only answer those questions in April, with a folder of receipts and a half-remembered year.

A Schedule C profit and loss is that same story kept all year: income in, business expenses out, net profit at the bottom. Build it monthly in a free Google Sheet and tax time is a transfer. Wait until filing season and it is archaeology.

This is general information, not tax advice. Rules depend on your facts. Use the sheet to stay organized and confirm the return with a qualified tax professional.

What a Schedule C profit and loss is

Schedule C (Form 1040) is where sole proprietors report business profit or loss. The profit or loss then flows to the personal return. Freelancers, consultants, and many single-member LLC owners land here even when they never say the words "profit and loss statement."

A P&L, an income statement, and Schedule C are telling the same story at different moments:

• The P&L is the working report you update through the year.
• Schedule C is the annual form that reports that story to the IRS.
• Net profit on a clean P&L is the starting point for the form, not a promise of the exact tax bill. Adjustments, the home-office calculation, and credits can still change what you owe.

The IRS does not require you to attach a spreadsheet. It does require the income and expense figures to be supportable. A year-round P&L is how you get there without reconstructing twelve months in one weekend.

If your business is not a sole prop or single-member LLC — an S corp, a partnership, a larger company — start with the general profit and loss statement template and its Google Sheets guide. This article is the Schedule C path.

What Schedule C asks for

You do not need to reprint the form to use it. Two parts do almost all of the work.

Part I — income

Part I is the top of a P&L:

• Gross receipts — what clients and customers paid you for the work or product.
• Returns and allowances — refunds you gave back.
• Cost of goods sold — direct costs of what you sold, if you have them (materials and merchandise; ask your preparer whether any contractor costs belong in COGS or contract labor). Many pure service freelancers have little or no COGS.
• Gross profit and other income — what remains after direct costs, plus anything else the business earned.
• Gross income — the figure expense lines are subtracted from.

On a monthly self-employed P&L, these are your revenue rows and the gross-profit line.

Part II — expenses

Part II is the operating-expense stack: advertising, car and truck, contract labor, insurance, office expense, supplies, travel, meals, utilities, and the other ordinary costs of running the work. After those, the form reaches tentative profit, then the business use of your home if you qualify, then net profit or loss.

That net profit is the number lenders ask for and the number self-employment tax starts from. It is not a tax return by itself. Keep the receipts and the bank records behind every line.

How to map freelance income and expenses into a monthly P&L

The practical move is one self-employed P&L with a column per month and a year-to-date total. Copy the self-employed profit and loss template, then fill it like this.

Separate business from personal first

Only business income and ordinary, necessary business expenses belong on the statement. A personal grocery run in the expense section understates profit and makes the file harder to defend. A separate business account makes this obvious. Mixed-use costs (a phone that is partly business) belong at the business percentage only.

Put income in by stream

One row per way you get paid: retainer clients, project invoices, product sales, platform payouts. Record the month the income belongs to. A single "money in" cell hides which work actually made the year.

Sort expenses the way Schedule C will

Use categories you can hand a preparer: advertising, software, contract labor, insurance, supplies, travel, meals, car and truck, office. The template's operating-expense section is already framed this way. Transaction-level detail — date, vendor, amount, receipt — lives more naturally in the freelancer expense tracker or the self-employed expense tracker. The P&L should show the monthly totals of those categories, not every coffee.

Read three profit lines, not one

• Gross profit = revenue minus direct costs. Thin gross profit means pricing or delivery cost, not "I bought too much software."
• Operating profit = gross profit minus operating expenses. This is whether the practice covers its overhead.
• Net profit = what is left after the rest of the business costs you included. This is the figure you carry toward Schedule C.

Margins (each profit line divided by revenue) tell you if a good month was actually a good month. The template calculates them so you are not doing that math in the margin of a notebook.

Close the month, then stop

Update the P&L monthly. Twelve honest months beat one heroic April. Export a PDF or share the Google Sheet when a lender, a landlord, or a CPA asks for a current profit and loss. Questions about setup, what to exclude, and what lenders expect are collected on the self-employed P&L questions page.

Self-employment tax starts from net profit

Employees split Social Security and Medicare with an employer. Self-employed people pay both halves on net profit — self-employment tax — on top of income tax. That is why a sloppy P&L is expensive in both directions: missed business expenses inflate profit, and personal spending mixed into the books deflates it.

Net profit on the P&L is the starting point, not the final tax. The home-office calculation, the deductible half of self-employment tax, and other adjustments happen on the return. Do not treat the spreadsheet total as the amount to write to the IRS.

What you can do with the number is plan. If profit is landing every month, set a portion aside so quarterly estimated payments are not a surprise. A sinking funds tracker is a simple place to park that holdback so it does not get spent as take-home pay. Confirm the percentage and the voucher dates with your preparer — this page is not calculating your tax.

Keep the P&L live with Avery

The failure mode is always the same: the sheet is fine, the data entry is not. A Schedule C profit and loss that was last touched in January cannot support an April form or a June mortgage application.

Avery for Google Sheets can import transactions from supported bank accounts. Review suggested categories, check how records map to your worksheet, and reconcile the totals. Avery Pro includes profit-and-loss and cash-flow reports in the app; the spreadsheet and app are distinct workflows.

Avery Pro brings accounts, expenses, invoices and reports together in the mobile and web apps. Business adds recurring invoices, payment reminders and advanced bookkeeping tools. If you prefer a spreadsheet workflow, Avery for Google Sheets imports transactions from supported accounts, with categories and rules for you to review. Compare the plans. The free template also works with manual entry.

Keep going

• Use the sheet: self-employed profit and loss template.
• Quick answers: self-employed P&L questions.
• A P&L that is not Schedule C–specific: profit and loss statement template and the profit and loss statement guide.
• The transactions behind the totals: freelancer expense tracker and self-employed expense tracker.
• Hold the tax cash aside: sinking funds tracker.