Download BGL Simple Fund Guidelines

Contents
About this document
3
Audience........................................................................................................... 3
Objectives ......................................................................................................... 3
Related documentation ....................................................................................... 3
Upload data from BGL into V-Wrap via the XML File Upload
4
Setting up the link between BGL and V-Wrap ........................................................ 4
Creating the file in BGL ....................................................................................... 5
Uploading the BGL file into V-Wrap ...................................................................... 6
Reconciling V-Wrap to Simple Fund ...................................................................... 7
Extracting the Reconciliation Information from BGL ................................................ 8
To run these reports in BGL: ....................................................................................... 8
Checking and amending the end holding result .............................................................. 9
Upload data for the current year into the portfolio via V-Wrap’s preformatted spreadsheet
10
Cash books ..................................................................................................... 10
Timing differences and other reconciliation items ................................................. 11
Upload data from V-Wrap into BGL
12
Save the BGL code in V-Wrap ............................................................................ 12
Setting up the download in V-Wrap .................................................................... 12
With Contra G/L Accounts and cash books ...................................................................12
With Contra G/L Accounts and no V-Wrap cash books ...................................................13
Without Contra G/L Accounts .....................................................................................13
Investment codes for Buy and Sell transactions ............................................................13
Service Assets in V-Wrap ...........................................................................................14
Configuring the V-Wrap to BGL interface ............................................................. 15
G/L Asset Code Override ...........................................................................................15
To set up a G/L Asset Code Override: .........................................................................15
G/L Security Code Override .......................................................................................16
To set up a G/L Security Code Override: ......................................................................16
The V-Wrap cash book...................................................................................... 16
Multiple Bank Accounts..............................................................................................18
Preparing the download file in V-Wrap ................................................................ 18
Selecting the file attributes: .......................................................................................18
Using the BGL web interface to upload your V-Wrap data ...................................... 20
Setting up BGL Simple Fund.......................................................................................20
To set up Simple Fund: .............................................................................................20
Service ID numbers ..................................................................................................21
Uploading the transactions into BGL Simple Fund .........................................................22
Creating the file manually ................................................................................. 23
Upload into BGL ............................................................................................... 24
Funds with Segregated Assets ........................................................................... 26
Version 1 Definitive 18 March 2009
COMMERCIAL–IN CONFIDENCE
© 2008 Præmium