Home · Blog · article

Spreadsheet vs. ERP for OOH media owners: 9 signs your operation should have migrated already

The spreadsheet worked until now. But if you lose points to double-booking, build proposals in 40 minutes, collect via WhatsApp, and don't know which rep sold what — the problem isn't the team. It's the tool.

· Hivestr · 110 views

Spreadsheet vs. ERP for OOH media owners: 9 signs your operation should have migrated already

Nobody wakes up and decides to migrate from spreadsheets. What happens is different: the sales rep sells a point that was already sold. Proof is late because nobody can find the photos. The invoice is wrong because the spreadsheet price doesn't match the contract. The rep claims commission on a canceled sale. And then, in the middle of a chaotic month, someone asks: "why are we still doing all this in a spreadsheet?"

If that question has crossed your mind, this article is for you. We'll show the 9 signs the spreadsheet should have been replaced, how much it really costs in rework and lost opportunities, and what changes when a media owner migrates to an ERP built for OOH.

The math nobody does

The spreadsheet is "free." But the sales rep's time building proposals in PowerPoint (40 min each), finance manually checking amounts, proof delayed because photos are in someone's WhatsApp, and sales lost to double-booking — all of that has a cost. In media companies with 30+ points, the hidden cost of spreadsheets reaches ~$1,700/month in rework. An OOH ERP starts at $20.

In this article
  1. The 9 signs the spreadsheet should have been replaced
  2. How much the spreadsheet really costs per month
  3. What changes with an ERP built for OOH
  4. Table: spreadsheet vs. ERP — 12 daily tasks
  5. How to migrate without stopping operations

The 9 signs the spreadsheet should have been replaced

1

You've sold the same point twice

Rep A didn't know Rep B already sold it. The spreadsheet doesn't lock availability in real time. Result: apology, rework, or losing the client.

2

Building a proposal takes over 15 minutes

Open spreadsheet → check availability → copy to PowerPoint → verify price → insert photos → format → save PDF → send. If it takes more than 15 minutes, the process is too manual.

3

You don't know if the client opened the proposal

Sent the PDF and waited. Called after 3 days. Client said they "didn't receive it." They did — and ignored it. But you don't know because PDFs don't track.

4

Proof lives in someone's WhatsApp

The installer sent photos to the WhatsApp group. Nobody organized them. The client asked for proof. The rep asked the installer to resend. The installer already deleted them.

5

Finance and sales use different spreadsheets

Sales has one spreadsheet. Finance has another. The numbers don't match. Nobody knows which version is correct. The invoice goes out wrong.

6

You don't know each rep's exact commission

Commissions are calculated at month-end, manually, checking sale by sale. There's always a dispute. There's always an error.

7

A site lease expired and nobody noticed

The lease for the highway billboard expired last month. Nobody flagged it. Now the landowner wants to renegotiate at 30% more. Without automatic alerts, expiration is a surprise.

8

Agencies ask for availability and you're slow to respond

The agency emailed asking for available points in August. The rep took 24 hours because they had to check the spreadsheet line by line. The agency already closed with another media owner.

9

You have no media kit on your site and no map with your points

The agency can't see your inventory outside business hours. If they're building a plan at 10 PM, you don't exist in that plan.

The spreadsheet isn't free. It charges in rework, lost sales, and clients who choose another media owner.

What changes with an ERP built for OOH

CHANGES
Real-time availability

The rep sees which points are free, builds the proposal, and the point locks automatically on approval. Zero double-booking.

CHANGES
Proposal in 5 minutes

Select points, the system pulls price and audience data, generates the interactive link. No PowerPoint.

CHANGES
Open tracking

Know if the client opened, how many times, from where. Follow-up based on data, not guesswork.

CHANGES
Automatic proof

Photo book born from the approved proposal. Photos attached to the point. Planned vs. delivered — automatic.

CHANGES
Integrated finance

Invoicing, billing, and commissions born from the proposal. One flow. No parallel spreadsheet.

CHANGES
Expiration alerts

Lease contracts with 30/15/1 day alerts. No expiration catches you off guard.

Table: spreadsheet vs. ERP — 12 daily tasks

TaskSpreadsheetERP (Hivestr)
Check availabilityOpen file, filter, check line by lineReal-time, visual, period filter
Build proposal40 min (spreadsheet + PPT + photos)5 min (interactive link with data)
Send proposalPDF by emailShareable link (opens anywhere)
Know if client openedDon't knowReal-time tracking
Approve proposalEmail / call / WhatsApp"Approve" button in the link
Reserve pointManual (double-booking risk)Automatic on approval
ProofPhotos in WhatsApp + manual PDFAuto book linked to proposal
Issue invoiceSeparate system, verify amountsIntegrated, proposal amounts
Collect paymentGenerate slip manuallyAuto billing
Rep commissionManual month-end calculationAutomatic per sale
Lease expiration alertNobody monitors30/15/1 day before
Media kit for agenciesDoesn't existOn site, 24/7, with analytics
Hidden cost of the spreadsheet
~$1,700/month
Adding rework (proposals + proof + finance), lost sales from slow response, and double-booking costs. For media companies with 30+ points, this is conservative. Hivestr starts at R$97/month — less than 1.2% of the cost the spreadsheet generates.
$20/month vs. $1,700/month in rework

The spreadsheet costs more than any ERP.

Real-time inventory, interactive proposals in 5 minutes, automatic proof, integrated finance with invoicing, media kit on your site, and expiration alerts. Everything the spreadsheet doesn't do. From R$97/month. Free trial for 7 days.

Replace the spreadsheet · 7 days free →

Your media company's whole operation

Inventory, proposals with online approval, CRM, campaigns, proof of posting and finance in one account. 7 days free to try.

Subscribe to the Hivestr newsletter

Get tips, OOH/DOOH industry news, and Hivestr content straight to your inbox.

No spam. Just tips, industry news, and Hivestr content. Unsubscribe anytime.

← Back to Blog