Multi-currency and locales
-
Foreign currency bank accounts
-
Foreign currency debtors
-
Foreign currency creditors
-
Per-transaction exchange rates
-
Accounting for unrealised and realised foreign exchange gains/losses
-
per-document localisation
Doing accounts in New Zealand for an Australian company? No problem: MoneyWorks 5 can apply localisation for each document you work with.
-
Custom base currency symbol
Your computers localisation is set to British, but your company's accounts are in Euros? You can set the base currency and symbol for each document separately.
User-defined named filters on all main lists
-
New Filter popup replaces the Display popup in transaction view by type, and is also available in all tab views, all other main lists and in Choices popup lists.
Effectively a stored Advanced Find that is applied automatically when you switch back to a tab
You can now define your own views, such as "Bank account X"
Multi-user and Network sharing improvements
-
Faster networking (up to 5x faster over high latency connection)
Networking access for remote clients over the Internet is now up to 5 times faster. There are significant improvements for LAN connections as well.
-
Datacentre clone document facility
New documents can be created on the server by clients (by cloning from a template) without having filesystem access to the server
-
Datacentre partitioning
For ASPs, a Datacentre server may now be partitioned so that users have secure access to only their own documents.
-
Broadcast message to other users
An administrator can broadcast a message to all users logged in to a document
-
Recurring transactions on period open
Better recurring transaction behaviour on Datacentre.
-
Report signing: single file upload to Datacentre option
If you have changed a single report or form, you can select it in the Upload tab of the signing dialog and upload it to the server. Each client will get the modified file the next time they log in.
-
Log entries now record initials of user (if "Password protect" is on)
-
New privileges:
Separate View/Modify/Create/Delete for GL/Names/Products/Jobs
Show Balances in Bank popups
Elective Posting
"Replace" privilege
See all Job sheet entries—Denying this privilege allows data entry operators to be restricted to viewing only job data that they have entered themselves.
Select Filters—This privilege allows a considerable degree of data access control, since an individual user can now be locked into a filter for a particular list view, allowing them to be restricted to viewing a subset of data.
-
Fewer operations require single-user access to the database
For example, more kinds of reporting can include unposted transactions while other users are logged in; You can now change a debtor to also be a creditor (and vice versa) while other users are logged in; changes to reference number sequences can now be done without single0user access.
-
Server now shares on all available network links
The MoneyWorks/Datacentre network service should now be accessible on all network interfaces on the server. Useful for multi-link multi-homed servers.
-
Datacentre status page has hyperlinks to connect to documents
New Bank Reconciliation
-
New 2-pane layout

-
top pane shows reconciled transactions in statement order
-
running balances
-
drag statement items to reorder
-
Start Over option
-
Displays bank account number
-
Mouseless-reconciliation using up/down/space
-
Clearer warnings when reconciliation does not balance
-
Privilege control for changing statement opening balance
-
Printed summary shows account name
-
Summary shows unpresented, unposted items
-
Privilege control for accepting non-balancing reconciliations
Reports and Printing
-
Global subsummaries
most reports can now be automatically summarised with subtotals by category, header accounts, departments etc

26 predefined summary and subtotal breakdown options, plus virtually unlimited user-defined summaries and subtotals in up to 5 dimensions to any number of code digits (Gold)

