1 / 31

Stewardship Reports

Group Guide. Stewardship Reports. Deliverables. Client Report Title Page Summary of Assets Transactions Record Income Statement Management Report Management Report Summary Brokerage Statement. Group Guide. Group Dynamics. UISES guy downloads the statement, prepares the balance.

greta
Télécharger la présentation

Stewardship Reports

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Group Guide Stewardship Reports

  2. Deliverables • Client Report • Title Page • Summary of Assets • Transactions Record • Income Statement • Management Report • Management Report Summary • Brokerage Statement

  3. Group Guide

  4. Group Dynamics • UISES guy downloads the statement, prepares the balance. • Excel guy sets up the client report. • Audit guy audits the statement for completeness and balance. • Proofreader guy proofreads the paper copy and prints the final copy for submission.

  5. #1:UISES Guy • Download the Stewardship report template. • Download the UISES statement, formats it, and incorporates it into the Stew • Enters the balance totals into the Management Report sheet. • Sends the stew to Excel Guy

  6. Notes for UISES guy • Make sure you download the UISES statement for the correct date • The UISES Statement is a source document. Make sure you sort and calculate subtotals (formatting) but do not adjust or alter the data in any way.

  7. Notes for UISES guy • Sort positions • Alpha order by description • Sort transactions • Alpha order by description • Date order within each issue

  8. #2: Excel Guy • Enters the information into the client report • Title page (do this first) • Data sheet (do this second) • Income Statement • Transaction • Stewardship • Make sure the report balances • Sends the stew to Audit guy

  9. Notes for Excel Guy • Before you enter anything in a cell, make sure you are not overwriting a formula. • Financial Spreadsheets are color coded • Blue = input • Black = calculation • Use Copy, PasteValues from theStewardship Ribbon so that youdon't overwrite formats

  10. Notes for Excel Guy • If you need to enter rows make sure you copy the formulae properly. • In the Transactions tab the position, book value, and BVS columns have formulae that look at the previous row and the following row. Make sure you don't introduce unintended gaps. • Formulae will only work if indate order within issues

  11. Book Value Out of Balance Out of Balance • The Stewardship Report template contains balance points that raise a red flag if the balance condition is not met. Book Value Out of balance

  12. OUT OF BALANCE • An out of balance flag is a symptom of a problem – so dig out the cause of the problem, don’t just paper over the symptom

  13. Audit guy • Verifies • Title Page: • Company Name & correct date • UISES: • Subtotals have been correctly calculated from the right data • Management Report: • Balances

  14. Audit guy • Verifies: • Income Statement • Dividend data with dividend.com • Interest on cash • Transactions Statement • Properly reflected and calculated • Cash properly calculated and balanced • Stewardship Report • Properly reflected and calculated • Rate of return for each month is correctlycalculated

  15. Notes for Audit guy • Remember that the template is a tool designed to assist you, it is not a plug-and-play guarantee. It is your responsibility to ensure that your stewardship report is clean and accurate.

  16. Proofreader guy • Prepares the file to print properly • Prints the report • Makes sure the report is clean and professional.

  17. Notes for Proofreader guy • Stewardship Report Ribbon to manage • Consistent font and font size, • Footers, • Page layout.

  18. Font Size • Use a font of no less than 8 pts. PRINT AT 100% ON ALL PAGES If you print fit-to-page the font becomes microscopic and neither you, I, nor the client, can read it without using a magnifying glass. If in any doubt whatsoever stick with the Arial Narrow 10 in the template. Anything smaller will not be accepted. Print size is controlled in the [File][Page Setup] applet. • Use a font of no less than 8 pts. PRINT AT 100% ON ALL PAGES If you print fit-to-page the font becomes microscopic and neither you, I, nor the client, can read it without using a magnifying glass. If in any doubt whatsoever stick with the Arial Narrow 10 in the template. Anything smaller will not be accepted. Print size is controlled in the [File][Page Setup] applet.

  19. Do not use fit-to-page Font Size It's never a good idea to insult the intelligence of your client by giving him tiny print inside a huge white space

  20. Notes for Proofreader guy • Use [Page Setup] [Page] to set Landscape Set to 100%

  21. Notes for Proofreader guy • Use [Page Setup] [Header/Footer] to set Custom Footer Contact Information Client

  22. Notes for Proofreader guy • Use [Page Setup] [Sheet] to set Print area Repeat Headers for when you go to multiple pages

  23. Notes for Proofreader guy • Use [Hide Rows] to hide empty rows from print • Use [Unhide Rows] to open them up again • Use [Breaks] to force Excel to break pages in a logical place

  24. Notes for Proofreader guy • ALWAYS proofread the printed copy • Adjust column width to fit • NEVER break a page horizontally These book values go with what assets?????

  25. Notes for Proofreader guy • If it's not good enough to show a recruiter as an example of your work then it's not good enough.

  26. Signatures Signatures

  27. Management Report • Signatures, • not printed names, • not typewritten • All of you

  28. Signatures • If the same person prepares, audits, and proofreads you won't catch the errors and omissions.

  29. Professionalism • Having one person prepare, audit, and proof and then having different people sign as preparer, auditor, and proofreader constitutes fraud. • If we don't get you, Sarbanes Oxley will.

  30. Group Contract

  31. The End Stewardship Reports

More Related