- [critical] Fixed a caching issue that was causing inappropriate behaviour in the groups/categories lists. This could cause department add to group etc to fail.
- Work around missing ↔ character in XP version of Tahoma
- Added Print Details icon to Posted view toolbar
- Fixed problem with printing from Batch debtor receipts on Windows
- Fixed a problem with date constant handling in the search optimiser
- Some multiline text entry fields were not calculating length correctly on Windows
- Provide better feedback to other users when one user is locking the database
- Tighter control on changing account types (account used as control account elsewhere could be changed to a bank account)
- Datacentre document cloning was throwing a spurious error
- Updated cashflow report to handle more bank accounts
- Form thumbnails were not updating
MoneyWorks support
Change History for 7.0.2
Posted in Change History
Comments Off on Change History for 7.0.2
Change History for 7.0.1r1
Quick fix for crasher introduced in 7.0.1.
- [critical] Fix for crashing Year on Year Dashboard chart (Parsing non-numeric string as number crashing on Mac introduced by 7.0.1)
- [critical] Fix for infinite loop on CreateSelection for highlight where original selection is sorted descending
- Fixed inadvertent div by zero in stock history report
Posted in Change History
Comments Off on Change History for 7.0.1r1
Change History for 7.0.1
Version 7.0.1; September 2013
Bug fixes
- [critical] Fixed bug in server-side posting on 64-bit Mac Datacentre server concerning currency amounts exceeding ~65 million
- Fix support for multi-byte encoded thousands separators (Quebec)
- Fix non-functional line width and transparency popups in Forms Designer on Windows
- Fix crashes on Windows primarily affecting XP machines with insufficient memory
- Added UTF-8 re-conversion to Diagnostics (requires single-user mode)
- Fix failure to calculate correct tax on freight charges in orders
- Fix crash after an email fails to send due to no configured email client
- Updated Aged Receivables/Payables Reports
- Fix crash when selecting previous receipt in Batch Debtor Receipts (Windows)
- Fix slow document startup on Datacentre with heavily populated (~10000) Pictures folder(s)
- Refresh Navigator after switching to recent file (auto-closing previous file)
- Fix networked stocktake entry
- Fixed Excel launching on Windows
- Posting Transaction: PostedBy is now populated on Datacentre
- Fix unintended data relookup when exiting unchanged fields (Mac)
- Fix crash after attempting to open local file in a client-only Gold installation
- Accented characters now render properly in PDF on Windows (non-Roman text is not currently supported for PDF output on Windows)
- Added account/dept range support back into the Ledger Report
Posted in Change History
Comments Off on Change History for 7.0.1
Change History for 7.0
Version 7.0; August 2013
These notes pertain to MoneyWorks Gold and Datacentre (although many items also apply to Express and Cashbook).
- Faster—Operation on slow (high latency) networks is now much faster, and large document performance is also improved.
Access your MoneyWorks Datacentre over the internet. Cloud services: not just for web browsers.
- Easy full-text search—The new search field in the toolbar does a fast asynchronous full-text search (including sticky notes and transaction details).
Finding information is faster and easier than ever.
- Unicode—The full gamut of accented and non-Roman characters can now be entered into the database and are preserved across platforms. Accented characters (including macrons for Māori), special symbols, Chinese, Japanese, Runes, Emojis, etc..
您可以输入中文字符. પણ અને ગુજરાતી
- Scripting—MoneyWorks Gold 7 includes a built-in script editor and compiler for an easy to learn and use scripting language which allows for extensive customisation of application behaviour.
MoneyWorks is now more customisable than ever.
- Stock Counting—Super simple “stock” mode, for those who want a stock count but don’t want the complexity of inventory accounting.
- Full list of other changes
- XML import no longer trims leading and trailing whitespace in fields
- Per-customer discounts are now respected for job sheet entries (with appropriate product pricing mode)
- Navigator cosmetic fixes
- Help and Help on This now go to web-based help
- Network timeout after connection loss due to client sleep is now shorter
- Images for products with punctuation in code are now stored reliably
- Custom report settings: custom controls with same name as std checkbox now set the std option
- Windows commandline client now uses appropriate programdata directory according to the user it is running as
- Fixed a problem with Switch User with a newly created user
- Fixed issues with charts in HTML-formatted reports
- Fixed a Navigator display problem related to previewing reports
- Prevent changing taxcode type back from component to normal
- GST Journal: Now populates account code for composite tax comprised of two GST type taxes (Quebec)
- Duplicate Order: Backorder qty is now being populated
- Current user initials are now cleared when switching to a document that does not have password protection
- Find Related now always defaults to Make Found Set at the start of each session (since this mode is much faster)
- Expression editor window is now resizable
- Expression editor window: added some missing functions to the functions list
- Fixed cosmetic button alignment issue with some OS X versions
- Saving bank reconciliation over slow network is now much faster
- Windows: can now close note window over Batch Debtor Receipts
- Prevent a potential crashing issue when transaction reference number prefs are bad
- Electronic Banking: Re-exporting with different account codes makes an entry in the log file
- Tightened checks for making system header accounts
- Fixed report cell word-wrapping issue on Windows
- Session file creation no longer fails with a disk space error on volumes with certain free-space conditions
- New meta search mnemonics *foundorall, *highlight, *found
- Report Hotlinks of type lixx now work more reliably
- Datacentre: Serverside reporting no longer consumes a concurrent login
- CLI -v is now more verbose
- Filenames containing dots other than the extension separator are now interpreted more reliably
- REST reports list now omits dirs and files beginning with ~
- New list: no longer allows a blank list id
- Datacentre: Custom plugins Upload All now replaces entire plugn folder on server (rather than merging)
- Include Unposted on slow network is now much faster
- ForEach in report no longer terminates prematurely when iterating over text with an empty line
- Date arithmetic in expressions now works properly when adding or subtracting a negative number of days to a date
- Windows update: No longer need to elevate app to install: just runs installer elevated. Note that on XP you MUST turn off the “Protect my computer” checkbox (which actually means “don’t run installer”).
- Closing documents now copes better with unexpected file system errors
- Make/Break Jnls: Check that items are stocked or have COGS acct on entry
- Duplicating Name records is no longer modal
- Modeless entry windows on Mac display dirty indicator in close blob
- New Currency bank account creation no longer suggests a ~ code
- CRC check error now mentions that wrong extension is most likely cause for error on block 0
- Toolbars icons that do not fit in window are now in a chevron menu
- The (unused) AmtPaid field is now set for recurring CR and CP
- All previously hard-coded reports (except GST report) are now fully customisable.
- Time Sheet Entry: By Resource: now populates units field in resultant job sheet items
- Future-dating an order no longer attempts to open periods up to the date
- CLI plugin download now completely replaces old plugins cache (instead of merging)
- Standard Reports now feature explicit privilege control (so do not need to be signed)
- Datacentre now supports up to 30 simultaneously open documents without special configuration
- Create New Product during stocktake: StockTakeValue now set to costprice
- Bank Reconcile – Other (non Bank account) no longer shows Orders
- Change GL Account Code now updates associated Auto Allocation Rules
- Importing Accounts: No longer allows incorrect tax code for Bank Accounts
- Product sell units in Express can now use the full field length
- Detail Line Items List: “Product Lines” view is now “Item Lines”
- Stock Creation/Writeoff Jnls: No longer complain if contra is SA or CS account
- Job Sheet Entry: Account Code field now modifiable
- Serverside reports run on Windows server: autoscale works more reliably
- Windows console now tests component versions to detect failed updated
- Log list has a search box field
- Duplicating a banking journal retains the banking flag on
- Return Refund to Debtor window is now resizable
- Report Editor: Making a report part a Running Header no longer sets all preceding report parts to running header
- Script function: SetExchangeRate(currency, date, period, newRate)
- Script functions SetPersistent/GetPersistent
- Script function: GetMutex/ReleaseMutex
- Receive Refund from Creditor/Return refund to debtor: Left hand column show theirref/ourref
- Toolbar Print icon renamed to List (indicating that it Prints the List)
- Server side reporting now supports very long running reports without risking network timeout
- Stock Counting (without full inventory)
- Can switch between Find (by field) and Advanced Find on the fly
- Transaction Get Info Amt Owing is now displays cents
- FieldLabel() function: for extracting custom field names
- SetColumnWidth(“COLN”, points) can change a custom report columnwidth (from the setup script)
- All list sidebars now scrollable if necessary
- SumSelection can take a selection variable as second parameter
- Report controls: Invis selection variable retains sort order, even after passing through an expression
- Print dialog displays indicator that report will (attempt to) run on server
- REST server: option to transform GET to POST, for stupid useragents (FM, looking at you)
- Treat Job Related Income as Pre-payments setting moved to preferences
- New User2 file with more fields for script use
- Analysis reports can now run on the server
- XML import now capitalises codes
- Right-click on toolbar icon now waits for mouseup before executing command
- Import Products: COGS Acct no longer required to be EX
- DisplaySelection(sel) script function
- Detail: f_no_stock_effect set more consistently
- “Other” item class
- Script Function to display sticky note
- XML Name import with update now works
- Report custom controls: #PER result is now numeric type
- Improved log rotation
- Increased maximum number of parts in a report to 1753 (long story)
- Windows PDF generation now more tolerant of OpenType fonts
- Name.taxnumber: now available in transaction import
- Aged Debtors/Creditors reports now more tolerant of incorrectly coded Head-office/branch relationships
- Serverside reports for output modes other than Preview
- Save report as HTML to a remote citrix volume is now much faster
- Transaction Hold checkbox now requires Pricing and Terms override privilege
- Authenticate(user, password) function
- Build product no longer requires parts to be in stock
- Report Writer: Accounts of Type “GST Received” had wrong search
- Unicode() function to get unicode codepoint of character
- Load Bank Statement: Now autoreconciles existing transactions that match incoming skipped transactions
- Don’t allow opening documents in read-only directories (since it causes pain when changes need to be saved)
- New path variables for POSIX paths on Mac
- Account importing no longer mangles comments
- Custom form testing less crashy when no database is open
- Login.permissions encoding has changed
- File opening now attempts to reduce fragmentation of the temp working file by pre-setting the length
- File opening now pre-caches data blocks more effectively for a snappier startup with large files
- User definable labels on address fields in name entry screen (modifiable from scripts)
- XMLl importing – detail field work-it-out and calculations work properly for multi-line transactions
- Scripting: can now trap entry to fields (using MWScript only)
- Bank reconciliation is now much snappier when running over a slow network
- Posting is now done on the server and therefore much faster when on a slow network
- Accountants Export can now be emailed via direct SMTP emailing (now has dialog box for addressing and message)
- Report Designer – Now changes font settings in cells when modifying a range of parts
- Fixed issues with very large autofill caches
- Find Related from some transaction views was omitting Detail Line Items as an option
- Auto complete popup now sized better on Windows
- Sales Enquiry Movements list no longer shows Debtor Receipts
- DatePaid Field: No longer set on transactions generated by the job system
- Fixed a bug in Batch Debtor Receipts that allowed previous overpayment amount to be changed
- Changing Department Code now updates JobSheet items
- Report Cell dialog on Windows: Ctrl key no longer acts as Alt
- Overdue credit notes no longer generate overdue invoice warning for debtors
- Custom script invocation from toolbars
- Helper Script hooks for before and after posting
- Custom column sorting now works with column calculations that use functions that take search strings
- Item importing: “Update if Exists” no longer truncates description
- Report Writer: new custom control type “radio”
- New option to clear locally cached custom plugins folder when logged in to Datacentre (select Custom Reports in Index to Reports)
- Fixed a potential crasher in HTML report export
- Auto insert Salesperson field with custom validation could erroneously insert into ourref: fixed
- Fixed crasher when canceling Return Cheque to Debtor on HO/Parent
- Pasting XML now displays import progress
- Transaction list does now retains scroll position across posting when Windows-stye focus rect is displayed
- Expression optimiser was converting = to <>
- REST import now reporting imported count for memo file import
- Fixed verbose logging crash in REST HTTP server when logging POST data > 32K
- Function Left(x, negativecount) now returns empty string
- Fixed potential crasher when cancel Duplicate Transaction (at the refnum Ask dialog)
- Log file: now records app version on new file creation
- Invoice printing with “Plain” invoice was randomly failing to set printed flag
- Reports: Floating Accounts now work correctly on Balance Sheet when printing Condensed
- XML Import: transaction.specialbank now enforces field length
- Fixed a resource leak on Windows
- Fixed a potential crash with a malformed Applescript export request
- No longer pad NZ bank account numbers to 8 digits on entry
Posted in Change History
Comments Off on Change History for 7.0
Multi-location plug-in
This plug-in is no longer required or supported as the functionality has been built-in to MoneyWorks 8
What is it
The Multilocation stock Plug-in facilitates management of inventory in multiple locations. It is suitable where you have multiple warehouses, consignment stock, vehicles that contain inventory etc.
The plug-in enables the transfer of stock from one location to another, automatically creating the new location if required. Locations are represented by a single alpha-numeric character which is appended to the stock code. This enables full audit trails of all stock transfers and sales.
The download includes includes instructions, a plug-in for Window (“Transfer Stock.exe”), and a plug-in for Mac (“Transfer Stock.app). Ensure that you only install the plug-in appropriate for you platform.
Downloads
Posted in Multi-Location, Resources
Comments Off on Multi-location plug-in
Introducing MoneyWorks 7: The fastest just got faster
MoneyWorks 7 was first released in August 2013—these release notes are preserved for posterity
With many significant new capabilities and extensive work “under the hood”, MoneyWorks 7 is both faster and easier to use.
Faster, easier full-text search
The new search box in the toolbar makes finding information both faster and easier. Just type a word and MoneyWorks instantly starts searching the full text of the records in the list (even including sticky notes and detail lines).
Unicode
Now you can record information and prepare invoices/reports in almost any language, including Chinese, Japanese, Greek, Cyrillic and most other non-Roman text. This also provides full cross platform support for accented characters (bonne idée, Māori) and other special symbols.
Faster
MoneyWorks has long been a speed king in the accounting software world, but now the database and network performance have been made even faster. Datacentre users in particular will benefit from some dramatic network performance increases—especially for clients connecting over the Internet.
“
I just used MW7 on […] Starbucks wifi and I honestly can’t believe how fast it was!”
—Jon, UK beta tester
Scripting
MoneyWorks Gold 7 includes a built-in script editor and compiler for an easy to learn and use scripting language which allows for extensive customisation of application behaviour. Scripting dramatically increases the power of MoneyWorks, allowing you to place your own buttons on windows to add additional functionality to MoneyWorks. Want to automatically round transactions to the nearest 10 cents? Automatically update exchange rates daily, weekly or monthly? Implement a complex pricebook? It can be done with a script.
Stock Counting
Stock counting is ideal for those who do not want the overheads of running full stock accounting, but just want to keep a simple count of items. Available in all products (including Cashbook and Express), it is ideal for situations like farm accounting and share portfolios, where full inventory accounting is not appropriate.
More Reports
We’ve added some great new reports and reorganised the existing ones to make them easier to access. Many reports can now be accessed directly from the list sidebar. New reports include:
- Daily Summary Dashboard
- Executive Summary
- Backdated Transactions
- Recurring Transactions
- Overpayments Report
- Trial Balance to Date
- Chart of Accounts
- Department Listing
- Profit and Loss for Five Years
- Cumulative Profit and Loss for Period Range
Other changes include…
- Posting
Posting now happens on the server so it is much faster when running on a network. And to streamline things, the posting process no longer stops and asks for a decision on how to treat out-of-stock conditions. - Customisable Reports
With the exception of the GST/VAT report, all reports have been reimplemented as custom reports, so you can modify them (in MoneyWorks Gold) if you want. - Sidebar Reports
Reports which operate on list selections are now directly accessible through the list’s sidebar. - New locale for Malaysia
- Electronic banking security enhancement (multiple exports with different accounts are logged)
- Toolbar icons that do not fit in window are now accessible from a chevron menu
- Report Privileges
Access to the standard reports is now subject to privilege control, for easier management of financial security. For example, you can only run a Profit and Loss report if you have the Account Enquiry privilege. Reports can still be signed for a finer level of access control (the factory-standard reports have been signed by Cognito to allow them to be run by anyone with appropriate privileges. - Building Items
Parts need no longer be in stock (they will just go into negative stock). Components no longer need to be purchased, but only require a cost account specified on the Item’s Costing tab. - Additional user-defined storage in the User2 table
-
Transaction Details printing
Get a transaction details report for selected transactions right from the transaction list toolbar or sidebar. This report is now customisable using the Report Writer. -
MoneyWorks Manual
The revised User Guide for MoneyWorks 7 is now installed on-demand and can be updated via Software Updates, should that be required. -
On-line help
The on-line help system is now fully integrated with our web site for an improved and consistent answer-finding experience. - Improved Refund dialogs make it easier to select credits for refunding (especially if you have hundreds of them!)
Scripting
New scripting facilities allow for easy customisation and extension of MoneyWorks functionality.
With MWScript, you can:
- Add toolbar buttons or menu commands to invoke your scripts
- Validate or auto-fill data entry fields or screens
- Invoke or look up data from external web services
- Create simple dialog boxes for data capture
- Included example scripts for exchange rate lookup, cash-rounding, BOM cost update and journal creation, purchase order creation.
Scripting language features
- Platform neutral: Write once; deploy on either platform
- Fully embedded: Policy-enforcing scripts cannot be circumvented by removing script file.
- Fast. Scripts run right in MoneyWorks, so there is no IPC overhead
- The MWScript language is closely aligned with purpose, making it really easy to customise MoneyWorks.
- Very dynamic loading of scripts: Make a change, activate script and it’s immediately enabled.
- Easy deployment: Scripts can be emailed to customers and installed by a double-click.
- See the Developer page for MWScript Documentation.
MoneyWorks Datacentre Server 7
MoneyWorks Datacentre 7 naturally includes all of the new features and benefits of MoneyWorks Gold 7, plus a few specific improvements. The upgrade to version 7 is provided at no additional charge as part of the Datacentre software maintenance programme (programme subscription must be up-to-date).
The Cloud
It’s not just for web browsers.
With phenomenal performance enhancements to overcome Internet latency, and interoperability features such as the REST interface introduced in v6.1, MoneyWorks Datacentre now gives you the opportunity to run your own access-anywhere cloud server. Host on your own site, or with an application hosting service.
Your data, on your server, with a fully interactive desktop user interface. Integrate with other applications on your desktop, or server-based applications on your server.
Enhanced Internet performance
Extensive work has been done to dramatically increase the performance of MoneyWorks Datacentre over a high latency network (aka “the internet”). For most operations, using Datacentre over the internet from a remote location is almost as fast as a local area connection.
- Faster login
The server connection process has been optimised to dramatically speed up login to the server. - Server-side reporting
All standard reports (including sales analysis, GST etc) now run on the server, and all output modes are now supported when running on the server (in version 6, only previewing was supported for server-side reports). It is no longer necessary to reserve a user login for use by the server-side reporting service. - Faster searches
Advanced Find (used by complex search by formula) is now optimised and progressively executed on the server, so this type of search is now much faster. And of course there is the new dead-simple full text search in the toolbar.
- Faster list display
Advanced look-ahead caching means list display on a slow network is as responsive as on a LAN. (Note, if you have custom calculated columns in your lists then these may defeat the caching, so your mileage may vary). - Faster Enquiries
The include-unposted function of the account enquiry is now executed on the server, so is much faster. - Faster posting
Now done on the server. Don’t blink. - Faster Bank Rec
Starts much faster and much more responsive on a slow network. - 64-bit
Datacentre database servers now run in 64-bit mode on Windows as well as Mac, improving memory availability and therefore performance for very large files.
System Requirements
- Mac
Mac OS X 10.6.8 or later. Intel processor - Windows
Windows XP SP3 or later. x86 or x64 processor.
Upgrading
- Gold, Express, and Cashbook
Upgrades may be purchased on our store - Datacentre
Upgrade is provided as part of your maintenance programme. Please ensure your maintenance subscription is up-to-date.
Posted in Change History, FAQ, Resources
Comments Off on Introducing MoneyWorks 7: The fastest just got faster
MoneyWorks-Daylite Connector
The connector provides a direct link between MoneyWorks Datacentre and Daylite, the award winning Business Productivity & CRM system from Marketcircle.
With the connector you can:
- Import your customer/supplier records in bulk from MoneyWorks into Daylite. Makes it easy for existing MoneyWorks users to get Daylite up and running quickly.
- Update MoneyWorks in real time when the contact information changes in Daylite. MoneyWorks will reflect the change in the contact details with no data re-entry.
- See live MoneyWorks customer financial and transactional information in a Daylite “Dashboard”. See transaction and payment history, order information and account status information from MoneyWorks live in Daylite. All the information you need about your customers at your fingertips, without needing to physically access MoneyWorks.
- Import item records in bulk from MoneyWorks into Daylite to update your Daylite prices. Always have up to date pricing information when preparing estimates in Daylite.
- Send your Daylite estimates to MoneyWorks. Your Daylite estimates will appear as Quotes in MoneyWorks at the click of a button.
System Requirements
The connector requires Daylite 6 or later, and MoneyWorks 7.3 or later. Machines on which the connector is installed must using Mac OS X 10.8 (Mountain Lion) or later. For Datacentre users, the connector only needs to be installed on Macs running Daylite (MoneyWorks does not need to be installed on the same machine–indeed your MoneyWorks can be hosted on a PC in Kathmandu, and, barring accidents with firewalls, the connector will still work).
For MoneyWorks Gold and Express users Daylite and MoneyWorks must be running on the same computer. Note that MoneyWorks 7.3 or later is required for this desktop version of the connector.
The Connector requires a serial number, which can be purchased for USD99.00 or equivalent from the MoneyWorks Addon Store. When purchased, you will be emailed a receipt and the download link.
For convenience, the documentation link is below:
Trades Plugin
What is it
The MoneyWorks Trades Plug-in is a MoneyWorks extension that allows for the importation of price
books and invoices generated by the major trade suppliers in New Zealand
Benefits
- Up to date pricing: Your quotes and invoices will always use the latest prices—never be caught by price changes again
- No rekeying invoices: Let your suppliers do the keyboard work—simply download and import supplier-generated invoices, saving hours of time per week
- Better costing: Track your time and costs and profitability by job.
Downloads
Current Version: 1.5.0 updated 27 July 2012 (incorporates Mico/Crane new formats)
Posted in Resources, Trades Plugin
Comments Off on Trades Plugin
Converting from MYOB or AccountEdge
If you are an MYOB or AccountEdge user, you may have noticed that it is next to impossible to export your vital accounting information out of your system. For example, export your items list and there is no stock on hand. Export your customer list and there are no balances. This makes it hard for people to migrate from MYOB into a more modern system.
Enter the MoneyWorks MYOB Converter … your “Get out of MYOB Free” Card!
The converter is a free utility that we provide that will (probably) convert your MYOB or AccountEdge data into a MoneyWorks file! Simply run the converter, choose your MYOB (or AE) file, set a couple of parameters, and a new MoneyWorks data file will be created with most of your vital accounting information in it (at least that is the theory). See how easy the process is by watching this five minute video.
- Convert over the General ledger
- Transfer up to six years of financial balances (the limit in MYOB)
- Transfer your card file into the MoneyWorks Names list
- Transfer your items file (including any bills of material) into the MoneyWorks Products list
- Transfer your stock on hand at the average unit value in MYOB
- Transfer your outstanding invoices (as you will need to pay them)
- Transfer your unreconciled payments and receipts
- Transfer outstanding orders and quotes
What you need to do
First off, you will need a copy of MoneyWorks Gold (or the MoneyWorks Gold demo) installed on your computer. If you don’t have MoneyWorks Gold, you can download a trial version. Then simply download and decompress the MoneyWorks Converter application:
MoneyWorks Converter for Mac (6.3 MB – Universal Binary)
MoneyWorks Converter for Windows (15.0 MB)
Note that you can put this anywhere on your computer (it doesn’t need to be in the Applications or Program Files folder). Windows users should keep the MoneyWorks Converter Libs folder, the MoneyWorks Converter Resources folder and the MoneyWorks Converter.exe in the same directory.
Mac users should note that the converter, like MoneyWorks, is a universal binary and will run natively on both M1/M2 and Intel Macs.
Now download and read the MoneyWorks Converter Notes.pdf (about 1.7Mb).
Then:
- Make sure that there is NO open file in MoneyWorks (MoneyWorks can be running, but with no file open).
- Start the Converter. You will be presented with a file open dialog box — select your MYOB/AE data file. If the Converter can’t see your MYOB/AE file for some reason, change the file’s name to end in .myo (e.g. from “Accounts” to “Accounts.myo”). Note that the MYOB/AE data file must be on your local hard drive, not in a shared or mapped drive, and for Mac users should be somewhere in the Documents folder hierarchy.
- In the window that then opens, you need to specify (i) the current year that MYOB is operating in, and (ii) the last month of the financial year. Then click the Convert File button.
- The Converter will then read the appropriate data out of your MYOB file and send it to MoneyWorks. MoneyWorks will come to front (possibly hiding the Converter window — if MoneyWorks wasn’t running, you should see it start). It will also open and close the file twice, and the whole process may take a few minutes, depending on the size of your data file. Do not be tempted to interact with the MoneyWorks file while the conversion is in progress — the Converter is using MoneyWorks Automation, a powerful part of MoneyWorks that lets it interchange data with other systems, to send data into MoneyWorks.
- When the Converter has finished (you will know because it will say “Finished” — if necessary bring the Converter to the front by clicking its icon in the dock), and assuming that nothing has gone wrong, you will be able flick into MoneyWorks and you should see your data there.
- You should run off a Balance sheet (or trial balance) from MoneyWorks (under Reports>Balance Sheet) for the most recent period, being sure to click the “Include Unposted” option, and compare the results with that of MYOB (the balance sheet layout is a bit different, so you will need to match up the numbers and tick each one off, ignoring the subtotals in the MYOB report).
- If you used Multi-Currency in MYOB, you will need to manually set up those currencies in MoneyWorks (and set the exchange rate to whatever it was set to in MYOB), and use the Funds Transfer command to transfer the bank balances from the old accounts to the new MoneyWorks forex accounts.
- Finally you should enter the appropriate information into the Company Details (under the Show menu) screen in MoneyWorks.
And that in theory is all you need to do. You might at some point want to tidy up your chart of accounts to take advantage of the more powerful concepts available in MoneyWorks.
For more detailed instructions, please download the MoneyWorks Converter Notes.pdf (about 1.3MB).
We need your feedback!
If you have used the Converter we would like to hear from you, whether it worked or not. Please let us know how you got on by emailing info at cognito.co.nz.
MoneyWorks Converter FAQs
Is it Guaranteed?
Absolutely not. It is provided on a “best endeavours” basis — it works for us but may not work for you. In particular there can be so many odd things in an MYOB data file that MoneyWorks just will not let happen, and this may thwart you.
What versions of MYOB or AccountEdge does it work on?
Any version from about 2004 up to and including AccountEdge 2019 and MYOB v19.x. There are a plethora of versions (different for every year and country), and we have tried it with Canadian, US, UK, Australian and New Zealand. In principle it should work for any jurisdiction. Note that it will not work on FirstEdge or BusinessBasics files.
It will not work on any versions of AccountRight that use the new database format. This appears to be AccountRight 2012 and later.
My MYOB file has heaps of rubbish in the cards and items file. Should I tidy this up first?
Try just sending it through to MoneyWorks. Maintaining your products and names information in MoneyWorks is much, much easier than in MYOB (for example, you can batch delete).
Where does the MoneyWorks file get created?
It will get created in the same directory as your MYOB file, and will have the same name (but a file extension of .moneyworks).
What if I need to do it again?
No trouble — just run it again (but remember that the previous MoneyWorks file will be over-written, so move it or change its name if you want to keep it for some reason).
Why are some of the products in MoneyWorks showing in Red?
The Converter detected that you had dodgy linked account codes (such as a bank account instead of a cost of sales account), so has replaced the code with something more sensible.
Why are some of the accounts and transactions in MoneyWorks showing in Green?
The Converter detected that these involved a foreign currency. The currency handling under MYOB and MoneyWorks is done differently. You will need to add the appropriate currencies into MoneyWorks (at the last exchange rate used in MYOB), and modify the transactions (they are in the dollar value of the foreign currency, not your local currency). For information on multiple currencies in MoneyWorks please refer to the MoneyWorks Manual.
Posted in File Conversion, Resources
Comments Off on Converting from MYOB or AccountEdge
Payroll
We’re often asked why we don’t include a payroll module with MoneyWorks. There are a number of very good reasons why:
- Unlike accounting, payroll is different in every jurisdiction. Thus the payroll that works in Sydney will not be any use in Seattle;
- Different organisations have different payroll requirements, so not having a payroll built in means that you can choose the payroll that best suits your requirements;
- Payroll systems are high support, requiring updates whenever a tax change comes along, which in turns necessitates some sort of annual support fee;
- By not providing payroll, we are able to focus on what we do extremely well (continue to develop MoneyWorks);
- A payroll system will normally generate one payroll transaction per pay cycle, so the benefits of tight integration with your accounting system are questionable.
So with MoneyWorks you are free to choose the payroll that best suits your business. That said, the ones listed below are good starting points—they are all cross-platform (run on Mac and Windows), developed and maintained by professional payroll companies, and interface with MoneyWorks in some form. However if these don’t suit, find another that best meets your special requirements.