Profit & Loss Statement: Your Questions Answered
Clear, direct answers to the questions people ask most about the Profit & Loss Statement — setup, categories, taxes, and automation — all in one place.
Get the Profit & Loss Statement (Free)
We’ll email you a copy and open it in a new tab.
We’ll email you a copy and open the template in a new tab. No spam.
Profit and loss statement basics
What is a profit and loss statement?
A profit and loss statement is a financial report that totals your revenue and subtracts your costs and expenses over a set period — a month, quarter, or year — to show net profit or loss. It is the single clearest answer to the question "did my business make money?"
What is the difference between a P&L and an income statement?
There is no difference. "Profit and loss statement," "P&L statement," and "income statement" are three names for the exact same report. Accountants tend to say income statement; business owners and lenders tend to say P&L.
What is the difference between a profit and loss statement and a balance sheet?
A profit and loss statement covers a period of time and shows profitability (revenue minus expenses). A balance sheet is a snapshot at a single date and shows what you own and owe (assets, liabilities, and equity). You usually need both, and they answer different questions.
What should a profit and loss statement include?
A complete P&L includes total revenue, cost of goods sold (COGS), gross profit, operating expenses broken out by category, operating profit, any other income or expense, and net profit. This template has all of these sections pre-built.
Using the template
How do I make a profit and loss statement in Google Sheets?
The fastest way is to copy this template, enter your revenue and expenses into the labeled rows, and let the built-in formulas total gross profit, operating profit, and net profit for you. Building one from a blank sheet means writing those formulas yourself.
How do I customize the expense categories?
Rename, add, or delete any category row. The subtotal and net profit formulas use whole-section ranges, so they keep working as you reshape the categories to match how your business actually spends.
Can I track more than one month?
Yes. The template has a column per month and a year-to-date column that sums them automatically, so you can see trends across the year and compare month over month without rebuilding anything.
How do I read gross profit vs operating profit vs net profit?
Gross profit is revenue minus COGS. Operating profit is gross profit minus operating expenses. Net profit is what is left after everything, including taxes and interest. The template calculates all three plus their margins.
Taxes, lenders, and accountants
Can I use this profit and loss statement for taxes?
Yes. The categories map cleanly to the income and expense lines on a Schedule C or business return, so you (or your accountant) can transfer totals directly. Keep receipts to back up the numbers.
Will a bank accept this P&L for a loan or mortgage?
Lenders ask self-employed borrowers for a profit and loss statement, and a clean, dated P&L with revenue, expenses, and net profit is exactly what they want. Export it as a PDF or share the Google Sheet.
How often should I update my profit and loss statement?
Monthly is the sweet spot for most small businesses. A monthly P&L catches problems early and makes quarterly taxes painless. If you sync with Avery, it stays current continuously.
Automation with Avery
Do I have to enter every transaction manually?
No. Connect Avery and your bank and card transactions flow into the sheet automatically and get categorized, so your profit and loss statement updates itself instead of waiting for a monthly data-entry session.
Does the template still work without Avery?
Completely. You can copy the sheet and type in your numbers by hand forever. Avery just removes the repetitive part so the statement is never out of date.
Is my financial data secure?
Your P&L lives in your own Google account with Google's version history and security. Avery uses read-only bank connections through a regulated aggregator and never moves money.
Keep going