MoneyWorks blog

Mac App Store meltdown issues for Cashbook users

The Mac App store is currently having some sort of security issue that is affecting some users who purchased the App Store version of MoneyWork Cashbook (and also many other apps). Affected users get the message long the lines of: “Your software was purchased on another computer, enter your Apple ID”, or “Your software is damaged, please delete and re-download from the Apple store”. Neither of the suggested actions actually appear to fix the issue.

This is an Apple problem, and not something that we can resolve. It appears that a required security certificate was not updated, as reported in The Guardian.

We do not know how long it will take Apple to fix this.

What we will do though is offer all affected users an upgrade to the current full desktop version (MoneyWorks Cashbook 7) for the difference in what was paid for the App Store product and the current retail price ($US99.00). If you wish to take advantage of this please email a copy of your App Store receipt for MoneyWorks Cashbook to

Note: MoneyWorks Cashbook 7 will open your existing Cashbook 6 files (it keeps of copy of the old file and makes a new file in MoneyWorks 7 format, preserving your data).

Posted in Uncategorized | Comments Off on Mac App Store meltdown issues for Cashbook users

Important notice regarding Mac OS X 10.11 (El Capitan)

Update: 5 Oct 2015

We have tested the release version of El Capitan (Mac OS X 10.11) and have ascertained that the data destroying bug has been addressed. However other issues have appeared, so if you choose to install El Capitan 10.11 on your server (and our advice is to wait for Apple to get a few bug fix releases out the door before you do), you must do the upgrade in the following order:

1. You must first update your Datacentre to MoneyWorks 7.3 before upgrading your server to El Capitan. This is accomplished by clicking the Check Now button on the Update tab of the MoneyWorks Datacentre console, as described above.

2. Once the Datacentre upgrade has been done you can upgrade your server to El Capitan (however you should first check that any other software you run is compatible—FileMaker for example will not currently run on El Capitan).

Original Post: 30 Sep 2015

The El Capitan full installer released today has a bug that will break MoneyWorks Datacentre server installations. Among other issues, the bug breaks Datacentre’s software update mechanism, so it is very important that you DO NOT install El Capitan on a Datacentre server. We are devising a workaround for the bug, which will be in the Datacentre 7.3 update.

It is important that you install Datacentre 7.3 before updating your server Mac to El Capitan.

This problem only affects MoneyWorks Datacentre (and possibly other server software). It is safe to install El Capitan on your other Macs. Of course you should never install a new OS without having a complete backup of your computer.

Posted in Uncategorized | Comments Off on Important notice regarding Mac OS X 10.11 (El Capitan)

Prompt Payment Discounts in the UK

The handling of VAT on prompt payment discounts (PPD) in the UK changed from 1st April 2015, essentially making it the same as most other countries.

MoneyWorks 7 users do not need an update to do this. Instead simply change the PPD Settings in the Document Preferences of MoneyWorks (accessible under the Edit menu) from the old UK settings (the third option) to the first option, as shown below.

MoneyWorks Prompt Payment Discount settings for UK after April 2015

You will also need to make your PPD expense account taxable (i.e. give the it standard V tax code).

Note that you are also required to include text with the following meaning on the invoice.

A discount of x% of the full price applies if payment is made within n days. No credit note will be issued. Following payment you must ensure you have only recovered the VAT actually paid.

The easiest way to do this is to just have the text in the message area of the invoice. Alternatively you can customise the invoice to have the text “hard wired”.

Important: If you are paying/receipting an invoice that has a PPD that is dated before the 1st April, you will need to temporarily reset the preferences back to the old UK option (and the tax code on the PPD expense account) in order for the discount to be applied correctly and the correct VAT calculated.

Posted in Accounting | Comments Off on Prompt Payment Discounts in the UK

MoneyWorks Accounting for Schools training courses

Accounting for schools has always been a major strength for MoneyWorks, with hundreds of schools in Asia and Australasia using MoneyWorks for their school financials.

The features that particularly appeal to schools are the departmental accounting (cost centre accounting), and the powerful report writers that are built into MoneyWorks.

Over April and May, we’re having a series of courses that are specifically oriented for school administrators. Presented by Peter Cook, a long term MoneyWorks Consultant with special expertise in school accounting, these are a must for any schools that are using or considering using MoneyWorks. For further details please visit the Training courses.

