Stewardship Reports Group Guide Deliverables  Client Report     Title Page Summary of Assets Transactions Record Income Statement  Management Report  Management Report Summary  Brokerage Statement.

Download Report

Transcript Stewardship Reports Group Guide Deliverables  Client Report     Title Page Summary of Assets Transactions Record Income Statement  Management Report  Management Report Summary  Brokerage Statement.

Stewardship Reports

Group Guide

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.

 

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.

#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

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.

Notes for UISES guy



Sort positions



Alpha order by description



Sort transactions

 

Alpha order by description Date order within each issue

#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

Notes for Excel Guy

 

Financial Spreadsheets are color coded

 

Blue = input Black = calculation



Before you enter anything in a cell, make sure you are not overwriting a formula.

Use Copy, PasteValues from the Stewardship Ribbon so that you don't overwrite formats

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 in date order within issues

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 Book Value Out of balance

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

Audit guy



Verifies



Title Page:



Company Name & correct date



UISES:



Subtotals have been correctly calculated from the right data



Management Report:



Balances

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 correctly calculated

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.

Proofreader guy

  

Prepares the file to print properly Prints the report Makes sure the report is clean and professional.

Notes for Proofreader guy



Stewardship Report Ribbon to manage

  

Consistent font and font size, Footers, Page layout.

F

o n t S i z e

 

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

Notes for Proofreader guy



Use [Page Setup] [Page] to set Set to 100% Landscape

Notes for Proofreader guy



Use [Page Setup] [Header/Footer] to set Contact Information Custom Footer Client

Notes for Proofreader guy



Use [Page Setup] [Sheet] to set Repeat Headers for when you go to multiple pages Print area

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

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?????

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.

Signatures

Signatures

Management Report



Signatures,

  

not printed names, not typewritten All of you

Signatures



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

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.

Group Contract

Stewardship Reports

The End

Stewardship Reports Group Guide Deliverables  Client Report     Title Page Summary of Assets Transactions Record Income Statement  Management Report  Management Report Summary  Brokerage Statement.

Transcript Stewardship Reports Group Guide Deliverables  Client Report     Title Page Summary of Assets Transactions Record Income Statement  Management Report  Management Report Summary  Brokerage Statement.