0906 Ledger Position Transfer

• Summary:

Before the new ledger system can be used, the initial position for the accounts has to be transferred from the old ledger system.

This is a Excel program to complete the step 1 to 4 in the following process:

1. Download the existing balance for different accounts in the old ledger system.
2. Translate the old account code to new account code based on a set of rules.
3. Mark those records that cannot find any new account codes.
4. Construct a set of upload-able file for the new ledger system, each contains the a new account code and the initial balance.
5. User can verfiy and modify the number before uploading
6. User upload the initial balance.

• The user case:

• Program flow-chart:

• User interface:

NOTE: The software is company asset, therefore the code will not be revealed.