Managing Flash GP Reports

Created by Harriet Medlicott, Modified on Tue, 13 Dec, 2022 at 12:20 PM by Harriet Medlicott

Pinpoint

Flash Reporting

Editing a report provides the ability to accurately track expenditure across your organisation; record sales revenue and much more. Before you know it, you will have an instant picture of your financial performance. Pinpoint can calculate the difference between period targets and actual revenue up to, and including, the current date. Any cost adjustments will also be factored in. Dependant on how your organisation works, you can update the actual revenues daily, weekly, or monthly.

Click on images within this article for easier viewing.

TABLE OF CONTENTS

Getting Started
Target Revenue
Actual Net Revenue
Cost Adjustments
Navigating Around
What's Next?
Related Articles

Getting Started

Select the Pinpoint module from the left-hand navigation bar
Click Edit on the report to be adjusted
When in the report, click Edit under Period target net revenue to set the target revenue for that period (this will be distributed evenly across all days)

If the target revenue is to be distributed across Weekdays only, select the checkbox to set a revenue of £0.00 for Weekends.

Target Revenue

Once a period target revenue has been set, you will see the values distributed accordingly under the Target revenue column. If required, these fields can be amended. For example, you may have an event coming up and so you are expecting to achieve a higher revenue that day. Adjusting these will also update the Period target net revenue.

Actual Net Revenue

Under the Actual net revenue column, use the text fields to enter your daily revenue. This can be completed as the end of each day, week, or month - it is entirely up to how the organisation works. In doing this, Pinpoint will calculate the difference between the two revenues, providing a Daily flash GP%; Cumulative revenue and costs; and a Cumulative flash GP% for that day.

Cost Adjustments

The Cost adjustments column allows you the option to add manual cost items that take place outside of Pi. For example, this could be decorations for an event. Positive or negative values can be added, and both will alter the total net costs for that day.

To do this...

Click the link under Cost adjustments for the relevant day
Select the Add button to add manual cost items
Use the text fields to add the Description and Net value
Click the X icon to close

Navigating Around

As you complete the net revenues for each day (adding any additional adjustments), Pinpoint will continuously be calculating your expenditure whilst taking into account the set target revenues and GP%. The current day in the existing period will be in bold, so if you are updating on a daily/weekly basis, you can easily see where you are up to in the period. Further features in these reports are summarised below.

Period Navigation and Saving	Tools

The existing period will show by default. Here, you have the options to... Use the arrow buttons either side to navigate between the different periods within a report. Select Add new to create a new period for the next month/week, depending on the report settings. When doing this, you will be asked to confirm before proceeding. Any changes made will need to be saved. If you try to navigate away for the current period before saving, you will be alerted. Simply click Save changes to save your updates.	The Tools drop-down provides the options to... View Report settings, providing the option to amend the report name, target GP%, and display preference. Refresh costs will update cost data for the report. It might take a minute or two and you won't be able to make changes while updating. You can choose to refresh for the specific period only or all periods. Download will provide a detailed report in an Excel format.
Period Summary	Display Preference

At the top of each reporting period, you will see the chosen Cost centre for the generated report; the Target GP; and the Target vs. actual revenue (this is the difference between the period target and actual revenue up to, and including, the current date).	Using the Display preference options, you can flick between viewing the period's performance as GP% or Cash margin.

What's Next?

For every report created and the data included within, Pinpoint's Dashboard will provide the results in an easy-to-read graph, including Gross Profit summaries. Now you and your teams can compare different cost centres financial performance at a glance!