General description #

The profit-loss or P/L combined report gives you an overview of the profit or loss based on the orders for which sales invoices were created. It is one of the most important financial reports in Qbil-Trade, providing insight into the overall financial activity of the trade. The profit and loss report calculates the total margin (net and gross) by listing the revenue and associated costs of a specific order. The profit-loss report provides a detailed description of all costs (transport costs, order costs, production costs, and many others) associated with selling or purchasing a product, calculates the net and gross margin for each order, and thus provides a clear breakdown of the profit or loss generated for each order.
The profit loss report does not include miscellaneous sales invoices if the checkbox “ignore for profits losses” is checked on the misc. sales invoice screen.

The profit and loss report contains information on all sales invoices and miscellaneous sales invoices (if applicable) from the past year. It gives you information about the contracts, orders, and other order costs. The profit and loss report compares and calculates prices from purchase and sale contracts. This report shows whether the company made a profit or a loss on an order for which a sales invoice was created, and it does so in both currency and percentage terms. It helps you determine how well your business is doing. You can filter this report by product, customer, region, and more, just like many other reports.

Objectives/Purposes #

The profit-loss report, being one of the most important and crucial reports of the company, serves the following purposes:

• The report summarizes the company’s financial performance, showing whether the company has made a profit or a loss during the period.
• The profit-loss report can help managers and investors make informed decisions about the company’s financial future. For example, if the report shows that the company is consistently losing money, stakeholders may decide to implement cost-cutting measures or explore new revenue streams.
• The profit loss report can be used to track the profit loss status per relation, product, period, etc. using filters.

Additional filters #

The report is available with two additional filters:

1. Date Range: The date range filter in this report displays only those records that fall between the dates chosen for “From Date” and “To Date” of the filter. The date range filter is used on the Invoice date column, which shows the invoice date entered for an invoice. You can use this filter in the report to view the invoices created between a particular date range.
2. Cost Type: The two options available in the filter are “expected and finalized” and “finalized.”. These filters allow you to get the profit-loss status of your orders as per the finalized and expected values of the various costs related to the order, which include transport and other order costs. The data displayed for each selection of filter is as follows:
   • Expected and finalized: When the option is selected, the report displays both the expected and finalized amount for various order costs and transport order costs in their respective columns.
   • Finalized: The option displays only the finalized amount of various order costs and transport order costs, leaving the expected costs out.
     Note: The margin and profit of the orders may change depending on the option selected in the filters.

Columns #

