Custom Report Formats within Forecast.Live

Custom Report Formats - Reports and Categories

New report formats can be created by clicking the Add button in the Custom Report Formats section.

These reports can be fresh (with no categories) or use one of the Plus Software designed Templates which come with some categories pre-populated. 

Once Save is clicked, a new Report should now appear in the Custom Report Formats sections.

When you click on this Report, there should be no categories within the Report Categories section, unless you're chosen a Template, in which case there will be some categorisation.

You can then add more Categories to this report by clicking Add.

Fill in the sections as follows:

1. The Category Name - These must be unique across the report

2. Is Income? - A Category (and its GL Accounts) will conditionally format according to the following rule:
- If the checkbox is checked, a greater Actual than Budget will be Green and a lesser Actual than Budget will be Red.
 - If it's flagged as a not-Income account, the opposite will happen.

3. The Parent Category - If there are already Categories on the Report, you will be able to select one to act as a parent - the new account will be collapsed with the parent and display as a Child on the Forecast screen

4. The Formula field - This is where a user writes a custom formula that applies to the category's cells. It will accept any Spreadsheet-acceptable formula, and can reference any existing categories - write these as the category name in square brackets. E.G. [Sales]

5. The Field Picker - Allows a user to insert Categories into the Formula field by selecting, and clicking Add. No formatting necessary!

Note: In the Report Categories pane that Categories appear with a Folder Icon, and Categories with Calculations appear with a Calculator icon

If you need to edit the category (to change its name or other properties) click Edit.

You can also Co​py a category (this doesn't copy any mapped GL Accounts) or Delete the category if it no longer suits your needs.

Categories can also be moved Up or Down among their peers (the ones in the same level) using the arrow buttons to the right.

Once the categories are filled out, you're ready to start coupling General Ledger Accounts into them.

Need more information?

Send us a ticket to Support@Plus.Live

    • Related Articles

    • Custom Report Formats - An Overview

      The Custom Report Format builder is where a user can set up Reports for the Monthly Forecasts.  A Report is a hierarchy of ordered Categories, which can contain other categories and so on, and can also contain General Ledger accounts. Each of the ...
    • Custom Report Formats - GL Accounts

      When the report has all of the Categories you require, you're ready to start binding in the General Ledger (GL) Accounts. To do this, check the GL's you'd like to bind to a Category, click the Category in the middle pane, and then click "Add". The ...
    • Report: Outstanding Invoices

      This report shows a list of invoices that are Outstanding (not just Overdue) grouped by Customers' Groups and then by the Customers themselves. It shows a number of metrics at a per-invoice level, allowing for AR personnel and department heads to ...
    • What are Categories in Snapshot.Live?

      Categories are a way of identifying or grouping certain Dashboards together. For example: a Category might be Sales and all Dashboards relating to Sales could be within that Category. Only Adminstrators and Users who can add Dashboards can add ...
    • Report: Unallocated Invoices

      This is a great report /grid to show the Unallocated invoices synced from the Business System to Forecast.Live. Within this report you can view the unallocated invoices and we provide Matches and Possible Matches column headings to help with ...