---
title: "Holded sales by customer and product: monthly · Hypamoon"
description: "Building a pivot table to see which customer bought which products? Get one report from Holded per customer and product, with units and margin."
url: https://hypamoon.com/connect-to/holded/sales-by-product
---

1.  [Connect to](https://hypamoon.com/connect-to)
2.  [Holded](https://hypamoon.com/connect-to/holded)
3.  Sales by customer and product

For teams that run on Holded

# Holded sales by customer and product: monthly

Holded reports sales per customer and sales per product, each for up to twelve months. Seeing both together, which products each customer bought and how that changes, takes an export and a pivot table.

[Start free](https://app.hypamoon.com/?mode=signup&utm_source=connect-to&utm_campaign=holded/sales-by-product)

## How it goes today

1.  Export the sales invoices with their lines from Holded.
2.  Build a pivot table with customers and products.
3.  Add the cost price to work out the margin.
4.  Do it again for each period you want to compare.

## How it can go

**See which customer buys which products, in one report.**

Each month a report from the invoice lines in Holded: per customer the products, units, sales and margin, for the month and the year so far, next to the same period last year. Customers who stopped buying a product they bought before are listed apart.

## Say this in ChatGPT, Claude or Copilot

Your chat gets connected to Hypamoon first, with this request filled in. You paste your Holded key in the portal, never in the chat.

Your request

> With Hypamoon, each month make a report from our Holded sales invoice lines: per customer the products bought, units, sales without tax and margin from the cost price, for the month and the year so far, next to the same period last year. List the customers who stopped buying a product they bought before, and email me the report as a spreadsheet.

[Build this in your chat](https://hypamoon.com/connect?via=connect-to~holded/sales-by-product&say=a%20monthly%20report%20from%20Holded%20of%20which%20products%20each%20customer%20bought%2C%20with%20units%2C%20sales%20and%20margin%20against%20last%20year.)

[Start free](https://app.hypamoon.com/?mode=signup&utm_source=connect-to&utm_campaign=holded/sales-by-product)

You create the Holded key yourself under Settings, API, and choose what it may read and change. It stays yours.

## More for teams on Holded

-   [**I want to send the SEPA form to my contacts so they fill it in themselves.**](https://hypamoon.com/connect-to/holded/sepa-mandates)
-   [**I want to add my own income and expense lines to the forecast without linking them to an account.**](https://hypamoon.com/connect-to/holded/cash-forecast)
-   [**I want to calculate sales commission per agent; with tags it is a real mess.**](https://hypamoon.com/connect-to/holded/sales-commissions)
-   [**Repeating recurring tasks in every project is tedious and a waste of time.**](https://hypamoon.com/connect-to/holded/recurring-tasks)
-   [**Employees have to be able to report their expenses easily, without seeing everyone else's.**](https://hypamoon.com/connect-to/holded/employee-receipts)
-   [**Different documents with the same name show up as duplicates.**](https://hypamoon.com/connect-to/holded/duplicate-bills)
-   [**I have to create the document myself every time a customer asks for it.**](https://hypamoon.com/connect-to/holded/payment-receipts)
-   [**We repeat the same entries every month and have to do it by hand.**](https://hypamoon.com/connect-to/holded/recurring-journal-entries)
-   [**The worker forgets to clock in, especially when leaving.**](https://hypamoon.com/connect-to/holded/clock-in-reminders)
-   [**A report of average customer collection time and average supplier payment time.**](https://hypamoon.com/connect-to/holded/payment-times)
-   [**We need a record of the hours per project, because the client asks for it.**](https://hypamoon.com/connect-to/holded/project-hours)
-   [**When adding an intra-community contact, check the VAT number against VIES.**](https://hypamoon.com/connect-to/holded/vat-number-check)
-   [**Per customer, the due dates and the items still to be collected.**](https://hypamoon.com/connect-to/holded/aged-receivables)
-   [**You have to go in every day to send dozens of invoices by hand.**](https://hypamoon.com/connect-to/holded/send-invoices)
-   [**With many customers you have to go one by one changing the amount.**](https://hypamoon.com/connect-to/holded/recurring-invoice-prices)
-   [**Everything for Holded**](https://hypamoon.com/connect-to/holded)
