How to create a Pension set of Accounts

Introduction

This topic explains how to create a set of accounts for a Pension client on the new EPEN enhanced chart available from version 11.9.

 

Click the links below to jump to a particular section:

Step 1 – Creating a Pension Client

Step 2 - Adding Client Involvements

Step 3 - How to amend/view import Map

Step 4 - Creating a new Post File

Step 5 - Generating a set of Accounts

 


 

Step 1 – Creating A Pension Client

  1. From the Accounts Production Quick Launch toolbar, click the down arrow for and select Standard. Alternatively, from the menu, select Client | New

The following screen displays.

  1. Select CREATE a new client to be added to the database and click Next.

 

 

The following screen displays.

  1. Complete the relevant fields in the Basic Detail section.

  2. In the Type of business field click the drop-down arrow and select Other (this should only be used for Pension clients).

  3. Complete the relevant fields in the Address section and click Next.

  

The following screen displays.

  1. Click Next.

 

The following screen displays.

  1. Click Finish.

 

The following screen displays.

  1. In the Client Identifier field enter an identifier and click OK.

 

The following screen displays.

  1. Click OK.

 

 

Back to top


 

Step 2 – Adding Client Involvements

 

The following screen displays.

  1. Click the magnifying glass next to the Officers field.

The following screen displays listing existing people within the database.

  1. If the person is not listed, click New. If the person is listed, go to Step 10.

 

The following screen displays.

  1. Select CREATE a new client to be added to the database and click Next.

 

The following screen displays.

  1. Complete the relevant fields and click Next.

 

The following screen displays.

  1. Click Next.

 

The following screen displays.

  1. Click Finish.

 

The following screen displays.

  1. Click OK.

 

The following screen displays.

  1. Click OK.

 

The following screen displays.

  1. Click Save and Close.

 

The following screen displays.

  1. From the Client Browser highlight the relevant officer and click Select.

 

The following screen displays.

  1. Click OK.

 

The following screen displays.

  1. Select one of the following options:

 

Back to top


 

Step 3 – How to amend/view Import Map

View the Import Map

The standard import map is available to view from Setup | Import Map |Select Posting ‘entry to entry’ tab and highlight Enhanced Conversion O – Pensions.

 

Users can click to View or Print a list showing which accounts in PEN# are being mapped to which accounts in EPEN as listed below in the standard Import Map.

 

PEN# Chart

EPEN Chart

FUND ACCOUNT

 FUND ACCOUNT

Employers (2-6)

Employers contributions (1-10)

Members (7-11)

Employee contributions (15-19)

Transfer In (12-16)

Transfer In (25-29)

Other Income (17-21)

Other Income (35-39)

Benefits (22- 31)

Benefits paid or payable (45-54)

Payments  to leavers etc (32-41)

Payments  to leavers etc (61-70)

Other payments (42-51)

Other payments (75-84)

Administration expenses ( 52-70)

Administrative expenses (91-109)

Investment income (71-79)

Investment income (201-215)

Irrecoverable tax (80)

Irrecoverable tax (221)

Change in Market value (81-83)

Change in Market value (231-233)

Taxation ( 84-86)

Taxation (241-243)

Investment management expenses ( 87-94)

Investment management expenses (301-308)

 

 

Statement of Net Assets

Statement of Net Assets

Investments allocated to members

 

Fixed interest securities (500-503)

Fixed interest securities (800-803)

Equities (504-507)

Equities (804-807)

Index-linked securities (508-511)

Index-linked securities (808-811)

Pooled investment vehicles ( 512-515)

Pooled investment vehicles ( 812-815)

Unit Trusts (516-519)

Unit Trusts (816-819)

Property (520-523)

Property (824-827)

Insurance policies (524-527)

Insurance policies (828-831)

Loans (528 - 531)

Loans (832 - 835)

Other investments (532-535)

Other investments (836-839)

Cash deposits and cash in hand (536-539)

Cash deposits and cash in hand (844-847)

Other investment balances (540-543)

