Ensure your owner accounts are working correctly for all beneficiary, unitholder and partner reporting
One of the most challenging areas of Xero is owner reporting.
This is because accountants like to run a report which shows:
- Opening balance
- Advances
- Drawings
- Share of profit
- Closing balance
Xero DOES have this report.
Xero's reporting V Incumbent software
- Incumbent software usually rolls over at period end.
- Xero does not roll over at period end.
- The owner balances will accumulate over the life of the business.
- You will need to accept that, or, come up with further processes which add little value.
How Xero works
- Xero does NOT roll over at year end
- You can change transactions in 2005 and it will update the 2025 reports immediately
- The beneficiary / shareholder / unitholder / partner / proprietor accounts report is a MOVEMENT report
- See image below - it shows the beneficiary accounts open, activity, close
- The balance sheet hows the BALANCE of these accounts
- These balances can be different
- The beneficiary report shows opening and closing balances (black formula)
- You should NEVER have opening balance ACCOUNTS
- They are NOT needed and create headaches
- The benficiary report shows all accounts for beneficiaries (blue amounts)
- Beneficiary reporting is in LIABILITIES, NOT EQUITY
- Report codes have numbers on the end that represent the beneficiary number
- EG beneficiary 1 is LIA.NCL.ADV.1
We 100% recommend that you get used to accumulating owner accounts. Why?
- To avoid excessive processes
- When integrating with other apps, it is easier
Accumulating owner accounts may become an issue for your clients
To fix this you can:
- Build a custom balance sheet - Group owners together, give it an opening balance, Save this as the master balance sheet
- This means that if a client runs the balance sheet, they will see MOVEMENT, not balances
Example Report