PIE Attribution Report

PIE Attribution Report

Purpose

To show by client, their unit balance, Holding %, PIR and net income received for a reporting period.  It will also detail the income attributed to each PIR.

Timing

The report will be run monthly for each month during an attribution period and then quarterly at the end of the attribution period for the previous 3 months.

Access

  1. Unit Fund | Print PIE Attribution Report

Report


Report Specific Parameters

Field
Explanation
Start DateStart date for the reporting period when running monthly

Start date of the attribution period when running quarterly to support the IR852
End Date 
May be up to 3 months after the Start date, but no longer, so it coincides with the attribution period
Distribution Income Transaction Type
Transaction type specified on the Unit Fund Distribution Setup tab used to post gross distribution income to each unit fund account
Withholding Tax Transaction Type
Transaction type specified on the Unit Fund Account Type for the posting of withholding Tax

Clicking this button allows for the export of the IR852 csv file which may be uploaded to the IRD web site

Export Specific Parameters



FieldExplanation
Start DateDefaults to the Start Date enter at the PIE Attribution Report dialog
End Date 
Defaults to the End Date enter at the PIE Attribution Report dialog
Gross Income

Enter the Gross Income for the Attribution period. 

This will be the total of gross income for each distribution period within the attribution period as entered to the Unit Fund Distribution tab.
Deductible Expenses

Enter the Deductible Expenses for the Attribution period. 

This will be the total of deductible expenses for each distribution period within the attribution period as entered to or calculated by the Unit Fund Distribution tab.
IRD NumberPresetable.  IRD of the returning organisation
Company
Presetable.  Lookup to the Company the IR852 is to be filed for.
Export File Path
Lookup or enter the file path and name for the export file.  Export file extension must be .csv


    • Related Articles

    • Unit Fund Brokerage Report

      Purpose To allow the reporting of brokerage amounts to be paid to brokers calculated between user defined date ranges Timing This report may be run at any time, but is usually run at a month or quarter end. As the report is date range dependant, it ...
    • Unit Fund Account Summary Report

      Purpose To provide the client with a Transactional History and Balance of a Unit Fund Account Rules for selection of transactions to appear on summaries The transaction is not grouped Transaction value date is within the Transaction Date Range ...
    • Unit Fund Account Status Report

      Purpose Provides details of the Unit Fund account current and future ledger balances in dollar and unit amounts. Accrued Interest may also be reported. Timing The report may be run at any time Access Unit Fund | Print Variable Loan Account Status ...
    • Closing Unit Fund Accounts

      Purpose To allow the closure of Unit Fund accounts when funds are completely withdrawn Timing There are two parts to this process: Paying out Unit Fund accounts during the distribution period and writing off the future balance Closing the Unit Fund ...
    • Unit Fund Account Type Setup

      Purpose To allow for different types of Unit Fund Accounts to be created, such as Unit Fund and Loan Repayments Each Account Type can be assigned a different Unit Value if required Access Accounts | Edit/View Account Types | | Unit Fund Account Type ...