Expand an account number with a fixed value

You renumber the chart of accounts, for example to switch from a 4-digit chart of accounts to a 6-digit chart of accounts. You can do this by adding a code before or after the original account number.

Contents

Append a fixed value

You expand the ledger account numbers by 'attaching' a code to each number.

Example:

The journal structure has a 4-digit chart of accounts linked to it, but your financial administration has a 5-digit chart of accounts.

The original numbers have four positions. To expand them on the right with a zero, you have to place the fixed value '0' at target position 5. For this purpose you configure one replacement line that looks as follows:

  • account number = original account number + '0'

    During the journalising, the effect is:

  • 1800 becomes 18000
  • 1805 becomes 18050
  • Etc.

To expand account numbers with a fixed value:

  1. Go to: HR / Organisation / Employer.
  2. Open the employer’s properties.
  3. Go to the tab: Replacement ledger account.
  4. Click on the action: Maintenance.
  5. Select the Replacement line maintenance (advanced) entry layout.
  6. Click on: OK.
  7. Complete the first entry line, as follows:
    1. Leave Account number empty (because this line applies to all accounts).
    2. Select Fixed value in Source.
    3. Enter the Fixed value.

      This is the code with which you want to expand the account numbers.

    4. Enter the positions you want to replace in Target from and Target to.

  8.  Click on the action: Example chart.
  9. Close the view with the example.
  10. Click on: Finish.
Place a fixed value in front

You expand the ledger account numbers by adding a code in front of each ledger account, for example an employer code.

Example:

You have a journal structure with a 4-digit chart of accounts linked to it. Your financial administration has an 8-digit chart of accounts, with the first three positions taken up by the employer code. The code is followed by a period and then the rest of the account number

The original numbers have four positions. To expand the numbers with a code on the left, you configure two replacement lines:

  • The new numbers will have eight positions, with the last four positions used for the original account number.
  • The first four positions (left) are replaced by '001.'.

    During the journalising, the effect is:

  • 1800 becomes 001.1800
  • 1805 becomes 001.1805
  • Etc.

To expand account numbers with a fixed value:

  1. Complete the first entry line, as follows:
    1. Leave Account number empty (because this line applies to all accounts).
    2. Select the original ledger account number in Source.
    3. Enter the positions you want to replace in Target from and Target to.
  2. Complete the second entry line, as follows:
    1. Leave Account number empty (because this line applies to all accounts).
    2. Select Fixed value in Source.
    3. Enter 001. in Fixed value.
    4. Enter the positions you want to replace in Target from and Target to.

  3. Click on the action: Example chart.
  4. Close the view with the example.
  5. Click on: Finish.

Directly to

  1. Add replacement lines to Payroll journalising
  2. Replace a ledger account number by another number
  3. Expand an account number with a fixed value
  4. Expand account numbers with an allocation code
  5. Specific replacement lines
  6. Cut up account numbers and use parts of codes