System

Abacus Enterprise Workflow

Personal Tax

PRT

Authorised Investment Fund

Corporation Tax

Group Module

Investment Trust

Life

Hotline

Pack development

P11D

Partnership Tax

Partnership Gains

Tracker

Administrator

Irish Corporation Tax

Abacus+

Hong Kong Profits Tax

Abacus Enterprise Workflow

Abacus+ v2

PCS Client Manager

VAT

System Lite

Corporation Tax Lite

The Divisions feature provides the ability for individual figures within a computation to be composed of several distinct values, one for each division of the legal entity that the user chooses to identify. Typically, for a particular group, the divisions will be the top-level business units from the management hierarchy of that group (e.g. clusters, SBUs, operating units). However, the concept of a division is entirely arbitrary and can be interpreted to suit any subdivision of a legal entity that makes sense for a particular group or legal entity.

Preparing a computation for Divisions

In order for the divisional functionality in the software to be used effectively, it is necessary for the structure of the computation to be in place before figures are entered. Therefore, the starting point for the creation of a divisional computation is to develop all necessary sheets. However, extra sheets may be developed at a later point. It is also important that all necessary rows have been inserted in these sheets and captioned accordingly.

Configuring Divisions

Once the structure of the computation is in place, the divisional structure can then be configured using the menu option Data > Divisions > Configure?.

A window will be displayed allowing the names of each division to be entered. When all divisions have been entered, pressing the Save button will configure the computation.

Right-click on the top toolbar to turn on the Divisional Cell Contents Pane, which will appear on the right-hand side of the screen by default. It is a dockable pane and may be moved or docked wherever is convenient.

Creating a Taxpack

When the divisions have been configured, Taxpack will operate in divisional mode. The next step is to export a Taxpack using Data > Taxpack (Excel) > Export.

An individual Taxpack will be created for each division by default; allowing the data for each division to be compiled separately. You may un-tick the boxes next to any divisions for which you do not require a Taxpack. You may also choose to export a non-divisionalised Taxpack by ticking the box at the top of the pop-up window.

Once you have made your selections, click OK. Finally, you may select which sheets you would like to export by placing a tick box in the boxes next to the relevant sheets.

The Taxpacks may then be sent out and completed independently of each other.

Populating the computation

The next stage in completing your computation is to re-import the completed Taxpacks using Data > Taxpack (Excel) > Import. The software allows individual Taxpacks for each division to be imported separately. Multiple divisional Taxpacks may also be imported simultaneously by using shift or control to select the desired Taxpacks.

Once the Taxpacks have been imported, an error may appear saying ?Outstanding Issues?. To clear the error, you will need to change the selectors on the W_EXCEPTIONS Import exceptions sheet to ?Yes? as long as you have complied with the comments.

You should now find that each of the values from the divisions have pulled through into the main computation and combined to make the overall totals.

Viewing Divisions

To ensure you are looking at the main computation, i.e. the combination of all divisions, go to Data > Divisions > View and ensure that All is ticked. Or ensure that ?All? is displayed in the ?Current divisions? section of the Divisional Cell Contents Pane. Highlighting a divisional cell will show the individual totals for each division in the Divisional Cell Contents Pane. It is strongly advised that you do not enter or change values here; rather they should be entered in the relevant cells in the actual divisional computations.

To view the divisional computations, go to Data > Divisions > View and then select one of the divisions.

You may also use the ?Current Divisions? selector in the divisional toolbar. So the user is aware that they are viewing a divisional comp rather than the main comp, a watermark is displayed on the computation showing the name of the division.

To change the divisional values once they have been imported, you may type over the values that have been automatically populated by the Taxpack.

Divisional Analysis

To satisfy the requirement to see all divisional data on screen at once, the divisional analysis feature is provided. Once you have checked and entered all the values in the comp, you may do a divisional analysis. This is achieved by selecting Data > Divisions > Divisional analysis.

A window will appear warning you that analysis sheets are snapshots only and, as such, they will not update if changes are made unless the analysis is re-run. The window also points out that analysis sheets do not print by default and tells you the options available in order to print them.

Once you have read the message, click OK. A new sheet will appear with the suffix _DIV; for example, divisional analysis developed from the D sheet would appear as D_DIV. If the divisional analysis option is greyed out, then the current sheet does not support the function. Currently, the sheets which support the divisional analysis functionality are the Profit and Loss Account and Income and Expense Analysis.

Rolling Forward

On rolling forward a divisionally enabled computation, the divisions will be rolled forward to the new file. Prior year figures displayed in the new file will flex in the new file based on the viewing mode of the new file, the type of prior year file and provided the prior year file is open in the software at the same time. Where the prior year file is not available, the prior year figure will not change. It is entirely possible that the divisions in the new file will be edited so that they disagree with the prior year file. In this case, the prior year value will appear as a zero when viewing the new division in single division mode.

Links to files other than the prior year computation will not flex in single division mode. This means, for example, that it will not be possible for the group module to display figures from an individual division within a Corporation Tax computation.

Non-Divisional Prior Years

When a divisional computation is created for the first time, the prior year file for that computation will not contain a divisional breakdown.  Therefore, when individual divisions are viewed, the software cannot determine what values should go in the prior year columns.

Two options are provided to the user via Data > Divisions > Non divisional prior year values.  The first option is set by default; this shows all prior year values as the prior year total, regardless of whether you are viewing the computation in All mode or divisional mode.  The second option will give errors in all of the prior year values, informing the user that the prior year file is not divisional.  However, these errors will only appear at a divisional level and will not affect the completion of the overall computation.

For subsequent years, this option will not be available, as a divisional breakdown for prior year values will be available to the software.

Auto-adjust

 When entering data into a cell, if the cell contents do not equal the divisions total, a data access error will appear in the right hand side of the cell in the form of a ?. Clicking on this icon, will show the cell content figure and the divisions total.

To correct the error, you will need to select the actual figure required and adjust the figures in the divisional layers accordingly.

Selecting Data > Divisions > Auto-adjust divisional values will create an adjustments division which will automatically calculate the difference between the divisions total and the cell contents.

The adjustments division is there to alert you of any unallocated figures, which will then need to be allocated amongst the divisions, and deleted from the adjustments sheet.

Simple sums and formulae

The software allows you to enter simple sums and formulae into the divisional layers of a sheet.

A simple sum will automatically be converted to a total however, the detail of the sum will be retained in the division. For example: entering 1+1 in a divisional cell will show 2 in the cell but the divisional toolbar will show 1+1.

Types of formulae which can be input into divisions are:

Cell reference +/-/x Number e.g. +7*5 or -2000*0.25

Cell reference (plus link)  e.g. +B7

Note that division is obtained by multiplying by a decimal.

Formulae can only contain one cell reference, and cell references must refer to cells on the same sheet. Inputting an invalid formula will result in an error.

When formulae are entered into a divisional cell, the system formula in the overall cell will appear as <Divisional Formula>. This formula cannot be edited unless the Data > Divisions > Allow editing divisional formulae is selected.

The setting applies only to the file which is open, and is reset every time the computation is saved.

Clear all values from this division

 It is possible to delete all values in a division by clicking on Data > Divisions > Clear all values from this division. This function only removes values and not simple formulae.

Clear ADDINSIMPLEFORMULA

It is possible to delete simple sums and formulae at a sheet level or file level by selecting sheet or file from Data > Divisions > Clear Sums and Formulae.  This will also clear any divisional values in the cells that are cleared.