Profit and Loss Statement Template
Use the builder below to enter revenue and expenses, see profit and margins update live, and download the filled result. The blank Excel workbook has live formulas and a filled example sheet, and the CSV and print ready PDF are available immediately.
Build a profit and loss statement
Enter revenue and costs by category. The totals, gross margin, and operating margin update as you type, then the filled statement downloads as a real workbook or PDF.
Revenue
Direct costs
Operating expenses
Other income
Other expenses
Gross profit
$70,000.00
Operating income
$40,000.00
Net income
$40,000.00
Gross margin
70%
Operating margin
40%
Blank files for offline work
Email me a copy and useful tips
The download stays available without an email address. Add yours only if you want the link in your inbox and occasional practical bookkeeping guidance.
Use the result with current books
Use this result with the bookkeeping by industry guides and software comparisons that fit your business. GlacialBooks features explain how the underlying records stay current, and current pricing shows the path from a free tool into the product.
Template structure
Revenue: sales, service revenue, and other operating revenue. Direct costs: materials, fulfillment, direct labor, and merchant costs when your accounting policy treats them as direct. Operating expenses: payroll, rent, software, insurance, professional services, travel, and other overhead. Finish with other income, other expense, taxes, and net income.
Monthly close checks
Reconcile every bank and card account to its statement. Confirm revenue cutoffs, unpaid bills, payroll liabilities, loan balances, and owner transactions. Compare the result with the prior month and investigate changes that are material to the business.
How to use the result
Review gross margin, operating margin, and expense trends in both dollars and percentages. A clean statement should let you trace each figure back to ledger entries and source activity.
Frequently asked questions
What period should a profit and loss statement cover?
Monthly statements are useful for operating decisions. Quarterly and annual views help show seasonality and longer trends.
Is cash balance the same as profit?
No. Loan payments, owner contributions, asset purchases, unpaid invoices, and unpaid bills can make cash movement differ from profit.
Should every expense be grouped together?
No. Use categories that support decisions while keeping the chart of accounts stable enough for reliable comparisons.
Sources
Reviewed 2026-07-18.
Related guidance
Small Business Invoice Template
Create a small business invoice with a live preview and downloadable PDF, or download the blank Excel and PDF templates.
Small Business Chart of Accounts Template
Download populated chart of accounts workbooks and CSV files for a service business, ecommerce seller, or contractor.
Bookkeeping Cleanup Estimator
Estimate bookkeeping cleanup effort and cost from months behind, accounts, transaction volume, missing statements, payroll, and unresolved balances.
Bookkeeping for restaurants
Connect food, labor, sales, and processor activity to a statement that stays traceable.
Bookkeeping for service businesses
Keep delivery costs, overhead, billing, and margin visible by period.