• 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, Loans Received, Loans Made and Sales Tax Schedule, and Stats and Ratios report.
  • Memo records have a general format, not currency.
• Xero Integration
  • New setting available to include or exclude archived accounts.
  • Fixed issues with tracking code names.
  • Added a connection status and company name to title bar.
  • Pin screen is now moveable.
  • When Importing, we now use the existing sections of Forecast 5.
• System
  • Added "Months in Arrears” to GST/VAT settings.
  • Added Stock Units on Hand opening balance to Stock on Hand record.
  • Repaired issues with Import from Clipboard not creating folder structure properly.
  • Improved error handling to allow for error to be displayed to user.
  • Added option to Preferences to allow for description to be exported to clipboard on the P&L report.
  • Users can now copy and paste values between F5 and excel in the Set All box.
  • Formula values now allow for 2 decimals and 12 significant figures in total.
  • Remove issue with formula when "(" is first character.
  • Negative balances are now able to be entered in Actuals and Opening Balance screen.
  • All integrations and add-ons are available in the trial.
  • Actual Fixed Assets entry is now linked between Balance Sheet and Other.
  • P&L By Department Report now includes currency movements.
  • Fixed Asset Schedule is now reporting acquisitions and disposals correctly.
  • A new forecast can be created when in a forecast.
  • Integration to MYOB Account right has been added.
  • Show in Section options for Bad Debts has been cleaned up.
• Loans
  • Calculated and Manual Loan Made now calculating capital paid and received correctly.
  • Calculated and Manual Loan Taken now calculating capital paid, flow and received correctly.
  • Corrections made to the Financing Record calculations when in Actuals.
• Consolidations
  • Fixed error caused by record with numeric at the end, e.g. Cost and Cost 2.
  • Fixed issue with records with same name but different record types. The records will be numbered in consolidations.
  • Increase of consolidation calculation speeds, unless currency conversion is required.
  • Improved error handling for creation errors.

• 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 Loan Taken/Made.
• Xero Integration
  • Fixed the dbo access/windows authentication error when using Xero integration.
• MYOB Exo Integration
  • Allowed the importation of all branches into a single forecast.
• Sage 50 Integration
  • Added support for Sage 50 v24.
• One Touch Reporting
  • Added Variance Reports to One Touch Reporting.
• System
  • Updated the URL for downloads.
  • Allowed the licence form to work for 768 screens.
  • Fixed a divide by zero error when “Calculate Write Off Percent Of Opening” calculation was occurring.

• 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 of stock components on Funds Flow is working correctly.
• UK Specific Changes
  • Personal Allowance calculation changes.
  • Scotland region is now available. New database required.
  • Repair of database issues with PAYE/NI changes in older databases.
• Memo Records
  • Memo calculation crash has been fixed.
• Financing Record
  • Repair of opening balance entry and interest calculation.
  • Repair of reporting in funds flow.
• Xero Integration
  • Simplified the connection to Xero. Connection lasts for 30 minutes.
• System
  • Removal of forecast password protection.
  • Compare version crashes present error message.
  • Check license crashes present error message.
  • SQL Invalid Authorization Specification now prevented.
  • Upgraded to the latest Infragistics tool set.
  • Department name and percentage setting now able be changed.
  • Additional users will automatically be created in the database.
  • .NET Framework has been updated.
  • Retained earnings calculation changed to consider To/From records.
  • Allow for negative balances to be reported when using calculated loan made or take.
  • EULA has been updated to explain support inclusions.

• 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 excel file or template is open.
• UK - PAYE NI Rates
  • PAYE and NI default setting rates will be updated to the new rates. The will NOT affect existing forecasts. Only newly created.
• Reports
  • Fixed issue with Cashflow report where it did not balance correctly when an asset was purchased in the last period of the year.
  • Fixed issue with "suppress zero" where it removes row when it does not need to in the Year frequency of report.
• Admin Pack
  • Introduction of the Forecast Status Field for Admin Pack
  • A forecast can be in three difference status: Editable = Anything can be changed in the forecast. Budget Entry = Only numbers can be entered (settings and nodes cannot be added). Closed = Nothing is editable. Only available to Admin group users.
• Stock on Hand
  • Stock On Hand records can now be sold from multiple sales records
• Depreciation
  • Added option to add depreciation section into older forecasts.
• System
  • Updated some hotlink and consolidation errors to be more informative.
  • Updated clause 4 & 5 of the EULA.
  • In Manually Entered Loan Made record, As % of Memo has been added as options for Capital Paid and Capital Received.
  • New derivation added to Memo record called As % of Loan Balance. Can only be used with Manually Entered Loan Made record under Fixed Assets.
  • Transfer from P&L and Payment Profile now calculating the cashflow correctly.
• Actuals
  • Investment income record now calculates correctly.
  • Tax provision now calculates

• 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.
  • Accumulated profit in P&L reports correctly calculates for quarterly and yearly view.
• Integration
  • Fixed Xero integration to bring actuals in correctly.
  • Fixed issue with duplicated "Other Income" and "Gain (Loss) On Sale" records.
  • Rounding of negative numbers when importing has been fixed.
• System
  • HockeyApp now correctly reporting crashes again.
  • Updated EULA to include clause about the app “phoning home”.
• Calculations
  • Further improvement on handling Days On Hand calculation.
• Consolidations
  • Consolidation recalculation is forced after changes to the currency collection.

• 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.

• 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.