MYOBCommunity
Partner Zone
|
|
Partner Zone

Customise Client Accounting Reports

This thread is now closed to new comments.
Some of the links provided in this thread may no longer be available or relevant.
If you have a question please start a new post.
Nchan
2 Posts
Cover User
Nchan
Cover User

2Posts

0Kudos

0Solutions

Customise Client Accounting Reports

Hi,

 

I am using the new AE Ledger and I want to customise the reports so the Beneficiary Funds are condensed in the Balance Sheet and detailed beneficiary accounts in the notes to the financial statements. For example in the notes ideally want it to show;

 

Note 1. 

Beneficiary name 1

Opening Balance                            $XXXX

Capital Introduced                          $XXXX

Drawings                                         $XXXX

Share of profit                                 $XXXX

Total Beneficiary name 1             $XXXX

 

Beneficiary name 2

Opening Balance                            $XXXX

Capital Introduced                          $XXXX

Drawings                                         $XXXX

Share of profit                                 $XXXX

Total Beneficiary name 2             $XXXX

 

Total Beneficiary Funds               $XXXX

 

At the moment, I do not get sub totals for each beneficiary instead it only shows the grand total.

 

Can you please assist?

1 REPLY 1
MYOB Staff Post Kimberley_P
13 Posts
MYOB Staff Post
Australia
Kimberley_P
MYOB Staff Post

13Posts

6Kudos

2Solutions

Re: Customise Client Accounting Reports

Hi @Nchan,

 

Give this a try:


In the Account Groups window, expand the following folders in the Account Group Details pane (i.e. middle pane):

Balance Sheet > Assets and Liabilities > Liabilities > Current Liabilities > Unpaid Present Entitlements.

Allocate all beneficiary accounts to this Unpaid Present Entitlements (UPEs) group. Using your example, i'd allocate these accounts to the UPEs group:
- Beneficiary header account
- Opening balance
- Capital Introduced
- Drawings
- Share of Profit
 
Your account groups should look similar to the following:
(Note: I'm using an AccountRight style of chart and I've separated CR balances to appear in liabilities and DR balances to appear in assets, however this mapping shouldn't be any different if I was using a different style of chart)
AccGrp.PNG
So that your balance sheet balances, make sure you've also allocated the "Distribution to Beneficiaries" account to the Current Year Earnings group. This is my 3-7300 account in the screenshot above.

Your balance sheet should then look something like this:
AccGrp-result1.PNG

 

And your UPE's note should look similar to:
(My hypothetical clients, John and Jane started the year off with a Debit opening balance)
UPEs.PNG

Let me know how you go!

Regards,

Kim
User Assistance Writer
Practice Solutions
MYOB Australia Pty Ltd

Didn't find your answer here?
Try using advanced search to find a post more easily Advanced Search
or
Get the conversation started and make a new post Start a Post