Skip to content
Hypamoon

For teams that run on Twinfield

Twinfield revenue per customer, each month

Twinfield shows revenue per customer once a level 1 user designs a custom report from the general ledger card. Revenue per item works when each item has its own cost centre or revenue account.

How it goes today

  1. Open report design and start from the general ledger card.
  2. Set the columns and criteria so revenue is grouped per customer.
  3. Run it for this year and again for last year.
  4. Paste both into a spreadsheet to compare them.

How it can go

See revenue per customer each month, next to last year, without designing a report.

On the second working day of each month you get one spreadsheet from your Twinfield revenue accounts: revenue per customer for each month this year, the same months last year, the change, and the customers that bought last year and not this year. The columns stay the same, so your own formulas next to them keep working.

Say this in ChatGPT, Claude or Copilot

Your chat gets connected to Hypamoon first, with this request filled in. Twinfield 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 Twinfield once, never in the chat.

Your request

With Hypamoon, on the second working day of each month, make one spreadsheet from our Twinfield revenue accounts with revenue per customer per month this year, the same months last year and the difference, plus customers who bought last year but not this year. Keep the columns the same each month and email it to me.

Connecting to Twinfield needs a paid Twinfield API subscription with Wolters Kluwer, and Wolters Kluwer certifies the connection before it runs at full speed. After that you sign in to Twinfield once to approve it. It stays yours.