For teams that run on lexoffice
lexoffice sales by customer
Lexware Office has a dashboard and a BWA for the business as a whole. Looking at one customer over several years, or putting three years side by side, means exporting the invoices and building the table yourself.
How it goes today
- Export the invoices for each year separately.
- Sort them by customer in a spreadsheet.
- Subtract the credit notes for each customer.
- Build a table with the years next to each other.
How it can go
See what each customer brings in, year after year.
On the first working day of the month you get a report with net sales per customer for this year to date, next to the same period in the two years before, with credit notes subtracted. The customers who grew or dropped the most are at the top, and you can ask for one customer whenever you like.
Say this in ChatGPT, Claude or Copilot
Your chat gets connected to Hypamoon first, with this request filled in. You paste your lexoffice key in the portal, never in the chat.
With Hypamoon, on the first working day of each month, email me net sales per customer from Lexware Office for this year to date, next to the same period in each of the two previous years, with credit notes subtracted. Put the customers that grew or dropped the most at the top. When I ask for one customer, send their invoices and totals per month.
You create the Lexware Office key yourself on the Public API page of your account, which is part of the XL plan. It is valid for up to 24 months and can be extended there. It stays yours.
More for teams on lexoffice
- I want payment reminders to go out on their own, not one invoice at a time.
- I have two companies in Lexware Office and want one overview.
- I want a reminder to go to customers who have not answered a quote.
- I want to know when the same bill is in Lexware Office twice.
- I want my hours to turn into an invoice without retyping them.
- I want a colleague to approve supplier bills before they are booked.
- Everything for lexoffice