Tag Archives: MoneyWorks Singapore

The Salesperson

Software: MoneyWorks accounting software

A salesperson is a representative of a company selling goods and services to the other parties (the client). Often, we measure the productivity of the salesperson by the revenue they bring into the company.

You can use the Salesperson field in MoneyWorks to record the name of the salesperson in charge. Then, use an analysis report to analyse the revenue by each salesperson.

You can learn more about analysis report from the page G-345 of MoneyWorks v7 User Guide.

Below sample is using the source file from Transaction and break down the report into Salesperson, Customer name, and product code (you can change or remove any of the breakdowns which you think is not relevant).


This analysis report shows the quantity, net sales, cost, margin, and margin percentage (you can add or remove any irrelevant columns). Besides, you can also arrange the report in a list, report, or table format.

Analysis report provides a powerful way of extracting information for business decision making. You can create a report which breaks down the product sold by customer, the cost (or income) by a job, the Customer purchases by period, and etc.

The User Guide provides a step-by-step guide to creating an analysis report, try it out!


Stock valuation by location

Software: MoneyWorks accounting software

MoneyWorks accounting software has a free plug-in, Multi-location, which allows you to track inventory from multiple locations, such as inventory in different warehouses, branches, or shops. In our earlier post, we explained how to print a Stocktake List report by the different location, which you have set up in the software. The Multi-locations plug-in adds a “location” extension behind the stock code such as “StockCode/A” or “StockCode/B” and also recorded the “location” in the Category 4 field of the item profile.


The Find by Field function at the Item list allows you to search items by location. For example, to have a product list for location “A”, you can search for Category 4 containing “A”. Once you have prepared the product list of the “location”, highlight these items and print a Stock Valuation report (check the Highlighted Only checkbox in the report setting window).



Financial year-end

Software: MoneyWorks accounting software

Financial Year (aka Fiscal Year) consist of financial periods used to calculate annual income statement for businesses. If you are following the Calendar month, then your financial year-end closing is December.

During financial year-end closing, besides preparing the accounting schedules and post all transactions, you have to do a stocktake, bank reconciliation and set a closing exchange rate.

Do a backup before you start a stocktake process from the command menu of the MoneyWorks accounting software. You have to do the stocktake process before your new financial year. Once the stock count has entered, complete the stocktaking process by activating the Finish Stocktake from the Command menu (ensure dated as the start stocktaking date). Then, print the Stock Valuation Report (usually I will keep a PDF copy as well) and backup your company file.


You should reconcile your banks that are in foreign currency before set the exchange rate for the year-end closing. Once you entered the exchange rate, MoneyWorks will automatically generate unrealised exchange gain/loss journal to adjust the banks, accounts receivable and accounts payable which are in foreign currency.

Backup and lock the period once you have completed the financial year-end closing to prevent other users from recording transaction into the wrong period.

Merry Christmas!