Profit and loss template

Everhour keeps project capacity visible while a profit and loss template turns revenue and costs into net profit.

How much will this projectcost to deliver?

Estimate total cost by combining labor hours, materials, and overhead. Know your numbers before you send the proposal.

$
$
15%

Indirect costs on top of labor + materials

Total project cost
Labor cost$12,000
Materials$2,000
Overhead amount$2,100

Everhour does it all — track, budget, report & invoice

The calculator gives you the number — Everhour takes it from there.

Go ahead — start tracking!

One click and you're timing. Start a timer, add an entry, edit the details. This is exactly how it feels in Everhour.

  • One-click timer — browser, desktop & mobile
  • Works inside Asana, ClickUp, Linear, GitHub & more
  • Simple setup, no learning curve
Works with your favorite tool:
Everhour — Time Tracking
Time Entries
01:24:00
00:31:00
01:07:00

No more budget surprises

Set a budget, assign rates, and get alerted before you're over.

  • Real-time cost tracking
  • Set different rates per person or project
  • Alerts before you hit the budget limit
Everhour — Budgeting
Acme Web Project
1
50% of budget used
$2,500.00of $5,000.00
$2,500.00 remaining
75%
Actual costRemaining cost

Measurement

Track your budget through time or costs

Simple, customizable reports

Every report you need — configured your way, always up to date.

  • See who does what in real time
  • Configure any report
  • Scheduled email reports
Everhour — Reports

Your invoice is ready!

Tracked hours flow straight into a polished invoice — no copy-paste, no manual math.

  • Billable hours straight into the invoice
  • Configure invoice templates
  • Copy invoices to QuickBooks or Xero
  • Invoicing dashboard with status
Everhour — Invoices
Your Company LLChello@yourcompany.com
INVOICE
Invoice #1042
Group by:
DescriptionHoursRateAmount
Website Redesign14h$150/h$2,100.00
Brand Guidelines7h$150/h$1,050.00
Marketing Strategy3.5h$150/h$525.00
Total Due$3,675.00
Try Everhour for real yourself

Turning revenue and costs into profit

What this calculation answers

A profit and loss template answers one practical question: after revenue, cost of goods sold, and operating expenses, did the business or project make money? The first layer is gross profit, calculated as net receipts after returns and allowances minus COGS. The second layer is net profit, calculated after business expenses reduce business income further.

For U.S. small-business tax reporting, COGS matters when production, purchase, or sale of merchandise is an income-producing factor. Most service businesses with no merchandise income factor use net receipts as gross profit. A template should keep those cases separate, because adding a service firm's ordinary operating expenses into COGS can distort gross margin.

Set up the template lines

Start with revenue or net receipts, after returns and allowances. Then list COGS only when the business has goods, production, or merchandise costs. For inventory-based businesses, the COGS structure is beginning inventory plus purchases, labor, materials, and other costs, minus ending inventory. Form 1125-A line 8 carries COGS to the U.S. income tax return.

Operating expenses sit below gross profit. Rent, software, advertising, professional fees, and administrative payroll often belong there rather than in COGS. The United States does not have a federal VAT or national sales tax. State and local sales-tax collections imposed on the buyer and remitted to the government generally stay out of gross receipts or sales.

Calculate gross and net profit

Use the template from top to bottom. Suppose a service project bills 73 hours at $140 per hour, producing $10,220 in revenue. Delivery labor costs 44 hours at $62 per hour, with $1,360 in project materials and $912 in allocated delivery overhead. COGS equals $5,000, so gross profit equals $5,220.

If operating expenses for project management, software, and administration total $1,850, net profit equals $3,370. The template should show each layer rather than one combined profit line. Gross profit explains delivery economics. Net profit shows the amount left after business expenses before income tax, owner draws, financing effects, and items outside the template.

Use it once or manage it continuously

A one-off template is enough for a quote check, monthly owner review, or cleanup before sending numbers to a bookkeeper. It gives a fast structure for revenue, COGS, expenses, gross profit, and net profit. It also exposes missing inputs, such as unassigned project materials or operating expenses that were posted to the wrong section.

A managed workflow becomes necessary when labor capacity changes the result week by week. Everhour Resource Planning shows member and project timelines, weekly capacity, availability gaps, scheduled time off, and planned versus actual time. That workflow helps teams see whether profit drift comes from pricing, staffing, scheduling, or delivery hours before the next template review.

This content is for general information only, may not be fully up to date, and is provided without any warranty or liability.

High Performer

G2

Summer 2026

Best Ease Of Use

Capterra

Summer 2026

Loved by teams. Proven everywhere.

Rated in the top time trackers across G2, Capterra, and TrustRadius — with consistent praise for ease of use, integrations, and support.

10K+Teams worldwide
90K+Installs Everhour extension
196M+Tasks completed
4M+Projects tracked

Frequently Asked Questions

What lines belong in a profit and loss template?

A basic profit and loss template needs revenue or net receipts, COGS when applicable, gross profit, operating expenses, and net profit. Inventory businesses also need beginning inventory, purchases, labor, materials, other production costs, and ending inventory. Service businesses with no merchandise income factor usually start gross profit from net receipts.

How do gross profit and net profit differ in a template?

Gross profit measures net receipts after returns and allowances minus COGS. Net profit goes further by subtracting business expenses from business income. Gross profit shows delivery or product economics. Net profit shows the remaining business result that a U.S. sole proprietor reports through Schedule C and Schedule 1 of Form 1040.

Should sales tax collected from customers appear as revenue?

State or local taxes imposed on the buyer and collected for remittance to the government generally are excluded from gross receipts or sales. Taxes imposed on the seller and collected from the buyer are included in gross receipts. A template should keep sales-tax handling jurisdiction-specific because the United States has state and local sales taxes, not a federal VAT.

Where do inventory costs go in a profit and loss template?

Inventory costs flow through COGS when production, purchase, or sale of merchandise is an income-producing factor. The common structure is beginning inventory plus purchases, labor, materials, and other costs, minus ending inventory. Manufacturers can include direct labor, materials, freight-in, and allocable manufacturing overhead such as factory rent, utilities, depreciation, and supervision.

Can a template show break-even profit?

A profit and loss template can show whether actual revenue covered actual costs, but break-even analysis needs a separate fixed-versus-variable cost split. The unit formula is fixed costs divided by sales price per unit minus variable cost per unit. Contribution margin drives break-even, while COGS drives gross-profit accounting.

How does Everhour Resource Planning support profit reviews?

Everhour Resource Planning shows work on visual timelines by member or project, with weekly capacity, scheduled time off, availability gaps, and planned versus actual time. That helps managers compare the labor plan behind a profit and loss template with the hours the team actually delivered.

Keep project profit visible

Use Everhour Resource Planning to compare capacity, assignments, and planned versus actual time before project costs drift past the profit target.

14-day free trial  ·  No credit card  ·  Cancel anytime

Or