Skip to main content

Revenue accrual report on dashboard

Dashboard tracks accrued revenue (delivered but un-invoiced work) & accrued costs (received but unpaid services) with detailed breakdowns.

Arynne Hargreaves avatar
Written by Arynne Hargreaves
Updated over a month ago

Accrual accounting reports both accrued revenue and accrued costs, critical for tracking income and expenses that have been earned/incurred but not yet invoiced/paid. This helps ensure financial statements reflect the true state of the business at month-end or any selected date

What You See:

Accrued Revenue: Amount of delivered (completed) work that has not yet been invoiced, ie: orders where goods have been picked up/delivered but an invoice hasn’t been issued yet.

Accrued Costs: Cost for services or goods received but where a purchase invoice hasn’t been received or booked yet, ie: work subcontracted to another company but not yet billed to you.⁠⁠​

Breakdown by Source: Revenue/costs are split between those executed by your own fleet versus subcontractors, with stack/bar graphs visualising these splits over time.⁠⁠​

Line-Item Detail: Tables list individual charges or purchase lines, showing status, execution date, and whether they have been invoiced/booked, for full transparency.⁠


Typical Dashboard Views

Charts:

  • Stacked bar charts comparing accrued revenue, split by own fleet and subcontractors.⁠⁠​

  • Stacked bar charts for accrued revenue & costs; per order based on month end

Tables:

  • For revenue accrual: Charge-level detail with order, status, execution dates, charge amount, whether it is linked to an invoice.

  • For cost accrual: Similar table for purchase invoices.

Filtering:

  • Filter by collection or delivery date, own fleet vs. subcontracted services, customer, or other business dimensions.

  • Filtering updates both graphs & tables

How the Accrual Calculations Work

  • All amounts are shown in system base currency for consistency with accounting.

  • Clicking on entries allows drill-through to order, invoice, or purchase record level.

  • Conditional formatting/highlighting helps spot aged or high-value accruals.⁠⁠​

  • Exclusions: 'Don’t invoice' or non-billable lines never appear in accrued revenue.

Revenue Accrual

Accrued revenue

  • Calculated at the level of each individual charge (“charge line”), not just at the order level. This means for orders with only some charges invoiced, only the un-invoiced, completed charges are counted as accrued revenue, increasing the accuracy for complex scenarios.⁠⁠​

Calculation logic

A charge counts as accrued revenue if:

  • The collection or delivery of goods has occurred before (or on) the selected accrual date

  • The charge is not yet included in a (finalised) sales invoice

  • The work is marked as completed (“collected” or “delivered” status)⁠⁠​

Fleet/Subcontractor Split:

  • System calculates which proportion was executed by your own fleet vs. a subcontractor.

    • Revenue for each is broken down by multiplying the total line value with the % attributed to own fleet/charter.

Cost Accrual

Accrued cost

  • Calculated as the sum of all purchase invoice lines for goods/services received (work completed) but not yet invoiced by your supplier.

  • Each purchase invoice line is checked for execution date and booking status.⁠⁠

  • Only items where the work/trip has been executed but no supplier invoice has been booked are counted as accrued cost.

Summary:

True Accrual vs. Booked:

The dashboard is designed to easily reconcile numbers with accounting system, making sure all revenue/cost that should be accrued appears. No more missed or double-counted entries.⁠⁠​

Exportable Data:

Tables and underlying data can be exported (ie: to CSV) to support manual adjustments, reconciliations, or upload into accounting/ERP.

Performance:

The dashboard now supports higher row limits to handle large transaction volumes.⁠



Did this answer your question?