Local adjustments

To access the Local Adjustments page, click Data Entry > Manual Data Entry > Local Adjustments .

The top panel displays the list of local adjustments that are already available in the consolidation by:

  • Period: Current or Reference

  • Journal Type - the journal type and category of the local adjustment.

  • Journal Entry - the entry number of the local adjustment.

  • Company Code - code of the company for which the local adjustment is made.

  • Company Name - name of the company for which the local adjustment is made

  • Journal Text - description of the local adjustment.

  • Modification Date - date of the last modification.

  • Columns - This option lets you choose which columns to display in the table. Use the toggles beside each column name to show or hide them. For example, you can display columns such as Currency, Third Party, and Behavior directly in the table.

  • Actions:

    • - opens the selected local adjustment. On the page, you can view the details and modify the adjustment.

    • - deletes the selected local adjustment.

Journal details

The lower panel (data area) of the page is where the details of any adjustment selected on the top panel are displayed.

Preview journal details

In the Adjustments table, click on an adjustment. Details of the adjustment are displayed in Journal details.

Add a new journal

The Local Adjustments Manual Input page allows you to enter adjustments manually. To import adjustments, see Import Adjustments.

  1. Click . The page is refreshed for your input.

     

  2. In the top section of the page, enter the adjustment details. See Top of the page - adjustment-related information.

  3. Just above the data area are the following additional functions:

    • Sort by - Not applicable to local adjustments.
    • Tax - Not applicable to local adjustments.

    • - opens the View by Account pop-up, and displays Debit /Credit sums by account.

    • - opens the Multiply/Divide pop-up, allowing you to divide or multiply the selected amounts.

    • - adds a new set of rows below the existing rows.

  4. In the data area, select the applicable Account. See Data area for the descriptions of the other fields and functions.

     Note:
    • When you select an existing adjustment, the lines in this table are populated by the system.

    • When you start with a new adjustment, empty lines are displayed.

    • When adding a row for a new adjustment, this is the data area where you enter different lines for the adjustment.

  5. Below the data area you have these options:

    • - allows you to start a new blank adjustment.

    • - allows you to start a new adjustment by copying the layout of the current adjustment. Everything is copied except for the adjustment description and the amount of each adjustment line.

    • - deletes the journal.

    •  Note:   All modifications that you made will be lost if you click the button without saving.

    • - Select a format and click to download report .

    • - navigates away from the Local Adjustment Manual Input page and takes you back to the main Local Adjustments page.

    • - Reverses all the changes you made to the adjustment on this page.

       

View the details of an adjustment

To view an adjustment, click in the Actions column of the main Local Adjustments page. The adjustment details are displayed:

Top section of the page - Adjustment-related information

The top section of the page is where you enter general adjustment-related information.

  • Company - company code and name.

  • Journal - journal code and name.

  • Associated Journal - journal into which the adjustment will be carried forward.

  • Journal Entry - number assigned automatically by the system to the adjustment. You can change this number if you wish.

  • Currency - Not applicable to local adjustments.

  • Third Party - Not applicable to local adjustments.

  • Behavior - the action that will only be taken into account when we create a new period in a new year. For example, carry it forward to reserve, copy, reverse, etc. From the drop-down list, choose an option.

  • Attachment - using the upload icon, allows a document to be uploaded and attached.

  • Created - Date on which the adjustment record was created. System-populated after you save the adjustment.

  • Modified - Date on which the adjustment record was modified. System-populated after you save the adjustment.

  • By - Name of the person who created the adjustment. System-populated after you save the adjustment.

    Just above the data area are the following additional functions:

  • Sort by - Not applicable to local adjustments.

  • Tax - Not applicable to local adjustments.

  • - opens the View by Account pop-up, and displays Debit /Credit sums by account.

  • - opens the Multiply /Divide pop-up, allowing you to divide or multiply the selected amounts.

  • - adds a new set of rows below the existing rows.

Data area

 Note:
  • When you select an existing adjustment, the lines in this table are populated by the system.

  • When you start with a new adjustment, empty lines are displayed.

  • When adding a row for a new adjustment, this is the data area where you enter different lines for the adjustment.

  • Line - line number of the adjustment.

  • Account - account code and the account description. You can use the to search for an account. The code and description of the account you select are populated in their respective fields.

  • Debit - total of debit amounts automatically calculated.
  • Credit - total of credit amounts automatically calculated.

  • Actions column, click (the More button ) to display the actions you can perform on each line:

    • Repeat button - allows you to repeat the amount from the current line. For example, if you have a journal entry impacting for the same amount multiple accounts alternately as debit or credit, instead of filling in the account codes on each line, you can use this option to facilitate the input of adjustments having repetitive amounts and avoid input error. See Repeat an amount for details.
    • Difference button - inserts the difference between the total Debit and Credit amounts on the line in which you click the button.

    • Clear button - clears the content of a selected line.

Below the data area

  • - allows you to start a new blank adjustment.

  • - allows you to start a new adjustment by copying the layout of the current adjustment. Everything is copied except for the adjustment description and the amount of each adjustment line.

  • - deletes the journal.

  •  Note:   All modifications that you made will be lost if you click the button without saving.

  • - Select a format and click to download report .

  • - navigates away from the Local Adjustment Manual Input page and takes you back to the main Local Adjustments page.

  • - Reverses all the changes you made to the adjustment on this page.

Modify an adjustment

  1. To view an adjustment, click in the Actions column of the main Local Adjustments page. The adjustment details are displayed.

  2. Make the changes and save your work.

Multiply/Divide an adjustment

The Multiply / Divide button is very useful during a monthly reporting. You can easily recalculate a provision, depreciation, etc. to the Year-To-Date value.

 Note:  The Multiply / Divide button will work on all the lines that you select.

  1. Select adjustment lines

  1. Click . The Mulitply/Divide pop-up appears.

  2. Enter the fraction by which you want to multiply or divide.

  3. Click. The amounts are recalculated.

Repeat an amount

Using the Repeat function you can change all the amounts of an adjustment.

  1. Enter the amount you want to repeat on any line.

  2. Select the amount and then, click to copy the amount to the other lines. The new amounts will alternate between debit and credit.

     Note:  When using this option, it is recommended to enter the accounts in such an order that the amounts can alternate properly between debit and credit.