Back to Projects
How a spreadsheet nightmare became a 150-space operations command center
BLF Trucking Louisville, KY | Business Technology Consultant | 5 min read

How a spreadsheet nightmare became a 150-space operations command center

When I first saw their spreadsheet, I understood the problem immediately. BLF runs a trucking logistics operation—own fleet, load management, 150+ yard spaces for rent, even mechanics. All tracked in Excel. The shop and sales manager, Neftali Morales, was spending his mornings just figuring out who owed what.

5-10 hours lost weekly

Manual tracking in spreadsheets consumed the yard manager's entire mornings.

💸

Invoices slipping through cracks

No reliable system meant truckers weren't getting billed, revenue was walking out the gate.

📊

Zero visibility into occupancy

Which of 150 spaces were occupied? Available? Coming soon? Nobody knew without checking the lot.

📈

Growth blocked by broken processes

They couldn't scale operations when every new trucker meant more spreadsheet chaos.

Meet the Client

Neftali Morales

Shop and Sales Manager, BLF Transportation LLC

Neftali runs the day-to-day operations at BLF Transportation in Louisville, KY — managing 150+ yard spaces, coordinating truckers, and keeping invoices straight. Before the dashboard, his mornings started with spreadsheets. Now they start with answers.

Neftali Morales at his desk at BLF Transportation
Managing daily operations
Neftali with the new BLF dashboard
The new dashboard in action
Neftali checking payments on his phone
Checking payments on the go

The Solution

Built in under a month, deployed to production, now used daily.

The command center
01

The command center

Everything operations needs in one view. Monthly revenue, occupancy rates, active truckers, pending invoices—all surfaced through animated KPI cards that tick up on load. Revenue trends visualized with 12-month history, payment method breakdowns, and recent activity.

150 spaces, zero confusion
02

150 spaces, zero confusion

Yard management reimagined as a Kanban board. Three columns—Occupied, Available, Coming Soon—each showing counts, revenue calculations, and scrollable cards with trucker assignments. At a glance, Neftali knows exactly what's happening in the yard.

Know your truckers
03

Know your truckers

Every trucker gets a profile with quick stats: spaces rented, total paid, payment method. Payment score rings (0-100) visualize reliability at a glance. Loyalty badges reward tenure. Bulk selection enables batch operations when needed.

No invoice left behind
04

No invoice left behind

Full invoice management with sortable columns, status badges (Paid, Pending, Failed), and payment indicators. Global search spans truckers, spaces, and invoices. The spreadsheet-era problem of "did we bill them?" is gone.

Data that drives decisions
05

Data that drives decisions

Analytics transforms gut feelings into informed strategy. YTD revenue, average revenue per space, payment success rates, retention metrics—all visualized through bar charts, line graphs, and breakdowns the owner can actually use.

See the future
06

See the future

Revenue forecasting predicts Q1 projections with growth percentages and confidence levels. For a business that used to operate blind, seeing what's coming changed how they plan staffing, maintenance, and expansion.

One click, not twenty
07

One click, not twenty

Batch operations that used to take hours: Charge All, Send Reminders, Generate Reports, Add Trucker. A floating action bar appears on selection. What once required opening 20 spreadsheet tabs now happens in seconds.

The Results

5-10 hrs
Saved weekly
0
Missed invoices
100%
Payment visibility

"Working with Ernesto has truly been one of our best decisions. From the moment we needed a system to provide our customers with better and more secure service, we could count on his work and professionalism. Throughout the entire process and even after its completion, he has provided us with the necessary support to implement the solution he provided. It's truly a pleasure to have him as a service provider."

Neftali Morales - Shop and Sales Manager, BLF Transportation LLC

The owner's relief was visible. What used to be a source of daily stress—tracking, billing, not knowing—became a solved problem. BLF can now focus on growing their operation instead of fighting their tools.

Have a spreadsheet problem? Let's talk.

Get in Touch