The Reporting screen allows you to produce reports in Excel.

 

Templates

 

A Report Template provides all the configuration details on how to create a report. You can save and copy templates to make it easier to regenerate a particular report for a Reportance .rep file.


When you first go to the Reports tab, you will start in the 'Default' template, which is the initial template that Reportance provides for each file.


To create a new template, you can select an existing template and select Create Copy, or you can make changes at any point to any template, and then select Save Changes As to save those changes as a new template.


Details


The first step is to provide the basic Report details, as follows:


Template Name      A unique name to identify the template, for example, "2014 Statutory Report"

Entity                    Select the particular entity you are generating the report for, or leave it as 'Multiple' if more than one entity's figures will appear in the report

Entity Type            Select the particular entity type, which will change the terminology used throughout the report. 

Report Header        This is a sample of what the "Header" on each main report page will look like (for the Balance Sheet, Profit and Loss and Notes). You can edit the top two rows to display anything you like.


Next, you determine which columns you wish to display in the report. Click Add Column to create another column. Each column represents a column of data that will appear in the report. There is no limit on the number of columns you can have.


The column fields are as follows:

Field

Description

Validation




Column Header

Contains the text shown at the header of this column in the report. It is defaulted based on the value selected in ‘Dataset’. There are three rows available to provide values.


Dataset

A dropbox that allows you to select from any available Dataset in the Reportance file.

Required Field

Division

If selected, this limits the trial balance information to show just the data for the selected Division. Generally use in Profit and Loss statements only.


Delete Icon

Deletes the column



Reports Tab




The Reports grid lets you select which report pages will be included within the report. Click on a report page to select or deselect the page.


The Accounting Policies tab lets you choose which accounting policies will be included within the Notes section of the report. The policies available are set from the Accounting Policies screen which can be found by going to the Data drop-down menu and selecting Accounting Policies.


Layout Tab




In the layout tab, the list of available accounts is displayed. This list lets you determine how much detail is shown in the report, and is a What You See Is What You Get (WYSIWYG) editor. 


To hide detailed accounts, simply select the arrow to 'roll-up' the header and show only a total.


If you tick the Include Details in Note, only the header with a total will be hidden from the face of the financial statements, they will appear in the Notes section of the report.


Note, when selecting "Include Details In Note", the Note presentation will appear in the same form as displayed when you expand the header account. This means you can roll-up and hide or expand detail within the note, and also have a 'Note within a Note'.


Depreciation Tab


In this tab, click Add Depreciation Report if you wish to include any depreciation reports in this Report. The report settings are per the Depreciation Reporting module:


Once you have added a depreciation report, you can add additional depreciation reports or remove them by selecting Remove.



Create the Report


Once you are happy with the current report settings, we recommend clicking Save Template if you wish to save the changes you have made to the current template.


Next, simply click Create Report, which will open up Excel and produce the Report. Please wait for the loading icon to disappear before interacting with the Excel Report.