GL2 has been designed to be easy for GL2 system administrators to implement their own entities and ledgers. The recommended practice is to set up the chart of accounts in the Live environment first. Then switch to the Test environment, import the opening balances and do a month or more of processing (if switching from another accounting system). This will highlight any accounts that need creating and / or any special setup that may be required. Once you are satisfied that the setup and usage is correct, the process is repeated (more quickly and easily) in the Live environment.
Steps to complete
- Create the Entity and Ledger in GL2 in the Live and Test environments.
- Create users in the Test environment.
- Set up the chart of accounts in the Live environment.
- Link the Special Accounts in the Live environment, as required.
- Export the chart of accounts and map the existing trial balance to the GL2 accounts.
- Import the accounts, sub-accounts, legacy accounts and opening balances into the Test environment.
- Set up bank accounts / cheques / receipts / tax in the Test environment.
- Set up the statements and interest features in the Test environment, if using these features.
- Import budgets into the Test environment, if required.
- Training - train all users in the Test environment.
- Testing - if required, process a month or more of data, testing all required features and functions.
- Go live
- Set the correct Financial Year and Period Start in the Live environment.
- Redo the opening balances as at the go live date. Import into the Live environment.
- Set up bank accounts / cheques / receipts / tax in the Live environment.
- Set up the statements and interest features in the Live environment, if using these features.
- Redo and import the budgets into the Live environment, if using this feature. Can be done later though.
- Ensure all users created in Live.
Task | Live | Test | Done? | ||
---|---|---|---|---|---|
1 | Create the Entity and Ledger in GL2 | X | X | ||
2 | Create users | X | |||
3 | Set up the chart of accounts | X | |||
4 | Link the Special Accounts | X | |||
5 | Export the chart of accounts and map the existing trial balance to the GL2 accounts. | ||||
6 | Import the accounts, sub-accounts, legacy accounts and opening balances | X | X | ||
7 | Set up bank accounts / cheques / receipts | X | |||
8 | Set up the statements and interest features, if using them | X | |||
9 | Import budgets, if required | X | |||
10 | Training - train all users | X | |||
11 | Testing - if required, process a month or more of data, testing all required features and functions. | X | |||
12 | Go live | ||||
a | SetConfirm that the correct Financial Year and Period Start has been set | X | |||
b | Redo the opening balances as at the go live date. Import into the Live environment. | X | |||
c | Link the Special Accounts | X | |||
d | Set up bank accounts / cheques / receipts | X | d|||
e | Set up the statements and interest features, if using them | X | e|||
f | Redo and import the budgets | , if using this feature(optional at this time) | X | f||
g | Ensure all users created in Live. | X |
Steps explained
Step 1 - Create the Entity and Ledger in GL2 in the Live and Test environments
...
Sub-accounts can be created individually in GL2 as explained below, or in bulk using the Excel account import template.Using the Excel import template is covered XX.at Import data into GL2
- Go to System > Administration.
- Select the relevant ledger.
- Tick the Show Sub-Accounts Only box.
- Click on the relevant category, then click Add Sub-Account.
- Complete the relevant fields, then click Save.
- Code - 10 characters max.
- Name - 50 characters max.
- Address - Email - may be used in the future, e.genter where relevant, such as on Church, Entity, Location, Student, and Who sub-account types.
- Email - will be used in a future release, e.g. for emailing statements.
- Analysis Category - if not already selected, choose the correct category.
- Allow Posting - Select the earliest period that posting will be allowed from. The To field can be left blank so that posting can occur indefinitely.
- Currency - select the currency of the sub-account (if using multi-currency)
- Repeat steps 3-5 to create all sub-accounts.
...
Sub-accounts can be assigned individually as explained below, or in bulk using the Excel account import template. Using the Excel import template is covered XX.:
- Go to System > Administration.
- Select the relevant ledger.
- Select an account to have sub-accounts assigned.
- Click on the Assign Sub-Accounts tab.
- From the Sub-Accounts Available list, highlight one or more sub-accounts (use Shift and/or Ctrl to highlight multiple accounts) and click on the arrow to move them to the Sub-Accounts Assigned field.
- Repeat steps 3-5 as required.
...
Determine what type of testing will be done, and who will participate in this important process. Will you re-process one or more month's of data in Test, or will you just complete the areas outlined in the User Acceptance Testing document?
Step 12 - Go live
a. |
...
Confirm that the correct Financial Year and Period Start has been set |
|
b. Redo the opening balances as at the go live date. Import into the Live environment. | As per Step 6 above. Save a copy of the Opening balances file created for importing into Test, then update the figures and import into the Live environment. |
c. Link the Special Accounts | As per Step 4 above. |
d. Set up bank accounts / cheques / receipts | As per Step 7 above. |
e. Set up the statements and interest features, if using them | As per Step 8 above. |
f. Redo and import the budgets (optional at this time) | This can be done after going live if they are not ready to be imported at this time. As per Step 9 above. |
g. Ensure all users created in Live | As per Step 2 above. |