Xero feature missing: revenue/invoices by customer

Forums › IT Pro and developers › Xero feature missing: revenue/invoices by customer

freitasm

BDFL - Memuneh
80646 posts

Uber Geek
+1 received by user: 41029

Administrator

ID Verified

Trusted

Geekzone

Lifetime subscriber

#70489 25-Oct-2010 08:20

This week I was looking aroun Xero to find out exactly how much revenue per customer we have had in the last few years. There isn't a report for that - unless you go to each customer and list invoices updating the start/end period.

I wanted a simple report that would list the Top [X] customers by revenue in a period. Lucky we only have a few customers so I could manually check the ten or so records for the top ones, but anyone with a bigger flow would need more than this.

Referral links: Quic Broadband (free setup code: R587125ERQ6VE) | Samsung | AliExpress | Wise | Sharesies

Support Geekzone by subscribing (browse ads-free), or making a one-off or recurring donation through PressPatron.

alasta

6888 posts

Uber Geek
+1 received by user: 3362

Trusted

Subscriber

#395426 25-Oct-2010 09:55

It's a pity you can't design customised reports. That's a pretty standard feature with the major out-of-the-box accounting packages.

CatherineXero

6 posts

Wannabe Geek

Trusted

Xero

#395454 25-Oct-2010 11:56

@freitasm I was wondering how useful the Income by Contacts report would be? It lists all customers invoiced in a particular period, with the overall total for that customer. And if you update the report to run period=12 months, compare with previous=3 months for example, you'd get the amount invoiced for the last 4 years for each customer with an overall total for the 4 years. Sure, you'd need to export the report to spreadsheet in order to sort by biggest customer per year or overall total but in the absence of a specific Top X report you might still be able to get what you need? You can also drill into any of the yearly figures or overall total to get the list of invoices (again, you'd have to export and combine all this data if you wanted it all in one place to that level).

Catherine Walker
Community Manager, Xero
http://www.xero.com

freitasm

BDFL - Memuneh
80646 posts

Uber Geek
+1 received by user: 41029

Administrator

ID Verified

Trusted

Geekzone

Lifetime subscriber

#395503 25-Oct-2010 16:44

Yes, that will do it... Interesting when I asked Xero Support about this the answer was to view invoice by individual contact. No mention of Income by Contact report.

Thanks

Referral links: Quic Broadband (free setup code: R587125ERQ6VE) | Samsung | AliExpress | Wise | Sharesies

Support Geekzone by subscribing (browse ads-free), or making a one-off or recurring donation through PressPatron.

CatherineXero

6 posts

Wannabe Geek

Trusted

Xero

#395508 25-Oct-2010 17:00

Eeek, would like to track that down - do you have a ticket number?

Catherine Walker
Community Manager, Xero
http://www.xero.com

brewer

18 posts

Geek

#402428 10-Nov-2010 00:53

Hey Mauricio we're currently developing a tool that let's Xero customers create their own business intelligence dashboard. Take a look at www.thinkcloud.co.nz we are looking for people interested in being our beta test drivers. Please contact me on the website if you're interested.
Cheers, Rob Owen.