
Note: If you want to the run the script from more than one MoneyWorks file, you will need to install it into each one separately. You should read the instructions before you install the script. The download is a zip file (so you will need to decompress it) that contains a pdf of the instructions and a file OpeningARAP.mwxml-double-clicking the latter will install it into the currently open MoneyWorks file. To download the script and documentation, click the link below.


The script requires MoneyWorks Gold/Datacentre 7.2 or later to run on. If the report contains page headings, which most accounting reports do, you can tell the script how to identify and skip these. You just need to tell it which columns contain the data. When entering your serial number it note that it is in the form the form XXX-nnnnn-nnnnn, and must be entered exactly as provided. If the report is well structured and you can get it into Excel or a similar spreadsheet, then the OpeningARAP MoneyWorks script might be useful.īasically the script will read a structured, tab-delimited text file (which is one of the Saving options in Excel), and import the customer or supplier balances. The sample Acme file (used for the tutorial) can be used indefinitely, allowing you to thoroughly explore MoneyWorks. However most systems do have some sort of Receivables and Payables report, probably with ageing. It is made harder because some systems do not let you export this information in a sensible format (so even MoneyWorks’ powerful importing can’t just re-import it). There are more than 10 alternatives to MoneyWorks for a variety of platforms, including Windows, Online / Web-based, Mac, SaaS and Linux. One of the time-consuming tasks in changing to a new accounting system is getting your opening receivables and payables entered. MoneyWorks is described as 'Easy to use, flexible, and a powerful information system that won’t restrict you as your business grows in size' and is an app in the business & commerce category.
