How to check whether a batch of goods has paid off: invoice profitability analysis

Evaluation of a specific batch: how to check the profitability of a specific incoming invoice and whether a specific purchase has paid off, taking into account discounts given to customers?

To assess whether a specific purchase (product batch) has paid off, Torgsoft provides a special report: «Incoming Invoice Profitability Analysis». This tool allows you to track the lifecycle of products from a specific delivery, from the moment they are posted to the current date.

This report can be opened in three ways:

1. Through the main menu Analysis -> Incoming Invoice Profitability Analysis.

2. Through the menu Warehouse -> Incoming Invoice Register -> select the required invoice and click the Profitability of the selected incoming invoice button.

3. Through the menu Document -> Incoming Invoice Check -> click the Invoice Profitability button.

What information the report provides for profitability assessment

The user can configure which columns should be displayed. For each product item from the selected invoice, the program shows detailed information:

• Sales revenue and profit received: calculated for each sold product, taking its cost into account.

• Amount and percentage of discounts provided: you can clearly see how much money was lost in the form of customer discounts (discount cards, promotions, and so on) for each item from this batch.

• Quantity of sold products and stock balances: shows how many units have already been sold and how many are still in stock.

• Value of stock balances: the amount, at purchase prices, for which the product still remains in stock.

• Prices: comparison of the purchase price and the actual selling price.

• Returns: the amount and quantity of products that customers returned specifically from this delivery.

Important details for obtaining accurate data

• For profit data to be correct, it is recommended to use the Recalculate cost button directly in this report window. This updates the cost of the products included in the selected invoice.

• The report form also displays the overall percentage of products sold from the invoice. This indicator helps analyze the priority of payments to the supplier. For example, if the products were taken on consignment or with deferred payment, and the sales percentage is low, you can request a payment deferral.

• If your purchase was issued not with one invoice but with several, you can combine them in the supply directory into a single Supply Batch. The profitability analysis has a «Supply Batches» filter, which allows you to see the consolidated profitability result for the entire batch at once.