Skip to main content

Order revenues report

The Order revenues report shows your revenue order by order for a chosen date range. Use it to check revenue for a day or period, see how each order was paid, and see how refunds change your figures.

Written by Ben Hamrogue

If your site has a fiscalisation integration, the report also shows the fiscal receipt ID for each order. This makes it easy to match your revenue to the fiscal receipts that were issued.

To access this report head to Reports > Sales > Order revenues.

What the report shows

  • Revenue date – the date the order’s revenue is reported against (see below)

  • Order reference

  • Status – the status of the order, e.g. Settled (checked out)

  • Settled at – the date and time [the order was settled / the fiscal receipt was issued]

  • Fiscal receipt ID – only shown if you have a fiscalisation integration. The fiscal receipt number for the order, e.g. “ft13E#0278-0001”. Use this number when matching to your fiscal records.

  • Payment methods – how the order was paid, e.g. “Pms folio” or “Adyen”

  • Card brands – the card type used, where relevant, e.g. “Amex”

  • Revenue amount columns – e.g. Gross / Net / Tax / Revenue centres

Order revenues with no fiscalisation:

Order revenues with fiscalisation:

Filtering by revenue date

Select the date range at the top of the report to choose which orders are included. To check revenue for a single day, set the start and end date to the same day.

If you have a high volume of orders our recommendation is to minimise the date ranges to allow for the report to fully load, we will ensure future updates allow for this report to support larger date ranges.

The revenue date of an order is the latest date an item in the order is booked for. For example, if a guest has items booked on 31 October and 1 November, the revenue date for the whole order is 1 November.

Please note: the revenue date is not always the same as the payment date. An order paid in October for a booking in November will appear under November.

How the rows and totals work

Each row is one order containing the payment method, fiscal ID if required as well as the revenue associated to this order. If you have a fiscalisation integration, one order can have more than one fiscal document. For example, it might have a fiscal receipt for the sale and another for a refund. This means you may see more than one fiscal receipt ID for the same order.

Exporting the report

Select the Export button to download the report as a spreadsheet. If you’re reconciling fiscal receipts, we recommend:

  • exporting the exact day or date range you’re checking

  • keeping the export as your record for audits

  • sorting the export to find rows with no fiscal receipt ID, refunds or negative amounts, and high-value orders

Check a refund

If an order shows a negative amount or lower revenue than expected:

  1. Copy the Order ref and search it to open the order.

  2. Go to the Ledger tab to see the fiscal documents for the order. You should see the original sale and a separate document for the refund.

  3. Check that the fiscal receipt IDs match what your finance team expects for that date range.

You can also see every fiscal receipt sent for your site in the Fiscalisation receipts report.

Common questions

Why is there no fiscal receipt ID for an order?

This can happen if:

  • the fiscal receipt hasn’t been generated yet, e.g. the order hasn’t been checked out

  • the fiscal receipt failed to send to your fiscalisation partner

Search the Order ref and check the Ledger tab on the order, or look for the order in the Fiscalisation receipts report. If the receipt is still missing, please contact our support team ([email protected]) with the order ref.

Why does the same order appear more than once?

An order can have more than one fiscal document, for example the original sale and a refund, or partial refunds made on different dates. Compare the fiscal receipt IDs and amounts to check that each one is a separate document.

Why don’t the totals match my payouts?

This is expected. Payouts are based on when money reaches your account, not the revenue date, and they also take off card processing fees. Refunds and disputed payments made outside your selected date range will also cause differences. Fiscal receipts aren’t affected by payout timing.

Please note: if you’re comparing this report to the Revenue allocations summary, make sure both reports use the same revenue date range.

Did this answer your question?