Quarterly Profit & Loss layouts

With Spotlight, you can use the customisation options to amend the pages of the report to suit your needs. In the Profit and Loss Analysis page, this includes setting different comparison options.

Each profit and loss page can contain a maximum of 12 columns, however as you can add multiple copies of any of the standard pages, you can include several versions of the profit and loss page to ensure you show all of the information you need. 

Note: This article contains details of the quarterly comparison options. For step-by-step information about how to customise the profit and loss page, including accessing the comparison options please refer to our separate article. You can also compare monthly and two-monthly information.

Quarterly report options

The last section of the comparisons drop-down list shows all of your quarterly comparison options. All comparisons are based on the report date in the Customise Layout tab.

Screenshot 2017 09 14 15.28.38

Current quarter, budget and variance

This option shows four columns.  The first column, highlighted in green, shows the current quarter actuals. The second column shows the total budget value for the current quarter. The budget values do not include any changes made since the original import. The remaining two columns show the currency and percentage variances between the actuals and the budget for the quarter.

Screenshot 2017 09 14 17.30.27

Current and last 3 quarters

This option shows four columns, the first column highlighted in green is the value for the current quarter. The following three columns are the values for the past three quarters.

Screenshot 2017 09 14 17.31.08

This quarter and this quarter last year

The first column in this group shows the total value for the current quarter, highlighted in green. The second column shows the total value for the same quarter in the prior year. The last two columns show the currency and percentage variance between this year and last year.

Screenshot 2017 09 14 17.31.41

Next, current and last 2 quarters

This option shows the total value for four different quarters. The first column in the group, highlighted in yellow, is the projected values for the next quarter, based on budgets. The second column, highlighted in green, is the total value for the current quarter. The last two columns, shown in white are the total values for the previous two quarters.

Screenshot 2017 09 14 17.32.18

  

Back to top

Release Notes - Terms of Use - Privacy Policy - Launch Application - Copyright Spotlight Reporting 2019