For teams that run on Moneybird
Moneybird revenue per product, each month
Moneybird reports revenue per contact, project and ledger account. To see revenue per product, its own help article suggests exporting the invoices per line to Excel and sorting on the description.
How it goes today
- Export the sales invoices per invoice line to Excel.
- Sort the lines on the description and add them up per product.
- Clean up lines where the description was typed differently.
- Repeat the export every month and paste it next to the last one.
How it can go
See what each product or service brings in, month by month.
On the first working day of the month you get an overview per product: quantity, revenue excluding VAT, and the same month last year, built from the invoice lines in Moneybird. Lines without a product are grouped by their description, so you see what still needs a product. The overview stays up to date on a page you can open any day.
Say this in ChatGPT, Claude or Copilot
Your chat gets connected to Hypamoon first, with this request filled in. You paste your Moneybird key in the portal, never in the chat.
With Hypamoon, every first working day of the month, send me an overview of our revenue per product from Moneybird: quantity sold and revenue excluding VAT for last month, next to the same month a year earlier. Group invoice lines without a product by their description and list those separately. Keep the same overview on a page I can open any day.
You create the Moneybird API token yourself in Moneybird, under your user account, Developers. It stays yours.
More for teams on Moneybird
- I want to raise my prices by a few percent without editing each product and each recurring invoice.
- I want to charge interest on invoices that are paid late, without working it out per invoice.
- I want my credit card transactions in Moneybird without converting the statement every month.
- I want to put in a week of hours at once, from the calendar or sheet where I already keep them.
- I want customers who do not reply to a quote to get a reminder.
- I want a work order for my team from the accepted quote, without the prices on it.
- I want to send a proforma invoice for a prepayment or for customs, without it counting as an invoice.
- I want to mark a set of old unpaid invoices as uncollectible together.
- I want the numbers of my companies together without merging spreadsheets.
- I want my sales to consumers in other EU countries per country and rate, ready to enter in the one-stop shop return.
- I want the cost of my sold products on the books without a journal entry per sale.
- Everything for Moneybird