Purchasing (Закупка товаров)
The screen is shown in Russian. Labels are given as they appear on screen, with an English translation in brackets.
Why#
Compare one product's price across suppliers, see what got more expensive, check suppliers and stock movement by store for a month.
Where to find it#
Menu «Аналитика» (Analytics) → «Закупка товаров» (Purchasing).
Ekrānuzņēmumsleft menu, «Аналитика» group expanded, «Закупка товаров» highlightedThe section is included in Procure Control, Food Cost Control, Food Cost Managed and the free trial. If the company's plan does not include it, the menu item is not shown.
What is on the screen#
Four tabs at the top. Under each tab: the question it answers, filters, a summary and a table. At the bottom: how the numbers are calculated.
- «Сравнение цен» (Price comparison) - one product across suppliers for the last 3 months, the cheapest highlighted.
- «Динамика цен» (Price trends) - last delivery against the previous one and against the 30-day average.
- «Поставщики» (Suppliers) - all company suppliers for the whole history: invoices, mapping, turnover.
- «Движение товара» (Stock movement) - opening stock + purchases - consumption = closing stock for the month, by store.
On a phone the section shows only «Движение товара».
How to#
Find where a product is cheaper#
- Open the «Сравнение цен» tab.
- In «Показать» (Show) choose «со сравнением (2+)» (with comparison) - only products bought from two or more suppliers. «все товары» (all products) also includes single-supplier products.
- In «VAT» choose «только несоответствия» (mismatches only) to see rows where the invoice VAT rate differs from the expected one.
- In the column «Поставщики - цена за ед. (дешевле выделен)» find the highlighted supplier. «+X%» on the others shows how much more expensive they are than the cheapest.
- Click a product row to open prices by supplier. Here you can change the expected VAT rate: «Изменить ожидаемую ставку НДС» → enter a number → «Сохранить» (Save).
See what got more expensive#
- Open the «Динамика цен» tab.
- In «База расчёта» (Calculation base) choose the window: «30д», «60д», «90д» or «180д» (days).
- In «Класс» (Class) choose «A», «B», «C» or «все» (all).
- In «Направление» (Direction) choose «↑ дорожает» (rising) or «↓ дешевеет» (falling).
- In «Сортировка» (Sort) choose «боль для бюджета» (budget pain - large changes on expensive products first) or «оборот» (turnover).
- Click a product row to see its deliveries and price chart. From there you can open the invoice - «Открыть накладную».
The table shows the first 50 products.
Ekrānuzņēmums«Динамика цен» tab, filters «База расчёта», «Класс», «Направление», «Сортировка» highlightedCheck a supplier#
- Open the «Поставщики» tab.
- In «Активность» (Activity) choose «Все» (All), «Новые» (New) or «Популярные» (Popular).
- Click a supplier - its products open with the price per base unit.
- Find a product with the search field «Поиск товара по названию или коду».
- To go back, click «← Вернуться к списку поставщиков».
See stock movement for a month#
- Open the «Движение товара» tab.
- Use the arrows next to the month on the right to change the month.
- Choose a store or «Все склады» (All stores).
What the numbers mean#
- Prices come from invoices processed in RestoAudit. Only products linked to the Syrve product list are included.
- Price is per base unit (kg, l, pcs): amount without VAT divided by quantity in base units. One invoice is one observation. Returns are not in the price series and are deducted from turnover.
«Сравнение цен» tab, period - last 3 months:
- «Товаров в выборке» - products in the table with current filters.
- «Со сравнением 2+» - products bought from several suppliers.
- «Разброс ≥10%» - products where the most expensive supplier is 10% or more above the cheapest.
- «VAT-несоответствий» - products where the invoice VAT rate differs from the expected one.
«Динамика цен» tab, period - the selected «База расчёта»:
- «Позиций в выборке» - products with current filters.
- «Над порогом» (Over threshold) - price change above the threshold. The threshold depends on class and purchase frequency: frequent A-class ±5%, B and medium frequency ±12%, C and rare ±30%. For seasonal products only the comparison with the previous delivery counts.
- «A-класс» - products that make 80% of turnover.
- «Оборот без НДС» - purchases without VAT for the window.
- «Δ vs last» - last delivery against the previous one inside the window. If the previous one is older than the window, there is nothing to compare.
- «Δ vs 30д avg» - last delivery against the 30-day average excluding it. Does not depend on the window.
- A supplier-change icon in the «Поставщик» column means «Δ vs last» compares two different suppliers.
«Поставщики» tab, period - whole history:
- «Новые» - first invoice within the last month.
- «Популярные» - invoices in two consecutive months, the latest not earlier than last month.
- «Замаппнуто» (Mapped) - share of the supplier's products linked to the Syrve product list.
- «Returns» - share of lines with negative quantity (returns, claims).
«Движение товара» tab, period - calendar month:
- «Закупка» (Purchases) - invoice lines without VAT.
- «Расход» (Consumption) - everything that left stock in the accounting system: recipe consumption, manual write-offs, deleted dishes, ± inventory.
- «Остаток» (Stock) - quantity in store valued at unit cost.
- If the equation does not add up, the screen shows the gap. The usual reason is that the period's invoices are not exported yet.
FAQ#
Why is a product missing from the comparison? It is not linked to the Syrve product list or is bought from one supplier only. Choose «все товары» in «Показать».
Why is there no opening stock? No data came from the accounting system for the previous month. Purchases and consumption are shown, the total is not calculated.
Why is there no average-price alert for a seasonal product? Seasonal prices swing naturally, so only the last delivery is compared with the previous one.