-
Drill-down in report previews
Click to drill down to source data for a report
-
Pyjama stripes printing option
-
Lists print in colour
-
Automatic "Best Fit" for reports
-
New report output options: Send reports directly to Excel, Word or Clipboard
New Standard Reports
Committed Stock
Exchange Rates
Unrealised Gain and Loss on currency
Retrospective Aged Debtors/Aged Creditors
Commission Report
New P&L month-month and year-year comparison
Top N customers, products or salespeople, graphed for period range—customisable
Backorder summary by product
Backorder summary by customer
Expanded Report Writer
-
Ledger ranges—finer control of reporting of departmentalised accounts
-
Subsummaries can be applied to individual account/ledger ranges
-
Report on data from any file in the database—not just accounts
New For Loop construct to loop through any selection of records
Also loop through numeric ranges and arbitrary lists and tables
-
Calculated headings can have embedded tabs to format heading into columns
-
Improved debugging
When testing, report editor now highlights the part where an error occurred
Trace mode, reports cell values and control variables as the report is generated
-
Resizable cells—cells can extend into other columns
-
Per cell adornments
overscores, underscores, shading, boxes, colour
Cell text and background colour can be calculated
-
Word-wrapped cells—text in a cell can be wrapped over multiple lines
-
User-defined drill down
Specify what data clicking in a cell on previewd report will drill down to
-
B budget option for future period reporting
-
Customisable settings
Add custom Checkbox, number, text, popup to the settings dialog box and use the values in the report.
Optionally remove standard settings and periods from report settings dialog
-
Customisable "show transactions" format (per report)
-
Graphs
Include column, stacked column, line, pie charts in reports
Mix curve types on the same graph
Moving averages
-
Remarks—document your reports
-
Improved Running headers—Two levels of running headers, which may be redefined within the report
-
Running footers
-
Open report editor from the Reports menu (hold shoft key)
Improved Analysis reporting
-
Speed improvements for many common analysis types
-
Show full names now shows code and name in separate columns
-
Calculated breakdown values
-
Graphical Analysis results
Line, column, stacked column, pie formats
-
Option to filter the basis file (e.g. to exclude detail lines you dont want to analyse)
-
Auto formatting (centred and scaled)
-
Customisable Show Transactions format
Enhanced expression evaluation (for reports, analysis, advanced find etc)
-
Optimised advanced Find (converts expression to indexed search(es) where possible)
-
New Intrinsic Functions for tabular data manipulation
-
Analyse() — perform sales/purchase analysis, yielding a table
-
DayOfWeek() — Monday = 1...Sunday = 7
-
Quarter() — convert a period or date into an alternative division of a finanacial year (e.g. "Q1"-"Q4", "H1"-"H2")
-
WeekOfYear() — ISO 8601:1988 week number for a date
-
CurrencyConvert(amount, fromISOCode, toISOCode [, periodOrDate = current]) — convert currency amount
-
CurrencyFormat(amt, currency) — format a currency value
-
GetOffBalance(searchFunction, dateOrPeriod [, doBudget]) — extract actual or budget value from off-ledger file
-
Lookup() function may now be used with the Offledger. Use KIND/NAME for key e.g. Lookup("CUR/USD", "Offledger.Description")
-
DollarsToEnglish() respects the base currency and takes an optional foreign currency parameter. Supported currencies are dollars, EUR, GBP, NPR.
-
GetUIField(windowID, fieldID) — Get text out of a field in a dialog box
-
Field name lists and popups are now alphabetical
-
Powerful relational searching scheme
Custom Forms
-
free-form lists (records from any file) with optional relational searching (which makes, e.g. statement-invoices possible)
-
2-level sorts
-
drag-import common bitmap formats (JPG, PNG, BMP, TIFF, etc). These formats are cross-platform.
-
Fit Form to Page option (in Layout). Use this to make an A4 form fit on US Letter and vice versa.
Importing
-
Optionally "Use Value" when updating existing records
-
Calculate values to import based on other data in the import file
-
field numbers displayed in import map
-
Single-pass import option: skips bad records and dumps them to a Rejects file. This makes iterative error correction much easier when you have cruddy source data to import.
Improved Account Enquiry

-
By account, selection, range, Simple Find, Advanced Find, saved find (filter)
-
Improved graphing (stacked column option: breakdown by categories, department, group, account)
-
9-month moving average
-
Customer and Product sales enquiries feature the same improvements
Transaction entry
-
Change transaction type while entering new transaction
-
Colour-coded transaction entry—each type has a different colour on the entry screen
-
end-of-period date displayed in period popup
-
bank balances displayed in bank popup (with privilege control)
-
Drop Shipping
-
Pin control to explicitly set favourite bank
-
Per-receipt bank/branch/account for deposits
-
Enter products by barcode
-
per-line-item margin display
Improved Bank Statement (QIF) importing and coding

