# ERP Vendor Quote Comparison Worksheet (Five Year Normalised)

> Source: https://netray.co/tools/erp-vendor-quote-comparison-worksheet
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

Put every vendor's quote line on the same footing: one time fees, annual fees, years and an uplift, giving a comparable five year total.

## Category

erp-migration

## Audience

- CFO
- CIO
- Procurement
- ERP project lead

## Tool

**Kind:** worksheet

**Mode:** editable

**Currency:** $

**Columns:**

#### Vendor

**Key:** vendor

**Type:** text

#### Quote line

**Key:** item

**Type:** text

#### Type

**Key:** type

**Type:** select

**Options:**

- One time
- Annual
- Per user per year

#### Unit price

**Key:** unit_price

**Type:** number

**Format:** currency

#### Quantity

**Key:** qty

**Type:** number

#### Years charged

**Key:** years

**Type:** number

#### Annual uplift (%)

**Key:** uplift

**Type:** number

#### Five year cost (approx)

**Key:** five_year

**Type:** number

**Expr:** unit_price * qty * years * (1 + uplift / 100 * (years - 1) / 2)

**Format:** currency

#### Assumption / exclusion

**Key:** notes

**Type:** text

**Rows:**

**Vendor:** Vendor A

**Item:** Cloud subscription, 120 users

**Type:** Per user per year

**Unit price:** 1800

**Qty:** 120

**Years:** 5

**Uplift:** 5

**Notes:** Price lock for 3 years only

**Vendor:** Vendor A

**Item:** Implementation services

**Type:** One time

**Unit price:** 650000

**Qty:** 1

**Years:** 1

**Uplift:** 0

**Notes:** Time and materials estimate

**Vendor:** Vendor B

**Item:** Perpetual licence, 120 users

**Type:** One time

**Unit price:** 2200

**Qty:** 120

**Years:** 1

**Uplift:** 0

**Notes:** Excludes integration add-ons

**Vendor:** Vendor B

**Item:** Annual maintenance

**Type:** Annual

**Unit price:** 58000

**Qty:** 1

**Years:** 5

**Uplift:** 4

**Notes:** Percent of licence

**Vendor:** Vendor B

**Item:** Implementation services

**Type:** One time

**Unit price:** 540000

**Qty:** 1

**Years:** 1

**Uplift:** 0

**Notes:** Fixed price design, T&M build

**Vendor:** Vendor B

**Item:** Infrastructure and DBA

**Type:** Annual

**Unit price:** 36000

**Qty:** 1

**Years:** 5

**Uplift:** 3

**Notes:** Our estimate, hosted in own datacentre

**Totals:**

#### Combined five year cost (all lines)

**Key:** five_year

**Agg:** sum

**Format:** currency

**Summary:**

#### Quote lines

**Key:** lines

**Expr:** count

**Format:** integer

#### Average line cost

**Key:** avg_line

**Expr:** sum_five_year / count

**Format:** currency

**Primary:** true

**Notes:** Filter by vendor in Excel after export and sum each vendor's lines to compare totals. The uplift formula applies the average increase over the years charged as a simple approximation; replace it with year by year figures if your quote gives a price schedule. Always add internal staff time, training, data migration and contingency, which are rarely in vendor quotes.

## Content

**Intro:** ERP quotes arrive in different shapes: perpetual licence plus maintenance, per user subscription, tiered bundles, fixed price and time and materials services. This worksheet puts every line on a five year basis so you compare cost, not presentation.

**Sections:**

#### How to use the worksheet

**Body:** Enter one row per line item from each vendor quote: vendor, item, price type, unit price, quantity, years charged and expected annual uplift. The sheet estimates the five year cost per line. Add your own lines for what vendors leave out, such as infrastructure, backup, integration licences and third party tools. After exporting to Excel, filter by vendor and total each section to compare.

**Bullets:**

- One time fees use years = 1
- Subscriptions use years = 5 and the real uplift cap
- Include your own costs on separate lines
- Note every exclusion in the last column

#### Normalising different pricing models

**Body:** A perpetual licence has a large up front fee and annual maintenance, commonly a percentage of the licence. A subscription spreads the cost and includes upgrades, but rises with users and often with annual uplift clauses. Over five years the totals can be similar, but cash flow and risk differ. Treat infrastructure, support tiers and extra modules as part of the comparison, because a lower base price often hides add-ons.

#### Hidden costs to add

**Body:** Quotes seldom include internal staff time, backfill for key users, training, data cleansing, testing environments, extra integrations, custom reports, change management, post go-live support and contingency. For many ERP programs the services and internal costs exceed the software cost. Add them as lines for every vendor using the same assumptions so the comparison stays fair.

#### Common mistakes

**Body:** Comparing year one cost only, ignoring uplift caps, forgetting that user counts grow, and treating a time and materials estimate as a fixed price. Ask each vendor to confirm in writing what is included, what the uplift cap is and what triggers repricing. Use the summary here for orientation, then build a full total cost model for the finalists.

**Cta:** If you want a modelled five year total that also includes AI, reporting and integration costs on your current Infor or NetSuite platform, Netray can help build it.

**Faq:**

#### How is the five year cost estimated?

**Answer:** Each line multiplies unit price, quantity and years charged, then applies an approximate average uplift across the years. It is a quick comparison, not an accounting forecast. For precise figures use the year by year price schedule from the vendor.

#### Should I discount future costs?

**Answer:** For a finance view, yes: compute net present value with your discount rate for the finalists. For first stage comparison, undiscounted five year cost is clear enough and avoids debate about the rate.

#### Why five years?

**Answer:** It captures the first renewal cycles and most of the maintenance or subscription uplift without becoming speculation. Many organisations also compare ten years for a core ERP; change the years column to do that.

#### What if vendors quote different user counts?

**Answer:** Ask them to requote on the same user mix: full, limited and occasional users. Otherwise the totals are not comparable. Document your assumption in the notes column.

## Search terms

erp quote comparison template, erp pricing comparison excel, compare erp vendor quotes, erp cost comparison spreadsheet, erp five year cost comparison, erp subscription vs licence comparison

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json