Partisanship in analysis: how to track movement and profit on a specific supplier invoice

How to understand what happened to a specific purchase after goods receipt

If you need to understand what happened to a specific purchase after goods receipt, Torgsoft allows you to use accounting and analytical reports by supply batches and goods receipt invoices. They help you see how many goods were sold, returned, written off, what stock balance remains in the warehouse, and what financial result was generated by a specific purchase or a group of invoices combined into one supply batch.

You can combine documents in the system by creating "Supply Batches" in the goods supply directory and linking both existing and new goods receipt invoices to them.

The tool for evaluating the profitability of each purchase is the "Analysis of Goods Movement by Supply Batches" report. This report provides detailed information about goods movement for the selected period, by a specific goods receipt invoice, from any supplier in a specific currency.

What indicators can be analyzed in the report

• Purchase and return history. When and at what prices the goods were purchased, as well as information about the quantity and amount of returns to the supplier and defective goods returns.

• Sales details. The quantity of goods sold, sales amount, retail price, as well as the amount and percentage of the discount provided.

• Write-offs and customer returns. The report shows the quantity and amount of returns of this product from customers, as well as information about goods write-off.

• Financial result (Profitability). In the summary data, you can see the balance, received proceeds (sales amount minus returns amount), and final revenue (calculated as: sales amount — returns amount — cost of sales + cost of returns).

How to configure the report for detailed analysis

• Filtering. You can filter data by supplier, purchase currency, and also use the "Invoice Payment Method" field (for example, to analyze the profitability of goods receipt invoices taken "On Consignment" or with "Deferred Payment").

• Additional profit settings. The form contains the "Include write-offs when calculating profit" setting, which allows written-off goods to be deducted from the final profit of the supply, as well as the option to calculate based on the purchase price, purchase cost, or accounting price.

• Grouping. For convenient analysis, you can click and drag the header of any column (Name, SKU, Barcode) to a special grouping strip. This allows you to sort products, for example, from the smallest sales amounts to the largest.

How to track goods movement and profit by goods receipt invoice or supply batch

For an even more accurate profitability assessment of each separate purchase, you should use the "Goods Receipt Invoice Profitability Analysis" report.

• It allows you to see how many goods from a specific invoice were sold during the period from the date of its creation to the specified moment.

• This report has the "Supply Batches" filter, which will display the goods from all invoices related to the specified batch.

• The report shows the quantity of remaining goods, their value in purchase prices, sales amounts, returns, discounts, as well as total revenue and profit.

• You can view a detailed breakdown of sold goods: the sale date, how much was sold and at what price, what discount was applied, and what profit the sales generated depending on the price change.

• Assessment for decision-making: the form displays information about the total percentage of goods sold from this goods receipt invoice. This information is important for analyzing the priority of paying credit invoices: if the sales percentage is low, the owner should ask the supplier for an additional payment deferral.