Skip to content
Hypamoon

For teams that run on InvoiceXpress

InvoiceXpress sales report by customer and item

In InvoiceXpress the Reports menu, with invoicing by customer, invoicing by item and outstanding payments, comes with the X500 plan and higher. On the smaller plans the customer account statement is the report, and the rest starts with an export of the document list to Excel.

How it goes today

  1. Filter the invoices on type, status and the dates of last month.
  2. Select the page, then every document, and export with the items to Excel.
  3. Build a pivot table by customer and by item.
  4. Look up separately which invoices are still open.

How it can go

Your month in sales arrives by email, by customer and by item.

On the first working day of the month you get one email: net sales of last month by customer and by item, next to the same month last year, with credit notes taken off. The top five customers are on top, and the invoices still open follow with their days past due. The numbers come from the documents in InvoiceXpress, and your accountant can be on the copy.

Say this in ChatGPT, Claude or Copilot

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

Your request

With Hypamoon, on the first working day of each month, email me last month's net sales from InvoiceXpress by customer and by item, next to the same month last year, with credit notes deducted. Add the top five customers and the invoices still open with their days past due. Copy my accountant.

You create the API key yourself in InvoiceXpress under Settings, Account Preferences, API, for your own user, and can regenerate or remove it there. It stays yours.