Release Notes

Download the latest version of Forecast 5 here

  • 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.
  • 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 a P&L and Balance Sheet summary preview in Forecast Node.
  • Assumptions
    • New Record Type: To model and document the assumptions taken when creating the forecast.
    • New Section Type: Used to create and group Assumption records.
    • New Report Type: To report/document the assumptions taken when creating the forecast.
  • System
    • Importing from clipboard when multiple departments were specified now works.
    • Copy Forecast with no values did not clear the Retained Earnings or Capital Account records when copying. This is now fixed.
    • Added a link to the release notes in the “About” form. This takes the user to the website.
    • Fixed importing forecasts date issue to show the latest imported forecasts at the top.
    • We have defaulted all NEW forecasts to suppress zero rows in reports.
    • Removed calculation of system records when currencies are changed.
  • Reports
    • Updated to the latest Infragistics control set 17.1
    • Moved Power BI mapping table for P&L.
    • P&L By Department is now reporting Gross Profit correctly.
    • Repaired lost column names when exporting to clipboard.
    • Repaired printing from actuals and opening balances screen.
    • Moved the new “Assumptions Report” from the reports section to schedules.
    • P&L by Department now calculating accumulated profit correctly.
    • Variance Cash flow reports now shows negative receipts and debtors like the cashflow report.
  • Stock on Hand
    • Fixed calculation issue with number of days exceeded the number of periods left.
  • Bad Debts
    • Change to show negative receipts on cashflow
    • Change for write-off to come from bank not debtors
    • Removed GST/VAT from the calculations in bad debts provisioning.
  • Foreign Currency
    • The opening balances are now being recalculated when entering foreign currency.
  • Fixed Asset Record
    • Removed GST and VAT from the calculation of fixed assets revaluation with using transfer from capital.
  • Wages
    • Scrollbar now added to the employee group form.
    • Remove As % of wages from Add to Stock.
    • Now export wages records as gross amount instead of Net.
  • Stock
    • Stock as % of wages no longer processed through creditors.
    • Remove Transfer From P&L and Transfer from Wages for Gross Payments.
  • Consolidations
    • Fixed multi-currency consolidation bank account and exchange rate calculation.
  • Actuals
    • Added prompt to opt to keep actuals as their budget figures when resetting to no actuals.
    • Fixed issues with Rolling and Actuals not behaving as required in costs records.
    • Loan cashflow now shows when in actuals.
    • Provision records now calculate the cash flow correctly when it actuals.
  • 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 drill down to the record by double clicking.
    • Only available on P&L records.
  • Hotlinks
    • When hotlinking memo records, we have allowed for 2 decimal places.
  • Depreciation
    • Added a default depreciation section to standardise reports.
  • Settings
    • Can now edit currencies when creating a new forecast
  • Tax Provision
    • Handling of tax provision has been fixed.
  • Reports
    • Employee schedule will now print second year figures.
    • All reports now print aligned.
    • Calculation in the Cash Flow report were changed.
    • Reporting of wrong figures in reports fixed.
    • Drill down to a record from a report by double clicking.
  • License Message
    • Added message to encourage manual activation.
  • Financed Asset Record
    • Calculations now correct when selling at balloon.
    • Calculations now correct when selling at value.
  • Formulas
    • Issue with formulas sometimes crashing when an item from the tree is added has been fixed.
  • Fixed Asset Record
    • Calculations for depreciation and net asset has been fixed.
    • Fixes to Fixed Asset Record when Actuals are being entered and both Sales and Acquisition are budgeted for the same month.
  • Wages
    • Calculation of PAYE and Pension fix.
  • Bank Account
    • Entering Overdraft Interest for Actuals fixed.
    • Bank Transfers now work without needing something banked first.
  • PAYE
    • Update to UK PAYE bands.
    • Fixes to Calculation of PAYE/Pension for Employee Groups on Wages Records.
    • Fixed calculation of PAYE for wages records when adding bonuses.
    • The calculation of PAYE after commission or bonus are applied is now done by month.
  • Xero Integration
    • Allowed for Xero Integration to not import tracking codes.
  • Consolidations
    • Consolidation Schedules now work.
    • Consolidation Provisional Tax Payments are now able to be amended.
    • Consolidation Dividend Payments are now able to be amended.
  • Actuals
    • While in actuals, the net cashflow was not being calculated correctly. This has now been fixed.
  • Other Creditor/Debtor Record
    • Calculations for Other Creditor Debtor Record where changed.
  • 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 from the stock on hand.
    • Resolved method calculation issue.
  • Gross Wages
    • Allowed for the new Gross Wages Record to be selectable in Formula Memos.
    • New Wages Record to allow entry as gross wages.
  • Third Party Report Views
    • Created views to allow third party application to get report data for Power BI.
  • Importing / Exporting
    • Balance sheet importing issue where the movement of the period is imported but not the balance has been fixed.
    • Fixed issues when exporting reports when the user wanted to export Jan to Dec reports.
    • Issues with negative and positive signs of values when importing now fixed.
    • P&L balances no longer being imported to balance sheet has been fixed.
    • Data now shows straight after importation. Do not need to click on “Calculate Totals”.
    • The scroll bar now appears in the correct place when importing data. This means that the scroll button in your mouse will work now.
    • Duplicate heading row on exported reports now resolved.
    • Depreciation Records were importing twice is now fixed.
  • System
    • Initialising of bank accounts.
    • Cashflow report now allows negative receipts and payments to be shown and added up correctly.
    • Changes made to the financing record to have correct budget data used.
    • Funds Flow is now showing Tax Provisioning correctly..
    • Fixed issue when users update data in Hotlinks where records were not being recalculated.
    • Rounding figures now fixed.
    • P&L By Department report issue where no data was being reported has been fixed.
    • Extended functionality of the application to allow “Capital Payments (Receipts)” in the “Capital Reserve” records to allow hotlink to be used.
    • Added new TAB in Actuals Entry to allow for the entry of assets additions and disposals.
    • Change of fixed assets records to allow for the entry of assets added and disposed in actuals.
    • Stopped calculations of additions and disposals for assets added and disposed in actuals.
    • Created a refresh all hotlinks button to refresh and recalculate all records in all forecasts with hotlinks.
    • Opening balances and Actuals importing resolved.
    • Fixed capital record initialising incorrectly when creating a forecast.
    • Improved region selection on forecast creation.
    • Manually Entered and Days Credit available to be used as calculating tax payments.
    • Updated to latest PAYE, PAYG and NI rates. Only takes effect in a new database.
    • Hockey App integrated for better crash and bug fixing.
    • Bonus message added to settings.
    • Fixed Asset Duplication fixed.
  • 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
  • Memo Record
    • Method created to allow demand on component records in stock made to be dictated by memo record.
  • Balancing
    • Fixed out of balance issue with exchange movement.
    • Fixed out of balance issue with foreign currency bank paying out interest.
    • Fixed out of balance issue with bank paying out interest.
  • Consolidation
    • Added Consolidations into cache scheme
    • Added new Index on “Consolidation Value List” Table. This is the table that keeps the values for consolidations.
  • System
    • Update currencies button on New Forecast now works.
    • Fixed inconsistent issue where F5 would crash when System Records where being calculated.
    • Changes to a component record correctly updates in Stock On Hand Calculation and Total Component.
    • GST is now being set correctly when a new component was created.
    • Add To Stock method options on the component record are now correct when the Stock Usage method of the Stock Made Record was changed.
    • Issue with P&L Reports showing the payment of the component twice when using a To/From Record has been resolved.
  • Integration
    • Allow mapping of multiple accounts from Sage 50 to be mapped to a single forecast 5 record
    • Issue with rounding data from Sage 50 fixed.
  • 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 reports decreased to 12 to adjust column headers.
  • Fixed Asset Section
    • Able to delete section with no folders or records under it if two fixed asset records exist in forecast.
  • 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 Capital and Retained Earnings corrected.
  • Actuals Cash Flow
    • Calculated Bank Balance is only shown when viewing the rolling budget on a forecast.
    • Overdraft Interest now being handled correctly when calculating the “Calculated Bank Balance”.
    • Calculated Bank Balance is shown across all frequency combinations when viewing the report.
  • Actuals Trade Debtors/Creditors
    • Cash Flow changes are calculated more accurately when entering actuals for Debtors and Creditors Forecast Records.
    • No longer able to enter Opening Payments, Gross Cost Invoices and Gross Payments when on actuals for Trade Creditors Record.
    • No longer able to enter Opening Receipts, Gross Sales Invoices and Gross Receipts when on actuals for Trade Debtors Record
  • Variance Report
    • Exports any selected period.
    • Prints any selected period.
  • Accumulated Profit
    • P&L and P&L by department totals no longer calculated.
  • Cash Flow
    • Negative receipts and payments show on the cash flow.
  • Profit and Loss
    • Retained Earnings now showing as Profit After Tax and Dividend.
    • Added Accumulated Profit.
  • Profit and Loss By Department
    • Retained Earnings now showing as Profit After Tax and Dividend
    • Added Accumulated Profit
    • Report no longer showing as blank if income (only cost) is not in any period in the forecast
  • Consolidations
    • Bank account records in a consolidation now recalculated properly when the user changes parameters.
  • Income Tax
    • Provision for tax is now updating the retained earnings.
  • Reports
    • Font size in the reports increased.
  • Funds Flow
    • Net Profit no longer showing in "Profit and Loss" Section (Standard Forecast and Consolidation).
  • Exchange Movements
    • Now visible on Bank Account Records
    • Enterable while a forecast is on actuals
    • P&L entry includes these accounts after “Operating Profit” and before “Interest Expense”
  • Import from Clipboard
    • Error message fixed: “KeyNotFoundException: The given key was not present in the dictionary”. Caused if there were more than two departments next to each other in the import list.
  • GST Scheme
    • Calculation of GST Payments if the GST Scheme selected was Cash Payments is now fixed.
    • If GST Scheme was changed using the Combo-Box in the record, the record did not calculate. The record and the main back are now calculated when the selection is changed.
  • Integration
    • Fixed an issue with exporting settings data for Sage 50 Integration.
    • Licencing updated to allow for easier inclusion of future features.

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 can now be consolidated.
    • Handling of Capital and Retained Earnings corrected.
  • Actuals Cash Flow
    • Calculated Bank Balance is only shown when viewing the rolling budget on a forecast.
    • Overdraft Interest now being handled correctly when calculating the “Calculated Bank Balance”.
    • Calculated Bank Balance is shown across all frequency combinations when viewing the report.
  • Actuals Trade Debtors/Creditors
    • Cash Flow changes are calculated more accurately when entering actuals for Debtors and Creditors Forecast Records.
    • No longer able to enter Opening Payments, Gross Cost Invoices and Gross Payments when on actuals for Trade Creditors Record.
    • No longer able to enter Opening Receipts, Gross Sales Invoices and Gross Receipts when on actuals for Trade Debtors Record
  • Variance Report
    • Exports any selected period.
    • Prints any selected period.
  • Accumulated Profit
    • P&L and P&L by department totals no longer calculated.
  • Cash Flow
    • Negative receipts and payments show on the cash flow.
  • Profit and Loss
    • Retained Earnings now showing as Profit After Tax and Dividend.
    • Added Accumulated Profit.
  • Profit and Loss By Department
    • Retained Earnings now showing as Profit After Tax and Dividend
    • Added Accumulated Profit
  • 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.
  • 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 on actuals changed.
    • Balance sheet last month depreciation has been fixed– both Fixed assets and Financed assets.
    • Calculation of Receipts/Payments with asset addition or disposal was looked at.
  • Variance Report:
    • Fixed issue with incorrect reporting variance against Original budget.
  • Calculations:
    • Fixed error if the “Days Credit” was 0.
    • No longer calculates the periods that are actuals.
  • Budget:
    • Fixed General Provisioning and Write-Off.
    • Fixed Obsolete Stock Provisioning and Write-Off.
    • Fixed Bad Debts Provisioning and Write-Off.
  • Speed Improvements:
    • Methods for calculating "Explorer Records" have been further optimised.
    • Cache and speed changes.
  • Reporting:
    • Renaming explorer records (Tax) changes the reported name.
  • Consolidations:
    • Base forecasts with separately invoiced record foreign currency banked to a separate bank account with the same currency as the record.
    • Consolidate forecasts with different currencies.
    • Eliminations are now working.
    • Update Currencies Button no longer crashes.
    • Enabled "Details" and "Currency" settings.
    • Multi-year forecasts now create a multi-year consolidation.
    • Consolidations System Records are now calculating correctly.
    • Depreciation reporting flow through from source forecast to report in the correct section.
  • Actuals:
    • Entering of "Balance Values" now works on actuals.
    • Actuals entered in the P&L and balance sheet are now overwritten.
    • Balance Sheet shows missing records.
    • Fixed Assets Depreciation calculates correctly on the rolling forecast.
    • Days Credit Calculations for receipts working correctly.
    • Changes for Cash Flow for “Calculated Bank Balance”.
    • Bank Overdraft Interest sign fixed when entering through actuals.
    • In a wages record, Gross Wages for the record are now entered. The system now calculates Net and PAYE.
    • Actuals entry is done in the local currency. The record updates with the correct exchange rate value.
    • Accumulated Depreciation on Fixed Assets correctly reporting.
  • 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 in the Retained Earnings calculation in the balance sheet.
  • Copy No Values:
    • Removed No Values option from Save As and Copy Forecast.
    • Added Copy Forecast No Values button.
    • Cleared the hotlink values from forecast.
  • Forecast Deletion:
    • Deleting open forecasts is not allowed.
  • Initialisation of Records:
    • Sections in the Opening Balance and Enter Actuals screen are highlighted in blue.
  • Opening Balance Entry:
    • Fixed issues with records not updating.
  • P & L Actuals Entry:
    • Cost/overhead section headings for depreciation no longer appear in the Enter Actuals screen if it does not have a fixed asset assigned.
    • Section name will now appear in the depreciation heading.
  • Settings:
    • Profiles and Tax Rates are able to be updated on multi-year forecasts.
  • Speed Improvements:
    • Added Caching to the calculations of System records.
Categories: 
Difficulty Level: 
Beginner
Rating: 
0

No votes yet