Finance
Reports
Fourteen reports over one date range and one set of filters, nine standard tabs and five drayage intelligence reports, each exportable as CSV, Excel or PDF.
Reports is the analysis hub. Every report reads the same filtered set of loads, so when you narrow the range to last month or one customer, every tab answers for that same slice. Nine tabs are the reports any TMS has. Five more, under Drayage, are the ones specific to ocean drayage: customer concentration, collections, margin, demurrage and carrier risk.
- Where
- Finance → Reports (/reports)
- Who can open it
- Reports · view. By default: Owner, General Manager, Finance Manager, Accounts Team, Sales Manager, Transportation Manager
- Who can export
- Reports · export (every default role except Viewer)
- Agent handover tab
- Owner only
- Rebill (Demurrage watch)
- Invoices · create
- Saves
- Only the Rebill button saves. Every export is audited
Choosing the slice
Date range
The range buttons in the header pick a preset: This month (the default), Last month, Last 90 days or This year. Typing a From and To date in the filters overrides the preset; you typed two dates, so those are the dates used.
Filters
| Filter | Options |
|---|---|
| From / To | A custom window |
| Customer | Every customer, or one |
| Carrier | Every carrier, or one |
| Sales agent | Every agent, or one |
| Load status | Any status, or one status (grouped by phase) |
| Billing | Any billing, Unpaid, Part paid or Paid |
Click Apply to run the filters, or Clear all to return to the unfiltered report. The bar shows how many loads matched, and warns if From is after To. The tab, range and filters are all in the page address, so a report is a link you can send.
Tabs that ignore the range
Three kinds of report do not use the date range, and they say so on screen rather than silently ignoring it:
| Tab | Why |
|---|---|
| Ageing, Collections, Demurrage watch | They are about what is open right now. They still honour the customer, carrier and agent filters |
| Commission | Monthly by definition. Marked "Monthly · range not used" |
| Carrier risk | A property of the carrier, not of a period |
The standard tabs
Overview
Five figures for the slice: Loads (with how many customers and carriers), Revenue, Carrier cost, Gross profit (with margin %) and Average per load (gross ÷ priced loads, with how many are priced and unpriced). A Revenue and gross chart shows the monthly trend; it covers the whole period, not the range, and says so on the card.
Profitability
Two tables: Profit by customer (which accounts actually make money, as opposed to which are simply large) and Profit by lane (the same question asked of the route).
Commission
The latest month's commission table, read-only. See Commissions to calculate and pay.
Ageing
The same view as Collections below: open invoices by bucket and the chase list.
Customer
Volume, revenue and margin per account over the range, up to 25 rows.
Carrier
What each carrier costs you: gross margin on the loads each carrier ran, up to 20 rows. "A carrier who is cheap on paper and slow in practice shows up as a thin margin here."
Load
Loads grouped by the route they ran, with the margin each route returned, up to 25 rows.
Finance
The P&L card twice: This month and Year to date.
Agent handover
Every agent's book over the range: loads, revenue, gross, margin and overdue. Only the Owner sees this tab. Anyone else who opens it by its address sees "Not yours to see · The owner's report only".
Margin tables, explained
The Profitability, Customer, Carrier, Load and Margin tabs share one table:
| Column | Meaning |
|---|---|
| Customer / Lane / Carrier | What the row groups by |
| Loads | Loads in the slice |
| Revenue | Customer rate total |
| Gross | Revenue minus carrier cost |
| Margin | Gross as a share of revenue, with a bar |
A row that lost money is tinted red.
The drayage intelligence reports
Concentration
How dependent you are on your biggest customers. A verdict leads the page:
| Largest customer's share of revenue | Verdict |
|---|---|
| 33% or more | A dependency: "Losing that account would not be survivable without notice." |
| 25% to 33% | Worth watching |
| Under 25% | Spread out |
A Share of revenue donut shows the five largest and "Others", and the By customer table lists loads, revenue and share.
Collections
Open receivables by bucket (Not due, 1–30, 31–60, 60+ days past due) and a Chase list with what to do:
| Days past due | What to do |
|---|---|
| Over 60 | Escalate to the owner |
| 31–60 | Call, do not email |
| 1–30 | First chase |
With nothing past due it reads "Nothing past due · Every invoice is inside terms".
Margin
Margin by lane and Margin by customer, the 16 largest of each.
Demurrage watch
Containers at or near their last free day (LFD) at the terminal, within the next five days or already past it, that have not yet been returned empty.
| Figure | Meaning |
|---|---|
| Past last free day | Containers already accruing |
| Inside three days | Containers about to start |
| Not yet rebilled | The amount you could still bill the customer |
The table shows Container, Customer, Free until, Clock, the Rebill amount and an Action. Demurrage is rebilled at $225 per container per day past the LFD.
Rebill adds a Per Diem charge billed to the customer for the days past the LFD. Because it is a charge, it reaches the invoice by itself (R14). The server refuses when:
- The load already carries a Per Diem or Storage charge.
- The load is already invoiced: "Raise a debit note instead." See Debit & credit notes.
- The load is not past its last free day.
A rebill raises the load's customer rate, writes a line on the load feed and an audit entry charge.rebill. For the full detention and per diem tools, see Detention & demurrage.
Carrier risk
Carriers with a compliance gap or a warning sign, worst first, up to 20 rows.
| Column | Meaning |
|---|---|
| Carrier | Name |
| Docket | MC and DOT, never shortened |
| Standing | Red when the carrier fails compliance and still has open loads; amber for warnings |
| Open | Open loads riding on the carrier |
| Exposure | Money on those loads |
| What is wrong | The list of indicators |
The indicators checked are: no FMCSA-registered email; insurance lapsed or expiring within 30 days; a Conditional or Unrated safety rating; no W9; payment redirected to a factoring company; approved without a written comment. With nothing flagged it reads "No carrier flagged".
Export
The Export menu offers CSV, Excel (.xlsx) and PDF of the tab you are on, with the same range and filters. The file is named after the report and today's date. Every export writes an audit entry saying who exported which report, how many rows, and in what format. CSV cells that start like a spreadsheet formula are escaped, so a file cannot run anything when opened.