...
Guide

Client reporting in Microsoft PowerPoint: how to stop rebuilding the pack every quarter.

The client pack is the same deck every quarter with different numbers in it. This guide walks through the three ways teams produce it, what goes wrong with each, and what a bound template looks like in practice.

The manual way, and what it costs

Most client packs are built the same way: the analyst exports from the performance system to Excel, tidies the tables, copies each chart and figure into last quarter's deck, and reads it three times looking for the one that did not get updated. For a pack of 30 slides and 20 clients that is a working week per quarter, and the week is spent on the least valuable part of the job.

The cost is not the week. It is the number on slide 4 that still shows last quarter, because it was the one chart nobody touched, and the client noticed.

The next step most teams try is Paste Link: paste the Excel chart into PowerPoint with a live link. It works on the analyst's own machine for a while, then breaks the way it always breaks:

  • The workbook moves, gets renamed, or lives on a colleague's drive, and the link points at nothing.
  • Two people edit the deck and the links resolve to two different files.
  • The chart updates but the number in the text box next to it does not, because text boxes cannot be paste linked.
  • Formatting drifts: the linked chart brings Excel's colors and fonts back into the brand template every refresh.
  • Nothing filters. One workbook per client, one deck per client, and the count of things to maintain doubles.
The test

If you cannot tell, for any number on any slide, which cell or query it came from, the deck is not linked. It is copied.

The bound template way

A bound template is one PowerPoint deck where every figure, chart and table is tied to the place its data comes from, and a filter decides which client you are looking at. INSYNCR is a PowerPoint add in that does this inside the deck you already have.

1. Connect to where the data already is

Excel or Excel Online for most teams (Starter). SharePoint, Google Sheets, Access and MySQL in Business. SQL Server, PostgreSQL, Oracle, Salesforce, ODBC and OData in Professional, which is how the performance and portfolio systems are usually reached. The add in uses the credentials you already have; nothing is uploaded.

The first connection: pick the source, INSYNCR reads its structure.
The first connection: pick the source, INSYNCR reads its structure.

2. Bind each shape to its data

Click a text box, a chart or a table on the slide and choose the cell, column or query it should show. Text boxes bind like charts do, so the number in the sentence and the number in the chart come from the same place.

A text box bound to a value. The sentence updates with the data.
A text box bound to a value. The sentence updates with the data.

3. Filter per client

One template, one filter. Set the client or fund as the filter value and every bound shape follows. Snapshot then produces one file per client, PowerPoint or PDF, named as you name them.

In slide filtering: the same template, a different client.
In slide filtering: the same template, a different client.

4. Rules for the things that change shape

Conditional formatting colors a value by rule, so a negative return is red without anyone checking. Smart slide logic includes or excludes a slide by rule, so a client with no alternatives allocation does not get an empty alternatives page.

5. Refresh at quarter end

New period, new data, one click. The reviewer reads what changed rather than everything again, and the auditor can follow any number back to its source.

Which KPIs do clients actually read?

Clients care about numbers that tie to revenue, cost and growth. These ten come up again and again:

  1. Revenue, not traffic. How much did we generate, and how much of it came from marketing?
  2. Cost per acquisition. What does it cost to win a customer, by channel?
  3. Return on ad spend. The capital efficiency number finance and investors ask about.
  4. Pipeline value. Qualified pipeline and how deals move through the stages, not form fills.
  5. Customer acquisition cost. Read next to lifetime value, or strategy turns into guesswork.
  6. Lifetime value. Which channels bring customers who stay and pay well.
  7. Time to conversion. How long a lead takes to become a customer.
  8. Channel efficiency. Which channel brings the best leads, the shortest cycle and the best return.
  9. Forecast accuracy. How close last period's forecast came, and what the next one says.
  10. The insight. Trends, an explanation of what moved, and clear next steps.

When the deck refreshes from the data, the team spends its time on number 10 instead of copying numbers 1 to 9.

What review looks like afterwards

The four eyes check does not go away. It gets shorter, because the question changes from "is every number right?" to "did the rules do what we meant?". Teams that moved to bound templates report more reports per analyst and clients moving to monthly rather than quarterly, because monthly is now a Refresh.

One team's numbers

Lumen Research replaced manual copy and paste and broken Excel links with linked templates. Clients moved to monthly and quarterly reports, and reporting became a recurring revenue stream. "It saves me so much time, by taking the administrative and repetitive away, so I can focus on quality."

FAQ

Questions people ask before they try it

Can INSYNCR read our performance system directly?

If the system exposes SQL Server, PostgreSQL, Oracle, an ODBC driver or an OData feed, yes, in the Professional plan. Otherwise the export to Excel that you already produce is enough, in Starter.

Does the client pack have to be rebuilt in a new template?

No. INSYNCR works inside the deck you already have. You bind the shapes that exist.

What about the commentary text?

Write it as you do today. Bind the numbers inside the sentences so the commentary and the charts agree, and leave the prose to the analyst.

Who else reads the deck?

Anyone with a Viewer seat can open and refresh the bound deck. Viewer is 27 euros a month, billed annually per person and needs one Starter, Business or Professional license in the team.

Sending this to IT? Everything they ask is on one page. The trial is in the rail above: 7 days, full access, nothing leaves your PC.

Start free trial

No credit card · Your data stays on your PC · Windows, Office 2016+