Tag Archives: accounting software singapore

Work with lists

Transaction list, product list, name list, account list, enquiry list, historical transaction list within an item are lists in MoneyWorks.

List view is like a spreadsheet, with rows and columns of data. You can sort it by clicking on the column header or search the list by entering your request into the search bar on the top right corner. That’s how MoneyWorks presented the information. Simple and easy.

Customise list

Exchange rate
add an exchange rate field to the list

You can customise the list view, add or remove columns according to your preference. The receivable list, for example, shows the outstanding invoices with transaction currency by default. You can add an exchange rate column to show the rate used for the invoice by customising the list view (got to the Edit menu and follow by Customise List View). From the List View Option windows, highlight the ExchangeRate field from the available field window on the left and click the >Move> button to move it across to the Fields to be Displayed in this List window (on the right).

That’s it! The exchange rate column added to the receivable list.

Heading Field

heading field
add a heading field to the list

The heading is a customisable field available in the list view options window. You can use it to pick up data fields from another table, such as lookup for the category or country field of the name table from sales transaction list. Or you may add a formula (Gross-AmtPaid)/ExchangeRate into the heading field to get the home currency equivalent outstanding amount of the receivable.

fields added to the list
Data field added to the list

MoneyWorks is a powerful small business accounting system, available on both desktop and cloud-based. Sign up a free product demo or download a trial to test drive to find out more.

Multiple locations plug-in for MoneyWorks accounting software

Software: MoneyWorks accounting software

You can transfer and track the stock of each store with the Multiple Locations plug-in for MoneyWorks accounting software. Example, the retailer can do a store to store transfer or view the stock on hand (or stock value) of each item in each store from the item list if he/she has a few stores in the city.

MoneyWorks create a new stock code such as “StockCode/A” or “StockCode/B” to show stock in a different location. The Alpha-numeric code behind the stock code, which representing the stock location, is also recorded in the Category 4 field of the item profile. Hence, to do a stocktake of each store, you can print a stocktake list report with page break by location (Category 4).

multiple-warehouses

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.

stocktake

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!