Bookkeeping

Profit and Loss Statement Template for Google Sheets

See whether your business actually made money — month by month, automatically.

Who it’s for: Small business owners, freelancers, bookkeepers, and side-hustlers who need a clean P&L without building one from scratch.
Problem it solves: Most profit and loss templates are static — you re-key every number by hand, so the statement is always out of date when you need it for a loan, a tax return, or a pricing decision.

We’ll email you a copy and open the template in a new tab. No spam.

Key benefits

Pre-built revenue, COGS, and operating expense sections
Automatic gross profit, operating profit, and net profit margins
Monthly columns with year-to-date totals that roll up on their own
Works for sole proprietors, LLCs, and S-Corps
Syncs with Avery so bank transactions flow straight into the statement

The Profit & Loss Statement template gives you a real income statement in Google Sheets without the formula-building, the broken totals, or the blank-page paralysis. Enter your revenue and expenses — or sync them from your bank with Avery — and the template calculates gross profit, operating profit, net profit, and every margin across each month and year-to-date.

Who it's for

This profit and loss template is built for small business owners, freelancers, consultants, e-commerce sellers, and bookkeepers who need a clean P&L they can hand to an accountant, attach to a loan application, or use to make a pricing decision — without paying for accounting software they don't need yet.

What's inside

A revenue section for every income stream
A cost of goods sold (COGS) section that drives gross profit
A fully categorized operating expenses section
Automatic gross profit, operating profit, and net profit with margins
Monthly columns plus a self-summing year-to-date total
A layout that exports cleanly to PDF or Excel for lenders and tax prep

Go deeper

New to this? Read the full walkthrough in our profit and loss statement template guide, or jump straight to the most-asked profit and loss questions for quick, direct answers on setup, taxes, and margins.

FAQ

Frequently Asked Questions

What is a profit and loss statement?

A profit and loss statement (also called a P&L statement or income statement) is a financial report that summarizes your revenue, costs, and expenses over a period of time to show your net profit or loss. This template builds one automatically from the numbers you enter.

Is this profit and loss template free?

Yes. The Google Sheets profit and loss statement template is completely free to copy and use. Enter your email, we send you a copy, and the template opens in a new tab.

Does it work in Excel as well as Google Sheets?

The template is built for Google Sheets, but you can download it as an .xlsx file (File → Download → Microsoft Excel) and the formulas carry over, so it works as a profit and loss template in Excel too.

Can I use this P&L for my taxes or a loan application?

Yes. The statement organizes income and expenses the way accountants and lenders expect, so you can export a clean monthly or year-to-date P&L for tax prep, a bank loan, or an investor.

Do I have to enter every transaction by hand?

Not if you connect Avery. Avery syncs your bank and card transactions into Google Sheets and categorizes them, so your profit and loss statement stays current without manual data entry.

See all 14 questions & answers

Helpful next steps

Related guides

Questions & answers

14 answers on setup, deductions, categories, and taxes — written for answer engines and people in a hurry.

Browse all 14 Q&As →

Need a custom template

Enjoy a 30-day free trial when you join today.

Start for free