• Invoice Number: This column provides the sales invoice number of the order. For a miscellaneous sales invoice, this column displays the misc. sales invoice number. On hover, the column displays the info text “Invoice number”.
• Order number: The order column mentions the order number generated automatically. On hover, the column displays the info text “Order number”.
• Location/delivery address: The unloading/delivery address of the product added to the destination of the orderline is displayed in this column. On hover, the column displays the info text “Address chosen for delivery”.
• Subsidiary: This column shows the name of the subsidiary for which the invoice has been made. On hover, the column displays the info text “Subsidiary that owns the contract/lot.”.
• Quarter: The quarter field shows the quarter number and year of the invoice date. On hover, the column displays the info text “Quarter”.
• Invoice Date: The date of the sales invoice for the order is mentioned in this field. On hover, the column displays the info text “The invoice date”.
• Period: The period column shows the month and year of the invoice. On hover, the column displays the info text “Period”.
• Supplier: The supplier is the trader in the purchase contract, which is mentioned in this field.  On hover, the column displays the info text “The Supplier”.
• Supplier relation type: The column displays the relation type of the supplier. On hover, the column header displays the short info text “Supplier relation type.”
• Supplier Grade: The grade of the supplier relation is displayed in this column. On hover, the column displays the short info text “Supplier Grade.”
• Supplier Reference: Any reference number related to the supplier is displayed in this column. On hover, the column displays the info text “Reference number of the supplier”.
• Customer: The buyer of the product is mentioned in this field. For a miscellaneous sale invoice, the company name of the relation for which the invoice was created is given in this column. On hover, the column displays the info text “Buyer of the product”.
• Customer relation type: The column displays the relation type of the customer. On hover, the column header displays the short info text “Supplier relation type.”
• Customer Grade: The grade of the customer relation is displayed in this column. On hover, the column displays the short info text “Customer Grade.”
• Client Country: Country of the buyer is mentioned in this field. On hover, the column displays the info text “Client Country”.
• Region:  Region to which the client country belongs is shown in this column. The region is fetched from the country screen. On hover, the column displays the info text “Region of the Country”.
• Purchase product code: The shortcode of the product purchased is displayed in this column. On hover, the column displays the info text “Shortcode of the purchase product”.
• Our reference: This column displays a reference number that is generated for an order from the Purchase contract number and Order number or warehouse reference. On hover, the column displays the info text “The reference number of the lot as known by the subsidiary”.
• Warehouse reference: The warehouse ref number or code entered in the orderline of the related order is displayed in this column. On hover, the column displays the info text “The reference number of the lot as known by the warehouse”.
• Purchase Incoterms: The delivery conditions agreed for the purchase contract are displayed here. On hover, the column displays the info text “Incoterms(Purchase contract)”.
• Purchase quantity: The quantity of the product in the purchase contract of the order. On hover, the column displays the info text “Purchased Quantity”.
• Purchase unit: The unit of the product in the purchase contract is shown in this field. On hover, the column displays the info text “Purchase Unit”.
• Purchase price per ton: The price of the product per ton(1000 units) in the purchase contract is shown here. On hover, the column displays the info text “Purchase ppt”.
• Purchase price unit: The pricing unit as per the purchase contract is given in this column. On hover, the column displays the short info text “Purchase pricing unit.”
• Purchase Amount: The total amount of the purchased quantity is displayed in this field. On hover, the column displays the info text “Purchase amount”.
• Purchase analysis costs: The column shows any costs added against the analysis of the purchased product. On hover, the column displays the info text “Analysis value of the purchase quantity of stock”.
• Purchase anti-dumping costs: This shows the value of any anti-dumping duty imposed on products. On hover, the column displays the short info text “Purchase anti-dumping costs”.
• Purchase commission costs: The commission of the broker(if involved) in the purchase contract is displayed in this column. On hover, the column displays the short info text “Purchase commission costs”.
• Purchase demurrage costs: Any demurrage costs involved in the product delivery are mentioned here. On hover, the column displays the info text “Purchase demurrage costs”.
• Purchase Document costs: Any charges related to documentation are shown in this field. On hover, the column displays the info text “Purchase document costs”.
• Purchase forwarding costs: Any costs involved in the expedition are mentioned in this column. On hover, the column displays the info text “Purchase forwarding costs”.
• Purchase import duties costs: Any import duties charged for an order are displayed in this field. On hover, the column displays the info text “Purchase import duties costs”.
• Product included estimated mark up: This field mentions any cost charged on the product for storage in the warehouses where these charges have already been defined on the basis of per week per 1000 kg. On hover, the column displays the short info text “Purchase included estimated markup”.
• Purchase included interest: Any carried interest amount charged against the purchased quantity is mentioned in this field. On hover, the column displays the short info text “Purchase included interest”.
• Purchase mixing costs.: Any costs involved in the production of the stock product are shown in this field. On hover, the column displays the short info text “Purchase mixing costs”.
• Purchase storage costs: Any costs imposed for the storage of the product in the warehouse are fetched in this column. On hover, the column displays the info text “Purchase storage costs”.
• Purchase other costs: Miscellaneous costs involved with the purchase contract are mentioned in this field. On hover, the column displays the info text “Purchase other costs”.
• Purchase other transport costs: Miscellaneous transport costs applied for the delivery, loading and unloading of a product are displayed in this column. On hover, the column displays the short info text “Purchase other transport costs”.
• Purchase terminal container costs: Charges related to a container or terminal handling of purchased products are displayed here. On hover, the column displays the short info text “Purchase anti-dumping costs”.
• Purchase transport costs: Any transport charges implied while shipping purchased products against the purchase contract is displayed in this column. On hover, the column displays the short info text “Purchase transport costs”.
• Purchase cutting costs: Charges related to the cutting of purchased products are shown in this field. On hover, the column displays the short info text “Purchase cutting costs”.
• Purchase repackaging cleaning costs: Costs implied due to repacking & cleaning of the purchased products. On hover, the column displays the short info text “Purchase repackaging cleaning costs”.
• Purchase processing costs: Any processing charges included against purchase quantity are shown here. On hover, the column displays the info text “Purchase processing costs”.
• Purchase interest costs: Any interest paid against a purchase contract of the related order is displayed here. On hover, the column displays the info text “Purchase interest costs”.
• Purchase estimate storage costs: Any charges related to the storage of products from the purchase contract are displayed here. On hover, the column displays the info text “Purchase estimate storage costs”.
• Purchase Value: The total cost of the purchased quantity including all the extra costs. On hover, the column displays the info text “Total Purchase value”.
• Sales product code: This field displays the name of the Selling product or product name mentioned in the sale contract. On hover, the column displays the info text “Shortcode of the sales product”.
• Tarif/Eural Code: Tarif code column shows the tariff code of the product. On hover, the column displays the info text “Tariff code”.
• Sales item group: This field shows the product group of the selling product. On hover, the column displays the info text “Product group the sales product belongs to”.
• Sales packing: The type of packing used for selling products is mentioned in this field. On hover, the column displays the info text “Sales packaging”.
• Sales tax: This shows the VAT percentage applied in the sales contract of the order. On hover, the column displays the info text “Sales tax”.
• Sales Quantity: The product quantity in the sales contract is mentioned in this field. On hover, the column displays the info text “Sales quantity”.
• Sales unit: The unit of product on the sales contract is displayed in this field. On hover, the column displays the info text “Sales unit”.
• Analysis: Any analysis costs charged for sales products are displayed in this column.  On hover, the column displays the info text “Analysis original value of the stock”.
• Anti-dumping costs price: Any anti-dumping costs implied on sales products are mentioned in this field. On hover, the column displays the info text “Anti-dumping costs”.
• Commission costs: Commission costs paid to the broker (if involved in the sales contract) are displayed in this field. On hover, the column displays the info text “Commission costs”.
• Demurrage costs: Any demurrage costs that are paid for the sales product are mentioned in this column.  On hover, the column displays the info text “Demurrage costs”.
• Document costs: Any documentation involved in documentation against the sales contract is mentioned in this field.  On hover, the column displays the info text “Document costs”.
• Forwarding costs: Any expedition charges involved against sales products are shown in this field. On hover, the column displays the info text “Forwarding costs”.
• Import Duties costs: The import duty tax imposed for the transportation or delivery of sale products is shown here. On hover, the column displays the info text “Import duties costs”.
• Repacking Cleaning costs: Any costs charged for the repacking or cleaning of the sales product are shown in this field. On hover, the column displays the info text “Repacking cleaning costs”.
• Storage Costs: Costs involved in the storage of sales product is shown in this field. On hover, the column displays the info text “Storage costs”.
• Other costs: Any miscellaneous costs involved in the maintenance of the sales product are mentioned in this field. On hover, the column displays the info text “Other costs”.
• Other Transport costs: Any miscellaneous transport charges paid are also mentioned in this field.  On hover, it displays the info text “Other transport costs”.
• Terminal container fees: Any charges against terminal or container handling or operating are mentioned in this field. On hover, the column displays the info text “Terminal container fees”.
• Transportation costs: Transporation charges for the ordered quantity are displayed in this field.  On hover, the column displays the info text “Transportation costs”.
• Cutting costs: Charges related to the cutting of Selling products are shown in this field.  On hover, the column displays the info text “Cutting costs”.
• Processing costs: Any processing costs on sales product are mentioned here.  On hover, the column displays the info text “Processing costs”.
• Costs of Sales: The total costs involved in the sales side are mentioned here. On hover, the column displays the info text “Cost of sales”.
• Sales price per ton: This field shows the sales price of the product per ton. On hover, the column displays the text “Sales ppt”.
• Sales pricing unit: The column displays the pricing unit as per the sales contract. on hover, the column gives the short info text “Sales pricing unit.”
• Position list price per ton: This field shows the reference price of the product mentioned in the order in the currency of the subsidiary. On hover, the column displays the text “Position list ppt”.
• Reference PPT euro: This field shows the reference price of the product mentioned in the order in EURO. On hover, the column displays the text “Reference ppt Euro”.
• Sales Value: This field shows the rate of sales quantity including sales side costs. On hover, the column displays the text “Sales value”.
• Interest Costs: Any interests paid against sales quantity are mentioned here. On hover, the column displays the text “Interest costs”.
• Result: The net profit or loss amount is mentioned in this field. On hover, the column displays the text “Result”.
• Margin: The net profit or loss in percentage is shown in this field. On hover, the column displays the text “Margin”.
• Gross Profit: The gross profit or loss amount is mentioned in this field. On hover, the column displays the text “Gross Profit”.
• Gross Margin: The gross profit or loss in percentage is shown in this field. On hover, the column displays the text “Gross margin”.
• Broker: This field shows the name of the broker involved in the order. On hover, displays the text “Broker involved with this contract”.
• Printed: This shows whether the order has been printed or not. On hover, the column displays the text “Invoice is printed or not”.
• Emailed: This shows whether the order has been emailed or not. On hover, the column displays the text “Emailed”.
• Exported: This shows whether the order has been exported or not. On hover, the column displays the text “Exported”.
• Purchase Sender: This field shows the name of the trader/sender(if any) involved in the Purchase Contract of the related order. On hover, the column displays the text “Purchase Sender”.
• Sales Sender: This field shows the name of the trader/sender(if any) involved in the Sales Contract of the related order. On hover, the column displays the text “Sales Sender”.
• Purchase contract: The purchase contract number of the order is shown in this field. On hover, the column displays the text “Purchase contract”.
• Sales Contract: The sales contract number of the order is shown here. On hover, the column displays the text “Sales contract”.
• Sales Incoterms: The delivery conditions selected in the sales contract are shown here. On hover, the column displays the text “Incoterms (Sales contract)”.
• Order Quantity: The product quantity in order or ordered quantity is shown in this field. On hover, the column displays the text “Order Quantity”.
• Quantity: The invoiced quantity is displayed in the Sales quantity. On hover, the column displays the text “Quantity per contract line”.
• Payment Condition: The payment conditions agreed against the sales contract is defined in this field. On hover, the column displays the text “Payment conditions”.
• Logistic Employees: This column shows the logistic employees of the buyer involved in the sales contract.  On hover, the column displays the text “Responsible logistic employees”.
• Created by: This field shows the name of the employee who created the order. On hover, the column displays the text “Created by”.
• Purchase accounting code: This is a dynamic field that fetches data from the product screen. The accounting code added in the product details (of purchase product) is displayed here.  On hover, the column displays the text “Purchase accounting code”.
• Sales Accounting Code: The accounting code of the sales product is displayed here. The code is fetched from the product screen. It is a dynamic field.  On hover, the column displays the text “Sales accounting code”.
• DUNS code: This field shows the nine-digit DUNS number of the buyer.  On hover, the column displays the text “DUNS code”.
• ONS code: This field shows the ONS number of the relation. On hover, the column displays the text “ONS code”.
• Unloading Date: The unloading date of the order is shown in this column. On hover, the column displays the info text “Unloading Date”.
• Foreign hedge accruals Purchase: The costs added due to currency hedging are mentioned in this field. On hover, the column displays the info text “Foreign hedge accruals purchase”.
• Foreign hedge accruals Sale: Any costs raised due to currency hedging of sales products are shown in this field. On hover, the column displays the info text “Foreign hedge accruals sales”.
• Your VAT Number: The VAT number of the buyer is displayed in this column. On hover, the column displays the info text “VAT number of the supplier/buyer”.
• Supplier Country Code: Two-letter country code of the supplier is shown in this column. On hover, the column displays the info text “Supplier country code”.