Need more, need help now?
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals

generating a sales report of top customers

Sage 50 general help forum - Free help and support for all general issues
Post Reply
gaddsgav
User
User
Posts: 2
Joined: 24 Mar 2020, 17:41
Sage Version: Other

generating a sales report of top customers

Post by gaddsgav » 24 Mar 2020, 17:46

hi i am running UK version of sage50 accounts v.26.2. I am a newbie to it and i need to identify who our top customers are in terms of sales in the last 24 months. I then want to go on and identify the top customers in terms of profit over the same period. any help at all would be a godsend.
kind regards
gav

User avatar
brucedenney
Site Admin
Site Admin
Posts: 4619
Joined: 28 Feb 2006, 09:56
Sage Version: v28 UK/Europe/Africa

Re: generating a sales report of top customers

Post by brucedenney » 24 Mar 2020, 17:58

"By Sales" I assume this means sales turnover.

If your company is new to sage, you probably do not have 24 months of data.
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.

gaddsgav
User
User
Posts: 2
Joined: 24 Mar 2020, 17:41
Sage Version: Other

Re: generating a sales report of top customers

Post by gaddsgav » 24 Mar 2020, 20:55

Hi Bruce - our company is not new to sage I am. We have used it for years. However, i am trying to use it to do some data analysis to make our sales and marketing more efficient. I have used it a little over the last year. There was a previous person in post who used to compile all manner of reports. I just want to do something I think will be relatively simple as per my question, Hope that makes sense.
Regards
Gav

User avatar
brucedenney
Site Admin
Site Admin
Posts: 4619
Joined: 28 Feb 2006, 09:56
Sage Version: v28 UK/Europe/Africa

Re: generating a sales report of top customers

Post by brucedenney » 25 Mar 2020, 11:17

Thanks for that clarification.

The way I would do this is to create a linked excel spreadsheet that has the data from the invoicing module in it, you could then use this to create pivot tables in excel to analyse the information over any period, analysing it against products, customers, date ranges, whatever you want.

The trouble with that is that is it is beyond a quick and easy tutorial on a forum. If you wanted to hire me it would take about half an hour to build the sheet on your pc and give you a quick run through, if you have not used pivot tables before than allow an extra 15 mins so I can walk you through using them to. (If you want to learn how to modify the sheet to add more data and link in other tables then allow a further 30 mins.) These are rough and ready estimates, if you are not very used to Excel, then they will be an under estimate, if you are an excel wiz then they are an over estimate, My current rate is £72.60 per hour + VAT. (If you are on an old version Sage and a new version of Excel then there are some potential issues we should talk about first give me a ring and have a chat)

If you want to write a report, you cannot write one using the data in the customer record, this only goes back a year. So no good for your application.

You would need to use the data in the invoicing module.

To do this, you need to have the invoice table as the detail section and then add up all the invoices for each customer in a customer footer section, you will need a criteria for the date range of invoices and you will want to hide the details section as you don't want the details of each invoice in your report.

The issue with this is that the customers grouping will list them in account order. Not in the total sales value for the period. So still not a good outcome, hence my first suggestion. There is an advanced method of getting total, before the report is output, this is one of the really badly documented features of Sage 50 that even I have had issues with, again, probably more than one could address in a simple forum and it will only give you one report, you have to do a separate one for the profitability and so on. (The Excel approach is the better all round solution.)
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.

Post Reply

Who is online

Users browsing this forum: No registered users and 8 guests