QSMART Reporting System Client User Manual
Contents
1. Login The Initial Login Access the login screen via the Quantum website at www quantumgroup com au then follow the link at the bottom right hand corner of the home page Already a OSmart Client Login to your individual portfolio management system The following will display Remember User ID Enter the login details user id and defa assword and then click to proceed If the user wishes Praemium to remember the user id ensure the Remember user ID box is checked with a tick The first time the user logs in a screen will appear to change the password from the default main f Logout Back Enter Current Password Enter New Password Confirm New Password Save New Password Enter the current password changeme Enter the new password This must be at least 6 characters and is case sensitive Confirm the password Once this has been completed successfully the user will be taken to the transactional site for the service Change Password Password Likewise users can change their password at any time Go to Maintenance on the menu bar select the sub menu User Maintenance and click on Change Password Logout Back Maintenance Portfolio Reports Trading Activity Print Preview Help Feedback User Sam Sample User Maintenance gt Change User Details Portfolio Management gt Change User Preferences Quick Help gt gt gt Make Credit Card Payment Change Password2. Portable Document Format Top Tithe With Image w Top Title With Image Top Title Mo image Mo Tithe Mo Image Forntable Document Format HTML Wiewer Word Format Excel Header Excel Format Side Tithe Mo Image Rich Text Format MHo Header Or Footer Select ranges for certain reports by adjusting the dates in the boxes and change criteria by selecting the options available in the drop down boxes All other dates are defined by the recalculate to date Select the report s to print by clicking in the Select Report Box Select one or more reports as required Once the selections have been made click Show Reporti and follow any prompts to print Remember the content of the reports will reflect the date that the portfolio has been recalculated to and the searches submitted A Guide to the Menus Across the top of the screen there is a menu bar which will allow you to navigate your way around Praemium When the cursor is placed over a selection on the bar if there are further options a sub me taken straight to the Logout Back User Sam Sample Quick Help gt gt gt Maintenance Request Invoice Personal Assets Add New Portfolio s Previous Next gt Select Portfolio Name Portfolio Type User Maintenance d Change User Details Portholio Management H Change User Preferences Make Credit Card Payment Change Password Process From u appears with those options Just click on
3. Quick Help gt gt gt Export to Excel Show GICS Total Cost 383 735 Value 489 766 Gain Loss 106 031 Est Income 15 673 Est Yield 3 The Portfolio Valuation by Security is a summary of the portfolio holdings It displays the total cost of the investments in the portfolio and the total current value at the processed to date based on the day s closing prices The Gain Loss is the nominal difference between the total value and the total cost NOT the CGT gain or loss The estimated income is indicative only and is based on the income generated by the holdings over the previous 12 month period The estimated yield is the estimated income as a percentage of the market value of the portfolio The portfolio can be displayed either in alphabetical order under categories such as ASX Listed or Managed Funds or by GICS Global Industry Classification Standard The GICS can be toggled on or off using the GICS indicator H Show Gics Beneath the portfolio totals is a table showing summary details for each holding see Previous Next Security Code Quantity Unit Cost Adj Cost Unit Value Value GainiLoss Est Income Est Yield AIP 1 000 1 12 1 120 00 1 09 1 090 00 30 00 98 5 99 13 500 00 16 3 7 100 00 12 For each security the following is displayed The Security code e g AMC This could also be the APIR code or service personal asset code The name of the holding and descrip
4. yj QUANTUMGROUP QSMART Reporting System Client User Manual Contents LOOT prosio risin tu sxncaveans eavevea wens OOT OAE ONE E EO EOE 3 Toe an a ores iea n a E r E E E E E 3 Change PassWord iicvesccicesssssaveatenvstiunansiciasvseiandassisunvesssssancecounvasivelaaveseuvseiseiaeveninusscoseaverscaniavensanteneacnceeeseissvetennsianssanbans 4 FESS Vy OU E EE E E AE T E E E Snowe aun S E T tito denoen dein E E E E A O 4 TBE CE OF AS VO a E E E E E E E E E E E 4 Heip and ASSISCANCE siesecsecsicccacscevcnnssssetasweawastanssaeasnacewenseenereonesvecvetwseedaceusscnaaeasiaenseedtsecutvccesetecnsssustaenednestsassenstreueuseaias 5 e Ke Pe e E E EEE E E E E E E A 5 Po ON oe A E E sunset voncadac E E E E 5 Basic Tips on Navisating the System sasvscescccccccessesssicsesssevsssensenceseseisevacuwesetwanaceensvessdacdavovasewesvoceesdardecesasanauievesteussevacsede 7 Moving From One Screen Page to the NOX iescaciccieccccncicereacatecenesaadiaanvseaderabaccaateodetntadctaiastencteuonacsanehenensthedensdenusentnte 7 Us mee Se iy A as ss coe a E utes esc ee cee enone asec ase Neer E E e ace 7 Sorting Screen Information by Selected Headings cc cesssssessssssseeeceeecececcccecececeaeeaaeeeaaeassseseeeeeeeeeeeeeeeeeeeenes 8 Viewing Information for another Portfolio without Leaving the Screen ccc seeeeeessseseeeeceecececeecececeeeeeeeeeeeaeeeeees 8 Kecalculatine the POrilOlio seseissscessssscaceanevesciussanscrvcrdessvseieceavcncetessSescwe
5. 0 00 0 00 M Edit ia go paeta 6 02 2004 4 500 52 925 00 0 00 0 00 Edit i g eet 19 02 2004 13 500 52 925 00 0 00 0 00 Edit i o Rane PRKDA PATRICK DEFERRED SETTLEMENT 6 02 2004 13 500 52 925 00 0 00 0 00 F Edit aia Bio 19 02 2004 13 500 52 925 00 0 00 0 00 v This search process is available in the Income screen and also in the Cash Book but not for a security 11 Understanding the Reports Under the menu Portfolio Details there is a selection of screens that provide information about the portfolio All of these screens can be printed as reports See Creating and Printing The screens deal with Portfolio Valuation by Security Portfolio Asset Class Summary Portfolio Performance Holding Performance Trading Summary Realised CGT detailed and summary Unrealised CGT detailed and summary Every screen report has the following information which appears under the menu bar e The userID e g Admin Istrator e The selected portfolio for which the report is displaying e g Demo 301 e The Processed To date The date the information for the portfolio represents This can be amended by activating the recalculate to process to the required date Portfolio Valuation by Security A Main Logout Back Maintenance Portfolio Details Trading Activity Print Reports _System Management Feedback User admin istrator Portfolio 643 CJ demo 301 Processed to 17 04 2004
6. 28 03 2002 28 03 2002 3 400 00 J lt iii gt Click in the box to the left of the Security to select the holdings to be used in the What If calculation More than one can be clicked Then click the mauve Recalculate button to see the result Quick Help gt gt gt Close What if Summary Realised Gains Carried Forward Losses Losses Generated in Period Total Losses Available to be offset 725 725 Pre Offset Gain Losses Used to Offset After Offset Gain Less than 1 Year Gain Non Discounted Gain 526 526 E Discounted Gain 7 417 199 7 317 5 Net Gain 7 318 lt lt Previous WNext gt gt gt eects Pong staid Quantity Cost gente CGT Gain Losses Tax Date SS are ii rk i AMC AMCOR Ltd Ord 2 500 13 500 00 20 650 00 3 575 00 1 02 1998 1 02 1998 13 851 00 C ANZ ANZ BANKING GROUP LIMITED 10 000 27 400 00 181 299 99 76 950 00 10 01 1999 10 01 1999 27 756 20 C CBA COMMONWEALTH BANK OF AUSTRALIA Ord 000 138 000 00 152 100 00 14 100 00 1110 2001 11 10 2001 138 000 00 106 3 400 00 3 224 52 175 48 28 03 2002 28 03 2002 3 400 00 a lt mT gt The selected unrealised gains losses have been merged into the Realised position Click the S sa Wik 5 button This report can be viewed in both detail and summary format 21 Reports Creating and Printing To review create and print reports for a single portfolio click Print Reports on the menu bar The following screen displays Show Rep
7. Maintenance Portfolio Reports Trading Activity Print Preview Help Feed User Sam Sample Dotto MrJohn Smith Processed to 10 10 2002 User Samgample Portfolio MrJohnSmith Processed to 10 10 2002 Quick Help gt gt gt Quick Help lt lt lt If you are receiving or have received DRP or BSP units enter the company details here This will enable Praemium to auto generate historical and current DRP details Resulting transactions should be reviewed and edited in the Transaction History screen as there Ad may be minor rounding differences in the quantity received If you are in a Share Purchase Plan enter the details of units purchased in the Buys Sells screen aa lt Previous Next gt gt gt Security Code Description Reinvestment Type FromDate To Date Add Delete CBA COMMONWEALTH BANK OF AUSTRALIA Ord Dividend Reinvestment Inception Current aa lt Previous Next gt gt gt SS Security Code Description Reinvestment Type From Date To Date Delete CBA COMMONWEALTH BANK OF AUSTRALIA Ord Dividend Reinvestment Inception Current sas Previous Next gt gt gt Feedback Feedback is an interactive Help process initiated by emailing a message to be actioned It can be used for assistance to alert errors in the data or to provide general information Click the button on the right hand side of the menu bar This brings up a screen for the user to enter details Logout Back Maintenance Portfolio
8. 4 56 AMC 2 592 06 9 11 3 752 8 13 19 1 160 74 4 08 AMP 1 600 19 49 1 600 19 49 0 ANZ 52 28 0 37 722 5 17 774 28 5 55 ANZR 30 34 19 71 30 34 19 71 0 BTA0126AU 9 807 23 20 87 6 618 48 14 09 3 188 75 6 79 CML 7 690 769 7 490 749 200 20 GAN 332 92 8 13 36 52 0 89 296 4 7 24 S PRK 16 953 58 28 07 15 525 25 7 1 428 58 2 37 WBKPA 177 92 1 78 14 0 14 163 92 1 64 There is a select criteria panel which provides the options to sort the information You can sort by Ascending or descending codes 1 e alphabetically Ascending or descending Performance Ascending or descending Gain Ascending or descending Impact Select Data Sort Just click on your preferred method The above sort selection can be applied to Capital and Income 1 e Total Gain Capital only or o Income only O Capital amp Income Capital Only O Income Only Click the appropriate circle The data table is sorted depending on the selection made The information displays in dollar values and percentages Click Print Reports on the menu bar to print the performance report using the sort criteria you have selected 16 Trading Summary The Trading Summary provides the summary profit or loss for a financial year or part thereof as a result of trading for the period It is NOT a tax report It measures the nominal profit or loss on both the realised and unrealised pos
9. Losses Available to be offset 550 550 taxable gain loss for the financial year or the current year to date Pre Offset Gain Losses Used to Offset After Offset Ga depending on when the portfolio is recalculated to Less than 1 Year Gain Non Discounted Gain 526 526 Discounted Gain 3 842 24 3 830 Net Gain 3 830 lt lt lt Previous Next gt gt Sale Security Description Quantity Cost Sale Amnt CGT Gain Losses BIG Big Bucks Pty Ltd 1 000 1 000 00 450 00 550 00 1 AMC AMCOR Ltd Ord 2 327 12 565 80 19 965 66 3 699 93 1 Each line shows the detail of 173 934 20 1 484 34 525 85 the calculation for each JET JETSET TRAVELVWWORLD LTD 3 000 225 00 510 00 142 disposal lt lt lt Previous Next gt gt gt These columns to the left of the blue line show the m selected taxable amounts based on the method used Purchase Indexed Non CGT Indexed Discounted These columns to the right Tax Date Date Sale Date Cost Gain Loss Gross Gain Other Gain Gain Gain of the blue line show the 1 02 2002 1 02 2002 3 10 2002 1 000 00 detail of each type of 1021998 1 02 1998 15 09 2002 12 992 51 7 399 86 7 073 15 3 699 93 eain loss as it applies to each 11021998 1 02 1998 15 09 2002 958 49 550 14 525 85 275 07 disposal and is for 1112 2000 1412 2000 15 09 2002 225 00 295 00 142 50 information only NOTE The 2 sections either side of the blue line display as one table on the screen lt The table is in two pa
10. Reports Trading Activity Print Preview Help User Sam Sample Portfolio MrJohn Smith Processed to 10 10 2002 Quick Help gt gt gt Function Being Executed Dividend Reinvestment Details Type Make your selection by clicking these circles eError O Enhancement Information Importance OLow Medium Odigh You must enter something in these boxes Submit Feedback to describe the item for Feedback Feedback Heading Feedback Detail Select the type of feedback to be provided by clicking in the appropriate circle Then click the level of importance attributed to the feedback item Enter a meaningful heading in the Feedback Heading box as this will be the reference point in any subsequent communication Enter the detail of the feedback question item in the box provided When all these items are completed click the Submit Feedback button This sends an email message with all the details to the relevant personnel Basic Tips on Navigating the System As a general rule throughout Praemium where it is required to click a button to activate a process such as Savel the button must be clicked Do NOT use the enter key as a substitute The Praemium process will not respond and in some cases cause the user to be aborted from the session When the user wishes to return to the previous screen click Bac k on the menu bar If the user wishes to go straight back to the main menu Po
11. Request Invoice Personal Assets The following screen displays Logout Back Help Enter Current Password Enter New Password Confirm New Password Save New Password The user will be required to enter the current password then enter the new password and in the bottom box confirm the new password Remember the password must be at least 6 characters and is case sensitive HELP What happens if I forget my password Forgotten Password If users in the service forget their password they must contact Quantum to reset it Quantum does not know clients passwords and will never ask for a password Quantum will reset the password to the default The user can then login to the system and change the password per the process discussed above Use the default as the current password Help and Assistance Quick Help This information is provided on most screens It includes short notes on what that particular screen does and how to navigate through it The Quick Help defaults to close down mode To activate Quick Help click the Quick Help gt gt gt button which is located at the top left hand side of the page beneath the menu bar It will open up to reveal the notes Likewise it can be closed down again by clicking Quick Help lt lt lt Click here to open and close Main Logout Back Maintenance Pol Rents Trading Activity Pin Preew Help Feedhe Main Layout Back
12. and the user wishes to scroll back to a previous screen click lt lt lt Previous The number of lines to a screen page can be changed and this is discussed in User Preferences Using the Screen Bars If the user cannot see all of a screen in the screen view use the blue bars at the right hand side and across the bottom to bring the required information in to view Click on the bar and drag it up down or left right Logout Back Maintenance Portfolio Reports Trading Activity Print Preview Help Feedback A Sam Sample Portfolio ir John Smith Processed to 26 09 2002 E E rows 2670972003 ious WNext gt gt gt Name change from HRK HEARTLINK L JET JETSET TRAVELVVORLD LTD Entitlement JETN JETSET TRAVELVVORLD LI 1 08 2001 1 500 105 00 Take Up Rights Corp Action 4 2002 0 0 00 elete Select Type Description Quantity Amat Method Notes C Buy AMC AMCOR Ltd Ord 1 02 1998 5 000 33 100 00 C Corp Action 12 04 2000 0 6 100 003 Reconstruction of 1 PPX for eachfevery 3 C Buy ANZ ANZ BANKING GROUP LIMITED 10 01 1999 10 000 27 400 00 F Buy CBA COMMONVVEALTH BANK OF AUSTRALIA Ord 11 10 2001 5 000 138 000 00 C Buy 28 03 2002 106 3 400 00 D ocation C Buy JET JETSET TRAVELVVORLD LTD 1M 2 2000 6 000 450 C Corp Action 15 08 2001 S00 105 00 Code Merge from JETN to JET all O iv Click and drag the blue bars Sorting Screen Information by Selected Headings Some of the column headi
13. can also be benchmarked to one of a selection of indexes lA The benchmark can be set up at service level in the Service Maintenance screen but can be overwritten at portfolio level simply by selecting an alternative index from the drop down box in the screen Net Performance 4 31 Select index from the drop PS amp P ASX 200 ACCUMULATION INDHA 21 down box Holding Performance The Holding Performance Report shows the performance of the individual holdings in the portfolio over a specified date range using asset weighted compound return methodology 15 Once an account has been activated the performance period will default to 1 year to the current date as a result of the daily roll forward function However the period can be changed by entering the required from to dates in the relevant boxes and clicking The performance is measured on both capital and income for the selected period and can be reviewed combined or independently Main Logout Back Maintenance Portfolio Details Trading Activity Print Reports _Systern Management Feedback User administrator Portfolio 4543 demo 301 Processed to 23 04 2004 Quick Help gt gt gt Holding performance For Period 24 04 2003 To 23 04 2004 Select Data amp Sort Desc Por lt lt lt Previous Next gt gt Security Total Gain Total Perf Capital Gain Capital Pert Income Income Pert ALL 51 960 151 9 50 400 147 34 1 560
14. your menu choice and you will be Trading Activity Print Reports Help Feedback ae AsAt Market Value Status Role Access Rights Owner The following table is a list of the complete menu and submenu options and provides a brief explanation for each Main Menu Logout Sub Menu Main Back Maintenance User Maintenance Change User Details Change User Preferences Change Password c30 30C Portfolio Management Portfolio Details Portfolio User Links Registered Addresses c30 30c Portfolio Broker Links Portfolio Bank Links Portfolio Tax Details Portfolio Billing Balance History Lock Tax Year Detail This will log the user out of the current session Note This only appears on the main menu This will take the user back to the main menu This will take the user back to the previous screen Menus for maintaining the portfolio s profile amp user options For user detail changes such as change of address and contact details For setting up and maintaining user preferences such as the number of lines per page Change your password here If the password has been forgotten contact the System Administrator For amending portfolio details such as the name tax amp consolidation types and active status etc Link portfolios to users and amend linked users access levels here Can be used to capture an address if required used for client billing Add amend broker details
15. Next gt gt 10 Searches Select a Range of Transactions within a Single Portfolio In the Trading Transaction screens Income and Cash Books a range of transactions can be selected within an individual portfolio This can be for a date range across all securities a date range for one security or all transactions for a security For example in the Transaction History screen click Search Export to Excel Upload Add 1 v Row s sada aah Ll only Show Unconfirmed The screen redisplays Export to Excel Cancel Search Cony Show Unconfirmed Show transactions For from Inception To Today Security All Sec Submit CO All Portfolio s To search for a date range highlight Inception and overwrite with the start date xx xx xx Highlight Today and over write with the end date xx xx xx If only one security is required highlight All Sec and overwrite with the security code Click the green button E g The screen redisplays with the results Show transactions For from 1 07 2001 To 31 03 2004 Security PRK Submit C All Portfolio s from 1 07 2001 To 31 03 2004 security PRK EN Oall Portfolio s lt lt Previous Next gt gt gt Delete Select Type Security Description Quantity Pies Brokerage GST Meth Buy PRK PATRICK CORPORATION LTD 15 11 2002 2 500 28 625 00 0 00 0 00 C Buy 1107 2003 2 500 30 375 00 0 00 0 00 Ol sell 9 10 2003 500 6 875 00
16. al Gain Loss will be the aggregate of the unrealised and realised gains and losses In our example this is a net loss of 47 307 Turnover Statistics The Trading Summary also provides details of the trading turnover statistics including the total value of both buys and sells for the trading period The takeover percentage is the total value of turnover divided by the closing market value of the trading period In our example this is 80 160 379 597 100 21 12 17 If the brokerage has been separately recorded the Trading Summary is able to provide the total cost to the portfolio for brokerage and fees paid Turnover Statistics Tot T Over Yalue of Buys Yalue of Sells Amount T Over ot Fee Brok 58 200 21 960 80 160 21 12 lt Realised Gains The Realised Gains Report displays the Capital Gains Tax gains and losses made on disposal of assets for the tax year at the date the portfolio is recalculated to It contains a summary table which shows the taxable gain or loss for that period represented by the method applied Less than 1 year other Non discounted gain indexed e Discounted gain The table below the summary shows how individual disposals have been allocated to arrive at the taxable gain loss This report calculates on a financial year period Hide CGT Summary Summary Realised Gains This is the summary and shows the Carried Forward Losses Losses Generated in Period Total
17. ated transactions corporate actions which have been created from the Recalculate To process At the top of the page under the menu bar the Processed To date is updated to show the date to which the portfolio has been recalculated If the portfolio is recalculated to Today then the current date should be displayed Income and Expenses Overview Income for all ASX listed stocks and most managed funds is updated daily All ASX listed stocks components are recorded such as franked unfranked and imputation credits For listed trusts any estimated tax free and tax deferred amounts are also accounted for To view income entries go to Trading Activity on the menu bar and click on Income Details The following screen displays Main Logout Back Maintenance Portfolio Reports Trading Activity Print Preview Help Feedback User Sam Sample Portfolio Mr John Smith Processed to 26 09 2002 Quick Help gt gt gt Cancel Search Current Selection 1 07 2002 to 1 10 2002 For Show entries from 1 07 2002 To 1 10 2002 Security All Sec Submit lt lt lt Previous Next gt Total F Total Quantity Amount Unfranked Total Franked Select Description Date Paid Onhand Received Amount Amount Confirm O ANZ ANZ BANKING GROUP LIMITED 1 07 2002 10 000 3 900 00 3 900 00 Confirm O PPX PAPERLINX Ltd Ord 19 09 2002 1 667 233 38 58 35 175 04 lt lt lt Previous
18. cesses the CGT calculations and the performance to the selected recalculate to date How to Recalculate the Portfolio Enter the date the portfolio 1s required to be recalculated to in the box to the right of the Recalculate To button then click the Recalculate To button The default is Today which is the current date though any other date can be selected xx xx xxxx To view the results of this recalculation go to Transaction History in the Trading Activity Menu All reports are amended accordingly Main Logout Back maintenance Portfolio Reports Trading Activity Print Preview Help Feedback User Sam Sample Portfolio Mir John Smith Processed to 23 09 2002 Quick Help gt gt gt Enter the date here and then click Upload Add 1 Row s 23 09 2002 the Recalculate To button lt lt lt Previous Next gt gt gt s re Total Delete Select Type Description Quantity Hran Method Notes O Buy AMC AMCOR Ltd Ord 1 02 1998 000 33 100 00 Delete Corp Action 12 04 2000 O 6 100 00 Reconstruction o ANZ BANKING GROUP LIMITED 10 01 1999 10 000 27 400 00 28 03 2002 106 3 400 00 DRP Allocation Delete m d oO COMMONWEALTH BANK OF AUSTRALIA Ord 11 10 2001 000 138 000 00 m d Corp Action PPX PAPERLINX Ltd Ord 12 04 2000 1 667 6 100 00 Reconstruction o The Transaction History screen for the portfolio now displays the buy and sell transactions together with the auto gener
19. ctussecienedsusauseseecssssessueveegsaslacecencavdedbisaiseeceibeevestixs 9 Recalculate the Portfolio to a Specific Date Recalculate TO ccccsnsnsnessnesessseeeeseecececeececeeeeeeaseeeeeeaeeneees 9 RN IU yeast n se ect setts oa aca ceete etic dice aise oes cee ea et ceases ea ota Genie eee ee se ea tio rsa seats iene ate oc cam ats saree sen eae be yeaa utencer 9 PIOW to Rocalculate the POOO ssir A hast pcasesenease esteem ce ok ceaace 9 icome and EX DCHSES sieisen aenn a EEEE ATEN DOONAN 10 Bn e o eI EEA TAE AEE ee E ENA T EE eee A AE A EA A E E E E A nce eee 10 SeArCES ssia n E E A E E E E A A E 11 Select a Range of Transactions within a Single Portfolio sssseeseseesssssssssssssssssseeeerererreeesesssssssssssseeseereeseereeererees 11 Understanding the Repor iS saasaa a aapa a 12 Pottolo Valuation DY SCCUIY norises raara a Tear a EENE ENESA ENNEA aN ai 12 Pono Assor Class SOAN 9s ace cece cette ren eiS arae A EEr O E oE S 13 The Pe OTC NN serran E EEEE EE E 14 Hooe Perrot maino aa E E A E E A 15 Tada a a E E E A E r E 17 K E a E E A T A E E tone ceaecosenseens 18 AVA AS Gans REDOT pesse E S Re 20 Reports Creatine and Printing sisitsvcssscacedecccsssccsussavsedesseanesds secsctnscscssicastecedesesssvedadscsesnesssbasessiewsvaassaveuetisesdasadesecenssi 22 A G ide 10 he MEDUS socacassscascssassdecssccesacasescscsbendacedanessasaseascssvesespabesetssscncessoeedensoacesdssesseaoonsassbeacssssandosusnasecenesevassesteses 23
20. d in Period Total Losses Available to be offset 550 Pre Offset Gain Losses Used to Offset After Offset Gain ain S a in 526 526 zi 3 842 24 3 830 Net Gain 3 830 Open Close Indexed Non CGT Indexed Discounted ity Amount Amount CGT Gain Losses Tax Date Open Date Close Date Cost GainLoss Gross Gain Other Gain Gain Gain 00 1 000 00 450 00 550 00 1 02 2002 1 02 2002 3 10 2002 1 000 00 27 12 565 80 19 965 66 3 699 93 1 02 1998 1 02 1998 15 09 2002 12 892 51 7 399 86 7 073 15 3 699 93 3 934 20 1 484 34 E 525 85 1 02 1998 1 02 1998 15 09 2002 958 49 550 14 525 85 275 07 00 9 700 00 9 400 00 11 2002 7 11 2002 300 00 300 00 00 225 00 510 00 142 50 1 12 2000 15 09 2002 225 00 285 00 142 50 In this example even though at first glance it would appear that the unted gain of 275 07 would be the best selection Praemium has changed the method to use the indexed result to take full advantage of the 550 loss 19 Indexed Discounted Gross Gain Other Gain Gain Gain r 399 86 i Utes ceo saan ns 550 14 525 85 275 07 CGT gain is 8235 4200 00 205 00 142 50 The gross CGT gain is 8235 The loss available to offset is 550 Gain for discounting at 50 7685 Taxable Gain after discounting 3842 50 By switching the method to apply the loss to the best fit indexed calculation Praemium has reduced the taxable gain to 3 830 in this instance Per Summary This report can be displayed in bo
21. ement between the difference between the capital value and capital cost in the period If this is a loss it will appear in the Less sector Net Contributions in is a balancing figure and represents net inflows into the fund If this is a net outflow it will appear in the Less sector Click the gt Reconciliation button to access a spreadsheet with back up schedules for this amount Expenses are the expenses paid for the period The Closing Balance is the result of the opening balance plus and minus the various components for the period and should agree to the total market value per the Portfolio Valuation Report for the end date of the period The Gross Gain is the movement between the opening and closing values adjusted for net contributions in out In the example a Closing Value 726 196 76 m Less Opening value 523 687 99 7 Less Net Contributions In 150 720 00 51 788 77 Tax Credit Amount is the value of tax credits received on the income received for the period The tax credits can be omitted from the screen and percentage calculation by switching off the option at service level in the Service Maintenance screen Net Performance is based on the Gross Gain plus the Tax Credit Amount if this is switched on see above divided by the Average Portfolio Value In the example Gross Gain 51 788 77 Tax Credit Amount 0 51 788 77 Divided by Average Portfolio Value 688 275 29 7 52 The performance
22. er through the upload process or manually This also allows you to view the trading activity without the auto generated transactions Short Sell open amp close transactions are entered here This also allows you to view short sell transactions independently from all other transactions Write Take and subsequent close out transactions for ETO s are entered here You can also view all ETO transactions here independently from all other transactions Enter exercise details for ETO s amp company options here 24 Take Up Rights Convert Notes Convert Preference Shares Carried Forward Losses Dividend Reinvestment Details Change Disposal Alloc Method Income amp Expenses S u b c303_ Income Details Income Declared not Paid Expense Details Print Reports System Management Feedback The system will automatically lapse rights If all or some were taken up use this screen to enter the details The system will automatically redeem notes If all or some were converted use this screen to enter the details The system will automatically redeem pref shares If all or some were converted use this screen to enter the details Enter any unused prior year capital losses here This information should be verified and is needed to offset against gains in the current financial year If the user participates in a DRP or has done so enter the company details here This will allow the system to enter aut
23. for automatic contract note upload There is also a sample letter to assist with instructing a broker to set up this process Set up bank links for the bank details upload process Not yet available Creates the billing profile and links the portfolio to a billing structure Not yet available Locks in all the transactions to a nominated year end 23 Billing Billing Schedule Fee Tables Asset Maintenance Personal Assets Service Assets Yield Overrides Asset Class Targets Data Upload Data Download Portfolio Details Portfolio Valuation by Security Portfolio Asset Class Summary Portfolio Performance Holding Performance Trading Summary Realised Detailed Gains Summary Unrealised Detailed gains Portfolio Search Portfolio Selection for Reports Download Report Pack Trading Activity Recalculate Portfolio Cash Book Transaction History Buys Sells Short Selling c33 gC Options Write Take Options Exercise Summary Set up billing schedules for portfolios Set up fee tables for portfolios Maintain assets at portfolio level Maintain Assets at service level Maintain yields for service assets Set up asset class targets for portfolio comparison Process to upload cost history and bank details from some commonly used applications For download into BGL Simple Fund Covered in a separate user manual and for certain ex Advent Users Various Screens providing portf
24. itions Where appropriate in the situation where short sell trading has been used the report shows the trading figures for the long and short portfolio separately A Main Logout Back Maintenance Portfolio Details Trading Activity Print Reports Help Feedback User Sam Sample Portfolio 303 Mr John Smith Processed to 30 06 2003 Trading Summary for 30 06 2002 to 30 06 2003 Normal Equities Portfolio Unrealised Gains 30 06 2002 30 06 2003 Cost 206 215 250 285 J Value 417 356 379 597 Gain Loss Unpaid Unrealised for Period Income Gain Loss for Period Gain Loss 211 141 129 312 81 829 6 411 75 418 Realised Gains Realised Gain Loss Cost Proceeds Income Paid for Period 14 125 21 960 20 P76 28 111 Tot Gain Loss 47 307 Unrealised Gains In the above example the Gain Loss for Period of 81 829 is the movement of the difference between the market value and cost from 30 06 2002 and 30 06 2003 The Unpaid Income represents dividends or distributions where the holder has an entitlement but the cash has not been received as at 30 06 2003 This amount will include any imputation credits due Realised Gains The realised gain loss is the difference between the proceeds and cost for the trading period plus income actually received in the period since the previous year end The income is adjusted for any accrual unpaid income at the end of the previous year end The tot
25. ngs in a grid of screen data can be clicked to sort the information If this is the case the heading appears as a button For example in the Transaction History screen the default 1s by Security If the user wishes to view the information in date order click on the column heading and the information will redisplay in date order Once for descending order click again for ascending order Rows igus Next Select Type Description Quantity Aloe Method Notes FI Aw Ahr AMCOR t Cer Tint aaa Ann 4100 0N MM plete Viewing Information for another Portfolio without Leaving the Screen The user may wish to view information for another portfolio This can be done within a screen if the id of the alternate portfolio is known Enter the id in the box entitled Portfolio Click theo the right of the box and the user is switched to that portfolio Logout Maintenance Portfolio Details Trading Activity Print Reports f Feedback User administrator Portfolio 20 eo Processed to 11 02 2004 Quick Help gt gt gt Export to Excel Upload Add J Row s Today Search Dony Show Unconfirmed Recalculating the Portfolio Recalculate the Portfolio to a Specific Date Recalculate To Overview This is Praemium s most important function Activating the Recalculate To process not only updates the trading activity with the relevant corporate actions and the income transactions it also repro
26. olio holding performance and CGT information Portfolio Summary details as at the processed to date listed by code in alpha order Toggle GICS The Portfolio by Asset Class This screen can be expanded to reveal the holdings in each class This report provides performance information for the portfolio for a selected date range A report providing details of the portfolio s performance offering various options in both content and sorting Reports on accounting gain or loss for the current year to date The realised gains as at the processed to date comprising information regarding gain type discount indexed or other and detail for each disposal The unrealised gains as at the processed to date comprising gain loss for each holding or by tax lot This also includes a What If function A facility to search for data across portfolios Select portfolios for bulk reporting Monitor progress of report file and maintain files for created report packs Menus for data entry Allows the user to recalculate the portfolio from any screen Transaction details for a cashbook that is part of the portfolio can be entered here either manually or from an upload This screen shows all the transactions including buys sells Short sells amp options which have been manually entered and auto generated transactions The auto generated transactions should be reviewed and edited here The buy and sell trades are entered here eith
27. omatically DRP transactions as appropriate Enables the user to change the disposal method across the portfolio for a chosen date range The system will automatically update income information for ASX listed securities and most managed funds However other income details must be entered manually here These reports will display information using selected criteria Expenses can also be tracked by entering transactions manually Click here to access the screen to set up printed reports They can be created reviewed amp printed be merged into Excel or Word or downloaded into other applications System Administrator Access Only described in Section 1 This screen provides a facility for the user to submit questions information comments and request help It sends the information to Praemium Service staff by email 25
28. ort Select File Format Select Format Style Select Color Mod Create Report Packs Portable Document Format vi Top Title With Image v Color Logo Report From Date To Date Report Name Holding Performance 24 Apr 2003 to 23 Apr 2004 Tax Summary F 1 Jul 2003 to 23 Apr 2004 Realised C 1 Jul 2003 23 Apr 2004 Realised Detail v Unrealised F as t 23 Apr 2004 Unrealised Detail F Income F 1 Jul 2003 23 Apr 2004 Using the tax date v Transactions oO 1 Jul 2003 23 Apr 2004 Include Corp Actions Y Asset Class Summary F as a 23 Apr 2004 Display Bar Graph vi Portfolio by Asset Class O as at 23 Apr 2004 Asset Allocation O as at 23 Apr 2004 Portfolio Valuation F as at 23 Apr 2004 Use GICS i Cash Book oO 1 Jul 2003 o 43 Apr 2004 CASH MAIN CASH ACCOUNT v Trading Summary F 1 Jul 2003 o 23 Apr 2004 Portfolio Performance O 1 Apr 2004 to 23 Apr 2004 Expenses F 1 Jul 2003 o 23 4pr 2004 Invoic O as at 23 Apr 2004 a Select the File and Style formats from the drop down boxes The usual file format is Portable Document if the us r has access have Adobe Acrobat reader or HTML viewer The other file formats are useful for merging reports into applications such ak Word or Excel or Rich Text format for downloading into other computer applications The Formats enable reports to be printed on plain paper or to be merged into other pre printed mediums Select File Format Select Format Style
29. perty Australian Fixed Interest International Fixed Interest Cash amp Equivalents Other This report can be downloaded into excel Click the Export to Excel button on the left hand side of the screen above the data grid The Portfolio Performance This measures the performance of the portfolio between two selected periods at summary level The report will display for the current quarter to date Enter the required start and end dates and then click the button The information will redisplay for the chosen date range For Period 01 07 2004 To 30 09 2004 Value at 01 07 2004 523 687 99 Plus Income 4 948 78 DRP Stock Not Delivered Realised Capital Gain 35 073 73 Unrealised Capital Gain 15 669 77 Net Capital Inflow 150 720 00 __ Reconciliation Expenses 583 50 Realised Capital Losses 3 320 01 Unrealised Capital Losses 3 Net Capital Outflow Yalue at 30 09 2004 726 196 76 Gross Gain for Period 51 788 77 Average Portfolio Value 688 275 29 Net Performance 7 52 S amp P ASX 200 INDEX 3 74 Value at opening date is the balance at the start of business on the day 1 e in this case it should agree to the total market value per the Portfolio Valuation Report for 30 06 2004 14 Income This is the income received for the period Realised Capital Gain is the movement in the gross capital gain as opposed to taxable gain in the period Unrealised Capital Gain is the mov
30. rtfolio List click on the menu bar The following are some handy hints on navigating Praemium Moving from one screen to another Using the screen bars to get from one part of the screen to another Sorting the information on the screen by selected headings Going straight to information for another portfolio Moving From One Screen Page to the Next The default number of lines of data in a screen page is 10 If there is more than one screen page of information the word next gt gt gt at both the top and the bottom of the screen will change colour Click Next gt gt gt and the screen will scroll to the next page zsa Previous NEn SS gt n see z Total Delete Select Type Description Quantity Wan Method Notes O Buy AMC AMCOR Ltd Ord 1102 1998 5 000 33 100 00 C Corp Action 12 04 2000 0 6 100 00 Reconstruction of 1 PPX for es Buy ANZ ANZ BAMKING GROUP LIMITED 10 01 1999 10 000 27 400 00 O Buy CBA COMMONWEALTH BANK OF AUSTRALIA Ord 11 10 2001 5 000 138 000 00 O Buy 29 03 2002 106 3 400 00 DRP Allocation O Buy JET JETSET TRAVELWORLD LTD 1 12 2000 6 000 450 00 C Corp Action 15 08 2001 1 500 105 00 Code Merge from JETN to JET Name change from HRK HE O A i due JET JETSET TRAVELWORLL Oo JETN JETSET TRAVELWORLD LTD NEW 1 08 2001 1 500 105 00 Take Up Rights o 15 08 2001 41 500 105 00 Code Merge from JETN to JET lt lt lt Previous Next gt gt Likewise once the bottom of the list of information is reached
31. rts divided by a vertical blue line Information to the left of the line shows 18 The security code The holding description The sale quantity The original cost The sale amount If applicable the selected optimised capital gain on the disposal or If applicable the loss on the disposal Details of how these gain or loss values were selected are shown to the right of the blue line Non CGT gain or loss This will include details for holdings for which CGT does not apply e g fixed interest short sells or for holdings that were purchased before CGT legislation applied Gross Gain This represents the gain before any discounting or indexing is applied Other Gain If a holding has been disposed of within 12 months of acquisition any gain will appear here Indexed gain shows the gain between the indexed cost and the disposal value 1f applicable Discounted Gain includes amounts that have had the discount value applied If a rule does not apply to a disposal the cell will be blank If the portfolio is for a company then the discount rate is zero There is a question mark against a line What does this mean 3O au pnu Where the system is set to the default to minimise the taxable gain Praemium will switch methods where there is a loss to offset and the optimal calculation is to offset this gain against an indexed rather than a discounted gain Summary Realised Gains sses Losses Generate
32. th detail and summary format Unrealised Gains Report The Unrealised Gains Report displays the Capital Gains Tax gains and losses that would be made on disposal of assets at the date the portfolio is recalculated to The information is in the same format as the Realised Gains Report HELP What if I wish to know the impact of a particular disposal on the portfolio s realised gain What If scenarios can be created Click the green Witi ii button on the screen The following screen redisplays now including the realised gains summary box 20 User Sam Sample Portfolio MrJohn Smith Processed to 03 10 2002 a Quick Help gt gt gt Close What if Summary Realised Gains Carried Forward Losses Losses Generated in Period Total Losses Available to be offset 550 550 Pre Offset Gain Losses Used to Offset After Offset Gain Less than 1 Year Gain J Non Discounted Gain 526 526 g Discounted Gain 3 842 24 3 830 Net Gain 3 830 lt lt lt Previous Next gt gt i Aare Market Purchase Indexed Non CGT se Sahg Quantity Cost Value CGT Gain Losses Tax Date Date Cost Gain C AMC AMCOR Ltd Ord 2 500 13 500 00 20 650 00 3 575 00 1402 1998 1 021998 13 851 00 C ANZ ANZ BANKING GROUP LIMITED 10 000 27 400 00 181 299 99 76 950 00 10 0141999 10 01 1999 27 756 20 C CBA COMMONWEALTH BANK OF AUSTRALIA Ord 000 138 000 00 152 100 00 14 100 00 11 10 2001 11 10 2001 138 000 00 106 3 400 00 3 224 52 175 48
33. the box at the left hand side of the class Summar sss TPES lea oo Asset Class Cost Value Gain Loss of Total Australian Shares 99 370 00 91 607 94 Ch 762 06 Ad 34 InteWational Shares 50 000 00 52 067 85 2 067 95 30 88 Listed Fer 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 4 fn gn nin gn nn nn Detail sas Previous Next gt gt gt Asset Class Coie cription Oty Cost Value GainLoss of Total Australian Shares 99 370 00 91 607 94 7762 06 64 34 NAB NATIONAL AUSTRALIA BANK Ltd Ord 1 000 35 000 00 30 930 00 4 070 00 18 35 PEROO12AU Perpetual s Conservative Growth Fund 46 477 04 50 000 00 48 707 94 1 292 06 28 89 TLS TELSTRA CORPORATION LIMITED Ord 3 000 14 370 00 11 970 00 2 400 00 7 10 fr The asset class is predefined for ASX listed shares and Managed Funds Managed Funds can be classified across more than one sector 13 Service and personal asset holdings must have their asset class defined when they are set up Go to Maintenance on the menu bar and select Asset Maintenance then Service Assets In the screen that displays to set up the holding details enter the asset class from the drop down box Tax Traditional Sh Cash Exempt Security Security Asmithst Smith Street Investment Property 1 01 1998 1 01 2050 O C Code Description Start Date End Date Asset Class Australian Shares International Shares Listed Propert Direct Pro
34. tion e g Amcor Ltd Ord being ordinary shares The total quantity held at that time e g 2500 The unit cost being an average of all the parcels for that holding e g 5 40 The adjusted cost adjusted for return of capital etc e g 13 500 The unit value being the Value divided by the quantity e g 8 24 The Value based on the closing price for the day The estimated annual income based on prior 12 months income for the holding The estimated yield as a percentage of the current market value Note For Managed Funds the most recent available price issued by the Fund Manager is used For service assets the last price entered by the service for that holding is used Dividends that the holder has an entitlement to 1 e gone ex but not yet paid are also reported under the code DIVSNOTPAID This report can be downloaded into excel Click the Export to Excel button on the left hand side of the screen above the data grid Portfolio Asset Class Summary The Portfolio Asset Class Summary is similar to the Portfolio Valuation but groups the holdings according to asset class There are two levels to the report e Summary This displays the total values for the class and percentage of the total current market value of the portfolio e Detail This shows the holdings that make up the class with their respective percentages of the market value of the portfolio The report is expanded to show the detail by clicking
Download Pdf Manuals
Related Search