Other investment balances (848-851)

AVC funds (544 -547)

AVC funds ( 840-843)

 

 

Investments not allocated to members

 

Fixed interest securities (548-551)

Fixed interest securities (852-855)

Equities (552-555)

Equities (856-859)

Index-linked securities (556-559)

Index-linked securities (860-863)

PIV – Managed funds (560-563)

PIV – Managed funds (864-867)

PIV - Unit Trusts (564-567)

PIV - Unit Trusts (868-871)

Property (568-571)

Property (876-879)

Insurance policies (572-575)

Insurance policies (880-883)

Loans (576-579)

Loans (884-887)

Other investments (580-583)

Other investments (888-891)

Cash deposits and cash in hand (584-587)

Cash deposits and cash in hand (896-899)

Other investment balances (588-591)

Other investment balances (900-903)

AVC funds (592-595)

AVC funds (892-895)

 

 

Assets for own use (596-607)

Assets for own use (650-651)

Borrowings ( 608-647)

Borrowings (660-661)

Current Assets ( 648-667)

Current Assets (670-679)

VAT (1)

VAT ( 690)

Current Liabilities (668-679)

Current Liabilities (700-709)

Derivatives allocated to members (700 – 703)

Derivatives allocated to members (820-823)

Derivatives not allocated to members (704-707)

Derivatives not allocated to members (872-875)

 

 

Fund Account (680)

Fund Account (730)

 

 

Amend Import Map

After viewing the import map, if you would like to make amendments click Copy to New.

Highlight the new import map and select the Change option. You can now add to or delete/amend the accounts listed.

Selecting an amended import map

During the conversion of a client, amended import maps can be selected from the Import Map screen.

 

 

Back to top


 

Step 4 – Creating a new Post File

Having clicked Close to the Business Client Maintenance screen the following screen displays.

 

  1. Click Post to start posting accounts or Replace if you have an existing extract.bup file (clicking Replace will display a list of folders to select from).

 

If the No Accounts dialog doesn't display, from the Accounts Production toolbar, click the  option. Alternatively, click Posting | New

 

 

The following screen displays.

  1. In the New year-end date: field enter the Account period end date, for example, 31/10/2014 and click OK.

 

The following screen displays.

  1. Highlight the Accounting Period End date if is not already highlighted and click OK.

 

  1. In the Description field enter a description for the post file.

  2. Enter a Previous account end date or alternatively select OR use date incorporated. If entering a previous account period end date please go to Step 6. If a tick has been placed in OR use date incorporated, go to Step 11.

  3. Click the magnifying glass next to Previous account period end date.

The following screen displays.

  1. Select one of the following options:

 

The following screen displays.

  1. Click Add if the date required is not in the list, go to Step 9. If the date required is in the list, go to Step 10.

 

The following screen displays.

  1. In the New year-end date field enter the previous account end date and click OK.

 

The following screen displays.

  1. Highlight the relevant date and click OK.

 

The following screen displays.

  1. Click OK.

 

The following screen displays.

  1. Click the magnifying glass next to the Document type field.

 

The following screen displays.

  1. Highlight the relevant document type.

  2. Click Select and OK.

 

The following screen displays.

  1. In the Amount field enter the amount.

  2. Click the magnifying glass next to the Account field. Alternatively, manually enter the account code and then go to Step 18.

 

The following screen displays.

  1. Click the relevant account code from the list and click OK.

 

The Posting screen displays.

  1. Click the magnifying glass next to the Fund field.

  2. In the Narrative field enter a narrative if required.

  3. Click Add Posting.

  4. If further postings are required follow Steps 15-21. If no further postings are required, click Close to exit the posting screen.

Back to top


 

Step 5 – Generating a set of Accounts

  1. From the Accounts Production Quick Launch toolbar, click the  option.

The following screen displays.

  1. Ensure the relevant Report/Document type is entered (PEN).

  2. Ensure the correct post entry number has been entered in the Current field and click OK.

 

Back to top