Why are my MoneyWorks transactions posted in the wrong period

Why can’t we have current payments show up in the ‘Current Year’ category.  They can only be viewed under ‘The Previous Year’ category.   We have tried to change it to ‘Current Year’ but are unable to find directions for doing so.

Continue reading

How is the MoneyWorks Purchase Order default setup

Another common question from new users from who I received two this month, is about how MoneyWorks records ship to addresses on purchase orders and records  part numbers being ordered.


Q: I am confused about how MoneyWorks adds the shipping address to the Purchase Order I send to the supplier. Sometimes I need them to ship to a special address. And they also want me to use their part numbers, which totally messes up my Item coding system.


Continue reading

Job Costing example Tracking employee hours against jobs

Q: My company installs doors. windows etc. and has two employees, George Smith & Larry Jones. I pay them a monthly salary.
However some of their duties include installing doors & windows as well as doing service calls.
I want to track their hours against the various jobs,  but I do not want to record their installation hours against the GL as it would represent a double entry when I issued their monthly check/cheque.

Continue reading

Applying multiple suppliers to an open PO

Q: I have an open PO that I want to process multiple receivings’, with different supplier invoices against this open PO. How do I do that please?

Process the PO as Receive goods with Invoice {green Arrow} > Enter the Qty received for the first supplier > Click the OK button and the Order Processing window opens Assign the invoice no. and uncheck the Post Check Box. > Click Process….

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

How do I process drop shipments from Suppliers

Q: How do we track inventory when our suppliers ship direct to our customers. We would like to enter the order from the customer and have that become the order for the supplier but our inventory is always messed up.

If you want to manage inventory, tracking stock on hand etc., you have to record the sales by item number and you have to record the receiving of those items, even if they have never physically entered your warehouse, as in the case of your supplier shipping the goods directly to your customer.

However, using Gold or Datacentre you only have to enter the details of the order once. It starts by assigning the Usual Supplier to the Item Records…. Continue reading

Finding Cancelled Transactions

Q: We are a transaction intensive company.  I have about 400 transactions that were posted but have been cancelled and corrected. The problem is that the cancelled transaction looks exactly the same as the corrected one so  need to look up each transaction and then determine which one is correct.  Before I start doing that, I want to be sure this is the ONLY way to get this done.

The status or state of transactions (Receipts, Payments, Invoices etc.) is shown when you click on the Blue Info button of the transaction. Continue reading

Video, applying credit notes to invoices

Credit Notes are negative sales invoices, where you owe a customer for returned products etc. Likewise a Credit Note could be a negative supplier invoice where a supplier owes you money for products you may have returned for credit.

In the quick video below we have created a credit note for a customer who has returned goods and then applied that credit note to an outstanding receivable invoice that a customer still owes, using the Adjust > Contra option. Continue reading