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.

Written by Arynne Hargreaves
Updated over 10 months 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?