Practitioner Edition

11.3.1 Year End Processing: Distribute Tax and Profit – MWA Report

To enable you to correctly calculate tax liabilities for various members and correct profit distribution among members, Mclowd will calculate Member Weighted Averages and compose a Member Weighted Average (MWA) Report.

Your MWA report will list (and factor into the calculation) all segregated transactions, including member contributions, roll-ins, segregated income, and segregated expenses (e.g. insurance).

NOTE: You can manually override the % allocations calculated by Mclowd, if necessary, in both the  Net Profit and Loss Allocation to Member Accounts and the Allocate Income Tax screens. Simply type your values in the Override field before pressing the ALLOCATE button.

The MWA report is available for viewing by clicking the MWA Report button on the Net Profit and Loss Allocation to Member Accounts screen.

Accessing the MWA report


and also from the Allocate Tax screen screen.

Tax allocation MWA button

When you click MWA REPORT. Mclowd displays:

The MWA report

By considering segregated transactions, and the number of days in the financial year for which the respective income or expense increased or reduced the Fund’s asset balance, Mclowd calculates the percentage of the Fund that rightly attributes to each member. This calculation is useful for assessing tax obligations where some members are in Pension phase (and their income is tax exempt) and some members are in Accumulation phase (and income in taxed). These percentages are also used to calculate the percentage of annual profit/loss to attribute to each respective member.

The information in the MWA Report will assist an actuary to provide the Actuarial Report needed to claim income tax exemption for members in Pension Phase. If your Actuary makes adjustments to the percentages calculated by Mclowd, you can manually override the percentages shown when Mclowd allocates Tax and Profit, by typing new values into the Override fields.

Return to the Net Profit and Loss Allocation screen after checking the MWA report and accept or override the percentage values shown for each member account.


about the author:

Lorraine Cobcroft

With a background in accounting and financial management, followed by two decades writing software documentation, Lorraine joined the Mclowd team in mid-2016 and is enjoying working with a dynamic team to enhance an innovative product that has the potential to revolutionize the way Australians manage their retirement funding. Lorraine is also an accomplished business writer, ghost-writer, novelist and short-story writer and poet.

Leave a Reply