Posted in Uncategorized | Comments Off on MoneyWorks Accounting for Schools training courses

Ostendo release MoneyWorks Integration

Ostendo is “Operational Software” that includes advanced features for inventory, manufacturing and jobbing, and which now offers seamless, real-time integration with MoneyWorks Datacentre. In effect, Ostendo becomes an operational front end to MoneyWorks, adding powerful functionality for distribution, engineering and manufacturing, including:

  • Serial Number/Batch Tracking
  • Inventory and Purchasing
  • Landed Costing
  • MRP and Inventory Replenishment
  • Enhanced Job Costing and Projects
  • Labour, Timesheets and Job Tracking (includes Constraints Scheduling)
  • Distribution, POS and Service (includes Asset Preventive Maintenance)
  • CRM, Call Centre and Quoting
  • Manufacturing and Assembly
  • Configured Custom Products including Features and Options

Like MoneyWorks, Ostendo incorporates powerful custom reporting, graphical workflows, advanced scripting, and access from mobile devices, thus allowing for a high level of customisation to meet specific user requirements. For more information, visit or call +64-9-525-3612.

Posted in Uncategorized | Comments Off on Ostendo release MoneyWorks Integration

MoneyWorks Tops Accounting Reviews

MoneyWorks Gold 7 was named “top choice” in a recent review of accounting systems in the USA, beating out QuickBooks and AccountEdge (formerly MYOB), and earning 4.5 points out of a possible 5. To read the full article, click here

Posted in Accounting, News | Comments Off on MoneyWorks Tops Accounting Reviews

Importing Bills of Materials

It’s been possible to import a bill of materials (BOM) into MoneyWorks since about MoneyWorks 3. However it always had to be done using some sort of script (AppleScript on Mac, vbScript on Windows), as there is no user interface for it in MoneyWorks.

However it is relatively easy to add an Import command by using a Report Script, and this also has the benefit of being cross-platform (Report Scripts were covered in this earlier post).

The sample report script below will read a text file consisting of three columns (no headings):

  • Parent Item Code: The item code of the product that is being built
  • Quantity: The quantity used of the component
  • Component Item Code: The item code of the component used

The line of the text file must contain these three values (no blank rows), and the file can be either tab or comma delimited (you specify when the report script it run). Note that you cannot edit an existing bill of materials for an item; it is completely replaced by the components and quantities specified in the file (which must be ordered by Parent Item Code). Also note that no checking is done: if the items or components do not exist (or cannot be used in a BOM) the import will silently fail.

To act as a report script, the “Import Bills of Material.crep” file must be placed in your MoneyWorks Custom Plug-ins/Scripts folder (unzip it first). You can then run it by choosing “Import Bills of Material” from the Command menu in MoneyWorks Gold/Datacentre (requires MoneyWorks 7 or later).


Import Bills of

Posted in Technical, Tips | Comments Off on Importing Bills of Materials

MoneyWorks 7 Unicode support

Up until now, MoneyWorks has used the native “code page” text encoding for the platform it is running on, and as these are different on Mac and Windows, accented characters have not translated between platforms, and support for special characters has been limited. In v7, all text is encoded as Unicode, so the full gamut of non-Roman and accented characters, ideographs, and other special symbols can now be entered into the database and are preserved across platforms. Files created on earlier versions will be converted when first opened in v7 (and if the file contains accented text, be sure to do the conversion on the same platform that the file has been used on, since that platform’s default pre-unicode encoding is what the file uses).

If you’re not accustomed to using accented characters, here a few tips for typing some common accents on a standard “US”-style keyboard.

Mac (using the US, Australian, or UK keyboards):

