|
7.30.119.241
|
- Enhancements to application performance.
- Ability to Roll Up input rows on the Cash Flow into a single role, ideal for closing stages and rolling up detail data to a summarised level.
- Using the Revenue Collection Profile feature to collect deposits for the purpose of using Insured Deposits as a source of project funding.
- Improved support for High DPI displays.
- An application setting to toggle display of Milestone popup picklist.
|
|
7.20.109.487
|
- 7 Additional Loan facilities, bringing the total number of debt or equity funding sources you can configure in your project to 12; 1 x Developer’s Equity, 10 x flexible debt/equity sources, 1 x Senior Loan.
- Microsoft SQL Server as a Sales CRM import source; an interface to allow you to import sales contract data from a Real Estate CRM system.
- A Chart of Accounts Mapping function to allow you to map 'source' Cost Codes originating from an external Accounting System, to Cost Codes defined in a 'Master' Chart of Accounts that is adopted within the CashFlow worksheet.
- Exporting of files to Excel via Command Line automation.
- Importing of actuals from supported Accounting systems via Command Line automation.
- Importing of actuals from supported Sales CRM systems via Command Line automation.
- Ability to define Project Milestone Task Durations in either Days, Weeks or Months.
- The Project Milestones form loading in a 'Maximised' state by default.
- Consolidation of all application-level settings in a new 'Settings' area in the Application Menu.
|
|
7.10.101.410
|
- Some minor bug fixes and enhancements
|
|
7.10.95.409
|
- A 'Trace Precedents' function that displays the relationships between a formula and the cells that provide data to it (i.e. its precedents). A useful tool for checking formulas for accuracy or understanding how they are calculated.
- A 'Trace Errors' function that displays the source of formula errors to assist in troubleshooting.
- A Stage Summary report, where the costs, revenues and main KPI's are report side-by-side for each Stage.
- A preference to enforce the use of valid Cost Codes as defined in the Chart Accounts, for each cost and revenue line item.
- Ability to instantly filter the Chart of Accounts pop-up picklist, making finding and selecting a Cost Code for a line item a lot easier.
- A preference to control whether or not the Chart of Accounts pop-up picklist appears every time a 'Code' or 'Description' field is selected.
- A preference to change the width of the 'Code' and 'Stage' input fields to allow longer Cost Codes and Stage names to be visible.
- Splitting of commitments into 3 separate fields; Purchase Orders, Contracts and Change Orders.
- An 'Uncommitted' column on the Cash Flow, reporting the difference between the Current Forecast/Budget and the Total Commitments.
- An option to view and print the Cash Flow on a Financial Year basis.
- An option to group the Stock Summary cash flow data (Sales and Handovers) by Land Use Category.
- A 'Comments' column added on the Summary report, allowing the user to add commentary to explain budget variations.
- A 'Cost to Date' and 'Forecast to Complete' column added on the Summary report.
- Ability to control how Budget Variances on the Summary Report, including displaying both % and amount variations at the same time.
- Increased the maximum number of Project Milestone Tasks that the user can insert from 200 to 400.
- Added the 'Predecessors' column to the Project Milestones Gantt Chart to allow more control over dependency links, including the ability to define lead and lag times.
- Support for using lags and lead times when adopting Project Milestones for cost and revenue timings.
- Ability to pause the synchronisation of Project Milestones when opening an existing file to avoid recent changes to the Milestone Profile being applied to older files.
- A 'Standby Fee' included for each Loan, to calculate a fee to pay the lender for any undrawn/unused loan amounts.
- Saved calculated results from the 1-Way and 2-Way Sensitivity Analysis during, and reinstated them during the 'File Open' process.
- Automated process of updating custom formulae (in input fields or custom worksheets) to reflect any changes to rows/columns/worksheets implemented in software upgrades.
- Displaying the user name and machine that currently has locked a file when a different user is attempting to open it.
- Ability to hide custom worksheets, and keep them hidden when the file is exported to Excel.
|
|
6.60.88.315
|
- Some minor bug fixes and enhancements
|
|
6.60.84.313
|
- Support for the legislative changes to how GST is paid at settlement for the purchase of new residential premises or potential residential land (Australia only).
- Ability to export Tables created on custom worksheets to the Enterprise Database.
|
|
6.50.76.332
|
- Some minor bug fixes and enhancements
|
|
6.50.74.329
|
- Intuit QuickBooks Online as an Accounting System import source; an interface to allow you to import actuals from the QuickBooks Online accounting system.
- A Contingency Balancing Account feature where Construction and Project Contingencies can be automatically drawn upon to fund increases in costs based on a fixed budget amount.
- Construction lien holdback functionality to hold a particular percentage of a Professional Fee or Construction Cost payment for a stipulated length of time.
- Ability to enter Cell Comments in the Code, Stage and Description fields for most cost and revenue items.
- Ability to enter Comments for each Cost Code in the Chart of Accounts list, which then appear as cell comments when applied to cost and revenue items.
- Option to tile the Project Milestone window vertically or horizontally with the EstateMaster file.
- Popup picklist to link cost and revenue inputs to Project Milestone tasks.
- Preference to toggle Sales Commissions to be calculated on sales revenue inclusive of exclusive of tax.
- Expanded the Revenue Collection Profile table to now support up to 50 instalments (now located on the new 'Profiles' tab).
- Allow the Revenue Collection Profiles to continue collecting instalments post completion/settlement.
- Quickly navigate from an output on the Summary report to its related input assumption via a single click.
- Option to populate a linked Word Document with the custom Property/Project Photo inserted on the Intro tab.
|
|
6.40.62.264
|
- Some minor bug fixes and enhancements
|
|
6.40.61.264
|
- Chart of Accounts utility to centrally manage a list of transactions accounts from a company's general ledger and assign them to project cost or revenue line items.
- Microsoft SQL Server as an Accounting System import source; an interface to allow you to import actuals from SQL-based accounting systems.
- Salesforce.com as a Sales CRM import source; an interface to allow you to import sales contract data from customised Salesforce-based CRM systems.
- Propertybase as a Sales CRM import source; an interface to allow you to import sales contract data from a Real Estate CRM system.
- Option to toggle Gridlines and Row/Column Headers on custom workheets
- Keyboard shortcuts to the File Menu options (e.g. New, Open, Save, etc)
- Ability to use Milestone inputs for Loan Commencement/Maturity periods and Application Fee payment periods.
- Ability to use Milestone inputs for Revenue Collection Profile Installment inputs (when 'Specific Periods in Cash Flow' option is selected).
- A Cost Code 'Inclusions' function for the Xero Accounting Integration that allows you to define non Expense or Revenue Cost Codes (i.e.Equity, Assets or Liabilities) that you want included in the import process.
- Support for using Array Functions on Custom worksheets.
- Support for Data Tables (for scenario analysis), including importing Excel worksheets that contain Data Tables and creating them from scratch on the custom worksheets.
- A configurable timeout setting for the Validation tool to allow longer checks for circular references.
|
|
6.30.53.172
|
- Some minor bug fixes and enhancements
|
|
6.30.51.172
|
- Duplication/Clone function for Project Milestones.
- Gantt Chart Printing option for Project Milestones.
- Data Validation tool, to check for input data integrity, such as Circular References caused by user's custom formulas.
- Added xlsm file format to the Export to Excel function.
- Preference to charge Line Fees in arrears or in advance.
- Background calculations to check for multiple IRRs or where an IRR could not be calculated using the provided guess rate.
- New Funding Charts that graphically display the levels of debt and equity in the project, changes between budgets, and a forecast of the future funding requirements.
- A 'Go To' feature to assist with navigating to specific input and reporting areas of the program via the F5 shortcut.
- Dedicated KPI dashboard with a collapsible panel and additional reporting metrics.
- Additional input validation to improve data integrity.
- Update of spreadsheet interface (Spreadsheetgear), which includes support for 51 new Excel-compatible functions, Excel 2016 compatible conditional formatting and roved the performance of a number of worksheet functions.
|
|
6.20.42.616
|
- Some minor bug fixes and enhancements
|
|
6.20.40.558
|
- Project Milestones: Control the timings of your costs and revenues across all Development (DF and DM) CashFlows in a Project using an interactive Gantt Chart.
- Added formatting functionality (bold font and coloured cells) for Code/Stage/Description input fields for each line item.
- Allow linking to an Excel File that already has a link to an DM file with the same name.
- Added the input fields on the 'Intro' sheet to the Input Cell Protection function, so the user can password protect these inputs.
- File Autosave function, allowing the user to define a time interval between automatic saving,
- Allow changing tab colours of custom worksheets.
- Allow locking of the Current Month column in the Cash Flow, in addition to the historical months.
- Added WACC to One-Way Sensitivity table.
- Locking the 'Date of First Period' input and 'Cash Flow Rest Period' preference, once the model has rolled forward past period 0.
- Advanced Word Linking, allowing the user export defined cells and charts on custom worksheets to linked Word Documents.
|
|
6.12.27.194
|
- Added Sample Files library on the Welcome screen.
|
|
6.12
|
- Added 'No of Units' column in Rental Income section to be able to enter multiple tenancies on one line.
- Added options to enter rental income on a 'per unit' basis and also on 'weekly' basis.
- Ability to enter in a Settlement date before the lease end date for Capitalised Sales.
- 6 additional customisable S-Curve Profiles.
- A Preference for determining how Global Costs are proportioned across each stage in the StageCF report.
- A Preference for determining at what point the IRR and NPV for each stage is calculated from in the StageCF report.
- New PDF functionality that doesn't depend on postscript printer drivers.
|
|
6.11
|
- Extended Cost and Revenue Escalation Tables to 20 Years.
|
|
6.10
|
- A central application 'Welcome' screen that is loaded from a single shortcut within Windows.
- A Regional Settings function to define currency and tax settings that all new Estate Master file adopt.
- A 'Recent Files' listing in the 'Welcome' screen for each Estate Master application, showing all files recently saved and opened by the user.
- New application interface, along with more modernised report styling.
- Template functionality to allow user to create application templates that contain pre-defined inputs and settings. *
- Stage Cash Flow report, allowing the user to assign individual cost and revenue line items to a specific Stage in the project, then have the Stage Cash Flow report, provide a stage-by-stage breakdown.
- Inserting a Property/Project image or photo on the Intro tab and Title page.
- Data tables to accompany the 2-Way What If Sensitivity charts.
- Remove DPI and file size limitations for inserting logos/images.
|
|
5.32.3
|
- Improvements in the 'Change Source' and 'Break Links' options in the Excel Links functions.
|
|
5.32
|
- Added Capitalised Sales as a separate item to be exported to the Enterprise Database.
- Added integration with MYOB Live.
- Additional outputs added for the Word Link feature (bookmarks for the stored Forecasts/Budgets and Cost to Date data).
- Sped up certain functions (File Open, Recall Option, Database Import, and Import from Previous).
- Ability to define a single cell on a custom worksheet to store its value in the Enterprise Database.
- Added .dotm and .dotx file format to Word Links function.
- Ability to increase Revenue Collection Profiles to 20.
- Expand the the 'Month from Construction Start Release from Escrow' Inputs to one per ‘Revenue Collection Profile’.
- Ability to increase Sales/Rental Land Use categories to 20.
- Added CSV file types to importing accounts data from External File option.
- Changed Handover Summary calculations to ignore Revenue Collection Profile instalments.
- Upgraded application to utilise the Microsoft .Net 4.0 Framework.
- Exporting to an existing Excel file by appending worksheets.
- Password protection on custom worksheets.
|
|
5.31
|
- IRR/NPV calculation based on a cash flow excluding financing and interest but including corporate tax.
- Flexibility in creating Defined Names on custom worksheets, including the ability to set a value or text as the RefersTo property, not just a cell reference.
- Increased Disclaimer character limit to 2500.
- Separate Tenants sheet option in Print Reports menu. (DF only)
- Reset function for the Preferences Password.
- Loan Type preference for Loans 1, 2, 3 and 4 to indicate whether a Loan is a 'Debt' or 'Equity' facility.
- Stipulate when to release sales revenue that is collected via the ‘Revenue Collection Profile’ instalments, based on the number of time periods after Construction Start.
- Project Budget Variance report.
- Manual Budget column on Cash Flow worksheet to manually input a budget per line items.
- Auto-Save feature after setting Budgets.
- Locking function for individual Cash Flow line items.
- Stage filter on the Cash Flow report.
- Printing Input Assumptions in Landscape mode for all paper sizes if applicable.
- Reduced time taken to Roll Forward.
|
|
5.30
|
- Increased maximum time periods to 480.
- Manual Override option for Corporate Tax liability payments so they can be adjusted on a periodic basis on the Financials sheet.
- Ability to set the payment frequency of Corporate Tax liability payments, such as monthly, quarterly, bi-annually and annually.
- Option to realise tax benefit at time of loss or roll forward loss until profit is realised.
- Revenue Accrual/Adjustment manual input line on the Revenue Recognition section of Financials worksheet.
- Asset Revaluation Adjustment manual input line on the Fixed Asset section of the Financials worksheet.
- Amortization Expense (Write-Back) manual input line on the Profit and Loss section of the Financials worksheet.
- Ability to unlock the Equity, Surplus Cash and Loan Drawdown and Repayment lines in the cash flow for manual override of the default formulae.
- Expanded the 'Cash Flow View Options' function so that more columns in the Cash Flow sheet can be hidden.
- Automatically default to the filename of the file when exporting to Excel.
- Paper Size option added to the Page Setup settings of custom worksheets
- Added the Preferences report to the main Print Report menu.
- Ability to still calculate Stamp Duty even when 'Nil Tax' is set in the Preferences.
- Ability to resize the windows when an external Excel file is opened while using the Excel Links feature.
- Allow user to select any Excel file when using 'Change Source' option in Excel Links feature.
- Multi-coloured Gantt Chart, which each cost and revenue section is represented by different coloured bars.
- Upgraded SpreadsheetGear spreadsheet interface, including support for SUMIFS, AVERAGEIFS and COUNTIFS functions.
|
|
5.21.1
|
- 'Insert Image' function on custom worksheets.
- 'Data' functionality, such as Sorting, Grouping and Auto-Filters on the custom worksheets.
- Ability to copy any of the charts (on either the standard reports or custom worksheets) to the clipboard so it can be pasted in external documents as an image.
- Listing the status of Integration Modules (whether they are enabled or disabled for the specific licence) in the About screen.
- Updated the 'Export to Excel' function so that additional components (i.e. Charts, Range Names) are exported with the file.
|
|
5.21
|
- Integration with Microsoft Word, to allow Bookmarks in a Word Document to be populated by predefined outputs.
- Integration with Microsoft Excel, to allow 2-way live linking with external Excel Workbooks.
- Allowing copying/pasting of formulas on standard worksheets.
- Ability to change the order of custom sheet tabs as they appear in the workbook.
- Relabelling Construction heading on Summary sheet to remove "(inc Contingency)" if no contingency is used in the model.
- Print custom worksheets from the main Print Menu.
- Improved logic for Sales Commission calculations so that the calculated amounts each period aligned with the Sales Revenue payments, rather than being evenly spread.
- Allowing larger cost codes to be entered and displayed in the model.
- Detailed Stock Summary, showing Quantity and Area Handed Over on a line-by-line basis
- Integration with MYOB Exo accounting system
- The option to ignore cost code warnings during the Update from Accounts process
- Updated the 'Standard Table' format for the 'Update from Accounts' procedure to allow dates to be populated by formulas.
- Updated the 'Standard Table' format for the 'Update from Accounts' procedure to exclude the header row in the selected data.
- Importing of custom worksheets from a DF file when importing a feasibility.
|
|
5.13
|
- The ability to password lock input cells for over 40 different input areas for increased data integrity.
- New Formatting menu for custom sheets, including a Format Painter.
- Increased number of instalments from 9 to 12 for the Sales Revenue Collection Profile.
- Ability to vary the corporate tax rate for each cash flow period.
- Updated MYOB integration to import 'Money Spent' and 'Money Received' transactions.
- Updated MYOB integration to allow user to select to import data on either cash or accrual basis.
- Additional Chart to display the Net Cash Flow for all budgets/forecasts.
- New data import format for the 'Update from Accounts' function.
|
|
5.12
|
- Added the Freeze Pane functionality to custom sheets.
- Increased maximum for Construction, Sales and Tenant input rows to 500
|
|
5.0
|
- Work has completed in seamlessly migrating the Estate Master DF and DM programs into a Microsoft .Net software package independent of Microsoft Excel. This resulted in the following benefits:
- Significantly smaller file sizes (measured in kilobytes rather than megabytes!)
- No dependence on Microsoft Excel required.
- Microsoft Excel compatible functions such as entering formulas in input fields, linking cells, inserting additional worksheets, etc.
- Faster opening, saving and closing of files.
- A more robust and scalable software platform, providing a better development foundation for future enhancements.
- This process has already been successful in our new Investment Appraisal (IA) program. For an example of how this new platform will look, please download and evaluate a trial of Estate Master IA.
|
|
0.0
|
- Some minor bug fixes and enhancements
|
|
0.0
|
- Some minor bug fixes and enhancements
|
|
0.0
|
- Some minor bug fixes and enhancements
|
