Sales and Purchases Summary Report

Sales and Purchases Summary Report in Qoyod

(Product-level analytical report)

What is the Sales and Purchases Summary Report?

The Sales and Purchases Summary Report is an analytical report that shows product performance during a specified time period in terms of:

• Quantities sold and purchased

• Average selling and buying prices

• Return quantities

• Net amounts after calculating returns

️ This report does not display invoices or their numbers, and is not used to review accounting entries—it is only used for product performance analysis.

When should I use this report?

Use the Sales and Purchases Summary Report if you want to:

• Know the quantity of sales or purchases for each product

• Analyze the average selling or buying price

• Know the impact of returns on each product

• Compare product performance over a time period

• View sales for a single customer or purchases from a single supplier

• Analyze products by specific location / warehouse

And do not use it if you need:

• Invoice numbers

• Details of each transaction

• An accounting report (in that case use account statement or income statement)

How to generate the report

1. Go to the dropdown menu

2. Select Reports

3. Select Sales and Purchases Summary

4. Set the time period

5. Set the locations

   • You can select one or more locations

6. Set the party

   • One customer only or one supplier only

7. Set the type

   • Sales only

   • Purchases only

   • Or both

8. Click Search

How does the report rely on dates?

The report fully relies on:

Document Issue Date
This is the same as the accounting entry date.

Example:

• An invoice was created on 1/1

• But the issue date was set to 26/1
  → It will be counted in the report within the date of 26/1

How to access the report

From the main menu:
Reports → Sales and Purchases Summary

Available filter options in the report

1️⃣ Time Period

• From date

• To date

The report displays only transactions whose issue date falls within the specified period.

2️⃣ Locations (Branches / Warehouses)

• You can select one or more locations

• Location is mandatory in sales and purchase invoices

3️⃣ Party

• One customer only (for sales)

• One supplier only (for purchases)

You cannot select more than one customer or supplier in the same report

4️⃣ Report Type

• Sales only

• Purchases only

• Sales and purchases together

5️⃣ Show non-inventory products

When this option is enabled:

• Non-inventory products will appear (such as services)

• The displayed quantity reflects the unit used in the invoice

  • Example: service hours, sessions, subscriptions

• It does not necessarily mean an actual inventory quantity

What does the report display?

First: At the product level

The report displays all products that:

• Were sold

• Or were purchased
  during the specified period

Even if:

• The product’s sales equal its purchases (net zero)

• Or all its movement was returns

Purchases section (for each product)

Displays:

• Average purchase price

• Quantity purchased

• Return quantity

• Average return value

• Final total

How the total is calculated in purchases:

Sales section (for each product)

Displays:

• Average selling price

• Quantity sold

• Return quantity

• Average return value

• Final total

How the total is calculated in sales:

How is average price calculated?

The system is based on the Weighted Average.

This means the price is not calculated from a single invoice, but from all transactions during the period.

Illustrative example of how average price is calculated (Weighted Average)

Suppose you have one product, and during the period you set in the report, it had two sales transactions:

• In the first transaction, 10 units were sold at 100 SAR per unit

• In the second transaction, 30 units were sold at 80 SAR per unit

The system does not take the price from one invoice and display it as the average,
but rather adds up the total sales value and divides it by the total quantity sold.

The calculation is as follows:

• First sale value = 10 × 100 = 1,000 SAR

• Second sale value = 30 × 80 = 2,400 SAR

• Total sales value = 3,400 SAR

• Total quantity = 40 units

The average selling price that will appear in the Sales and Purchases Summary Report is:

3,400 ÷ 40 = 85 SAR per unit

Therefore, even if no single invoice has an exact price of 85 SAR,
this figure will appear in the report because it represents the true average selling price during the period.

Very important notes to understand the numbers

️ The product appears if:

• It had only sales

• Or only purchases

• Or sales and returns are equal (net zero)

The product does NOT appear if:

• It is archived
  even if it had transactions during the period

Returns

• Returns are based on credit notes

• They take effect immediately upon saving and approval

• They do not need allocation to reflect in the report

Currency

• The report displays all values in the entity’s base currency only

• Even if invoices are in foreign currency

Tax

• The report is tax-exclusive

• Prices and quantities are without tax

To view tax:

• Use the Tax Sales Invoices Report

• Or the Tax Purchases Invoices Report

What does this report NOT display?

Invoice numbers
Dates of each transaction
Details of entries
All customers in one report

Export and report usage

• At the top of the report you will find options to:

  • Export to Excel

  • Export to PDF

• After export:

  • The file is automatically sent to the email of the user who requested the report

Alternative report for common cases

I need total sales for multiple customers

Use:
Income Statement → Advanced Analysis → Dimension Type: Customers

If you need:

A report showing a group of customers with their total sales and net profit

Use the Income Statement Report instead:

Steps:

1. Go to Reports

2. Select Income Statement

3. Click Advanced Analysis

4. Set the time period

5. In Dimension Type select Customers

6. Specify the customer names required

7. Click Search

I need transaction details

Use:
Account Statement Report

I need an accounting review

Use:
Trial Balance or General Ledger

Export

You can:

• Export the report to Excel

• Or export it to PDF

After export:

• The file is automatically sent to the user’s email

Required permissions

To access the report:
Settings → Users → Manage Roles
Enable permission:
Reports → Sales and Purchases Summary

Frequently Asked Questions (FAQs)

Why is the average price different from the invoice prices?
Because it’s a weighted average and not the price from a single invoice.

Why does the product appear with zero quantity?
Because net sales equal returns.

Why is the report different from the income statement?
Because this is an analytical report at the product level, not an accounting report.

Is the report affected by allocation?
No, allocation has no effect. The impact comes only from the entry.