labs@atheron:~/industries/trucking/rescue$ recover --codebase --modernise

Trucking system rescue

Old settlement and shop databases, replaced with care.

Many carriers still run settlements or maintenance on an Access database or a workbook full of macros that one person understands. We review it first and write up what it really does, then replace it without stopping the weekly pay run.

Start a project See the example projects

// what matters here

What is different in this industry.

A review before a rebuild

Senior engineers read the old system and tell you plainly what it does, what is risky and what it would take.

History that adds up

Past settlements are moved across and checked against the statements owner-operators already received.

Run side by side

The new system runs beside the old one for a few cycles until the numbers match.

No single point of failure

Documented code and a system your office can learn, not one person's memory.

// example projects

Priced examples for this service.

Each one is hypothetical, labelled as such, and priced live from our rate card. Open any of them in the estimator and make it yours.

Example projectWeb app

Owner-operator settlements

Hypothetical. Not a client, not a result.

// The problem

A carrier settles its owner-operators from an Access database a former employee built, and every fuel advance, deduction and escrow question waits for the one person who knows it.

// What we would build

We start with an architecture review of the old database and write up what it really does, so you decide with the facts. Then a web system replaces it: loads, rates, fuel advances, deductions and escrow, weekly statements in an owner-operator portal, and settlements posted to QuickBooks Online through its API.

// What is in it

A written review of the old system before anything is rebuilt
Loads, rates, advances, deductions and escrow in one ledger per owner-operator
Weekly statements in a portal, with every line explained
Settlements posted to QuickBooks Online, both ways
History moved from the old database and checked against past statements

// Stack

Next.js
PostgreSQL
QuickBooks Online API
DigitalOcean Toronto

// estimate

Build: ≈ US$91,900 to US$141,000, delivered within 24 weeksCAD 130,900 to 200,200
Hosting: ≈ US$176 a monthCAD 250 a month
Support: ≈ US$2,500 a monthCAD 3,565 a month

Prices in your currency are estimates from today's Bank of Canada rate. All invoicing is in CAD or USD.

Timeline by milestone

Discovery: 2.9 to 3.4 weeks
Data mapping and sandbox connection: 0.4 weeks
Architecture review of the old system: 0.4 weeks
Design approved: 3.4 to 5.4 weeks
Core features: 1.9 to 2.9 weeks
Full build: 1.4 to 1.9 weeks
Sync built and reconciled in sandbox: 2.4 to 3.9 weeks
Testing and fixes: 0.9 to 1.9 weeks
Launch: 0.9 to 1.4 weeks
Live cutover: 0.9 to 1.4 weeks
Hypercare: 0.9 to 1.4 weeks

How it is paid

Deposit 20%: CAD 26,180 to 40,040
Discovery 3.4%: CAD 4,450.60 to 6,806.80
Data mapping and sandbox connection 5%: CAD 6,545 to 10,010
Architecture review of the old system 8.7%: CAD 11,388.30 to 17,417.40
Design approved 3.4%: CAD 4,450.60 to 6,806.80
Core features 10.3%: CAD 13,482.70 to 20,620.60
Full build 6.8%: CAD 8,901.20 to 13,613.60
Sync built and reconciled in sandbox 15.1%: CAD 19,765.90 to 30,230.20
Testing and fixes 3.4%: CAD 4,450.60 to 6,806.80
Launch 3.4%: CAD 4,450.60 to 6,806.80
Live cutover 5%: CAD 6,545 to 10,010
Hypercare 5.5%: CAD 7,199.50 to 11,011.00
Holdback, 30 days after launch (10%): CAD 13,090 to 20,020

Start from this example

// questions

Questions we get about this.

Do we have to stop settlements while the old database is replaced?

No. The new system runs beside the old one until a few weekly runs match, then you switch.

The person who built our system has left. Can you still read it?

Usually, yes. Reading an old Access or macro system is the first part of the review.

What if the review says a rebuild is not worth it?

Then we say so. Sometimes a smaller fix to the old system is the better answer.

Back to the industry: Trucking and fleet operators About the service: Rescue and modernization

// next

Not quite your project?

Tell us what you have in mind. We will come back to you with a range and the questions that would narrow it. Or book a call and talk it through.

Start a project Book a call