-
parsing of Code=, Ref=, Part=
-
define new rules
-
manual coding
-
exclude unwanted transactions
-
assign receipts to invoices
Names
-
Name User fields x 4
-
Name country fields
Improved address formatting for state, zip, country
-
Name.ABN
-
Name.Customer Payment method
Products
-
Product User fields x 4
The labels on the entry screen may be customised in the preferences (by default they are blank).
-
Easier entry of buy/sell unit conversions where sale units are smaller than purchase units (as is usual).
-
Product.LeadTimeDays
-
Product.CostPrice is maintained separately from Buy Price
Buy Price is recorded in the currency last used to buy. Cost Price may be set independently, including for products that are not bought (in which case it is a Standard Cost)
-
Buy Price currency
If a subsequent purchase is made in a different currency, MoneyWorks will suggest a buy price based on the converted previous buy price and will post a coach tip advising this
-
Product.Barcode
The barcode of the product may be entered into the product field of a transaction—MoneyWorks will substitute the 'real' product code for you. This allows the use of barcodes of up to 19 digits and makes scanned data entry using existing barcodes more practical.
-
Product.weight fields for buying and selling
MoneyWorks places no interpretation (or units) on this.
-
Cost-plus-% pricing option for D-F prices
Calculates sell price based on Product.CostPrice (which is the base currency equivalent of the last buy price if the product is bought). You can see this in the Costing tab
-
Discount% pricing option for D-F prices (apply special discount to A price)
This pricing mode operates independently of the across-the-board product discount (which will also still be applied). The selling price in this case is calculated based on the A price with a nominated discount percentage applied.
-
Pricing modes may be imported
Order Processing
-
Optionally synchronise Sales Orders and Invoice Numbers (i.e Invoice number is same as Sales Order number).
-
Customer Sales Enquiry shows orders
-
Deposit option on Sales Orders
-
Deposits on Purchase Orders
-
Departmentalised account on freight component on order now supported
-
Reorder Products smarter for non-stocked items
Jobs
-
Bill Job can drill down to job
-
Batch entry of timesheet/jobsheet
-
Jobsheet.EnteredBy: Job sheet data is automatically tagged with the user who entered it. It is possibly to restrict users to only see their own jobsheet entries.
-
Job screen displays job sheet entries
New tabs in the job entry screen for viewing pending, processed and budget jobsheet entries for that job.
-
Job.Project
Use this field to link related jobs together by entering the the job code of the master job (the project code) into the project field of subjobs.
-
Job.TargetDate
MoneyWorks puts no interpretation on this field. For documentary purposes only.
-
Job User fields x 4
These 4 fields may be used for anything. The first 2 can be up to 255 chars, the last 2 up to 15. The labels on the job entry screen may be customised in the preferences (by default they are blank).
-
Job number sequence can be reset in preferences
-
Synchronise Quote/Job/Invoice #
This option (Synchronise check box) is in the preferences under Sequence Nºs. When set, the reference number for new jobs, invoices, quotes, sales orders will have a common sequence. When billing a job, the invoice number will be the same as the job number (i.e. no new reference number allocated). Likewise when processing a quote to a job, the new job will inherit the same reference number rather than allocating a new one. If a job is invoiced multiple times, it is up to the user to append something to the invoice number to render it unique if this is a legal requirement (append /1, /2 or whatever). Same option applies to Sales Order->Invoice
-
Job code auto-copies to next detail line when entering purchase for job
If you enter a job code on a detail line of a transaction, MoneyWorks will now assume that you want the same code on the subsequently added line, and will auto-enter it for you. You can of course still change it or delete it.
-
Move to Processed without Billing
The command "Move to Processed without billing" appears in place of the Post menu item when pending items are highlighted.
-
Bill jobs by project
When billing a master job job, job sheet items for all jobs that have that job code in their project field will be available for billing on the job. Note that the expenses will still belong to the original subjob, but the income derived from them will be attached to the master job code that you are billing. For meaningful P&L, it will also be necessary to report on the project as a whole.
Open Recent
-
Quick access to recently opened/saved documents (including forms and reports)
Offledger file
-
Store user-defined per-period variables to use with KPI reporting
E.g. Headcount
-
Actuals and Budgets
More customisable field names
-
Customised field names appear on entry screens to facilitate data entry/staff training
Account categories x 3
Name categories x 4
Name custom fields x 4 (new fields)
Product categories x 4
Product custom fields x 4 (new fields)
Job categories x 4
Job custom fields x 4 (new fields)
Price codes x 6
Payment methods x 5
Department custom fields x 2 (new fields)
Customisable "Plain Invoice"
Customisable Banking deposit slip
Chart of accounts
-
"Header" option for accounts, departments. Disallows entry into transactions
-
Department User fields x 2
-
New account types for Sales and Cost of Sales
-
Tax codes can now be up to 3 letters instead of just 1, allowing for many more tax codes.
Receivables
-
multiple distribute options when allocating a receipt to invoices (Smart credit note use, Strict top-down, Dont use credit notes)
-
Show balance on Return Cheque to Debtor final screen
-
Invoices sortable for O/P alloc from CR entry
-
Show total of overpayments in Name balances panel
-
Prompt Payment discounts
-
Do Not Show On Statement checkbox when cancelling
-
Debtor Reconciliation report shows ageing
Payables
More stuff
- Option to confirm before quit (work around Microsoft UI design fault)
- Bank-to-bank transfer wizard
- Save An Empty Clone As—Make a new copy of a document with the same accounts and customers, but no transactions and a new balance date
- Per-bank-account cheque number sequences
- Prevent accidental rollback-all
- Show Detail Lines list view
- Adjust column widths for detail line entry (etc)
- Calculated columns in lists
- Set alignment in customised lists
- Expanded scroll-wheel support
-
Vertical scroll wheel changes active date field by days
-
Horizontal scroll wheel by months
-
Option-scrollwheel zooms on preview
-
Select 2 sort columns: select minor sort field, then option-click (shift Win) major sort field for 2-level sort
Macintosh-specific
-
Universal Binary—runs natively on Intel-based Macintoshes as well as PowerPC
-
Supports "Unicode" regional date/number formatting on Mac OS Tiger
-
Larger, easier-to-read dialog boxes
Windows-specific
-
Popups (aka combo boxes aka drop down lists) now optionally use the insane Windows-native behaviour (mash a key to cycle through options starting with that letter—by turning off "Combo-boxes use type-select" preference)
-
Expanded speech support on Windows (now supports both SAPI 4 and SAPI 5). This means speech just works on Windows XP with no additional software installation.
-
Context-sensitive help (Help On This)
Performance Improvements
MoneyWorks has always left the competition in the dust—in most cases—for both speed and scalability. Some aspects still needed improvement though.
Now, extensive performance tuning for v5 has yielded some significant speed gains.
-
Generally faster in both multi-user and single-user
-
Dramatic performance improvements for some specific operations, such as:
-
~5x faster over high latency internet connections*
- Analysis (cross-tabulation) Reports—up to 123x faster**;
- Historic Aged Debtors (Debtors Reconciliation)—up to 137x faster**
- Find Related—up to ~∞x faster***
also much faster:
- Sum Selection over a network
- Advanced Find
*scrolling through a list, 150ms latency DSL connection.
**600MB file, single-user, on Power Mac G5 Quad. Your mileage may vary. Improvements are less marked on smaller files/Windows platform
***may be slight exaggeration. Your mileage may vary.
Scripting
-
Applescript/COM-exported data now has clean formatting of numbers (no thousand separators—makes for easier parsing of exported data)
-
Export can take a relational search
-
Option to dump entire database to XML
there is more...
-
See the comprehensive and fully revised MoneyWorks manual for more details.