To access this window : Accounts Management - > Setup - > G/L Accounts - > Report Templates.

The following window will open up:

To view less details, uncheck the traverse tree check box then refresh :

Creating A Report Template

To create a report template, click on the ADD NEW Button.

The following screen will open up:

On this screen:

Parent Template - When creating a first time parent Header Entry, leave this field blank.

Otherwise when creating a Detail Entry, click on the lookup icon to open a "Report Template Lookup" dialog Box. Select the Parent (Header Entry) under which the Detail Entry will be.

Name - Enter the appropriate name of either the Header Entry or the Detail Entry.

Category - Select appropriately by clicking on the drop down then select "Header Entry".

Value computational mode - Pick either sum line item balances or aggregate line balances appropriately

Template file name -lookup and pick the appropriate template name from your desktop

Template file title-Put down the appropriate title for template

Value computational tag-Enter the appropriate name for the computational

Spreadsheet Cell Reference - Enter the cell reference where the data will be written on the Excel Spreadsheet. The Cell Reference format is (Row:Column) for example, looking at the example below, the detail entry of Share Capital is at the STARRED CELL (in red). Therefore it's Cell Reference in our template will be 10:4, this means count 10 rows from the top, then count 4 columns to the right.

Attached G/L Accounts Pane:

On this pane, you have to select appropriately the G/L Accounts.

The Asset Account always starts with a 1-xxxxxxxx

The Liability Account always starts with a 2-xxxxxxx

The Equity/Capital Account always starts with a 3-xxxxxxx

The Income/Revenue Account always starts with a 4-xxxxxxx

The Expense Account always starts with a 5-xxxxxxx

The following EXCEL worksheet will be used as an example reference in creating the Header and Detail Entries.

From this excerpt, the details circled in red will be used to illustrate how to create a header and an Entry.

A) How to Create a Header Entry

1. On the "Parent Template" field, DO NOT Select anything. Leave it BLANK

2. Next in the "Name", Enter the name of the Header Entry you want to create for example "FORM1 SASRA1/001: CAPITAL ADEQUACY RETURN".

3. Next Select the Category to be "Header Entry" since you are creating a Header.

4. As for the Spreadsheet Cell Reference, Enter the correct cell reference, following the CORRECT FORMAT.

The figure below illustrates the above procedure:

NOTE: Take one of the name of the Template.

5. To finalize click on the CREATE Button

On successful completion you will get a pop up message confirming that the operation was successful.

To view the created template, navigate back to the "Report Templates" Tab and click on REFRESH to see if the if the Header Entry was created.

B) How to Create a Detail Entry:

Using our previously created first Time Header Entry as our Parent Template:

1. Select the "Parent Template" by clicking on the lookup icon to open a "Report Template Lookup" dialog box. Select the Parent (Header Entry) under which the Detail Entry will be and in this case our Parent Template will be "FORM1 SASRA1/001: CAPITAL ADEQUACY RETURN"

2. Enter the name of the Detail Entry as it appears on the Excel Template. for Example, "1.1.00 Share Capital"

3. Next Select the Category Appropriately, and in this case we are creating a detail Entry, therefore "Detail Entry" will be selected.

4. On the Spreadsheet Cell Reference, you can enter the reference number,. otherwise you can fill in this later during linking up.

The figure below illustrates the above procedure:

5. To finalize click on the CREATE Button

On successful completion you will get a pop up message confirming that the operation was successful.

6. Go back to the "Report Templates" Tab and click on REFRESH to see if the if the Detail Entry was created as illustrated in the next figure below:

NOTE:

1. All "DETAIL ENTRIES" are those that will ACCEPT/REQUIRE data input.

2. While all the "HEADER ENTRIES" they DO NOT ACCEPT or REQUIRE data input.

Linking Of Report Templates :

Report template linkage comes in handy when reporting is to be done according to the Regulatory policies.

To achieve this:

Identify the template to be linked, e.g FORM 1; edit to open the following window :

Report Templates Fig 10

Identify the header to be linked, for instance Earning assets.

Check against the selected header:

Notice all the detail accounts that fall under the selected header are also checked :

To link the rest of the accounts to the templates, just select the header and its detail accounts will be automatically selected.

Repeat the above process till all linkages are done.

Created with the Personal Edition of HelpNDoc: Easy EPub and documentation editor