Welcome to the TOPS Software Help Center

Sign In to your account

Custom Report Guide

Follow

 

Custom report index

Located under the ‘Reports’ section of the main menu:

 

 

 

See a list of existing custom report templates or add a new one (Note: Custom reports are community specific):

 

Creating and Editing a Custom Report

The custom report tool has two major sections: The Options panel and the Report Builder

 

Options Panel

1.    Naming

Name and description are for internal purposes only and will appear on the Custom Report Index page. The report’s Display Name will act as the title and file name on all exports. When selecting custom report formats from the selector, it will use the Display Name

 

 

2.    Options and Schedule

  • Options – Clicking this will hide/reveal the options panel
  • Schedule – Schedules the report to run based on the designated date/time/frequency

 

3.    Report Type

Select from three base report types: Balance Sheet, Income Statement, and Reserve Statement. These form the base criteria for calculations on a given date or date range.

  • Balance Sheet – This report type will determine if the selected community is using Funds and show them accordingly
  • Income Statement – The Income Statement Report Type has an additional option: Show Detail (Actual, Budget, Variance) which allows the user to show the budget detail as it compares to the income and expense:

 

4.    Report Date

Defaults to the last date of the current period. For Income Statement and Reserve Statement, it will display Start Date and End Date fields instead. These will default to the current period’s start and end dates:

 

5.    Cost Centers

Choose which cost centers to display. Select all by clicking the button labeled ‘Select All’ (Deselect all will appear when all cost centers are selected). To choose multiple cost centers individually, click on the desired cost center while holding the CTRL key:

6.    Export Format and Orientation

Like other reports, export to PDF, Word, or Excel file. Additionally, choose between portrait and landscape for report orientation:

 

7.    Export and Apply

  • Export - Export the report to the chosen format and orientation.
  • Apply – Applies any changes made that are not currently reflected. Additionally, if transactions have occurred that would change any balances displayed since arriving at the report, it will update those figures. The Refresh button in the top-right corner of the screen functions identically to the Apply

 

Report Builder

Below the options panel is the report builder where the report is created and displayed for preview before export. Options include adding ranges, totals, and various formatting tools like lines and page breaks

 

Add a New Element

Clicking on the ‘New Element’ icon (  ) will give the following options:

  • Range – Choose from a single account range that belongs to the community and add it to the report
  • Total – Totals together designated elements (Ranges, other Total elements)
  • Label – Add the desired text to the report as a sub header
  • Line – Add a line going horizontally across the report
  • Empty Line – Add an empty line to the report to create space between elements
  • Page Break – Creates a new page start at the page break element

 

Adding and Editing a New Range

Displays all the accounts within the selected range

  1. Account Range – Choose from a list of account ranges belonging to the community
  2. Cost Center – Select a specific cost center for this range (overrides the cost center selection in the options panel)
  3. Group – A user definable field that allows for grouping of range elements to be used for totaling. Ex: Setting all Asset account ranges as ‘Group A’ will allow for those ranges to be summed together
  4. Reverse Sign – Show negative values as positive and positive values as negative
  5. Show Account Rang Balances – Lists out the accounts and their balances within the selected range



Adding and Editing a Total Element

Totals together grouped ranges and totals

  1. Name – The name for the Total element. This name will display on the report
  2. Group – A user definable field that allows for grouping of range elements to be used for totaling. This can be used sum together similar range types. It can also be used to create subtotals that will then sum together for a grand total
  3. BSNI – Generates the balance sheet net income for the selected community
  4. Difference – Subtracts Group 2 from Group 1 instead of summing together the elements in a single group
  5. Sum (sigma) Group – Sums together the group entered. Ex: Entering ‘Group A’ will sum together all elements that were previously assigned to ‘Group A’
  6. Total Underline – Choose to underline the total (None, Single, or Double)
  7. Total Column – Determines the horizontal placement of the total column on the report export

 

 

Additional Tools

  • Edit existing element: . Change the properties of an existing element (change group name, range type, etc.)
  • Move element placement: . Move the designated element up or down on the report
  • Remove element: . Removes the element from the report.
Was this article helpful?
0 out of 0 found this helpful

Comments