How to Contra invoices in MoneyWorks

Q: I created an invoice, then receipt for payment. I then wanted to cancel this invoice so I did a REVERSE on the invoice. It now has an outstanding invoice of negative amount. How do I remove/cancel this?

In this case the user now has the original [incorrect] posted invoice with a payment applied to it, the receipt that applied that payment and a manually reversed invoice.

Continue reading

Adding GST and PST to your invoices in BC

If you are using MoneyWorks V6 in BC you will now have to convert back to GST & PST (see previous article) and then add the GST &  PST to your invoices. If you were using MoneyWorks prior to July 1, 2010, you most likely have the appropriate fields on the form, In any case you will either have to modify them or add them to your invoice form using Forms Designer. At the bottom of the invoice you will need the following calculation fields: Continue reading

Setting up new Tax Rate for Quebec in Moneyworks

NOTE: The previous post was incorrect this update hopefully corrects that.

Rate change starting Jan 1, 2013 : As of January 1, 2013, the provincial rate will no longer be applied to federal GST, but it will be increased to 9.975% to compensate.

The existing tax codes in MoneyWorks will record the new tax rates correctly as the resulting tax rate remains the same, e.g. 14.975%

However if the Quebec government decided to change the tax rate in the future, changes would have to made to the MoneyWorks tax codes. So your choice is to do nothing until the next tax rate change or do a change now that will allow you to more easily manage tax rate changes in the future. Your choice.

Read on to see how to make the change now.

Continue reading

Printing Shipping Labels

Q: How can we print shipping labels for our sales orders, we are using MoneyWorks Gold accounting software for Mac?

MoneyWorks Gold and Express allow you to print consignment shipping labels directly from your sales and purchase transactions (receipts, invoices, sales orders etc.) Consignment in this case means recording the number of boxes sequentially on each shipping label e,g, 1 of 4, 2 of 4 etc. The procedure is quite simple, for example: Continue reading

Charging Interest on overdue invoices script

The latest MoneyWorks 6.0.6 update, introduces a new concept of running a MoneyWorks Report as a script.

Basically a Report Script consists of a MoneyWorks custom report that, instead of being installed in the Custom Reports folder, is installed in the Custom Scripts folder. Such a report will appear as an additional command at the bottom of the Command menu.

You can do a lot with a Report Script that you had to previously use something like vbScript (Windows) or AppleScript (Mac), and of course the scripts are platform independent. For example, a Report Script can read a text file, massage it in some way, and then bring the data into your MoneyWorks file as a set of transactions (or customers, jobs etc).

As an example, engineering has created an “Apply Interest” Report Script, which takes the overdue balances in your receivables (either 30+, 60+ or 90+), calculates the interest on these (at a whatever rate you decide), and then optionally creates invoices to charge the overdue customers. Continue reading

Video: How do I modify customer receipts

Q: When my customer makes a payment on an invoice I would like to print a receipt that shows the original items that they purchased.

In MoneyWorks Express and Gold when a customer makes a payment on an outstanding receivables invoice, you create a Receipt transaction coded to that customer and their outstanding invoices appear. When you apply the payment (full or partial) the printed receipt will only show the details it has recorded, the invoice number date amount paid etc., not the detail lines from the original invoice.

However with most things in MoneyWorks you do have options. Continue reading

How do I email a receipt or invoice to my clients directly out of moneyworks?

Q: How do I email a receipt or invoice to my clients directly out of moneyworks?  And how to I link my e-mail that is already set up in apple mail to moneyworks?

There’s really no “link” required.  To send an email directly out of MoneyWorks … for instance an invoice …. after entering the invoice details, click on the Printer icon (bottom right corner of the transaction entry screen) then click on OK. Continue reading

How do I handle Freight Charges

Q:I have several transactions where we need to include the shipping cost as part of the total charge to the customer.  I am currently inputting 2 transactions one by product and one by account so that the shipping charge does not get added to the profit for the sale.  Is it possible to receive money by item and by account on the same transaction?  This does not seem possible, but maybe I am missing something.

In MoneyWorks you can create a Shipping Item Code that can be used to record shipping charges on invoices where you are recording Items. Continue reading