Description

🚀 Simplify Your Transport Business with All-In-One Spreadsheet!

Transportation & Planner | CRM & Spedition | Fleet Management | Drivers & Wages Management | Financial Overview | Dashboards & Analytics

EUR & Metric system for measurements (e.g., kilometers, liters, Eur/km, L/100 km).

Choose between the Google Sheets or Excel version.

After purchase, you’ll receive two files:

• A manual and commercial use license
• A link to a private, ready-to-use Google Spreadsheet or an Excel file.

Both versions of the spreadsheet include all sheets:

🖥️TRANSPORTATION sheet

Track all orders: Record loaded/empty KM, freight revenue, extra pay, and related costs to monitor trip profitability.

🗓️PLANNER sheet

Manage fleet assignments and driver statuses: Schedule and plan trucks, trailers, and drivers for each trip. Automatically monitor driver availability, with clear indicators for on duty, off duty, and candidate statuses. Keep track of start/leave dates.

💼CRM sheet

Manage customer relationships: Track customer, carrier or lead details, statuses, and follow-ups. Automatically track performance metrics like revenue and profit by customer.

💻SPEDITION sheet

Manage forwarding deals: Track orders, pricing, and carrier costs, with automatic payment terms and profit margin calculations for informed decisions.

🚛TRUCKS sheet

Track essential details for each truck in your fleet, including numbers, fuel cards or current drivers (automated feature). Stay on top of insurance, registrations, and inspections with automated alerts for expiring documents.

🛞TRAILERS sheet

Monitor trailer assignments and track key information, with automated features like attached trucks and current drivers. Easily manage trailer equipment and document expiration dates with automated alerts.

🔧SERVICE sheet

Log and track vehicle and trailer repairs, maintenance history, and damage incidents. Track maintenance schedules and monitor costs for repairs and services.

👤DRIVERS sheet

Track driver details including personal information, with automated features like assigned trucks, and statuses (on duty, off duty, or candidate). Monitor licenses expirations and other key certifications with timely alerts.

💵WAGES sheet

Manage drivers’ wages with ease by tracking monthly balances, advances, and payments. Data from individual payroll sheets feeds into this main Wages sheet, ensuring accurate wage tracking and easy payroll processing.

📑PAYROLL sheets

Each driver has a personalized payroll sheet where all trips, pay calculations, extras, or deductions are recorded. Total pay can be calculated based on your preferences – either by days worked or kilometers driven. Additionally, fuel efficiency (L/100 km) is automatically calculated using the KM traveled and fuel consumed.

📋PROFIT REPORT sheet

Track trucks’ monthly, quarterly and yearly performance, including revenue, expenses, and profit/loss. Revenue and kilometers are pulled automatically from the Transportation sheet, while expenses such as fuel or tolls are manually entered or based on KMs. The sheet automatically calculates detailed financial metrics with breakdowns by truck, manager, month, and year.

⚖️🧮ANALYTICS sheets

Analytics Sheets give you real-time deeper insights into your transport, spedition and total business’s financial performance, helping you make informed decisions to maximize profitability.

Automated pivot tables provide detailed insights into truck, manager or expeditor, customer or carrier operations, empowering you to make informed decisions that enhance efficiency and profitability. Use interactive slicers to focus on a specific fields or time periods for targeted analysis.

💰📈📊THREE KEY DASHBOARDS

3 different dashboards provide a quick yet detailed visual summary of your company’s performance, encompassing total activities as well as specifics on transportation and forwarding operations.

All data is auto-sourced from Transportation, Spedition, and Profit Report sheets, ensuring current, fully integrated metrics. An interactive single slicer across charts enables totals, month-by-month, and multi-month analysis.

More than 30 automated and dynamic charts, including: 

Revenue | Profit | Profit Margin | Loaded and Empty Kilometers| Revenue & Costs per KM | Average Weight Hauled | Top Commodities Hauled | Average Payment Terms

KPIs broken down by Truck | Manager| Expeditor| Customer | Carrier

🌐NAVIGATION sheet

The Navigation Sheet serves as a dashboard, providing quick access to the necessary sheets in the spreadsheet. Simply click on any of the buttons to jump to the relevant sheet.

🔑COMMERCIAL USE LICENSE

This product comes with a Commercial Use License, granting you the right to use it for business-related purposes. Please note that the license is non-transferable, so you cannot resell or transfer it to others.

Ready to boost efficiency, eliminate manual tasks, and supercharge your transport business? Start today!

One-Time Purchase & Instant Download: Instantly access your personal Google spreadsheet or Excel file upon purchase.