Demo workspace · synthetic data · Foresail, FP&A that sets itself up

Customer revenue

Apr-26 to Sep-26NWES1 customer£k, net of VAT and credit notes

Largest customer: Distribuciones Sol SA, 100.0% of invoiced revenue from Apr-26 to Sep-26.

Invoiced against P&L revenue

GBPk · sales invoices less credit notes against revenue in the P&L · click P&L revenue for its accounts

MonthInvoicedP&L revenueRevenue less invoicedShare invoiced
Apr-2612.8151.6138.88.4%
May-2612.8158.5145.78.0%
Jun-2612.8151.3138.58.4%
Jul-2612.8159.6146.88.0%
Aug-2612.8164.9152.27.7%
Sep-2612.8157.7145.08.1%
Total76.5943.5867.08.1%

P&L revenue is every revenue account, partner cross-sales included. Revenue less invoiced is revenue posted by journal, such as accrued income or fees taken at withdrawal. A negative figure is invoiced ahead of revenue, such as deferred income or an invoice dated a month before its revenue.

Owed by customers

GBPk · approved invoices not yet paid, less unapplied credit notes, as at 25 Oct 2026 · by days past the due date · click a figure for its invoices

CustomerCurrent1 to 30 days31 to 60 days61 to 90 daysOver 90 daysTotal
Distribuciones Sol SA12.812.8
Total0.00.012.80.00.012.8

12.8 of 12.8 is overdue (100%).

Against the receivables control account

EntityCurrencyAs atOpen invoicesControl accountDifference
NWESEUR25 Oct 202615.015.00.0

In thousands of each entity's own currency, read from Xero at the same sync. A difference is usually unapplied customer overpayments or prepayments, journals posted to the control account, a document dated after the sync, or a foreign-currency revaluation.

Invoices to collect in the next 14 days

Approved sales invoices overdue at the last sync (25 Oct 2026) or due within 14 days of it, with the same customer's unapplied credit notes, in the currency each is invoiced in · chase the overdue ones first · nothing is sent to customers or posted to Xero

CustomerDocumentDueDays overdueTo collect €
Distribuciones Sol SAES-031115 Sept 202640€15k
Total, of which €15k overdue€15k

What moved revenue

GBPk · invoiced in Jul-26 to Sep-26 against Apr-26 to Jun-26, by customer · click a figure for its customers

CustomersGBPk
Apr-26 to Jun-2638.3
New customers00.0
Higher from existing customers00.0
Lower from existing customers00.0
No longer invoiced00.0
Jul-26 to Sep-2638.3

Net revenue retention: 100.0%, what the customers invoiced in Apr-26 to Jun-26 brought in during Jul-26 to Sep-26 against what they brought in before, new customers left out. New customers had nothing invoiced in Apr-26 to Jun-26; "no longer invoiced" had nothing in Jul-26 to Sep-26. A customer with only credit notes counts as not invoiced.

Revenue by customer cohort

GBPk · customers grouped by the first month they were invoiced, and what each group brings in every month · click a count for its customers

CohortCustomersInvoiced in Sep-26Apr-26May-26Jun-26Jul-26Aug-26Sep-26Total
Invoiced in Apr-261112.812.812.812.812.812.876.5
Total1112.812.812.812.812.812.876.5

A customer joins the cohort of the first month here with an invoice. Customers already invoiced in Apr-26, the first month held, are grouped there, though some started earlier. A customer with only credit notes joins the month of its first one. Each month's cohorts add up to the month's invoiced revenue.

New in Sep-26

First invoice in Sep-26, none in the months before it here

No new customer this month.

Biggest changes in Sep-26

Against the customer's average month before it · positive is more revenue

No customer moved by £1k or more.

Not invoiced in Sep-26

Invoiced in the months before Sep-26 but not in it · largest average month first

Every customer invoiced before Sep-26 was invoiced in it too.

Revenue by customer

GBPk · largest first · click a figure for its months

CustomerApr-26May-26Jun-26Jul-26Aug-26Sep-26TotalAverage beforeChange
Distribuciones Sol SA12.812.812.812.812.812.876.512.80.0
Total12.812.812.812.812.812.876.5

Sales invoices and customer credit notes as entered in Xero (submitted, approved or paid), by the month of the invoice, every entity in GBP at the month's average rate. A blank month had no invoice. A negative month had more credit notes than invoices. Invoice totals can differ from P&L revenue: journals and accrued income aren't invoices. Months after Sep-26 aren't closed yet, so they're left out.