Know Every Customer. Grow the Right Ones.

The Know Your Customer Power BI report shows each customer’s sales, profit, payments and risk, one click from their name.

Most businesses can tell you their total sales. Far fewer can say which customers are buying less this year, paying later than their terms, or getting discounts that cost more than they bring in. Know Your Customer answers those questions for every customer, using the data already in your ERP. It works with SAP Business One, eSOFT and most other systems with a database we can connect to, so your sales and finance teams can act before a customer drifts away or a debt goes bad.

Ready to know your customers better?

Book a free 30-minute demo. We’ll show you the report and tell you which pages your data can support.

Know Every Customer.
Grow the Right Ones.

What’s inside

The report has 31 pages, grouped by the job they help with.

Finding who needs attention

Customers List: every customer with sales, change against last year, gross profit, margin, balance, overdue %, days to pay, days since the last invoice and buying status. Right-click any name to open their pages.

Customers Needing Attention: customers with at least one warning, and the reason. Warnings cover sales down 20% or more, margin down 5 points or more, debts over 90 days, going over the credit limit, ordering later than usual and expired quotations.

The full customer picture

Overview: a one-page profile with 12-month trends, lifetime value, payment habits, ageing, open quotations and orders, and what the customer buys.

Customer Card: contact details, payment terms, credit limit and headline figures.

Lifetime & Value: sales and profit since the first invoice, years as a customer and share of company sales.

Health Score: described below.

Peer Benchmark: the customer against the average of their customer group and of the company on 10 figures, with their rank in the group.

Margin

Profitability: a waterfall from list price to profit, through discounts, credit notes, cost of sales and an estimated cost of late payment at an interest rate you choose.

Sales & Discounts and Quantity vs Discount: whether bigger discounts led to bigger orders, item by item.

Price Realisation: the net price the customer pays per item against the company and group average, and the total paid below average.

Credit Notes & Returns: return rate against the customer group, return reasons and the items credited.

Getting paid

Balance & Ageing: balance, credit limit usage, ageing and the overdue trend by month.

Payment Behaviour: average days to pay against terms and the share paid on time. It’s calculated two ways: by matching payments to the oldest invoices first, or from the invoice-to-payment matching recorded in your system.

Customer Statements: opening, running and closing balance with open items and ageing, ready to go through with the customer.

Selling more to existing customers

Customer vs Group Items: items that similar customers buy and this one doesn’t, which gives your reps a cross-sell list.

Items Status: new, lost, growing and declining items. Top and Bottom Items, Pareto 80/20, and items grouped by sales band or gross profit band.

Item Search: every document line for an item, with price, discount, net price and profit.

Planning

Forecast: the next 12 months, with base, pessimistic and optimistic figures worked out from the customer’s last year and the company’s growth.

Quotes & Orders: open quotations and orders, how quotations turn into orders and invoices, late deliveries and expired quotations.

Order Behaviour: how often the customer orders and how much, by month, weekday and invoice size.

Period Comparison: this month or quarter against the previous one, by any category.

Two pages that flag problems early

Customer Health Score

Each customer gets a score out of 100. Five things count for up to 20 points each: sales growth, margin compared with similar customers, how fast they pay, how much of their balance is overdue, and whether they’re ordering on their usual rhythm. Scores are graded A to D and shown next to the customer group and company averages. The scoring rules are printed on the page, so anyone can see why a customer got their grade.

Customers Needing Attention

This page lists every customer with a warning and gives the reason. A sales rep can see which customer has gone quiet, and finance can chase a debt soon after it passes 90 days.

Everyday use

Right-click any customer name to open any of the 31 pages for them.

Pick a predefined period or any date range, and the choice carries across every page.

Compare with last year, the previous period, the customer group or the whole company.

Choose the figure to show (sales, gross profit, quantity, margin and others) and set Top/Bottom N and percentages with sliders.

Each page has a short description of what it shows, so new users can find their way.

The report reads from your ERP’s database, so nobody has to export spreadsheets.

Who it’s for

Owners and managing directors who want to know which customers drive profit and which put it at risk.

Sales managers and reps preparing for customer meetings, with the customer’s figures and a cross-sell list in hand.

Finance and credit controllers tracking payment behaviour, overdue amounts and credit exposure for each customer, including what late payment costs.

Works with your ERP

Know Your Customer sits on top of the database of almost any ERP or accounting system. It works with systems such as SAP Business One and eSOFT, and we can connect it to most other ERPs and SQL databases. During setup we map your customers, items, sales documents and payments to the report.

What your data needs to include

Each page depends on data your system records. Sales invoices, credit notes, customers and items are enough for most of the sales and profit pages. Some pages need more:

  • Quotes & Orders needs quotations and sales orders in the system.
  • Balance & Ageing, Payment Behaviour and the statements need incoming payments. The reconciliation version of Payment Behaviour also needs a record of which payment settled which invoice.
  • Credit limit warnings need a credit limit on the customer record.
  • Return reasons need the reason recorded on the credit note.
  • Peer Benchmark, Health Score and the group comparisons need customers assigned to customer groups.

If your system doesn’t hold some of this, the pages that rely on it won’t work or will show less. We check your data before setup and tell you which pages you’ll get, so you know what to expect before go-live.

How it works

Free demo: we show you the report and talk about what you need from it.

Data check: we look at what your ERP records and confirm which pages will work for you.

Set up: we connect the report to your database and match it to your customer groups, item groups and sales team.

Tailor: we adjust pages, warning levels and scoring rules to your policies.

Go live: your team uses it in Power BI, with support from demzine.

Ready to know your customers better?

Book a free 30-minute demo. We’ll show you the report and tell you which pages your data can support.

FAQ

Which ERP systems does it work with?
SAP Business One, eSOFT and most other ERP or accounting systems whose database we can connect to. Tell us what you use and we’ll confirm.

Do I need to change my ERP?
No. The report reads the data your system already holds.

Will every page work with my data?
Most sales and profit pages only need invoices, credit notes, customers and items. Pages on quotations, payments, credit limits or returns need that data in your system. We confirm what’s available before we start.

Can I set my own warning levels?
Yes. Thresholds such as a 20% sales drop or 90 days overdue can be set to match your credit and sales policies.

Does it work alongside your other reports?
Yes. Sales Analytics and Financial Analytics give the company-wide view, and Know Your Customer looks at one customer at a time.

How long does setup take?

You may also like