COIN Data-Feed User Manual v4 0
Contents
1. 1 TER 5163 1 Unallocated Advisers Data Sowce extemal Platform Interface Close Unallocated Advies Data Source Adviser Code b Extemal Platform Interface jExtemal Platform Interface JEstemal Platform Interface Extemal Plalform Interface Extemal Platform Interface If an unallocated advisor exists users need to create an External Mapping ID for the adviser for this particular data source 2 Copyright Coin Software Pty Ltd Page 9 of 21 COIN FINANCIAL SOFTWARE ABN 87 104 331 795 Coin Data Feed User Guide 3 This can be done by logging into COIN and selecting Preferences Dealer Group User Management Users File Modules Products Workflow Admin Help ae il Bn Ss mw EBE EJ BSB Q Dice Branch gt er trateg Inc Client Mgmt DocDesigner Marquee Help Products Fees gt User Groups Report Writer gt User Type Strategy Writer gt Permission Groups Print Setup gt Unlock Users Fact Find gt Workflow gt Preferences gt Strategy Filters Marquee b 4 Select the User Name then click on Modify and go to External Mapping File Search By Usemame 0 v starting with stating with User 1 to 2 of 2 User name Login ID User Type Default Group MO Administrator admin Type 1 FTT REENEEEEEEEEER a T a HH Copyright Coin Software Pty Ltd Page 10 of 21 FINANCIAL SOFTWARE ABN 87 104 3312. COIN FINANCIAL SOFTWARE COIN Data Feed User Manual Author Owner Version Date Issued File Name Disclaimer Sunil Ponkshe Sunil Ponkshe 3 0 April 2008 COIN Data Feed User Manual doc The information contained in this document is for the exclusive use of Coin Financial Software Pty Ltd Any use or copying of this information is prohibited unless prior written consent has been provided by the management of Coin Financial Software Copyright Coin Financial Software Australia 2007 Enquiries are to be directed to Coin Financial Software Level 8 9 Castlereagh Street Sydney NSW 2000 Australia Ph 61 2 8224 0700 Fax 61 2 9223 0146 www coinsoftware com au OIN FINANCIAL SOFTWARE ABN 87 104 331 795 Coin Data Feed User Guide Document version control Version Author IssueDate Details Unknown December 2005 Use for COIN v2 5 v2 6 Pramod Moorthy July 2007 Use for COIN V2 7 V2 7 1 for 2 8 Document Distribution Recipient eee Recipient Role Sunil Ponkshe Data Feed Technical Analyst Copyright Coin Software Pty Ltd Page 2 of 21 OIN FINANCIAL SOFTWARE ABN 87 104 331 795 Coin Data Feed User Guide Table of Contents DOCUMENI VERHSION CONTHOL rice crate EXE EcmNmNMUA ERU qe DUE UID EPU PONE MEE 2 DOCUMENT DISTHIB TION cuanh iss sEeshu auUu peu EE y ER aCS ua euavEe eGien UD a Ec E bUR Erana EES 2 TABLE OF CONTENTS sts nts ects ap crest aan Ea KNEDEN
3. The First Column in the transaction History screen labeled DF stands for Data Feed The box will contain a tick if the data has been imported via Data Feed This tick cannot be added or removed manually Any manual transactions will show a empty box with no tick Copyright Coin Software Pty Ltd Page 21 of 21
4. 10378544 was not added as no stock movement transactions can e transaction 10379589 was not added as no stock movement transactions can ome transaction 10379815 was not added as no stock movement transactions can e transaction 10378478 was not added as no stock movement transactions can ome transaction 10381587 was not added as no stock movement transactions can transaction 10379580 was not added as no stock movement transactions can ome transaction 10378541 was not added as no stock movement transactions can e transaction 10382066 was not added as no stock movement transactions can ome transaction 10379423 was not added as no stock movement transactions can e transaction 10379577 was not added as no stock movement transactions can ome transaction 10379212 was not added as no stock movement transactions can e transaction 10378513 was not added as no stock movement transactions can ome transaction 10378912 was not added as no stock movement transactions can ie transaction 10380980 was not added as no stock movement transactions can ome transaction 10379550 was not added as no stock movement transactions can ELIT e trensacbon movement tranzactions car Page 8 of 21 Row Number OIN FINANCIAL SOFTWARE ABN 87 104 331 795 Coin Data Feed User Guide STEP 2 Adviser Mapping Check if there are any un mapped advisors by clicking on the Unallocated Advisors button
5. 10271943 was not deleted as cannot be found in the database or datafee transaction 10319808 was not deleted as cannot be found in the database or datafee ransaction 10349219 was not deleted as cannot be found in the database or datafee tansaction 10382196 was not deleted as cannot be found in the database or datafee transaction 10344229 was not deleted as cannot be found in the database or datafee come transaction 10378617 was not added as no stock movement transactions can come transaction 10381578 was not added as no stock movement transactions can ome transaction 10380104 was not added as no stock movement transactions can e transaction 10379571 was not added as no stock movement transactions can ome transaction 10380931 was not added as no stock movement transactions can transaction 10379523 was not added as no stock movement transactions can ome transaction 10380079 was not added as no stock movement transactions can e transaction 10381581 was not added as no stock movement transactions can ome transaction 10378454 was not added as no stock movement transactions can 1373538 was not added as no stoci ome transaction 10379496 was not added as no stock movement transactions can ie transaction 10378474 was not added as no stock movement transactions can ome transaction 10379504 was not added as no stock movement transactions can e transaction 10379402 was not added as no stock movement transactions can ome transaction
6. PM 5 07 2007 6 30 PM 5 07 2007 6 30 PM 5 07 2007 6 30 PM 5 07 2007 6 30 PM 5 07 2007 6 30 PM 5 07 2007 6 30 PM 5 07 2007 6 30 PM 5 07 Last run on 05 07 2007 v SG wy FileName APA 20070327 APA 20070327 APA 20070327 APA 20070327 APA 20070327 APA 20070327 APA 20070327 APA 20070327 APA 20070327 APA 20070327 APA 20070327 APA 20070327 APA 20070327 APA 20070327 APA 20070327 APA 20070327 APA 20070327 APA 20070327 APA 20070327 APA 20070327 A DONDE rong APA 20070327 APA 20070327 APA 20070327 APA 20070327 APA 20070327 APA 20070327 APA 20070327 APA 20070327 APA 20070327 APA 20070327 APA 20070327 APA 20070327 APA 20070327 APA 20070327 APA 20070327 APA 20070327 APA 20070327 APA 20070327 Account ID Account Name Description Data Feed started at 6 27 20 PM ransaction 10382198 was not deleted as cannot be found in the database or datafee ransaction 10361817 was not deleted as cannot be found in the database or datafee qansaction 10361813 was not deleted as cannot be found in the database or datafee Transaction 10361822 was not deleted as cannot be found in the database or datafee ransaction 10270142 was not deleted as cannot be found in the database or datafee ransaction 10270143 was not deleted as cannot be found in the database or datafee ransaction 10359362 was not deleted as cannot be found in the database or datafee ransaction
7. Platform Inter Extemal Platform Inter E Enema Platform Inter Extemal Platform Inter External Platform Inter External Platform Inter Extemal Platform External Platform Inter External Platform Inter External Platform Inter External Platform Inter External Platform Inter External Platform Inter External Platform Inter ___ Extemal Platform Inter External Platform Inter jExtemal Platform Inter jExtemal Platform Inter External Platform Inter I External Platform Inter External Platform Inter __ External Platform Inter External Platform Inter Estemal Platform Inter External Platform Inter External Platform Inter nter Copyright Coin Software Pty Ltd Data Feed Log 2293 messages _ Type Info To Estemal Platform Interfac w Date 5 07 2007 6 27 PM 5 07 2007 6 29 PM 5 07 2007 6 29 PM 5 07 2007 6 29 PM 5 07 2007 6 23 PM 5 07 2007 6 23 PM 5 07 2007 6 29 PM 5 07 2007 6 29 PM 5 07 2007 6 29 PM 5 07 2007 6 29 PM 5 07 2007 6 29 PM 5 07 2007 6 30 PM 5 07 2007 6 30 PM 5 07 2007 6 30 PM 5 07 2007 6 30 PM 5 07 2007 6 30 PM 5 07 2007 6 30 PM 5 07 2007 6 30 PM 5 07 2007 6 30 PM 5 07 2007 6 30 PM 5 07 2007 6 30 PM 5 07 2007 6 30 PM 2007 6 30 PM 5 07 2007 630 PM 5 07 2007 6 30 PM 5 07 2007 6 30 PM 5 07 2007 6 30 PM 5 07 2007 6 30 PM 5 07 2007 6 30 PM 5 07 2007 6 30 PM 5 07 2007 6 30 PM 5 07 2007 6 30 PM 5 07 2007 6 30 PM 5 07 2007 6 30 PM 5 07 2007 6 30
8. 005 4 56 PM i ActiveReports HtmlExport dll T24 KB Application Extension 3 03 2005 4 56 PM 253 ActiveReports Interop dll 124 KB Application Extension 3 03 2005 4 56 PM a ActiveReports PdFExport dll 228 KB Application Extension 3 03 2005 4 56 PM E ActiveReports REFExport dll 68 KB Application Extension 3 03 2005 4 56 PM a ActiveReports TextExport dll S52 KB Application Extension 3 03 2005 4 56 PM a ActiveReports TiFFExport dll 52 KB Application Extension 3 03 2005 4 56 PM 23 ActiveReports Viever dll 444 KB Application Extension 3 03 2005 4 56 PM 23 ActiveReports Wizards 4ddin dll 32 KB Application Extension 3 03 2005 4 57 PM a ActiveReports xIsExport dll 264 KB Application Extension 3 03 2005 4 57 PIM a ADODB dll 80 KB Application Extension 3 03 2005 4 57 PIM a AuditTrail dll 28KB Application Extension 3 03 2005 4 57 PM a AuditTrailBase dll 44 KB Application Extension 3 03 2005 4 57 PM a AutoLlpgrade Lib dll 32KB Application Extension 3 03 2005 4 56 PM a AutoUpgradeClib dll 36 KB Application Extension 3 03 2005 4 57 PM a AxInterop DHTMLEDLib dll 36 KB Application Extension 3 03 2005 4 57 PM a 4xInterop SHDoc w dlil 44KB Application Extension 3 03 2005 4 57 PM a AxONWCID dll 148 KB Application Extension 3 03 2005 4 57 PM a Balloon dll 24 KB Application Extension 3 03 2005 4 57 PM a Balloonvvindow dll 52KB Application Extension 3 03 2005 4 57 PM a BasRPA dll 4 KB Application Extension 3 03 2005 4 57 PM a BasRPAI
9. 7 M001 CS 19 04 2007 733 KB Workstation Setup External Platform Interface DG1 Unprocessed 7 When ready click the Import Data button to begin the data import process 8 The following screen will appear Data Feed Started on 24 06 2005 11 00 07 AM Importing data 9 The initial data feed could take up to 30 minutes depending on the size of downloaded files Subsequent data feeds will require less time Copyright Coin Software Pty Ltd Page 7 of 21 COIN FINANCIAL SOFTWARE ABN 87 104 331 795 Coin Data Feed User Guide 10 Once the transfer has completed the file will be moved from the Unprocessed Files list to the Processed Files list Files that can not be processed will be rejected and will be displayed in the Rejected Files list After every transfer successful or otherwise a log window will automatically open as shown below to show the results of the data feed 3 Log Viewer Data Feed Run on fom sms Data Source Message Type All Source Extemal Platform Inter Extetnal Platform Inter External Platform Inter External Platform Inter External Platform Inter External Platform Inter m External Platform Inter jExternal Platform Inter External Platform Inter Extemal Platform Inter External Platform Inter External Platform Inter External Platform Inter Extemal Platform Inter External Platform Inter Estemal Platform Inter External
10. 795 Coin Data Feed User Guide 5 Select the Source and add the adviser s External ID 7 User Details Buk Reassign Chert Te Un f a a E General Contact Reseach Delai Member ol Recommended List Permission Bling Extemal Mappng Stiasghi Through Processing Dele Extemal Mapping S User Mapping Exteinal Souce Exteinal Platform Inteface ve Extemel ID One this is complete OK out of all screens Close COIN and log back into DatafeedMain exe Copyright Coin Software Pty Ltd Page 11 of 21 COIN FINANCIAL SOFTWARE ABN 87 104 331 795 Coin Data Feed User Guide STEP 3 Client Mapping 1 Click the Client Mapping button to bring up the following screen JESITTUEU TITLES E n X uia Source usui Patom betel a anges blaag t depa Haj Thai m Toi Janis Fis By Mec ua Thear oia imt Apu watch cw Machu E rity i Ademari ade che we Matthey Lern Lp Dp e a igr Ersa nmm i iie L Accum frci I logy L Vroduc ifl nat VPresuci f ga lar asa Lact re fim Eee dal Fan l afl m E uiii Phat Lara ies T dhiiil Fc niteat iac T saree Paginae Lend iaa Ea niet de d amra Paikan bread cat L renl Pack read cen iana Paian brimi necat Fral Parcours rend ace E zimna Phatiicors Friend acm E ral Paier irigi cn E xbenrund Phaifcarn hrid ncm E sip gl Fg rikje p E siirsi Phal oria cm E sil Pagina raped e m Ebr Plain bred uc Eaten a er rape
11. Files Rejected Files Folder C Program Files Coin Financial Software Strategy Workstation Setup External Platform Interface DG1 Unprocessed File Name Last Modified Size Copyright Coin Software Pty Ltd Page 6 of 21 COIN FINANCIAL SOFTWARE ABN 87 104 331 795 Coin Data Feed User Guide 5 Add the datafeed file to the Unprocessed Files tab 3 Data Feed External Platform Interface File Process Tools Options Help Import Data Client Mapping Unallocated Advisers Unprocessed Files Processed Files Rejected Files _ Folder C Program Files Coin Financial Software Strategy Workstation Setup External Platform Interface DG1 Wnprocessed z File Name Last Modified Size APA 20070327 IU 001 CSY 19 04 2007 733 KB 6 Generally due to the size of an initial data file it is recommended that the Initial Load option is selected as illustrated below This will soeed up the process when the file size is large i e exceeding 50MB as it will ensure that no other data feeds can be run until this initial load has been processed 3 Data Feed External Platform Interface File Process Tools event Help TnitialLoad OO itial Load Import Data C ttt View Logs Auto map all client Close Balance Adjustment Li Unprocessed Files P Database Integrity Check Ignore Balance Checking Create task for unmapped clients z File Name Last Modified Size B APA 2007032
12. Mapping button to bring up the following screen ea Rm D umm Dem Om Pain ROUEN aaa Platters btm nca T Ai np ll ppp a uL Fp Lina Al abii Rai Fie Dg Maritus Tht Gong C hue dinge HD Pa mit Maur e Aham Dm imi a Haig bene tee herr A un F Le er ee Vise Fl dome Pi i bt I m Re ULP Puii E re a bim er P m Fm a Pra i g ee bri m P mm im e hir hd ga bv L ral aru Se hes bg poet LE L Pe um ee OR Wir ied ape ox mel Pm cm OT her el aod be E rena Pr cmm Rr Ha ape D i Pate en bii el qa baa ee Pharm rr emn Hei id ape Tu mna FP i ta Heb lel gored ba a fer ge me or lii quel L2 V mn sul Fais rm High el aret bs mi mar a ii nm Vi cg H arae pmi IL ops Hb H armi bea ai amm al E aria iiim lr el geet inn LET TTE Vi ce bi p aos fen al Ded as te hicr tia bila e P jie a i Vi eda gem pae rd eee Gar as iE lia w gpa bia Formal Pate ie lie e og gm B a e gms me Na h paa bis D ee aed ar ie i liei kl gpi pue oH Tm s har hl gee bs Dmm ol PP gei gi Hiii Bl auod Fa L ees d Pam uod d Hir blaue bis Ce cal Pr e Fir d arme Esai Lren Part irme hir klare bin Cc ual Fits n Nee Sl goed ea L renal Farm ee hor Sd appe p a Drema Pit ien Fi r d aao LI mani Eram irm rm UTILI E mal uL T MIL ET Fini Rd aped baal 0 rmy es ee eo Viii Sl arre Is aim nil Pham fme n ALOLE j al E vum id Fare ara arr Viii Ea qus bea pr ie i ima et el ged j aj 0 eee gfe ie arnor fal Hage ba TE armi 2 Allth
13. OIN data feed program Copyright Coin Software Pty Ltd Page 20 of 21 FINANCIAL SOFTWARE ABN 87 104 331 795 Coin Data Feed User Guide STEP 5 Check Data in Analyser 1 Login to COIN Office and enter your user name and password 2 When the Quick Info screen appears search for the relevant client 3 Select the client that you have mapped 4 Click on Analyser The client s assets and transaction details should now be visible in this module addam Adele ee Lk ee s a E it aL c a e i z 1 L e ES DEDI er al Vue sea a gn d Li Eu reum iem rie En Te F _ Hein HIE Se es ey x x r o Neck cie ee T dox Bepa um ae wo CA pea Soo Liner LI mic UM nt auni T Eo pm jor p 1 An wam Dw Erin BEI IL lis Pelee L e rim Shep Pema CPI bai dimak bin far Tiemie Tepa drwerwfeniowss Arn da hsi hum V mas cm med Pr Vi mnm LX TOI Vetus L art nien a kin T m Dips cee daa Lia Pres onc D XR i tical Dn LO 9l LESE bre Tuam ana agih b um Lis me o fuma bmi eot ales inn j ti 1 i V aru LE i N 000 3 115 X Em i Lu 2 aun i M X Dn Ig Vaeureew ll 1 it pu i i if LPR i i Pas memini m D ane E Jon y pA HDX EID OL Oe BIDGE nUD gunxX BO OE Oe ee PE QGOX I Ur ud sane le EE TH E an 3 LIE X pr LEO X Bud E mm x Bro 3 ig Jisa Meru Mea Dn hesa us E ramar ies lemma ur E EL ei h ETLES4 dE ph IL luo ered eg aas br os ed mda dm meom eee e Pies aliit
14. ansfer data the client s status will change to one of Mapped Unconfirmed or Partly Mapped If the clients are new and their information is not yet stored in the COIN database you can configure auto mapping to allow new clients to be mapped and transferred into the COIN database automatically To successfully auto map new clients you will need to tick all options under the Auto Mapping Options menu see the screen below The options available are Auto Create Unconfirmed Clients This option allows the data feed utility to create clients in the COIN database but does not attach them to any client entity group Auto Create Service This option allows the data feed utility to create a new account if a matching account does not already exist in the client s portfolio Note if there is more than one service of the same type provided by the feed i e two super services even if this option is selected no account will be created Auto Confirm Mapping and Transfer Data This option allows the data feed utility to automatically change the status of the client account to Mapped and transfer the data into COIN 3 Client Mapping Auto Mapping Options w Auto Create Unconfirmed Clients w Auto Create Service w Auto Confirm Mapping and Transfer Data TLS Mastery er Data Map Status All Once the clients are auto mapped the information will automatically transfer into COIN and the list of clien
15. cU SE Eua EE SER M Utd MES 3 INTR ODUG UON ere E rr 4 STEP 1 DATA IMPOR oricine niaes eaaa naaus idiarena 5 STEP 2 ADVISER MAPPING ise ntetusFsnituuti enu Eu rU Usu xo deu i RAN EU ee nena ere USER ERU 9 STEP 3 CGLIENT MAPPING tanta arene om tec ua FUxC Scu quU deux Hec EacsauqEcaeE Ue see FPE e aie x ea FudusEE ENSE 12 3 1 AUTO MAPPING PROCESS eere eer eeeee eniin n nnn 13 3 2 MANUAL IWAFPINO eee ee enn meron estes Ee een AIMER 17 STEP 4 TRANSFER DATA 5istiouxt ace tuoaukuckoua iieiea iaaii ceca n ave n dE EE E Rus 19 STEP 5 CHECK DATA IN ANAL Y ST ccasnscuuuu iE a eue EUn a NuUa con ra Yu bacE bac a cu Cu SEEN uE E 21 Copyright Coin Software Pty Ltd Page 3 of 21 OIN FINANCIAL SOFTWARE ABN 87 104 331 795 Coin Data Feed User Guide Introduction This guide outlines the process of importing client account and transaction data from various investment platforms using the COIN Office data feed program Prior to using this guide you must download the relevant data file s from the platform provider s website Copyright Coin Software Pty Ltd Page 4 of 21 COIN FINANCIAL SOFTWARE ABN 87 104 331 795 Coin Data Feed User Guide STEP 1 Data Import 1 Start the data feed program by clicking on the datafeedmain exe file located in C Program Files Coin Financial Software Strategy Client Workstation Setup Strategy Client Workstation Setup File Edit View Favorites To
16. e clients in the data file that are not mapped will appear in the left hand side list The auto mapping function located in the top left of the above screen can be used to check client s first name and surname with information stored in the adviser s existing database in COIN 3 Ifthe system can find a match on these two items Map Status will change from Not Mapped to Partly Mapped Matching Client Group and Matching Entity fields on the top right hand side of the screen are then automatically populated using information in the data feed which can be seen in full on the bottom right hand side of the screen 4 To complete the client mapping process users will need to add a new service selecting one of the following options Provider Name Asset Investment Provider Name Pension Provider Name Term Allocated Pension Provider Name Super Copyright Coin Software Pty Ltd Page 17 of 21 OIN FINANCIAL SOFTWARE ABN 87 104 331 795 Coin Data Feed User Guide 5 f you choose to map each client account you will need to add a new client group or allocate to an existing client group a new entity or existing entity and a new service or direct investment Matching Client Group Matching Entity and Matching Service each have an Ellipsis button box with 3 dots as well as a New Client New Entity and New Service button Matching Client Group Click on the ellipsis button if you wish to match the account to an ex
17. isting client group in the COIN database If the client is new and their information is not in the database click on the New Client button and enter or modify their details Matching Entity Click on the ellipsis button if you wish to match the client account to an entity in the selected client group in the COIN database You will be shown an entity or a number of entities that belong to the selected client group You can choose one of these entities If you wish to create a new entity in this client group click on the New Entity button Matching Service Click on the ellipsis button if you wish to match the account to an existing service account belonging to the selected entity Click on New Service to create a new service account 6 Adding a new client group 3 New Client Cent Group MN ame Marital Status Adviser Administrator hgg Client Spouse Title Given name Surname Date of birth 2070671945 7 The New Client button will bring up a window as shown above Most fields will be populated automatically Users will however need to check Tax Status Marital Status Advisor and Date of Birth When the Tax Status is changed to Couple the Spouse section at bottom right hand side will be enabled Users will then complete this section manually if appropriate Copyright Coin Software Pty Ltd Page 18 of 21 OIN FINANCIAL SOFTWARE ABN 87 104 331 795 Coin Data Feed User Guide 3 New Entity sic er Co
18. ity Type Relationship Entity M ame Confirm amp Close Confirm amp Load 2 Note that the client is displayed in the Primary Client field Type the designated Entity Group Name and click on Confirm amp Close this will confirm the new entity group and close the screen or Confirm amp Load this will confirm the new entity group and immediately open the client for use to finalise Copyright Coin Software Pty Ltd Page 15 of 21 OIN FINANCIAL SOFTWARE ABN 87 104 331 795 Coin Data Feed User Guide 3 lf you want to add another unconfirmed individual entity e g spouse or other entities that should belong to the same entity group click on Add Entity before you Confirm amp Close or Confirm amp Load The following screen will appear Add Entity Relationship Administrator x 4 You can search for the additional entity via the magnifying glass button in the Add Entity screen You can then select the type of entity Spouse Company Trust Super Fund or Other and the relationship between the selected entity and the primary client e g Spouse Click on OK 5 Once you are satisfied with the additional entities and the name of the entity group click on Confirm amp Close or Confirm amp Load to finish Copyright Coin Software Pty Ltd Page 16 of 21 COIN FINANCIAL SOFTWARE ABN 87 104 331 795 Coin Data Feed User Guide 3 2 Manual Mapping 1 Click the Client
19. mpany Entity Mame 8 The New Entity button will bring up a window as shown above Users can select between Company Trust Super Fund and Other or between client spouse and joint depending on the type of client ya New Service Ed service Name APA Partfalioa Administration Service Fee Option Fees and Commissions ee Commission Adviser Reduced Normal Reduced Entitlement Upfront Initial O00 x Deductible Fee Pa LL OO X pu a tu E Comments OK Cancel 9 The New Service button will bring up a window as shown above There are three service types to choose from wrap super wrap pension and wrap asset Users can adjust fee and commission percentages to appropriate levels Once finished mapping users need to accept the selection by clicking the Accept or Accept All buttons STEP 4 Transfer Data Copyright Coin Software Pty Ltd Page 19 of 21 COIN FINANCIAL SOFTWARE ABN 87 104 331 795 Coin Data Feed User Guide 1 The final step is to transfer mapped client s data into the COIN database by clicking Transfer Data This will remove the client s file from the list on the left hand side of the Client Mapping screen and place the file in the adviser s COIN database L3 reel LE iris Waal Fre FH reel LE LEE LE irs md fia ul ire mi Ee H ire iid iz oli a HEIHE a a E EEIELE ELI 2 Once you have transferred the data close the C
20. ntergration dll 7KB Application Extension 3 03 2005 4 57 PM 23 BatchProcessor Core dll 52 KB Application Extension 3 03 2005 4 57 PM a BatchProcessor Form dil 120 KB Application Extension 3 03 2005 4 57 PM E BossIntegration dll 20KB Application Extension 3 03 2005 4 57 PM a CashFlowMain dll 240 KB Application Extension 3 03 2005 4 57 PM E CISGlobals dll 164 KB Application Extension 3 03 2005 4 57 PM 29 CISGroupcConfirmation dll 324 KB Application Extension 3 03 2005 4 57 PIM 29 CoinCmpt dll 24 KB Application Extension 3 03 2005 4 57 PM 2 Alogin screen will appear Coin Office Login Profile Pramod Login ID admin Password Cancel Copyright Coin Software Pty Ltd Page 5 of 21 COIN FINANCIAL SOFTWARE ABN 87 104 331 795 Coin Data Feed User Guide 3 Login and select the appropriate data source in the Select Data Source screen Y3 Select Data Source Please select data source AN Asgard Ayanteos BT wrap Colonial First State Comm ec External Plattorna Interface Generic Investment Link Macquarie Bank Macquarie Bank CMT MLC Masterkey Navigator Portfolio ne 4 This action will bring you to the screen below Note the 3 tabs which house unprocessed files processed files and rejected files 3 Data Feed External Platform Interface File Process Tools Options Help Import Data Client Mapping Unallocated Advisers Auto map all clien Unprocessed Files Processed
21. ols Help ae sack eae I Search gm Folders Ha O c Program FilesyCoin Financial Software Strategy Client Wworkstal Name Size Type Date Modified Cad File and Folder Tasks E ChartFormats File Folder 3 03 2005 4 57 PM help File Folder 24 02 2005 8 18 AM Other Places tools File Folder 3 03 2005 4 57 PM ID upgrade cache File Folder 3 03 2005 4 56 PM ip oin Financial Software S mscomcrL ocx 1 053KB ActiveX Control 7 06 2002 4 13 AM i3 My Documents Co AutoUparade 15KB Application 15 12 2003 5 30 PM Xj My Computer C Auteuparadeconfia 28KB Application 3 03 2005 4 57 PM fain 52KB Application 3 03 2005 4 57 PM E DEMonitor 32 KB Application 3 03 2005 4 57 PM C Exiter 16 KB Application 3 03 2005 4 57 PM My Network Places Details wSHSTMain 420 KB Application 3 03 2005 4 57 PM L Profileconfia 40 KB Application 3 03 2005 4 57 PM DataFeedMain L ReplicatorProfileConFia 24KB Application 3 03 2005 4 57 PM Application C ReplicatorStub 68 KB Application 3 03 2005 4 57 PM Date Modified Thursday 3 C strategyExport 20 KB Application 24 02 2005 8 18 AM E March 2005 4 57 PM Cl StrategyImport 9KB Application 24 02 2005 8 18 AM Size 52 0 KB CM uparade 7 620 KB Application 3 03 2005 5 00 PM ia ActionDataModules dll 112KB Application Extension 3 03 2005 4 56 PM a ActiveReports Design dll 1 276 KB Application Extension 3 03 2005 4 56 PM E ActiveReports dll 812KB Application Extension 3 03 2
22. oop E inal al Pipe p a of E parigi Fagien 1 ie ae op IKE ER ri a legegegepepegepepoBPPPBPEPEPCPPPPCEPEPRPDBPP All the clients in the data file that are not mapped will appear in the left hand side list These clients will need to be mapped via two options Auto Mapping or Manual Mapping Please note that it is your discretion to use either option 2 he auto mapping function is located on the top left of the above screen and can be used to check client s first name surname and date of birth with information stored in the adviser s existing COIN database A successfully auto mapped account will show the map status as Mapped Copyright Coin Software Pty Ltd Page 12 of 21 OIN FINANCIAL SOFTWARE ABN 87 104 331 795 Coin Data Feed User Guide 3 1 Auto Mapping Process The data feed program will search for a match in the following order A On the client s First Initial Last Name DOB Adviser Code B If there are no matches for step A then the data feed program searches for a match on the client s Full First Name Last Name Advisor Code C If more than 1 match is found for an account in either step A or B then the map status will be updated to Duplicate D If the system finds a match in either step A or B then depending on whether a service is found in the clients portfolio that the account can be mapped to and whether the user has selected to auto confirm and tr
23. t accounts on the left of the screen will disappear Copyright Coin Software Pty Ltd Page 13 of 21 FINANCIAL SOFTWARE ABN 87 104 331 795 Coin Data Feed User Guide The next step is to close down the COIN data feed program and log into COIN Office using your User ID and Password The Quick Info screen will open listing your existing clients that have the status Confirmed The clients you have auto mapped will have the status Unconfirmed and will need to be allocated to an existing or new entity group To show the list of unconfirmed clients select Unconfirmed See the screen below and click on Search A iuick info Fie Lodge Chien Eris Gimp hams we bei te Green Marne Va pa ww Daty ed Eth huss Dmag Acad il Weasels Soho on m Catenin eWiegen gt a Shaw teracect Fitts Pre Rp ide died eus Cleri 1 bo Sof B eher window e v penGmup id Cone 1 To allocate the unconfirmed clients to an entity group hence changing their status to Confirmed select a client and click on the Open Group button located at the base of the Quick Info screen The Entity Group Confirmation screen will appear as follows Copyright Coin Software Pty Ltd Page 14 of 21 OIN FINANCIAL SOFTWARE ABN 87 104 331 795 Coin Data Feed User Guide Entity Group Confirmation BH Enty Group Name BENEEEEEEEEEEEEEEEEEEEEEEENNEN Primary Client LJ Primary Client Type Individual wv Entities Ent
Download Pdf Manuals
Related Search