Skip to content
Hypamoon

For teams that run on Björn Lundén

Björn Lundén sales reports: in a spreadsheet

Lundify has a balance sheet, a profit and loss report, a general ledger and a VAT report. For a list of customers who bought this year, sales per article per month or open invoices in Excel, BL Administration users paste a database query that support writes for them.

How it goes today

  1. Ask support on the forum for a query that gives the list.
  2. Paste the query in BL Administration under system maintenance.
  3. Change the dates in the query for the next period.
  4. Open the result in Excel and tidy the columns by hand.

How it can go

Sales per customer, per article and open invoices land in a spreadsheet each month.

On the first of each month you get a spreadsheet from the invoices and orders in Björn Lundén: customers who bought in the period with the amount excluding VAT, sales per article per month, invoices with their delivery date, and unpaid customer and supplier invoices with their due dates. You pick the period and the columns once, and the same lists come back each month, sorted by customer name. Nothing in Björn Lundén changes.

Say this in ChatGPT, Claude or Copilot

Your chat gets connected to Hypamoon first, with this request filled in. Björn Lundén works with a sign-in instead of a key, through an app that has to be approved first. That can take several business days; after that you sign in to Björn Lundén once, never in the chat.

Your request

With Hypamoon, on the first of each month, make a spreadsheet from our Björn Lundén invoices and orders with customers who bought in the period and the amount excluding VAT, sales per article per month, invoices with delivery date, and unpaid customer and supplier invoices with due dates. Sort by customer name and email it to me and our accountant.

Björn Lundén approves each app before it can connect and agrees which data it may use. After that someone with a Björn Lundén login switches the app on for the company under Integrations in Lundify or BL Administration. It stays yours.