Templated Reports

Templated reports are a series of pre-configured reports which can be run by simply choosing options from a selection of 'run time' parameters.

Whilst reports designed and configured within Mondial CRx's report writer are more typically aimed at 'C-Suite' recipients, Templated Reports focus on a more detailed level of analysis to validate, verify and support the period end close process.

There are several templated reports available. 

• Transaction History
• Current Period Trial Balance
• Trial Balance
• Detailed Trial Balance
• Invoice Listing (A/R and A/P)

Report Name	Additional notes
Transaction History
Current Period Trial Balance	In earlier versions of Mondial, this report was known as the Trial Balance. However, the report is not the Trial Balance report as expected by most users. The Profit and Loss accounts on this version of the Trial Balance display only the change in the balance for the selected period, and not the year-to-date balance for each account. This limits the usefulness of the report. Mondial considered withdrawing this report from circulation but decided instead to rename it and replace it with a Trial Balance (see below) that provides the user with more relevant information, and to keep this version available in case some users continue to find value in the information as it is presented.
Trial Balance	This report offers the Trial Balance report in the format expected by most users. The General Ledger accounts on this version of the Trial Balance display the following information: The Opening Balance brought forward at the beginning of the reporting period. The net debit or credit change during the period The Closing Balance at the end of the reporting period. Further, Profit & Loss accounts include information from the beginning of the current financial year to the reporting period date, meaning that the Closing Balance figure represents the year-to-date balance on each Profit and Loss account as expected by most users, not just the period total. Note: By default, the columns in the report include only Source System data, and this is indicated by the Source System flag being checked. If the user wishes to include Mondial-generated transactions in the report they may do so by checking the appropriate boxes for the required additional transactions. When the report is regenerated, the Opening Balance, Debits, Credits, and Closing Balance columns are updated to include the additional transaction types as required. Deselecting the fields and regenerating the report removes these transactions from the reported balances
Detailed Trial Balance	This report offers the user the ability to view the Trial Balance in more detail using individual columns to display changes by transaction type. The General Ledger accounts on this version of the Trial Balance display the following information: The Opening Balance brought forward at the beginning of the reporting period for all transaction types selected. The net change during the period with the changes for each transaction type selected displayed in separate columns. The Closing Balance at the end of the reporting period for all transaction types selected. Note: As with the Trial Balance, Profit & Loss accounts include information from the beginning of the current financial year to the reporting period date, meaning that the Closing Balance figure represents the year-to-date balance on each Profit and Loss account as expected by most users, not just the period total. The updated report now includes the information presented as follows: Opening Balance – all transactions for all selected transaction types up until the start of the reporting period Adjustments – all transactions for the current reporting period displayed in separate columns for each transaction type selected. Closing Balance – a single, combined figure for all transaction types selected This report uses identical information to the newly renamed Trial balance but sorts period data changes by selected transaction types.
Invoice Listing  (A/R and A/P)

To access the templated reports available for your company, select "Templated" from the reports dropdown.

 

The Templated Reports page contains two dropdown fields; Company and Report. Select the company whose report you wish to run from the Company drop-down and the type of report to run from the Report field dropdown. 

The company drop-down contains all the companies in the group as shown in the sample Bluesky Group of Companies templated field below:

The reports which are available for selection in are shown below:

The following fields must be defined in every report: Accounting Period, Natural Account Set, Ledger, and Output Type. There are other parameters that need to be defined depending on the report the user chooses  A custom accounting period can also be created by entering the relevant start date and end date.

For example, the Transaction History templated report contains fields that need to be defined in every other report as seen here:

Different reports, depending on their nature and focus, will require additional parameters for them to run conclusively.

In the accounting period drop-down the user can either select from the list provided or start typing to narrow the search - entering 2021 for example will narrow the search to a period in the year 2021 only.

The table below shows some of the additional fields that need to be defined in relation to the report being run:

Report	Additional Instructions
Current Period Trial Balance Detailed Trial Balance Trial Balance	1. Reporting Currency - Select a currency from the reporting currencies available for the company 2. Column selection - Choose a column by checking one of the boxes from the following: Regular Journal Entries, Statutory Adjustments, Revaluation Adjustments, or Elimination Entries
Invoice Listing	1. Ledger - choose the ledger to run from either Account Receivable or Accounts Payable

After the parameters for the relevant report have been set, click Generate. The report will be displayed in the selected output format.  

If web output is chosen, users will also be able to drill down to further levels of detailed data.  The drill down option is available on all fields with a hyperlink option associated with it. Typically, any data with an associated drill down is highlighted in blue

From a trial balance for example, a user is able to drill down into any value in the balance column and display the transactions associated with the balance. Further drill downs will then be available from the transactions display.