Profit and Loss Template for Small Business
Use this profit and loss template for small business to turn revenue, costs and expenses into gross, operating and net profit and margins. Free, no upload.
A profit and loss template for small business turns three kinds of numbers into one clear picture: what came in, what the product or service cost you to deliver, and what it cost to run the business. The result is gross profit, operating profit and net profit.
This free Profit and Loss Template from LiveFixPro Bookkeeping lets you rename the lines, add your own, compare against a prior period if you like, and see margins as a percent of revenue.
The calculations run on your own device. Your figures aren't sent, uploaded or stored, and the page works offline once it's open.
The numbers to bring
This period, for example "October 2026," and an optional prior period to compare.
Revenue lines. Sales, service income and other revenue to start.
Cost of goods sold lines. Materials and product costs, direct labor and freight in to start.
Operating expenses lines. Advertising, bank and card fees, insurance, supplies, rent, salaries and labor, software and subscriptions, utilities, professional fees, maintenance and repair costs, vehicle and fuel, and other expenses to start.
Other income. Interest earned to start.
Other expenses. Interest and one-time items. Interest paid to start.
The line names are common starting points. Rename them, delete the ones you don't use and add your own. Use your own numbers, for example from your bank or your QuickBooks® Profit and Loss report. To try it with example figures, tap Load a sample. The sample figures are invented for the demo.
The summary you see
A profit and loss summary for this period, and for the prior period if you entered one, showing:
Revenue and cost of goods sold
Gross profit and gross margin
Operating expenses
Operating profit and operating margin
Other income and other expenses
Net profit and net margin
Each line also shows its share of revenue. Print the summary or download a CSV. In the CSV download, a line or period name that starts with =, +, - or @ gets an apostrophe in front so a spreadsheet shows it as plain text.
How the profit lines add up
Gross profit = revenue minus cost of goods sold.
Operating profit = gross profit minus operating expenses.
Net profit = operating profit plus other income minus other expenses.
Each margin = that profit divided by revenue.
This is a planning summary from your numbers. It isn't a finished set of financial statements, and your accountant may adjust items.
Check it before you rely on it
Compare revenue with your bank deposits for the same period.
Make sure the bank accounts are reconciled, so expenses aren't missing.
Look for large "Other expenses" or uncategorized amounts and give them a proper category.
Run anything unusual past your accountant.
Using a prior period
Enter last month, or the same month last year, in the prior period column. The summary shows the two side by side so you can see which lines moved. Use the same line names for both periods, so the comparison is clean.
What the summary is not
This is a calculator that works from the figures you type. It doesn't read QuickBooks or your bank, and it can't review what you entered. It also isn't accounting or legal advice.
Want help with your monthly profit and loss?
Monthly bookkeeping is published at $499/mo; ask what it covers on the free consult. Book a free consult to go through your latest profit and loss together. See our bookkeeping services and plans.
Related free tools
FAQ
What is a profit and loss template for small business?
A layout that takes your revenue, cost of goods sold and expenses and works out gross profit, operating profit and net profit. This one also shows margins and an optional comparison with a prior period.
What's the difference between gross, operating and net profit?
Gross profit is revenue minus cost of goods sold. Operating profit subtracts operating expenses from that. Net profit adds other income and subtracts other expenses.
Can I rename or add lines?
Yes. The line names are starting points. Rename them, delete the ones you don't use and add your own.
Is this a financial statement?
No. It's a planning summary built from your numbers, and an accountant may adjust items.
Do my profit and loss figures leave my computer?
No. All the work happens in your browser, with no upload, no sending and no storage. Download the CSV when you want a copy.
Run your numbers now
Run your own figures through the template above. If you'd like help with your monthly profit and loss, schedule a free consult.
QuickBooks® is a registered trademark of Intuit Inc. LiveFixPro is independent and not endorsed by Intuit.
QuickBooks® is a registered trademark of Intuit Inc. LiveFixPro is independent and not endorsed by Intuit.
Mailing address: 701 Tillery Street Unit 12-1904, Austin, Texas 78702, United States
Get in touch
Bookkeeping Services FAQs
What are bookkeeping services for small businesses?
Bookkeeping services keep your day-to-day financial records accurate—categorizing transactions, reconciling accounts, and preparing clean books so you can see cash flow and make decisions with confidence.
Who is this for?
U.S. small businesses that want reliable monthly bookkeeping and clear books without hiring a full-time in-house bookkeeper. Deep QuickBooks cleanup is available separately when your books need a catch-up.
What’s included in monthly bookkeeping?
Transaction categorization, bank and credit-card reconciliation, and organized books ready for review.
How is pricing structured?
Monthly Bookkeeping is $499/mo, Support for QuickBooks Users is $149.99/mo, Cleanup for QuickBooks Users is $1,999 fixed one-time, and Catch-up Bookkeeping starts from $799.99 one-time. Final scope is confirmed on a free consultation.
Do you use QuickBooks?
Yes—work is for QuickBooks® users. Cleanup and ongoing bookkeeping can connect to your QuickBooks Online file when that is the right fit. LiveFixPro is independent and not endorsed by Intuit Inc.
How do we get started?
Book a free consultation on our calendar. We’ll confirm scope, access needs, and the right package before work begins: Book a free consultation
Intuit, QuickBooks, and QuickBooks ProAdvisor are registered trademarks of Intuit Inc. used with permission under the QuickBooks ProAdvisor Agreement.