Recent Topics
5.30.54 - Release Notes
Import/Export Employee details import will now import into multiple forecasts and the no of employees. The multiple forecast import should have the first column name as “Forecast Name” the template looks as below. The inside forecast employee details
5.30.47 - Release Notes
System Added the asset write off method to gain or loss on sale in fixed asset. Net asset is changed to calculate even if it is in actuals. There will be a CSV created for Cost and Sales records not imported. The payroll import has been updated. Reports
5.30.43 - Release Notes
Import/Export You can now import multiple months of sales and costs. Integrations For Xero integration, the loan made and taken accounts can now be import the P&L interest. UK Specific Correcting the NI Details in Scotland Forecasts Updating the NI default
5.30.30 - Release Notes
System Added the PL Interest GL Code for all the loan records. Admin pack to enforce restricted view for the consolidation and OTR reports Integrations Fixed the Xero import where the first month was missing. Reports Added EBITDA to the Profit and loss
5.3.027 - Release Notes
System Added 2 new derivations to Memo Records, Stock Units & Stock Units purchased. Added the Accumulate values into formula to use it for incremental growth. Added the ability to rename labels, e.g. GL Code, Project Code, Ext Code and other labels,
5.3.017 - Release Notes
System Now able to enter 2 decimal places for employees in the Wages record > Employee group. For example, this allow full time equivalent, e.g. 2.5 staff Created a new factoring section for factoring records. Added button to add new factoring section
5.2.073 - Release Notes
System Manually entered loan taken record added the calculation for other debtors creditors Fixed asset: reset the trade debtors and trade creditors on actuals save and corrected the calculation of asset added and sold. Integrations Xero Integration:
5.2.070 - Release Notes
System Bad debts: Correcting the calculation of write off in actuals. Bad debts: Correcting the calculation of write off in the manually entered derivation. Fixed location of Memo records on P&L Report Fixed issue with payment profile when extending forecast
5.2.066 - Release Notes
System You can now budget full time employee equivalents, e.g. .4 of a staff. Fixed issue with tax calculation without recalculating for the previous months Activated the cancel button in the employee collections screen Added the Formula derivation to
5.2.050 - Release Notes
System Fixed issue with Fixed Asset calculation, when manually entering the Asset Added value. Fixed issue with tax calculation without recalculating for the previous months. Fixed formula issue where parentheses were not calculated correctly. NZ PAYE
5.2.027 - Release Notes
Integrations Added support for later versions of Sage 50 Accounts up to v30. Fixed bank interest and bank loan import for MYOB Account Right. Added the YTD earnings to the Retained earnings for MYOB EXO. Fixed Negative value for MYOB Exo. Changed SAP
5.2.016 - Release Notes
Integrations SAP Business One Integration with both Hana and SQL database. MYOB AccountRight integration has been fixed to get the proper data for the selected month. Repaired MYOB Exo integration actual data import for Fixed Assets. Sage50 account categorisation
5.1.016 - Release Notes
Integration Upgrade to new Xero OAuth 2.0
5.1.001 - Release Notes
Integraions Financial Integration support for Sage 50 v 27 MYOB Advanced - integration now includes segments in sub-accounts for sales, cost and overhead sections. Financial Integrations - Import GL Account mapping can be saved as an XML and reused. Import
5.0.022 - Release Notes
Daily Cashflow & Reports The Stock record has been added to the Daily Cashflow worksheet. The opening bank balance is now relative to the Daily Cashflow start date instead of the very first opening bank balance. Fixed refresh bug when selecting a different
5.0.009 - Release Notes
Daily Cashflow The daily cashflow (DCF) is a rolling day-by-day bank position projection based on your budget for 90 days. Loans Repaired bug where a holiday on a loan was putting the balance sheet our of balance. Enter Actuals Balance Sheet entry screen
4.0.063 - Release Notes
Stock On Hand Stock on hand and Cost Per Unit calculations have been updated for the two different cost timinig settings and applied to stock on hand record. Hotlink Hotlink table rows now displaying correctly. MYOB Advanced Integration Fixed issues with
4.0.029 - Release Notes
Integrations Prior years now available on periods list for Sage 2019. Negative previous year values should now be positive. Forecast 5 should now be able to connect to the Sage 50 v25 data source Stock To From Stock has been excluded from the Retained
4.0.013 - Release Notes
Actuals Fixed an issue with actuals not saving and error of IndexOutOfRangeException P&L Tracking Report Fixed an issue where if the second tracking catergory was empty, the report would pull all data through. Fixed Asset The depreciation logic has been
4.0.010 - Release Notes
System An update has been applied to allow opening balances for System Records to be saved individually. The payment profile default value for 0 days is now 100 for Receipts and Payments. When in actuals, if you enter a Trade Debtors value, the value
3.7.018 - Release Notes
Actuals Enter Actuals P&L costs and direct costs import multiplier is now correct Fixed Asset net asset calculation is now working correctly when in actuals Fixed Asset depreciation is now being displayed as expected in the Enter Actuals P&L Reports Employee
3.7.015 - Release Notes
Actuals Import from clipboard button is now re-enabled. Enter actuals screen is now the same as the record list tree. Reports Corrected Employee Schedule report when Employee Group is larger than 10. Memo Added a new derivation called "Finance Interest".
3.7.002 - Release Notes
MYOB AccountRight Integration Integration to MYOB AccountRight has been completed. Contract Retention New derivation created in Accrued/Prepaid Cost/Sales records to model construction contracts retentions. Settings are managed in a new TAB created in
3.6.025 - Release Notes
One Touch Reporting Default paper size set to A4 Fixed report headers that were incorrect. Added “All Years” option. Added a “Summary” page when “All Years” is selected. Added P&L By Department (Budget and Variance) Added Schedules Tab with Employee,
3.6.010 - Release Notes
Loan Records Fixed the handling of the accrual interest when calculating payments other than monthly. Holiday and Bullet options in a calculated loan record are now mutually exclusive. Fixed calculation of interest when in actuals of Manually Entered
3.6.003 - Release Notes
Stock On Hand Stock on hand no longer reports twice and unit price calculation is correct. Draw from stock now works properly, does not cause balance sheet issue or cause crashes. Reports Second year of the Fixed Asset Schedule is now working Reporting
3.5.012 - Release Notes
Reporting Views Added the three fields of GL Code, Project Code and External Code to the P&L Integration view. Reporting views were now being created instantly when a new DB is created. One Touch Reporting Error message changed to advise user if invalid
3.5.001 - Release Notes
One Touch Reporting New Feature - Designed to export reports to a pre-defined template in Excel with the click of a button. Reports Loan Received Schedule reports the loan balance correctly. Headings now correct when viewing reports in quarterly frequency.
3.4.009 - Release Notes
Reports Receipts and payments from Capital Reserve records will now show in Funds Flow Report. Interest is now being handled properly in the Variance P&L Reports. Visuals Corrected EBITDA visual.
3.4.008 - Release Notes
Preferences Courtesy message now works. Show date now works. Scoll Bars Users below minimum specs are now able to scroll. Sample Data We have added a sample forecast called Sales Demo under C:\Program Files\Forecast 5 Ltd\Forecast5 3.0.
3.4.007 - Release Notes
Visuals Added visual reports. These can be printed and can also slice by Month, Quarter or Year. P&L: Sales graphs and EBITDA Cash Flow: Bank Balance and Movement Balance Sheet: Working Capital Days, Debtor Days and Net bank. Report Summary Preview Added
3.3.012 - Release Notes
Xero Integration Code Complete. Sage 50 Integration Code Complete. Sage 300 Integration Code Complete. MYOB EXO Integration Code Complete. Stock On Hand Create a new record to model the manufacturing of stock (units based) and selling at a later date
3.1.041 - Release Notes
Speed Increases Opening a forecast. Opening the "Balance Sheet Opening" Form. Opening the “Enter Actuals” Form. Calculating System Records. Making changes to To/From Record while it was being referenced in a Stock Made record took a long time to calculate
3.3.022 - Release Notes
Section Summary Section summary view when clicking on a section node has been added. Can drill down to the record by double clicking. Only available on P&L records. Stock On Hand Section summary view when clicking on a section node has been added. Can
3.1.034 - Release Notes
Extent and Amend Forecast Cycle Totals when using profile fixed. Extending Employee cycle totals when using employee records as method for wages is fixed. Variance Report Now shows records that have been added after start of Actuals. Font size on variance
3.1.032 - Release Notes
Consolidation Capital Record Opening Balance is being taken into consideration when consolidations are created. The Capital balance line is now appearing when viewing the balance sheet for a consolidation. Actuals can now be consolidated. Handling of
3.1.025 - Release Notes
New Zealand & Australia Release Only Consolidation Capital Record Opening Balance is being taken into consideration when consolidations are created. The Capital balance line is now appearing when viewing the balance sheet for a consolidation. Actuals
3.1.021 - Release Notes
Wages: NET Wages and PAYE in Actuals will now be calculated if a budget has not been entered. Consolidation: Fixed the reporting of the depreciation of a fixed asset when a record did not exist in a base forecast.
3.1.020 - Release Notes
Fixed Asset: Fixed issue around updating balances with actuals. Fixed calculations around accumulated depreciation. Removed opening balances for Debtors and Creditors. Removed Debtors and Creditors from Balance Sheet Opening Entry. Calculations while
3.1.007 - Release Notes
Actuals Entry: Fixed issues with records not updating. Foreign Bank Account: Fixed issues with the calculation of foreign bank account not showing the balance. Added - a new Currency Movement account which appears in the P&L and is taken into account