Completed

Help me as I use Xero to bookkeeping complex financial investment portfolio

Job Description:

I am seeking advice as to I can use Xero to enable me to keep records of a diverse investment portfolio that I manage on behalf of myself and some partners. I am very familiar with using Xero for regular businesses and indeed I myself use it for 2 businesses.

However Xero is not really designed for the requirements of an investment portfolio but there isn't an off the shelf alternative, so I have to make Xero work for me. Problems include how to account for partner's different % ownership of individual investments (the % split's are not the same on each investment), how to revalue the portfolio to reflect changing market values (there is no easy way of changing a price versus quantity and instead I believe that I need to revalue using spreadsheets outside Xero and then to input the changes as Unrealised Gains), to report Capital Gains upon disposals, to accrue income from either interest earnt or dividends to each Partner. etc etc.

For all of these various problems I can see solutions, but I would prefer to have an expert help me set up the very best system within Xero to achieve the requirements. To be clear THERE IS NO ONGOING BOOKKEEPING WORK for you that will result from this Project as the partners will not accept a third party having access. What I need is an expert accountant who knows Xero who can give me the advice over the phone/zoom/skype etc. Whilst there isn't ongoing bookkeeping work from this Project, it is likely that I come back for more advice in the future as I am growing my activity.

Please only show interest if you are qualified accountant, as I can not afford the time to waste with someone who is going to be making it up as we go along.

When I say "adapt Xero", what I mean is to use the accounting concepts to create the right type of accounts within Xero, such as Unrealised Gain accounts, Revaluation reserves, Accrued Capital Gains Tax Liability, Owner A, B, C, Accounts. Xero can do all of this but I need some help to work out the best way

Skills: Accounting, Bookkeeping, Finance, Tax, Xero

About the Client:
( 1 review ) London, United Kingdom

Project ID: #35899760

Awarded to:

burhanhabib786

Hello, I have read and understood your project details about Xero bookkeeping. I will suggest you how to create chart of accounts for investment portfolio. Which accounts are suitable to record transactions. Feel free More

£27 GBP / hour
(70 Reviews)
6.2

14 freelancers are bidding on average £26/hour for this job

Muhammad6979

Dear sir/madam I am an experienced chartered accountant with skills in XERO QuickBooks Myob and wave. You can see my profile. Thanks and regards Muhammad Ilyas Saeed

£32 GBP / hour
(142 Reviews)
6.6
dheerajjshetty19

Hi, We went through your project description and it seems like our team is a great fit for this job. We are an expert team which have many years of experience on Accounting Please come over chat and discuss your req More

£20 GBP / hour
(53 Reviews)
5.6
RaiUzair

Hi, I have read your requirements; Please review my profile as I have relevant skills and experience required for this project Let’s discuss further to start work. And see below more about me. #Preferred Freelancer More

£18 GBP / hour
(25 Reviews)
4.9
professorxwriter

Budget is negotiable and I will provide a free sample for you before you hire me as a gesture towards my impeccable expertise and professionalism. Hi, I can do it in the next few hours by working on it right now. Messa More

£27 GBP / hour
(3 Reviews)
3.6
mohamedahmedmoha

Hi, I have gone through your project, my expertise areas are bookkeeping , business plans , payroll, excel sheets , account and financial modeling. I can create payroll, maintain bookkeeping and all accounting works ve More

£27 GBP / hour
(5 Reviews)
2.8