Dynamic
CRM Solution

A reserve fund study is a report that assists condominium corporations in understanding what they own, how much money they have, the timing of potential replacements, future costs, and, ultimately, how to pay for the replacements when they are due. A reserve fund study is a financial document that is meant to act as a guide to assist with planning corporate budgets. This document takes a business approach to reserve fund management.

Existing Excel problem

In general, the reserve fund study is prepared by the engineer. Engineers will utilize a Reserve Fund Study template, frequently a complex Excel spreadsheet with many algorithms. Engineers will input data and supplement this document with a detailed narrative that analyses and reports the building’s condition.

Here comes some issues for the existing Excel solution:

  • Multiple engineers can not enter data at the same time.
  • Customers can not access the data from any device, anytime, anywhere.
  • Change the Excel template will involve in lots of update work.
  • Can not set the fine grained control for the data access.
  • Not time and cost effectively.

Reserve fund study Online Solution

CubeDrive helps the engineer move the reserve fund study from Excel to online application with ease. It allows customers easily access the data from any device, anytime, anywhere with the fine grained control. And all data can be exported as MS Excel. With CubeDrive form and flow, managing your reserve funds accurately has never been easier.

chart

Login to the CubeDrive account, and the manager can click the project icon on the sidebar to start building the reserve fund study with a drag and drop method. See the following example for details.

chart


Put all data together

Before you create the project and put all data together, you need have the related applications created. In this example, the following forms are created:

  • Condo list - A from includes all the required condominium information for Reserve Fund Study.
  • Mechanical system - List all mechanical costs for the different items.
  • Civil architectural - List all civil architectural costs for the different items.
  • Electrical system - List all electrical costs for the different items.
chart


Data mining

With all raw data input into the system by the engineers, the system will be able to generate the Reserve Fund Study result.

chart

Click the "Generate report" button, the system will extract the related information from applications and generate an online spreadsheet with customer required format for future reference. Customers may also export it as a MS Excel file.

chart

Touch

You can access all of your project information from a mobile device.

form       form       form      


Back Try CubeDrive