Purchase Analysis is a useful tool for finding out information about purchase documents, that is, who you buy from, what you buy, and how much you pay. As in the desktop application, the analysis is also available in the web interface (WUI).
It includes six basic types of analysis. If none of them suits your needs, you can create your own analysis and customize it to what you need to track.
💡 Do you need a specific data analysis that the standard Purchase Analysis doesn't offer? We can build a custom query for you based on your requirements.
Where can I find Purchase Analysis?
The fastest way is to use search at the top of the application. Type "Purchase Analysis" and, under Open agenda, select the agenda with the same name.
The second option is the All agendas overview in the left menu, where you will find the Purchase Analysis tile.
Analysis settings
When you open the agenda, the Analysis settings panel appears. The way the analysis is processed is determined by the field of the same name at the top of the panel. You can reopen the panel at any time using the Analysis settings button above the analysis result.
The six basic options are as follows:
Which supplier I bought the most from
Which supplier group I bought the most from
Which price list group I bought the most from
Which goods I bought the most
What I bought from a selected supplier
Who I bought selected goods from
The seventh item in the menu is Custom analysis settings.
The key fields of the analysis are Analyze and Group by. For the six basic options, they are filled in automatically. For example, with the option "What I bought from a selected supplier", turnover is analyzed by company and grouped by goods, and a Company field is added to the panel, where you select the supplier.
With custom analysis settings, you define the values of these fields yourself.
Refining the analysis
As an example, we will process the first basic option, "Which supplier I bought the most from". You can refine the analysis further using the following settings:
Document dates: determines which date is used to include a document in the analysis. You can choose between Posting date and Document issue date.
Posting date / Document issue date: the period for which documents are analyzed. It depends on the option selected in the Document dates field. On the preset tab, you select a common period (today, last 30 days, this month, this quarter, this year, this accounting period, and more); on the from-to tab, you enter a date range; and on the advanced tab, you set the period relative to today (for example, the last 7 days up to today).
Monthly summation: a toggle that adds totals for individual months to the result.
Cost center: determines which cost center the analysis is processed for. An empty field means all cost centers.
Include non-catalog items: a toggle that also includes document items that are not linked to the price list. You will mainly use it when analyzing goods movement.
Include non-accounting documents: a toggle that includes non-accounting document types in the analysis, such as advance payments and proforma invoices.
Once everything is set, run the analysis using the Analyze button in the bottom-right corner of the panel.
Analysis output
The result is displayed as a list. With the option "Which supplier I bought the most from", you can see the total purchase amount excluding VAT for each supplier for the selected period. In our example, purchases from Papírnictví Lipová s.r.o. totaled CZK 19,500 and purchases from Obaly Morava s.r.o. totaled CZK 9,860. By comparing this with the selling price, you can estimate the expected profit.
The default view shows only a few basic columns. However, the analysis output offers many more, and not every column is suitable for every type of analysis. As in any other agenda, you can customize the columns: click the gear icon in the list header to open Column settings, where you can show or hide columns (eye icon) and change their order by dragging. You can find more about working with columns and saving them in the article on working with Views.
Explanation of several important columns:
Total excl. VAT: the total value of purchases from the given supplier. The value depends on the selected type of analysis.
Discount: the total value of discounts on purchase documents. In the analysis, it is shown both as an amount and as a percentage (the Discount and Discount [%] columns).
Selling price: the selling price of the purchased items.
Total UoM: the number of units of measure of the purchased items. You will mainly use it when analyzing goods movement.
You can save the analysis result using the Export to Excel or Export to XML buttons in the list footer.
ℹ️ Sales Analysis, which evaluates issued invoices, works in a similar way.










