---
title: "Twinfield revenue per customer, each month · Hypamoon"
description: "Designing your own Twinfield report to see revenue per customer? Get each month's revenue per customer next to last year, in one spreadsheet."
url: https://hypamoon.com/connect-to/twinfield/revenue-per-customer
---

1.  [Connect to](https://hypamoon.com/connect-to)
2.  [Twinfield](https://hypamoon.com/connect-to/twinfield)
3.  Revenue per customer

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.

[Start free](https://app.hypamoon.com/?mode=signup&utm_source=connect-to&utm_campaign=twinfield/revenue-per-customer)

## 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.

[Build this in your chat](https://hypamoon.com/connect?via=connect-to~twinfield/revenue-per-customer&say=a%20monthly%20spreadsheet%20from%20Twinfield%20with%20revenue%20per%20customer%20per%20month%2C%20next%20to%20last%20year%2C%20and%20customers%20who%20stopped%20buying.)

[Start free](https://app.hypamoon.com/?mode=signup&utm_source=connect-to&utm_campaign=twinfield/revenue-per-customer)

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.

## More for teams on Twinfield

-   [**I want to charge interest and collection fees on late invoices, but credit management only uses the invoice amount.**](https://hypamoon.com/connect-to/twinfield/late-payment-charges)
-   [**I have to fix the MT940 file from my payment provider in a text editor before Twinfield accepts it.**](https://hypamoon.com/connect-to/twinfield/payment-provider-payouts)
-   [**Someone deleted a draft entry and I can't see what was in it.**](https://hypamoon.com/connect-to/twinfield/deleted-drafts)
-   [**I booked dozens of entries on the wrong account and have to correct them one at a time.**](https://hypamoon.com/connect-to/twinfield/reclassify-entries)
-   [**Each month I generate the same reports in Twinfield, wait for them and download them.**](https://hypamoon.com/connect-to/twinfield/monthly-report)
-   [**I build my cash flow forecast in a spreadsheet from Twinfield exports every week.**](https://hypamoon.com/connect-to/twinfield/cash-forecast)
-   [**Everything for Twinfield**](https://hypamoon.com/connect-to/twinfield)