To get acute and grave, type option-e or option-`, then the vowel you want to receive the accent. E.g. for é, type option-e then e. For è, type option-` then e. Here are a few more:

              for       type…	
               à	option-`, a	
               ç	option-c	 
               è	option-`, e	 
               é	option-e, e	
               ê	option-i, e	 
               ë	option-u, e
               î	option-i, i	
               ï	option-u, i	
               ô	option-i, o	
               ù	option-`, u	
               û	option-i, u	
               ü	option-u, u	  
               ñ	option-n, n	  

If you are running Lion, Mountain Lion, or Mavericks, you can just hold down the key you want an accent on, and a popup will give you the options:

Screen shot 2013-11-10 at 11.55.11 AM

Press the digit key for the character you want.

Windows (using the US, Australian, or UK keyboards):

For the occasional accent, and without changing your keyboard settings, you can type the “alt code” for the character you want. Here’s how:

  • Hold down the left-hand ALT key;
  • On the numeric keypad, type the 4-digit alt-code for the character you want;
  • Release the ALT key.
                        code		                code
               à	0224	               À	0192
               ç	0231	               Ç	0199
               è	0232	               È	0200
               é	0233	               É	0201
               ê	0234	               Ê	0202
               ë	0235	               Ë	0203
               î	0238	               Î	0206
               ï	0239	               Ï	0207
               ô	0244	               Ö	0212
               ù	0249	               Ù	0217
               û	0251	               Û	0219
               ü	0252	               Ü	0220

If you need to type quite a few accents, you might want to consider using the US International keyboard. See Using US-Int’l Keyboard Layout to Type Accented Characters.

Macrons for Māori

For our New Zealand users, who may need to type Māori long vowels, here’s how:

First, enable the Maori keyboard:

  • Mac OS X 10.6—10.8:
    System Preferences → Language and Text → Input Sources. Scroll down the input methods and click the check box next to Maori, and make sure the option “Show Input menu in menu bar” is turned on.
  • Mac OS X 10.9 (Mavericks):
    System Preferences → Keyboard → Input Sources. Click the +, select Maori from the list of input methods and click Add. Make sure the option “Show Input menu in menu bar” is turned on.

Now you can select the Maori keyboard from the menu next to the time in the menu bar. With this keyboard selected, just type option-a, option-e, option-u etc to get ā, ē, ū, …

Posted in News, Tips | Comments Off on MoneyWorks 7 Unicode support

MoneyWorks 7: Easier, faster search

MoneyWorks 7 is now available, so we’ll be posting some articles on how to make the most of the new features.

While Moneyworks has always had quite powerful searching, it was not sufficiently accessible to users who did not know which field they wanted to search on. These days people are used to near-instant results from a browser search bar. So that is what we now provide. The new search field in the toolbar does a fast asynchronous full-text search (including sticky notes and transaction details).

The Cmd-F or Ctrl-F keyboard shortcut now activates the search box in the toolbar. Just type a word and MoneyWorks instantly starts searching the full text of the records in the list. As usual, the search applies to the current view, and the currently selected filter, if any. For moderately-sized data files, the search will be instant. For very large files, it may take a little longer, but results will be added to the list as they are found, and you can continue working as the search proceeds.

The new search box. The filter popup is on the left; type in your search term.

For users who want more control over searching, the usual Find by Field and Find by Formula are still available. Just press Cmd-option-F (Mac) or Ctrl-Shift-F (Windows) to bring up the usual search dialog. This mode of searching has also been improved for network users: Even very complex searches are now performed entirely on the server, for faster results and less network and server load.

For more details on the new searching, see Finding Records using the Search Box in the new online manual (Yep, the entire MoneyWorks 7 manual is available on the web).

Posted in News | Comments Off on MoneyWorks 7: Easier, faster search

British Columbia change back to PST

On April 1st 2013, British Columbia is reverting to the more complex PST tax system, reversing a change to the simpler HST environment adopted a few years ago.

As this is a structural change in the tax system, you can’t just change the HST rate to the new GST+PST rate. Instead you must set up a new tax (or, for users who have had MoneyWorks for several years, reinstate the old one).

We have prepared a document which discusses how you can change your MoneyWorks file(s) to implement PST. It would also be a good idea to refresh yourself on how MoneyWorks handles taxes by revisiting pages 202-206 of the MoneyWorks 6 Manual (available under the Help menu in MoneyWorks).

Download the PST Reimplementation Notes as a PDF.

Note: The notes were updated on 26 March to include a section on changing your MoneyWorks Locale to “PE” so that the standard invoices would print with PST and GST instead of HST.

Posted in News | Comments Off on British Columbia change back to PST