-
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 bank account.
- Fixed the issue where the Daily Cashflow StartDate was a month at the end of the year and the Daily Cashflow periods stretched into the following year.
- On the Cashflow Report, trade debtor totals are now consolidated into a single row with the section name.
- For P&L reports, the duplicate issue in Overheads section has been resolved.
-
Actuals
- Fixed issue with wages calculations updating when in actuals.
- Enter Openings or Enter Actuals Balance Sheet screens should now correctly filter Accrual and Prepayment records under Current Assets and Liabilities.
- Closing and opening enter actuals screen should no longer trigger a system recalc.
-
System
- .NET Framework Parallel Processing has been removed from Currency-Budget loops.
- Repaired issue where stock unit and gross receipts were generating extra values in second month when extending.
- For report views, Interest and BankCreditInterest are now multiplied by -1. BudgetData for the the Loans section are also multiplied by -1.
- Added option in settings to select Move Gain/Loss to Depreciation Destination
- Department Cost Sections added to Depreciation Destination
- Formula added as Commission method.
- Fixed Dividend Accrual bug by adding Finance Interest to the NetProfitAfterTax calcs.
- Added new setting to preferences so that users can choose whether they want the receipts in the Cashflow report to be under a single Trade Debtors row or their individual cash receipts by section, folder and record.
-
Stock On Hand Component
- Resolved issue where a null reference exception that wasn’t being handled in the code and the exception wasn’t being thrown.
-
MYOB Advanced Integration
- A “branch” parameter has been added to the endpoint request. The actuals data can now be filtered based on the branch.
-
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 was causing issues. Has now been fixed.
-
Variance Report
- Tidied up balance sheet variance report.
-
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 opening balance entry.
- F5 periods are more synchronised with MYOB Advanced periods.
- Logic added to determine start month when not January.
-
Data Export
- Created a data export function for easy creation of forecasts from COA.
-
UK Version
- Updated UK and Scotland NI rates.
-
Employee Details Import
- Allowance and Employee details import has been added.
-
System
- Updated Infragistics to version 19.2
- Window now refreshes after importing a forecast
- Removed budget recalculation when in actuals issue.
- Fixed issue with other income extent not working.
- The calculations have been updated so that Wages records no longer zero out periods up to the current actuals index. The Amended Wages, Group PAYE and Gross Wages values should be as expected.
- Added two new derivations to Other Creditor/Debtor records.
- Fixed Short Term/Long Term loan split.
- Profile spread issue has been fixed.
- Fixed actual loan calculation issue.
- Added cancel button to Enter Actuals screen.
-
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 Earnings calculated fields in the Balance Sheet reports.
- The draw from stock transfer is excluded from the Profit and Loss and tax calculations.
- Fixed the cost per unit multiplier for Stock Unit components.
- Stock records are now appearing in the P&L Variance report.
- A new feature has been added to enable users to choose whether a component is calculated at the average cost per unit as at the beginning of the month or the previous month.
-
System
- Upgraded Hockey App to new app centre.
- Importing Stock On Hand values for Stock Records, Stock Made Records and Separately Invoiced Stock records into the Enter Actuals window should now be working.
- The Fixed Asset depreciation calculations have been updated.
- Repaired issue with Employee Group salary doubling when extending.
- Repaired issue with second month doubling when extending.
- Added Tag input to Forecast so that grouping in the Forecast list can be done by Tag
- The Creditors Due calculations have been updated so that the Creditors budget data are functioning as expected.
- When in actuals, the Opening Balance and Closing balance values should now be accurate.
-
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 refined for both Diminishing Value and Straight Line for forecast with actuals on or off.
-
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 should now update.
- Bank records should now be updating as expected.
- Change in System Record Recalculation DAL to improve the speed of the system record recalculation.
- Gross Profit has been added to the Enter Actuals P&L screen.
- Triggering a system record recalculation will now update the Tax provision as % of profit values.
- Repair typo of Extend and Amend screen OF should be of lower case and also the main settings screen "Number of Years".
- Stock usage is now updating for a Separately Invoiced Stock record when it is referenced in “Draw from Stock”.
- A fix has been applied that makes the Separately Invoice Stock - Draw From Stock not appear in Retained Earnings.
- GST now appears to be deducted from the bank account when creating a Sales record.
- Provisioning Records now updating correctly.
-
MYOB Advanced
- The first data date is now used for the MYOBAdvanced.
-
Hotlink
- Selecting an existing hotlink Excel file does not generate an exception.
-
Fixed Asset
- Depreciation now starts at the month of and asset purchase and not the next month.
- When in actuals, if you sell an asset for its book value there should be no gain on sale.
- The sign for the disposal of Fixed Assets and Financed Assets has been changed to negative 1.
- Straight Line Depreciation should now stop when the asset has been sold at book value.
- When actuals is on, diminishing value should change at the correct period/month.
- Diminishing Value should not continue to depreciate if the asset has been sold at book value.
-
Reports
- Fixing a stock record original budget error on Variance Report.
- Repaired GST duplicate on Balance Sheet.
- GST should now show in WhatIf Cashflow and Balance Sheet reports.
- The Balance Sheet report has been updated to use the WhatIf budget instead of the Forecast budget.
- The Funds Flow report has been updated to use the WhatIf budget instead of the Forecast budget.
- Corrected Provisional Tax values on Cashflow Report.
- Funds Flow Disposal of GainOrLoss is now being added to Fixed Asset values under Investing Activities.
-
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 Schedule now displays with no issues.
-
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".
-
PAYE and NI Values
- Updated the PAYE and NI values for UK, Scotland and NZ.
-
Fixed Asset
- Fixed Asset opening entries are now handled correctly.
-
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 the settings view.
-
Memo
- Added a memo section to the P&L report to improve the presentation of the records.
- Added 3 New Memo Derivation – Interest, Depreciation and & of Profit
- Added memo to the variance report.
-
Journal
- Created an option for banks to be treated as Journals. You will need to select for the records or transactions to that bank will to be reported in the cashflow.
- Check when deletion of record for any record being backed into account.
-
System
- Further groundwork made on integration views
- “Payment Delay (Months)” field in the Financed Asset record to allow users to enter the specific month that a bullet payment is to be added.
- Tidied up actuals P&L entry screen to.
- The Holiday period input field functions and Gross Payments are starting at the correct month for Calculated Loan Taken .
- Save What If as a new Forecast now working correctly.
- Fixed Asset and Financed Asset entry behaviour changed so that entry through actuals and opening balance screen is the same as if entering through the record.
-
Stock
- Fixed issue where As % of Cost was creating a double payment when used in stock component record
- Fixed issue where As % of Wages was creating a double payment when used in stock component record.
- Added a check for when deletion of record for any record being backed into bank account.
- Fixed Financed Assets interest only rounding error
- Funds now showing financed assets disposal correctly.
- Stock on hand transfer now reduces stock on hand to stop out of balance on Balance sheet.
-
Reports
- Department P&L calculates GP properly when frequency is annually
- Bad debts now showing accurately in the funds flow
- Loans interest accumulation are now being shown properly on Funds Flow Report.
- Profit After Tax and Dividend are now displaying properly on Funds Flow Report
- Changes to Balance sheet and Funds Flow to show Accrual of Financed Asset interest.
- Fixed Asset Schedule now showing assets additions and subtractions correctly.
- Overheads section summary view now shows net wages, instead of gross.
-
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.