On the Turnover list page you see your company turnover month by month: for every month it shows the value of customer orders, incoming invoices, proforma invoices, advance invoices, final invoices and receipts, and how much of it has already been settled. The page does not list individual documents, it summarises them: one row is one calendar month, and the numbers are the totals of the documents dated in that month. It helps you quickly answer questions such as:
The Turnover list is a statistics page, so it has no states, views or sub-modules of its own beyond the two tabs (Actions, Search). However, only documents in certain states are included in the numbers: documents in Draft, Cancellation and Cancelled state are left out, every other state is counted. The details are in the Frequently asked questions section.
Click Main menu / Sales / Statistics / Turnover list to open the page. You can also reach it via Main menu / Analytics / Turnover list if the Analytics block is visible in the sidebar. When the page opens, the Search tab is active and the period runs from 1 January of the current year to the end of the current month, so you immediately see the turnover of the year so far. The screenshots were taken in the Hungarian demo interface.
Three tabs are shown at the top of the page: Turnover list (this page), Detailed list and Operational statistics. The last two are separate pages; click the tab to switch to them.
Under the filter, the horizontal axis of the chart shows the months (year.month) and the vertical axis shows the gross amount in the default currency. Each month has four bars. The legend labels are shown in Hungarian on the screen in every language; the English meaning is given first, the on-screen label in brackets:
The chart always shows gross values; net and settled values are in the table. The Proforma invoice is not on the chart because it is not yet actual sales. The same deal may appear first as a customer order and later as an invoice, so do not add up the chart bars: read the order bar and the invoice bar side by side to see how much of the month order backlog has been invoiced.
In the table under the chart, one row is one month (Year/Month) and the columns are document types: Customer order, Incoming invoice, Proforma invoice, Advance invoice, Final invoice, Nyugta (receipt) and Total sales. In the document type cells three numbers are stacked, with a bar below them:
The Customer order cell has only two numbers (net and gross) because orders have no settlement, so there is no bar either. The Total sales cell also shows three numbers but has no bar.
Example from the demo data (row 2026-02): in the Final invoice column the net value is 1 039 472 Ft, the gross value is 1 179 058 Ft and the settled value is 450 205 Ft, and the bar ends at about 38%. This means that roughly 728 853 Ft of the gross value of the invoices dated in February is still unsettled. The net Total sales in the same row is 1 044 295 Ft, which is the sum of the net values of Advance invoice (3 873 Ft), Final invoice (1 039 472 Ft) and Nyugta (950 Ft).
If the Final invoice bar of a month is strikingly short, the month has many unsettled invoices. Open the Invoice list, filter on the Document date of that month and review which invoices are still waiting for settlement, so you can start payment reminders in a targeted way.
On the Search tab, use the Document date field pair (start and end date) to set the months you want to see. Pick the date from the calendar or type it in, and click Search to refresh the chart and the table. The Expand button is grey and not usable on this page because there are no further filter fields.
It is important to know that the filter selects months, not days: if you enter 2026.03.15 – 2026.05.10, the system shows the whole of March, April and May, with all documents of those months. The month list may also continue beyond the end date: on the demo data, with the end date 2026.10.31 the list runs to 2027.01, and the rows after the end month show 0 Ft.
On the Actions tab, click Download and choose XLSX lista from the dropdown to save the monthly data as an Excel file (receipt-list.xlsx). The download uses the current values of the date fields of the Search tab, so set the period you need first and download afterwards. The file contains one row per month; the meaning of the columns is explained in the Frequently asked questions section.
If you have to send a monthly summary to your accountant or management, set the requested months in the Document date fields, check the chart for unexpectedly high or low months, and then download the XLSX lista file. To compare two years, enter 1 January of the previous year as the start date: you then get the months of both years in a single file.
The columns of the monthly table, their meaning and how they are calculated. All values are shown in the default currency; documents issued in another currency are converted at the exchange rate recorded on the document.
| Column | What it shows | How it is calculated |
|---|---|---|
| Year/Month | The calendar month of the row in YYYY-MM format (e.g. 2026-02). | Documents fall into the month of their Document date; the performance date does not matter. |
| Customer order | Value of the customer orders dated in the month: net and gross (two numbers). | Sum of documents of the customer order type; documents in Draft, Cancellation and Cancelled state are left out. There is no settlement and no bar. |
| Incoming invoice | Value of the incoming (supplier) invoices dated in the month: net, gross, settled and bar. | Sum of documents of the incoming invoice type, with the same state exclusion. The settled value is the amount already paid. |
| Proforma invoice | Value of the proforma invoices issued in the month: net, gross, settled and bar. | Sum of documents of the proforma invoice type. A proforma invoice is not an actual invoice, so it is not part of the Total sales column. |
| Advance invoice | Value of the advance invoices issued in the month: net, gross, settled and bar. | Sum of documents of the advance invoice type. |
| Final invoice | Value of the invoices issued in the month: net, gross, settled and bar. | Sum of documents of the invoice type. |
| Nyugta (receipt) | Value of the in-store sale receipts dated in the month: net, gross, settled and bar. | Sum of the in-store sale documents. The header of this column is Nyugta in every language. |
| Total sales | Total sales of the month: net, gross and settled value (without a bar). | Advance invoice + Final invoice + Nyugta; the three values are summed separately. Customer order, Proforma invoice and Incoming invoice are not included. |
The elements of a document type cell:
| Element | Appearance | Meaning |
|---|---|---|
| Net total value | Top number, bluish (cyan) | Net value (without VAT) of the documents of the month. |
| Gross total value | Middle number, grey | Gross value (including VAT) of the documents of the month. |
| Settled total value | Bottom number, purple | Sum of the settlements recorded on the documents (the amount received on the sales side, the amount paid for incoming invoices). |
| Settlement bar | Bar under the cell | Settled amount / gross amount, rounded down to a whole percent (e.g. 38%). For a fully settled month the bar is full. |
The series of the chart (all show gross values):
| Series | Colour | What it contains |
|---|---|---|
| Customer order (Vevői rendelés) | Dark purple | Gross value of the customer orders of the month. |
| Sales (invoice, advance invoice) (Értékesítés (Számla, előlegszámla)) | Medium purple | Gross value of Final invoice + Advance invoice. |
| Incoming invoice (Bejövő számla) | Grey | Gross value of the incoming invoices of the month. |
| In-store sale (receipt) (Bolti értékesítés (Nyugta)) | Light purple | Gross value of the receipts of the month. |
Fields of the Search tab:
| Field / Element | Required | Description |
|---|---|---|
| Document date (start date) | First month of the period. By default 1 January of the current year. If you leave it empty, the list starts from January 2020. | |
| Document date (end date) | Last month of the period. By default the last day of the current month. | |
| Search button | Reloads the chart and the table with the set period. | |
| Expand button | Inactive on this page because there are no further filter fields. |
Elements of the Actions tab:
| Field / Element | Required | Description |
|---|---|---|
| Download > XLSX lista | Exports the monthly rows of the period of the Search tab to an XLSX file. |
A cell is 0 Ft when there is no document in that month (by Document date) that the page counts. There are three typical reasons: no document of that type was actually created in the month (for example a month that has not started yet); the document is still in Draft state; or the document is in Cancellation or Cancelled state, which the page leaves out. Check on the relevant list page that the document is finalised and that its date really falls in that month.
The most common reasons: (1) the page assigns documents to the month of their Document date, the performance date does not count, so an invoice dated at the end of a month but performed in the next month appears in the month of its date; (2) documents in Draft, Cancellation and Cancelled state are left out, although they may appear in the list; (3) only the Final invoice, Advance invoice, Proforma invoice and Incoming invoice types count, other document types do not; (4) the Turnover list shows net, gross and settled values, so always compare gross with gross and net with net; (5) documents in a foreign currency appear here converted to the default currency. For more details, see also the Invoice list guide.
The three numbers of a cell, from top to bottom: the bluish (cyan) one is the net total value, the grey one is the gross total value, the purple one is the settled total value. Hover over the numbers to see the label. The bar under the cell is the ratio of the settled and the gross amount: the longer it is, the larger part of the documents of the month is settled. The bar is not shown in the Customer order and Total sales columns.
The Total sales column is the sum of the Advance invoice, Final invoice and Nyugta values (net, gross and settled value separately). It does not include the Proforma invoice (not yet an actual invoice), the Incoming invoice (purchasing side) or the Customer order (an order not yet fulfilled). On the chart, the series Értékesítés (Számla, előlegszámla) contains only final invoices and advance invoices, while receipts are a separate bar (Bolti értékesítés (Nyugta)), so the sum of these two bars gives the gross total sales of the table.
The Document date pair determines which months appear as rows; the numbers of a month always sum up the whole month, day precision does not apply. After the end date the list may continue with a few empty (0 Ft) months. If you clear both dates, the list starts from January 2020. The filter only changes the displayed months; the total of an individual month does not depend on it.
Documents issued in a currency different from the company default (for example EUR) are converted to the default currency (Ft in the demo) at the exchange rate recorded on the document, and every value on the page is shown in this currency. So a foreign currency invoice appears here with the value calculated at the rate of its issue, not with the foreign currency amount shown on the invoice.
The downloaded receipt-list.xlsx file has one row per month, and the column headers are technical names: date_ym (Year/Month), currency_sign (currency sign), and, per document type, a prefix: order_in_ (Customer order), invoice19_ (Incoming invoice), invoice33_ (Proforma invoice), invoice13_ (Advance invoice), invoice8_ (Final invoice), cash_register_ (Nyugta). The suffix shows the value: price_netto (net), price_brutto (gross), compensate_amount (settled). Customer orders have no settled column, and the file does not contain the Total sales column; you can add it up in your spreadsheet.
The Turnover list appears under Main menu / Sales / Statistics (and in the Analytics block) only if the module is assigned to your user. If you do not see it, ask your system administrator to check the module assignment in your user settings.
Don't want to spend hours searching for a solution? Choose the most efficient way: book a personalized, 45-minute online training session dedicated entirely to you. Whether it's a walkthrough of the basics or a detailed setup of a specific module, our expert colleague will guide you through the whole process, step by step.
Don't waste your time - ask for help!
Our goal is to get you using our system as quickly and efficiently as possible. Whether you're completely new to us or stuck on a specific setting, don't hesitate to ask for help!
Create your account now,
pay later!
