Category Archives: Accounting Software Singapore

0-day payment term

Software: MoneyWorks accounting software

When you set the payment term for a customer as ‘0’ (zero) day in the Debtor control, it will print on the invoice as ‘0’ day as default if the Term field has added to the form template. The Invoice due date is calculated based on the value set in the Term field of the name profile, therefore only numeric is acceptable. For example, when you issued an invoice dated as 1st January and the Term set is ‘Within Days 30’, the due date of the invoice will be 31st January.

Although you cannot change the field setting, you can modify the print. An ‘if()’ function can be added to the invoice template if you prefer to name the payment term as instant, immediate, C.0.D. (Cash on Delivery), etc. instead of ‘0-days’ when printed.

Let’s say you prefer ‘immediate’ than 0-day, then add an if() into the payment term field from the form designer:

if (Name.DebtorTerms = “0”, “Immediate”, Name.DebtorTerms + ” Days”)

Payment Term

The above will tell MoneyWorks to print the term as ‘immediate’ if the term set in the name profile is ‘0’, or else print as the value set in the term field and add the text ‘ Days” behind it. In short, MoneyWorks will print as ‘immediate’ if the term is ‘0’ and ’30 Days” if the term is 30.

There are sample forms available which you can use or amend to suit your business. You can also create a new one from the File menu. Refer to the Forms Designer chapter on MoneyWorks User Guide to learn more about form design or get a Consultant to design a form for you.



How to use the Price Level in QuickBooks?

Software: QuickBooks Desktop accounting software

You can pre-set a discount level, either by a fixed percentage or per item basis, for each customer with the QuickBooks Price Level feature. QuickBooks Price Level feature help to ease the data entry if you are giving special pricing to the regular customer.

Fixed Percentage Price Level Type:

Select the Price Level List from the Lists menu, then click the Price Level button at the bottom of the screen and follow by New to add a new price level type into the list. Set the price level type as ‘Fixed %’ and the percentage to decrease accordingly, such as 10% or 20%.

QuickBooks Fixed Percentage Price Level

Next, add the price level which you have just created to the Customer who enjoys the discount.

QuickBooks Customer

Whenever you create a Sales Invoice for this customer, the unit price will always show the discounted price.

Per Item Price Level Type:

Besides fixed percentage price level, you can give a different price based on per item basis. That is, each customer can have a different item price. For example, the retail price for item A is $100; you sell to Customer123 at $88 and Customer456 at $83. Item B which is also $100, but you sell to Customer123 at $90 and Customer456 at $100 (no discount). Per Item price level comes in handy since fixed percentage discount will not work in this case.

QuickBooks Per Item Price Level

You need to change the price level type to ‘Per Item’ and set the Custom price for each item, and then link it to the customer.

Although price level is useful, there is a limitation. You can only set up to 100 different price levels at this moment. Besides, it seems to have a problem exporting ‘Per Item’ Price Level list when you try to use the same list for another company file.

Discuss with your QuickBooks Consultant if you are not sure how to implement Price Level for your company.


An accounting software with batch and expiry date tracking

Software: MoneyWorks accounting software

You will want to sell off those products which have an earlier expiry date or belong to an early batch if you are in a food-related or medical-related business. Hence, indicate the batch number in Sales Invoice or Pick List is important to you.

MoneyWorks accounting software version 8 comes with the batch number and expiry date tracking feature which helps to track the batch number of the product in invoices and stock on hand. This feature can be turned on from the Document Preferences (under the Data Entry tab of the Edit menu) and then set those products that require tracking the batch or expiry date individually. Once the tracking has turned on, you can enter the batch number and expiry date of the product in the purchase invoice and select the relevant batch when creating a sales invoice.

Batch number preferences

You can also consider using batch number tracking if you are in renovation material business such as supplying of the curtain, tiles, carpet, etc. Although the tiles from different batches have a similar pattern and color, the tone may vary. Using tiles from a different batch side by side in the same room may look odd.

Batch number on invoices

Batch tracking is useful, download a trial version now to test it out or sign up a demo* here. Alternatively, you may discuss with a MoneyWorks consultant on implementing MoneyWorks for your business.

Besides supporting Windows and macOS, MoneyWorks can also install on a private Cloud Server which you can share data across different offices.


*The demo is available in Singapore only.