What production reports are
They show you, in a single table, how much you have sold, how much it has cost you and how much you have earned, grouped by customer, supplier, product, destination, sales agent or office. They are generated instantly from file and group data and can be exported to Excel.
You find them in reports › Production Reports, with six views: Customers, Suppliers, Products, Destinations, Sellers and Global. Outstanding collections are in reports › Collection Forecast, and the Entry panel shows a quick summary (My production, Annual profit, Pending collections…; see Main menu and widgets).
| Column | What it means |
|---|---|
| Amount | Sale amount of the services, before discount. |
| Discount | Discount applied to the customer. |
| RRP | Sales net of discount. This is the sales figure. |
| Cost | Cost of the services (what is paid to the supplier). |
| Profit | RRP minus Cost. This is the margin in euros. |
| Benefit Base · Tax | Profit without the tax on the margin, and that tax separately. |
| Paid | Part of the cost already paid to the supplier. |
| Files · Groups · Services · Bookings | Number of files, groups, services and bookings included in each row. |
Production reports on video
Indicator map: where to find each figure
Each indicator you need, the report that gives it and whether it comes out directly or has to be calculated.
| Indicator | Where | How to get it |
|---|---|---|
| Sales | All production reports | Direct: RRP column. |
| Cost | All production reports | Direct: Cost column (shown with Show/Hide Columns). |
| Margin € | All production reports | Direct: Profit column. |
| Margin % | Sellers (direct); others in Excel | % Benefit column in Sellers. In the others, Profit ÷ RRP. |
| No. of files | Customers, Suppliers, Destinations, Sellers, Products | Direct: Files and Groups columns. |
| PAX | File record and each service record | Pax field of the file and No. of Pax of the service. Production reports have no passenger column. |
| Average ticket | Excel, from any report | RRP ÷ Files. |
| Average trip length | Each service record | Service Start Date, End of Service Date and days fields. The reports have no duration column. |
| Booking deposits | Collection Forecast · Paid column | What has been collected on account from the customer (Charged) and what has been paid to the supplier (Paid). |
| Outstanding collections | Collection Forecast · Entry panel | Direct: Outstanding Balance column and Pending collections widget. |
| By office | Global; filter in all | Branch filter; the Global report gives one row per branch. |
| By sales agent | Sellers | One row per sales agent; also Group by Table or Group by User. |
| By customer · destination | Customers · Destinations | One row per customer or per destination. In Actions, combined Production Report by Client and Destination. |
| Previous year | Global (direct); others in Excel | Compare period with previous year checkbox in Global. In the others, generate both periods and compare them. |
The 5 steps, valid for all reports
| Id | Code | Client | Files | Services | RRP | Profit |
|---|---|---|---|---|---|---|
| 101 | 101 | Sample Customer Ltd | 3 | 9 | 8.450,00 € | 1.120,40 € |
| 102 | 102 | Smith Taylor, Laura | 1 | 4 | 5.980,00 € | 742,10 € |
Step by step
- Click Filters to open the panel and set dates, branch and types.
- Click Generate Report.
- Use Show/Hide Columns to add Cost, Profit or Paid.
- Click the Excel icon to download the table.
Which date Orbis uses as a reference
You choose the date in each report. By default, reports open filtered by the file's Opening Date from 1 January of the current year.
| Criterion | When to use it | Where it is |
|---|---|---|
| Opening Date | Sales production: what has been sold (opened) in the period. | All reports. |
| Services Start Date | Production by departure or service delivery. | All reports. |
| Invoice Date | Reconcile with accounting and invoicing. | Customers, Sellers and Global. |
| Supplier Invoice Date | Purchases according to the invoice received from the supplier. | Suppliers, Products and Destinations. |
Service date or file date
With Date Services Start, the date of each service is used. Tick Use Start Date File Services / Group to use the departure date of the whole file, so that a trip is not split across two months.
Global report
In Global, choose the criterion in the Use drop-down: Opening Date, Invoice Date or Service Start Date, with a single From Date / To Date range.
What do you want to do?
Production by customer
What it is for
One row per customer with files, services, bookings, sales (RRP), cost, profit and what has already been paid to suppliers.
When to use it
To see your best customers, their margin and their average ticket, or to separate leisure from corporate production with the Client Types filter.
Step by step
- In Client Types, choose the segment (for example, LEISURE).
- Delete the opening date and fill in From / Until Date Services Start if you want production by departure.
- Click Generate Report and add the Cost and Profit columns.
| Filter or action | What it does |
|---|---|
| Client Types | Limits the report to customers that have that type assigned in their record (Types tab). |
| Web Clients Group · Department | Two other ways to segment customers. |
| Suppliers | Only the production of those suppliers' services. |
| Include | Files, Groups or All. |
| Actions › Production Report by Client and Destination | Report that breaks down each customer by destination. |
| Actions › Production Report by Client and Product | Report that breaks down each customer by product type. |
Production by sales agent and by office
What it is for
One row per sales agent with files, services, RRP, cost, profit and the % Benefit column, the only one that gives margin % directly.
When to use it
For team targets and commissions, or to see production by office with the Branch filter or grouping by desk.
| Seller | Files | RRP | Cost | Profit | % Benefit |
|---|---|---|---|---|---|
| SALES AGENT A | 24 | 96.400,00 € | 84.250,00 € | 12.150,00 € | 12,60 |
| SALES AGENT B | 17 | 58.900,00 € | 52.110,00 € | 6.790,00 € | 11,53 |
Step by step
- Choose the office in Branch (leave it empty for all).
- Tick Group by Table or Group by User depending on the level you want.
- Click Generate Report and show the % Benefit column.
Global production and comparison with the previous year
What it is for
Totals for each branch (Amount, RRP, Profit, Cost, Paid…) and, with one checkbox, the same period of the previous year and the increase.
When to use it
For month-end or quarter-end closing and to see how each office is doing compared with last year.
| Branch 4 | RRP | Cost | Profit | Paid |
|---|---|---|---|---|
| 2026 - HEAD OFFICE | 412.300,00 € | 360.940,00 € | 51.360,00 € | 298.700,00 € |
| 2025 - HEAD OFFICE | 385.150,00 € | 339.020,00 € | 46.130,00 € | 331.400,00 € |
| BRANCH INCREASE | 27.150,00 € | 21.920,00 € | 5.230,00 € | -32.700,00 € |
Step by step
- Fill in From Date and To Date within the same year.
- In Use, choose Opening Date, Invoice Date or Service Start Date.
- Tick Compare period with previous year and click Generate Report.
- Read the three rows for each branch: current year, previous year and INCREASE.
Production by supplier and AVASA / Serandipians filter
What it is for
One row per supplier with files, groups, services, sales (RRP), purchases (Cost), profit and paid. In Actions you also have the Production Report by Supplier and Destination and Production Report by Supplier and Products reports.
When to use it
To negotiate with suppliers, review overrides or see how much you produce with the suppliers of a network such as AVASA or Serandipians.
The field used to group suppliers is Provider Type. You assign it in the supplier record, Types tab (see Suppliers), and a supplier can have several types at once (for example, AVASA and Serandipians). It is then used as a filter in the Suppliers, Products and Destinations reports.
| Id | Name |
|---|---|
| 2 | SERANDIPIANS 2 |
| Id | Name |
|---|---|
| 1 | AVASA |
Step by step
- Open the supplier record in Management › Suppliers and go to the Types tab.
- Move the type (AVASA, SERANDIPIANS…) from Supplier Types to Assigned Supplier and save the record.
- In reports › Production Reports › Suppliers, choose the type in Provider Type.
- Click Generate Report.
| Supplier indicator | Column |
|---|---|
| Purchase volume | Cost |
| Sales volume | RRP |
| Margin generated | Profit (margin % = Profit ÷ RRP in Excel) |
| No. of files | Files and Groups |
| Production by destination | Actions › Production Report by Supplier and Destination, or the Destinations report filtered by supplier |
Production by destination
What it is for
One row per destination with Country, ISO and Zone, plus files, groups, services, RRP, cost and profit.
When to use it
To find out which destinations sell best and leave the most margin, and with which suppliers (Suppliers or Provider Type filter).
The destination is entered in two places: in the Destination field of the file (Main tab) and in the Destination field of each service. This way, a Japan + Maldives trip can have the Japan services with destination Japan and the Maldives services with destination Maldives, and each destination adds up the amount of its own services.
Step by step
- Fill in No. of Pax and the service dates: they are the basis for passengers and trip length.
- In each service, fill in Destination with the place where it is provided (Japan or Maldives).
- In the report, filter by Destinations if you only want one, or leave it empty to see them all.
| Destination indicator | How to get it |
|---|---|
| Sales and margin | RRP and Profit columns. |
| No. of files | Files and Groups columns. |
| Average ticket | RRP ÷ Files in Excel. |
| Suppliers used | Actions › Production Report by Supplier and Destination (from the Suppliers report). |
Outstanding collections and deposits
What it is for
Collection Forecast › Customers gives, per customer, the amount, what has been collected and what is outstanding. Collection Forecast › Invoices gives it per invoice.
When to use it
To chase payments before departure, keep track of deposits received and monitor debt by customer type.
| Client | Srv / RSV | Amount | Charged | Outstanding Balance 3 | Currency |
|---|---|---|---|---|---|
| Smith Taylor, Laura | 6 | 14.980,00 € | 3.000,00 € | 11.980,00 € | EUR |
| Sample Customer Ltd | 4 | 2.350,00 € | 2.350,00 € | 0,00 € | EUR |
Step by step
- Filter by Date Services Start to see upcoming trips.
- Set Show Only Debt Greater Than to remove stray cents.
- Check Charged (deposits and payments on account) and Outstanding Balance.
Customer type (leisure / corporate) and trip type
Customer type
You assign it in the customer record, Types tab (a customer can have several). Create the LEISURE and CORPORATE types and use them in the Client Types filter of the Customers and Sellers reports and of Collection Forecast.
Trip type
The file has the Type of Trip field, a drop-down with its own table where you can add COUPLE, HONEYMOON, FAMILY, SOLO TRAVELLER, etc.
Step by step
- Fill in Pax with the number of travellers in the file.
- Choose the value in Type of Trip when you open the file.
- Enter the main Destination; the breakdown by destination goes in each service.
How the second client works
What it is for
A file can have several clients. Each service carries its own Client, and the invoice is issued in the name of the client of the services being invoiced (see Clients in the Files manual).
When to use it
When part of the trip is paid by another person or company (for example, two couples travelling together or a wedding gift) and each one needs their own invoice.
| Id | Client 2 | Invoice Issued | Supplier | Amount |
|---|---|---|---|---|
| 1 | Smith Taylor, Laura | SUPPLIER A | 6.200,00 € | |
| 2 | Smith Taylor, Laura | SUPPLIER B | 4.180,00 € | |
| 3 | Brown Wilson, Paul | SUPPLIER A | 1.950,00 € |
Step by step
- In the Main tab, open Customers and click Add Client for the second customer.
- In Services, check the Client column of each service.
- Use Change service customer to move the services paid by the second client; Set Default sets the client for new services.
Export to Excel, choose columns and save filters
What it is for
Download any report to Excel or PDF, keep the columns you always use visible and save filter combinations so you do not have to repeat them.
When to use it
Whenever you prepare a recurring report: margin by destination for the month, AVASA production for the quarter, etc.
Step by step
- In Show/Hide Columns, keep the columns you need ticked (you can drag them to change the order).
- Click Save so the report always opens this way.
- With the filters set, open the funnel menu and click Save filter; you can retrieve it later in My filters.
Best practices
One date criterion per report
Decide whether you measure by opening, departure or invoice and always use the same one to compare periods.
Classify when you create records
Assign the customer type, trip type and supplier type when you create the record or the file: reports can only segment properly what is classified.
Destination in each service
In multi-destination trips, enter the destination of each service so that production is split correctly.
Excel templates
Keep an Excel file with the margin %, average ticket and change formulas, and paste each export into it.
- Only one date range is filled in.
- The branch and the type (customer or supplier) are the ones you want.
- Include is set to Files, Groups or All as appropriate.
- The Cost and Profit columns are visible before exporting.