Video help

In this video:

Creating Adjustments
Audit Trail - On screen
Audit Trail - Comprehensive
Import Adjustments
Roll forward

Jump to a specific point in the video with the chapters button in the video.

Adjustments features

Image shows the Adjustments screen in the software. The on-screen options have been labelled with numbers which correspond to the numbers in the table below.

	Option	Function	Notes
1	Allocation display format	Changes how the allocation is displayed	Code: allocations are presented with the code first, then the description, for example: CACOH - Cash on hand Description: allocations are presented with the description first, then the code, for example: Cash on hand - CACOH
2	New	Adds a new adjustment
3	Import	Import a list of adjustments from Excel	See Adjustments import format
4	Delete	Delete adjustments	If no adjustments are selected, it deletes all adjustments If adjustments are selected with #10, it deletes the selected adjustments
5	Clear balances	Sets balances to zero	Select a division and period to clear the balances from
6	Reset sorting	Resets sorting to the default	The default sort order is the order the adjustments were created in
7	Replace	Find and replace allocations	Select an allocation to find and replace with another allocation for all adjustment or just the adjustments selected with #10
8	Copy balances	Copy the prior balance to the current balance	Select adjustments to copy the prior balances to the current balances with the tickbox #11
9	Export	Export to Excel	Exports to Excel including any filters
10	New division	Adds a new consolidation division	Divisions can also be created and imported in Edit entity
11	Select	Selects the adjustment
12	Division name	Displays the division name	Click to select a different division
13	Comment	Adjustment comments	Click to edit Use descriptive comments
14	Delete adjustment	Deletes the adjustment and all rows within it
15	Reference	Adjustment reference	Enter an adjustment number, workpaper number etc If the current allocation is 'UNSET - unallocated account' and the reference entered is a valid account number in the Trial Balance, then the account allocation is looked up and assigned to that adjustment row automatically
16	Allocation	Adjustment allocation	Type all or part of an allocation or description A full list of codes is available here
17	Current balance	Current balance value	Click to edit Enter whole numbers, i.e. not rounded numbers
18	Prior balance	Prior balance value	Click to edit Enter whole numbers, i.e. not rounded numbers
19	Delete adjustment row	Delete the adjustment row clicked
20	New row	Adds a new row to the adjustment

Warnings

The following warnings may be shown on the Adjustments screen:

If any period does not balance, a balance warning will be displayed at the top of the screen, one warning for each period that does not balance
If any period with a balance, has an allocation of 'UNSET - Unallocated account', an UNSET warning will be displayed

Sorting

The default sort order is the order in which the Adjustments were created.

To change the sort order, click any column header. To sort by more than one column hold down SHIFT and click on the other columns you wish to sort by.

Adjustments examples

The following image shows an example of five Adjustments which have been entered across multiple divisions:

Image shows Adjustments screen in the software. There are five adjustments that have been made.

Adjustments import format

Create an import template file

To create an Excel file for importing Adjustments:

Click Inputs > Adjustments
Click the Export button to create a template file

The Export button will only be enabled if there is an adjustment. To force it to enable when there are no existing Adjustments click the New button, type a comment and click OK. The Export button will then be enabled.

Importing Adjustments

The following format does not apply to Interim Reports, see the next example Importing Adjustments (Interim Report only).

To import Adjustments:

Create an import template file
Click the Import button
Tick Delete existing Adjustments to delete all existing Adjustments
Click OK

Cells A1 to A3 will be automatically populated when Export is used. When importing, these cells are ignored and can be blank
The column headers must always start at row 5
Separate each adjustment with a blank row, as shown in rows 8 and 11 in the image below

	Column A	Column B	ColumnC	Column D	Column E	Column F	Column G	Column H
Column	Adjustment number	Division name or division alias	Reference	Allocation	Description	Current balance	Prior balance	Comments
Required	Optional	Required	Optional	Optional	Optional	Optional	Optional	Required
Header	#	Division	Ref	Allocation	Description	Bal - current	Bal - prior	Comments
Notes	Leave blank if unused	Full division name or the division alias	Leave blank if unused	Leave blank if unused	Description will populate from the allocation when imported	If blank and an allocation is present, it will import 0.00	If blank and an allocation is present, it will import 0.00	Required for the first Adjustment in each group

The following image shows a valid sample file:

Image shows a valid Excel import file with the data in the correct columns.

Note: the comments cells are merged when the file is created by clicking Export. The cells do not have to be merged for the file to be valid.

Importing Adjustments (Interim Report only)

To import Adjustments:

Create an import template file
Click the Import button
Tick Delete existing Adjustments to delete all existing Adjustments
Click OK

Cells A1 to A3 will be automatically populated when Export is used. When importing, these cells are ignored and can be blank
The column headers must always start at row 5
Separate each adjustment with a blank row, as shown in rows 8 and 11 in the image below

	Column A	Column B	Column C	Column D	Column E	Column F	Column G	Column H	Column I
Column	Adjustment number	Division name or division alias	Reference	Allocation	Description	Current balance	Prior balance	Annual balance	Comments
Required	Optional	Required	Optional	Optional	Optional	Optional	Optional	Optional	Required
Header	#	Division	Ref	Allocation	Description	Bal - current	Bal - prior	Bal - annual	Comments
Notes	Leave blank if unused	Full division name or the division alias	Leave blank if unused	Leave blank if unused	Description will populate from the allocation when imported	If blank and allocation is present, it will import 0.00	If blank and allocation is present, it will import 0.00	If blank and allocation is present, it will import 0.00	Required for the first Adjustment in each group

The following image shows a valid sample file:

Image shows a valid Excel import file with the data in the correct columns.

Note: the comments cells are merged when the file is created by clicking Export. The cells do not have to be merged for the file to be valid.

Import errors

There are several types of error that could occur while importing Adjustments:

Incorrect number of columns
Adjustments import file contains hidden columns
Division in column B is blank or contains an invalid division name or alias
Invalid allocation in column D
Comments are blank
More than 600 characters in the comments
A message is shown stating there the file contains no data to import, check the header in row 5 is exactly as shown in the image above