Two monthly 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 two-monthly 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 quarterly and monthly information.

Two monthly report options

The second section of the Comparisons drop-down list shows all of your two-monthly comparative options. All comparisons are based on the report date in the Customise Layout tab.

Screenshot 2017 09 14 15.23.38

Current two month period, budget and variance

This option shows the total value of current two months, highlighted in green. It also compares this to the total budget for the same period and a currency and percentage variance between the actuals and budget. The budget values do not include any changes made after the original import.

Screenshot 2017 09 14 17.02.01

Current and last 3 two month periods

This option includes four columns showing the total value of the current two month period, highlighted in green. It also shows the total values for each of the last three two-month periods.

Screenshot 2017 09 14 17.03.07

This two month period and this two month period last year

This option shows the current two month period actuals, highlighted in green, and the same period for the previous year. It also includes a currency and percentage variance between the current and past period.

Screenshot 2017 09 14 17.05.43

Next, current and last 2 two month periods

This option includes four columns, each showing two month periods. The first column, highlighted in yellow, is the total projected value for the next two month period based on your imported budget.  The budget values include any changes made to budget figures since the original import. The second column is the total value of the current two month period and the remaining two columns show the total value of each of the past 2 two month periods.

Screenshot 2017 09 14 17.08.05

 

 

Back to top

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