TMS Pro — Transportation Management

Remember me on this device

🚛

TMS Pro

Transportation Management

📂 Restore

Guest

Not logged in

View Report

Period

Status

Broker

COLUMNS:

🚛

Install TMS Pro

Add to your home screen — works like a real app, even offline

Linked File

No file linked

Supports .xlsx / .xls

Sheet Mapping

TMS data will be written to the following sheet:

Sheet will be created if it doesn't exist

Columns Exported

Load No Carrier Broker Driver Invoice # Driver INV # Broker INV Date Status Days Since INV Pickup Date Delivery Date Origin Destination Miles Gallons Rate Fuel Cost Net Revenue Lumper Detention Total Note

Auto-Sync

Auto-download updated Excel on every save

When enabled, every load add/edit/delete triggers an Excel download

🔥

Firebase Realtime Database RECOMMENDED

Professional · Real-time · Free · Works on any browser/PC instantly

Not connected

✅ Changes appear instantly on all browsers — no refresh needed
✅ Free forever — handles 1000s of loads
✅ No Apps Script — direct database, always works
✅ Same URL on every device — just paste once

⚡ 3-Minute Setup:
1. Go to console.firebase.google.com → Add project → name it CarrierTMS → Continue
2. Skip Google Analytics → Create project → Continue
3. Left menu → Build → Realtime Database → Create Database
4. Pick any location → select Test mode → Enable
5. Copy the URL (like https://carriertms-xxxxx-default-rtdb.firebaseio.com)
6. Paste below → Connect & Sync

Firebase Database URL

Must end with .firebaseio.com

☁️ Google Sheets / Cloud Sync

✅ Connected to Google Sheets

Connect to a Google Apps Script to sync directly to Google Sheets in the cloud. How to set up ▸

Apps Script Web App URL

Must contain /macros/s/ and end with /exec

Sheet Name

Auto-push on save

🔄 Multi-PC / Multi-Browser Sync

Always load from Google Sheets on startup

Every time TMS opens, it fetches the latest data — keeps all browsers in sync automatically

Auto-push every add/edit/delete to Sheets

Changes sync to Google Sheets instantly — other browsers get latest on next open

💡 Recommended for 2 PCs: Turn ON both checkboxes on every browser/PC you use. Google Sheets becomes your master database — always current everywhere.

🔗 Embed URL into TMS File

This bakes your Google Sheets URL directly into the HTML file.
Open the downloaded file on any browser or device → data loads automatically. No setup needed!

Auto-load data from Sheets every time TMS opens

Downloads a new TMS file with your URL built-in — share it with anyone

💡 Pull from Sheets = loads data from Google Sheet into this browser. Use this when opening TMS on a new device.

💾 OneDrive / SharePoint

Download the Excel file below and save it to your OneDrive folder. The file will auto-sync to the cloud via OneDrive's desktop app.

📝 TMS Notes

0 notes ✓ Synced

Broker Invoice

Invoice Fields

Driver Invoice

Invoice Info

Extras

Expenses

Custom Expenses

🏢 Freight Aid Trucking LLC

🏢 Safe Load LLC

👨‍✈️ Driver Invoice Settings

⏱️ Accounts Receivable — Invoice Aging Report

👤 Driver Revenue Summary

💰 Payment Tracking — Paid Loads

🔧 Fleet Maintenance

🚨 Upcoming Alerts

📈 Cost This Month

🚛 Fleet Status

🗺️ IFTA — Miles & Fuel by State

⛽ Fuel Fill-Up Log

Cost Center per Truck — Depreciation & CPM

🗓️ Dispatch Board

💰 Driver Payroll & Settlements

👥 User Management

Broker Invoice

Invoice Fields

Driver Invoice

Invoice Info

Extras

Expenses

Custom Expenses

🏢 Freight Aid Trucking LLC

🏢 Safe Load LLC

👨‍✈️ Driver Invoice Settings

⏱️ Accounts Receivable — Invoice Aging Report

👤 Driver Revenue Summary

💰 Payment Tracking — Paid Loads

🔧 Fleet Maintenance

🚨 Upcoming Alerts

📈 Cost This Month

🚛 Fleet Status

🗺️ IFTA — Miles & Fuel by State

⛽ Fuel Fill-Up Log

Cost Center per Truck — Depreciation & CPM

Add Truck

New Work Order

Log Fuel Fill-Up

Add PM Task

Add Vendor / Shop

Add Document

🗓️ Dispatch Board

💰 Driver Payroll & Settlements

🤖 AI Load Entry

⬡ Excel Sync

Add New Load

Set Invoice Sent Date