Enhancements - Management Accounts Professional with Budgeting & Forecasting
This release introduces support for adjusting journals to improve the accuracy of financial reporting.
Within ProudNumbers, adjusting journals can now be created and managed directly in the reporting environment. Journals can be saved as posted or unposted depending on workflow requirements, and can be easily reversed or copied to support corrections and recurring entries. All created journals can be monitored through the Adjusting Trial Balance function.
CSV
CSV import feature has been introduced, allowing users to import financial data from other accounting systems in addition to Sage 50 into ProudNumbers. Using an import wizard, users can upload three CSV files: a chart of accounts, a nominal ledger file and transaction files containing detailed financial data. Users will benefit from the same functionality available for Sage 50 data.
Enhancements - Management Accounts Professional with Budgeting&Forecasting
Enhancements - Management Accounts Professional
Bug fixes - Management Accounts Professional
Management Accounts Professional
Profit and Loss (Actual vs. Prior Year) Enhancements
Debtor & Creditor Payment Cut-off
Invoice payments are now included up to the 'Date To' reporting date (historical), instead of payments up to the current date.
Amendments to KPI Calculations
The system now calculates debtor and creditor days using a 12-month period and applies the following formula:
(Invoices minus Payments 12months ago) + (Invoices minus Payments Current)/2
Divided by: Total Sales
Multiplied by: 365
Stock Days
The system now applies the following formula:
(Stock at the end of the previous period) + (Stock at the end of the current period )/2
Divided by: Total Purchases for the period
Consolidation Module
Simplified Exchange Rate Handling
General Enhancements
Report Settings
Management Accounts Professional
Budgeting & Forecasting
Consolidated Accounts with FX Option
Cashflow report support Indirect and direct method according to FRS102.
The Budgeting & Forecasting module now supports Company/Department/Division setup. The budget is set up using a Reporting Chart accounts, which can be edited according to the user's needs. The budgeting method chosen is bottom up budgeting.
The focus on budgeting through categories helps to minimize manual data entry, while keeping a granular budget view. Special wizard allows to prepopulate budget from actuals while allowing increase/decrease in summary values according to user.
Contact the office to obtain an evaluation licence for Budgeting & Forecasting
The default filter allows to eliminate debtors/creditors with zero balances from the report. The filter can be adjusted as required.
Group Consolidation Module for Companies. Supports Transaction Elimination with Adjustment Journals. Allows for handing currency exchange for Balance Sheet and P∧L separately. Produces Management Accounts Pack in a usual format in chosen currency of the Group Consolidation.
Contact the office to obtain an evaluation licence.
Newly updated Transaction Inspector, making inspecting of underlying transactions easier and faster. Supports foreign currencies exchange rates.
Transaction Inspector correctly synchronizes invoice detail data with balance for a particular client.
Multi-Client Import is designed for ProudNumbers customers with multiple clients. This feature is designed to simplify and streamline data import process. Customers must have previously set up clients using the Import Data Wizard to use Multi-Client Import Wizard. All data path corrections to Sage must be made using the Import Wizard.
KPI report now supports more than 60 columns.
Following KPIs are computed and charted:
Similar to Debtor's report, accounts for suppliers and also calculates top 10 creditors.
A check has been implemented, disallowing nominal codes appearing twice in "partial" chart to generate Management Accounts
The application has been extensively reworked for a new look & feel and improving comprehension of the figures using new font types.
Data loading routines allow better utilization of memory and allow for taking advantages using SSD drives.
Many small usability improvements.
This new feature allows the user to populate Budget with amounts calculated from a previous financial year calculated P&L. This function is available via new icon [Fill budget from previous year P&L] that was added to the Budgeting Setup screen.
The user can select the Main Category to be automatically populated by calculated figures and what
percentage should be applied on these Main Category calculations. The same percentage is further applied on amounts
within the Category.
Any of the previous financial years can be chosen for Budget population.
The same percentage setting can be applied to one department or all. All Budget figures can be subsequently manually amended.
This new feature allows the user to export Data Drill screen content from the Profit and Loss report into Excel. This is enabled via new [Save As] icon that was added to the Data Drill screen.
The "Data Drill" screen can be exported as is or additional change can be made prior the export. For instance, in order to export data by date, user can drag "Date" column to the upper area of the screen with the text "Drag a column here to group by this column".
This report allows the user to revise budget forecast based on the actual data for the months closed to date and budgeted data for the months remaining
Function available via new options on ‘Save to Excel’ button


Department id does not get updated on import - fixed