Written by 9:10 pm QuickBooks, Software Tips & Advice

How Property Investors Can Manage Their Portfolio With QuickBooks

Real estate and property management are a very lucrative and capital intensive business. If run effectively, it can reward investors consistently but the reverse might be the case if cash flows are not properly tracked.

In this guide, I will be sharing useful tips on how I implemented QuickBooks for a property investment company in Nigeria and how you can deploy similar techniques in less time.

Tracking All Property Portfolio

Request For Our Accounting Software Service

For over 5 years, we have implemented QuickBooks and Sage 50 for several companies under Retail, Manufacturing, Oil & Gas, Real Estate & Construction, Travels, Hospitality,Legal, Co-operatives, NGOs, Financial & Service Sectors.
  • Mbaire Services Nigeria Ltd(Construction)
  • Chisco Transport Limited(Transport)
  • Lounge38(Hotel and Bars)
  • CTRL System Technologies Limited(Procurements)
  • Aristokrat 360 Limited(Creative & Media Agency)
  • Alpha Pharmacy (Health Care & Supermarket)
  • Ericsson Nigeria Multipurpose Co-operative Society (Co-operatives)
  • Fastanet Limited (ICT and Security)
  • Britanic Maritime (Maritime Service)
  • CEO Business Limited (Salary Advance, Credit Finance and Loan)
  • OneHealth Pharmacy (Health Care)
  • Widdi Pharmacy (Health Care)
  • Olpharm Pharmacy (Health Care & Distributor)
  • Hawkes Legal(Legal)
  • Kantessa Limited(Fashion Store)
  • OPI Nigeria International Limited (Oil & Gas Servicing)
  • Zenilum Company Limited (Oil & Gas Servicing)
  • Extol Security Services Limited (Security and Guard Services)
  • Lilygate Hotel(Hospitality)
  • Benstel Nigeria Limited(Bottle Water Production & Distribution)
  • Paraclete Nigeria Limited (Bottle Water Production & Distribution)
  • Lakia Construction Limited (Real Estate Development)
  • Josien Holdings Limited(Distribution)
  • Aisha Buhari Foundation (Futured Assured)(NGO)
  • Doheney HR Services(HR)
  • Insights Limited(Health Consultant)
  • Biddel Oil & Gas Limited (Oil & Gas)
  • System Intelligenz Limited(Contractor)
  • MagTech Information Security (IT)
  • Infusion Cakes Nigeria (Bakery)
  • SCERA Nigeria (NGO)
  • M.D School (Private School)
  • Travel Options (Travels)
  • Logos Travel Support & Solutions Ltd (Travels)
  • Melcurt Nigeria Limited (Oil and Gas Engineering and Pipeline Construction)
  • Starlight Nigeria (Retail)
  • Temple Private School (Education)
  • Value Mart Supermarket (Retail)
  • Transweb Bureau De Change (Financial Service)
  • Vektro Food Limited (Manufacturing & Retails)
  • Orient Petroleum PLC (Oil & Gas)
  • Plus More

I created all the properties owned as an investment property which is a non-current asset and enter their respective value as opening balances.

You might ask, what if the price changes, how will you enter it into the system? There is general journal feature designed to help you revalue each property and take the surplus/deficit to the retained earning.

In  a situation where you pool funds from clients and invest in property here are steps to follow:

  • Create a service item called ‘real estate investment trust service’
  • Under the income account, map it to a ‘Liability account’

When a client pays into your account, create a receipt and select the bank such payment was credited into.

Tracking Rental Income;

For income earned on each property via rent; Use journal entry to record such transaction.

  • Credit your rental income account
  • Debit the bank account the rent was paid into.

On profit distribution to property investors;

  • Credit your bank account
  • Debit retained earnings account with the actual amount paid.

Other transaction entries like expense payment, bank reconciliation et all remain the same.

For inquiries on how we can implement QuickBooks for your property investment company, send a mail to info@accountingsoftware.com.ng

(Visited 46 times, 1 visits today)
Last modified: March 24, 2021