Adjusting entries

Setup your adjusting entries

You can setup your adjusting entries either by uploading a CSV file or via our user interface.

The adjusting entries table contains the following fields:

• Description: Description of the adjusting entry.
• Period: Month of the adjusting entry.
• Account: Account number of the adjusting entry.
• Analytical axis: Code and description of the selected analytical axis of the adjusting entry.
• Amount: Amount of the adjusting entry.
• Created by: The user who created the adjusting entry.

Via User Interface

Definition

Prepare a CSV file with the following columns:

• Description [string]: Description of the adjusting entry.
• Period [string]: The period of the adjusting entry in the format YYYY-MM-DD.
• Amount [number]: Total amount.
• Account [number]: Account number.
• Axis [string]: Axis name
• Analytical axis [string]: Analytical axis code or description.

Example:

Description	Period	Amount	Account	Axis	Analytical axis
lorem ipsum	2022-03-25	-1056	600000	Cost Unit	R&D
lorem ipsum	2022-02-14	1056	440000	Cost Unit	R&D

Upload your CSV

1. Go to tab 'Adjusting Entries'.
2. Click
3. Browse to the CSV file on your computer and select and click 'Open'.
4. If you already have adjusting entries configured, select if you want to append or overwrite existing adjusting entries.
5. Click
6. If any errors occur they will be highlighted in red. Your adjusting entries will not be saved.
7. Fix the errors and click untill the adjusting entry is succelfully saved

Via CSV

Setup your adjusting entries

To create your adjusting entries via the Monitr user interface:

1. Go to tab 'Adjusting Entries'.
2. Click
3. If any errors occur they will be highlighted in red. Your adjusting entry will not be saved.
4. Fix the errors and click untill the adjusting entry is succelfully saved

Validation

The following validation checks are performed:

The sum of a period has to be equal to 0.
Period, Description, Account and Amount cannot be empty.