Skip to content

Video guide 5 of 12 · Your data · 1:32

Entering KPI data in SimpleKPI

How the KPI Data sheet works: whose figures you're entering, which periods you see, notes, and spreadsheets in and out.

What this guide shows

  • Pick a person at the top to enter figures on their sheet. They save as you go.
  • Use the multi period view to catch up on several months, or the single period view for one month against target.
  • Filter by category to see only the KPIs you need.
  • Add a note to a figure that needs explaining. It stays with the figure.
  • Upload figures from a spreadsheet in the example layout, or export your sheet to Excel.

Transcript

What's said in the video, by chapter. Press a time to play from there.

Where your figures go in

KPI Data is where your figures go in. Here's how to make it a two minute job. We'll choose whose sheet you're on, pick the periods you need, add notes, and bring figures in from a spreadsheet.

Whose sheet

Everyone sees the KPIs assigned to them. If you look after a team, pick a person at the top, and you're on their sheet. Here's Simon's, with just the figures he enters. Type them in for him, and they save as you go.

Which periods

Now the periods. The multi period view shows months side by side, good for catching up. The single period view shows one month, every KPI down the page, with how it's doing against target and its trend. Step back or forward a period, or pick a date. And filter by category to see just the KPIs you need.

Notes

When a figure needs explaining, add a note. Net profit dipped in July, so say why. The note stays with the figure, so whoever reads it later knows the story.

Upload and export

Already keep your figures in Excel? Under More Options, upload a spreadsheet. Download the example to see the layout it expects, fill it in, and choose your file. You can export to Excel too, for a copy of your sheet.

Get started with your KPI Software

Get started for free