Tag Archives: Singapore

By account or by Item?

Software: MoneyWorks accounting software

You have an option of recording the invoice, payment or receipt transaction either via by account or by item tab. What’s the difference?

itemised product

You use the ‘By Account’ tab to record transactions which charge directly to the GL (general ledger) such as rent, repayment of the loan, purchase of assets, etc.; or some time cost of goods sold when you are not using the accounting software to track the inventory.

Use the ‘By Product’ tab when you itemised the products and services. Itemised product save time in data entry as the item description filled up automatically when using it in the transaction. It’s unlike the ‘By Account’ scenario where you have to type the item description as and when you use it.

It updates the quantity on hand and debits the inventory asset account when the inventory item has purchased, it then debits the cost of goods sold when the sales invoice has posted. It gives a real-time inventory status when the itemised product has used.

It depends on the business requirement whether to use the ‘By Account’ or ‘By item’ tab to enter data. Itemise your product if you want to standardise the product description and better data analysis on the data which you have captured.

MoneyWorks accounting system is suitable for small businesses managing their business finance. Book a demo today to find out how MoneyWorks works for your business.

Import journals into accounting software

Software: MoneyWorks accounting software

You need to have type, date, reference, account, description, and amount field in the spreadsheet when preparing an import file for journal transaction.

For journal transaction, use “Jn” for type field. You can either have the type field in the spreadsheet or preset it in the import MAP. The Date is the date of the journal transaction, which you can either have it in the import file or set it in the import MAP as the date of import.

The account field captured the account code, which has to be the same code you used in MoneyWorks. You do not need to have the account name as it will pick up from the system automatically. The journal memo map to the description field of the detail line and the amount field contains both debit and credit value (with a negative for credit).

Import Journal into accounting software

Import the file from the File menu once you have prepared the spreadsheet. Alternatively, you can save the import MAP if you require to import frequently.

Besides importing journals, you can also import transaction such as Invoices, order, payment or receipt transactions. MoneyWorks is a powerful system which helps an accountant ease the daily accounting task. Book a demo today to find out more about how MoneyWorks helps in managing your business finance.

How to add a memo line in Sales Invoice?

Software: MoneyWorks accounting software

Sometime you may want to insert a note before or after an item when preparing an invoice. It could be delivery information for the driver, project information which you want to show in the invoice, or shipping information such as the port of discharge, port of destination, estimated date of arrival, etc.

You may add an asterisk (*) before an item code, link it to a memo income account (to prevent confusion with the actual sales account), and omit the * item from printing on the invoice form. For example:

Item code: *POD
Name: Port of Discharge:
Sales account: Memo income

asterisk item

Then, apply the below formula on those columns which you want to leave it blank when using an * item in the invoice form, columns such as stock code, quantity, unit price, tax code, and the amount.

Formula sample:

if (Detail.StockCode = “*@”, “”, Detail.StockCode)
or
if (Detail.StockCode = “*@”, “”, Detail.UnitPrice)

form design

In this way, only the description column prints the information which you have entered in the detail description column.

Print Invoice

Consult your MoneyWorks consultant if you need help in designing forms.

 

Reference: MoneyWorks User Guide, Form Design.