Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesFinanceBusiness FinanceCustomer Profitability Analysis

SpreadsheetBusiness FinanceFree

Customer Profitability Analysis

Revenue, direct costs and cost to serve by customer, with margin, ranking and who is unprofitable.

Shown with sample data

Colour

Customer Profitability Analysis

Revenue, direct costs and cost to serve by customer, with margin, ranking and who is unprofitable.

Total profit
$176,775
Overall margin
31%
Loss-making customers
1
Low-margin customers
1
Profit by customer
  • Harbor Logistics$71,700
  • Cedar Health$35,350
  • Atlas Freight$25,975
  • Juniper & Co$20,650
  • Bluepeak$17,300
  • Pine & Paper$6,900
  • Northwind Studio-$1,100

How to use it

  1. 1Set the internal cost per hour on the Settings sheet.
  2. 2Enter each customer’s annual revenue, direct costs and support hours.
  3. 3Sort by margin to find the bottom five.
  4. 4Agree an action for every customer marked Loss-making or Low margin.

In this workbook

  • About
  • What’s included
  • How to use
  • Related resources

About this template

Your biggest customers are not always your most profitable. Enter revenue, direct costs and the hours each account consumes; the analysis prices that time, shows true margin per customer and ranks them, so you know where to raise prices, reduce service or say no.

Who it’s for

  • Annual pricing reviews
  • Agencies with retainers
  • Deciding which accounts to grow

What’s included

  • Customers sheet: One row per customer.
  • Settings sheet: Assumptions.

How to use it

  1. 1Set the internal cost per hour on the Settings sheet.
  2. 2Enter each customer’s annual revenue, direct costs and support hours.
  3. 3Sort by margin to find the bottom five.
  4. 4Agree an action for every customer marked Loss-making or Low margin.
Related searchescustomer profitabilitycost to servecustomer marginaccount profitabilitypricing review

Details

Format
Spreadsheet
Category
Business Finance
Sheets
2
Setup
10 min
Level
Beginner
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetBusiness FinanceFree

Customer Profitability Analysis

Revenue, direct costs and cost to serve by customer, with margin, ranking and who is unprofitable.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
Business Finance
Sheets
2
Setup
10 min
Level
Beginner
Price
Free

Your copy is private to you.

More business finance templates

View all
Subscription Revenue (MRR) Tracker4 sheets

Current MRR

$281,700

ARR

$3,380,400

MRR growth, last month

5%

Net new MRR by month
$6,200
$4,300
$7,800
$8,500
$8,500
Dec 2025Jan 2026Feb 2026Mar 2026Apr 2026
SpreadsheetBusiness Finance

Subscription Revenue (MRR) Tracker

Monthly MRR bridge with new, expansion, contraction and churn, plus churn rate, net revenue retention, quick ratio and ARR.

10 min setupPreview
Capital Budgeting NPV and Payback Analysis5 sheets

NPV

$118,225

IRR (approx.)

15%

Profitability index

1.2

Cumulative cash by year
SpreadsheetBusiness Finance

Capital Budgeting NPV and Payback Analysis

Evaluate an investment the way a CFO does: after-tax cash flows, NPV, approximate IRR, profitability index and simple and discounted payback.

10 min setupPreview
Freelance Income & Tax Set-Aside4 sheets

Income this year

$33,050

Tax reserved

$9,254

Tax still to pay

$2,234

Income by client
44%
  • Brightline Media
  • Granite Partners
  • Cedar Health
  • Oak & Pine Studio
SpreadsheetBusiness Finance

Freelance Income & Tax Set-Aside

Split every client payment into tax, savings and spending, and plan each quarterly tax payment.

10 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