Tag Archives: Desktop accounting software

Year-end stocktaking

Software: MoneyWorks accounting software

A stocktake is a physical count of your inventoried items and is necessary on a periodic basis, no matter how careful you are, the actual stock on hand may differ from the record in MoneyWorks accounting software.

The steps taken are:

  • Enter and post all stock related transactions in MoneyWorks.
  • Backup company file.
  • Click the start stocktake process button.
  • Print the stocktake list report from the reports menu for the physical stock count.
  • Enter the stock count into the count column.
  • Highlight all the items and click the finish stocktake button to finalise the stocktake.
  • Print the stock valuation report.
  • Lock up the financial period.

MoneyWorks create a snapshot of the current stock on hand once you clicked the start stocktake process button. Any stock related transaction posted after the start stocktake process will not affect the snapshot quantity, and the calculation of the quantity differences are between the quantity count and snapshot. It’s important to hit the start stocktake button on or before the financial year-end to allow the accounting software to capture an accurate quantity on hand, although you may not enter the count quantity immediately.

stocktake

MoneyWorks will prompt to record a stock journal once you have finished the stocktaking, it will debit/credit from the inventory asset to the stock adjustment account stated in the journal. Then, print a stock valuation report and lock the financial period after completing the stocktake.

Stocktaking is an important process, consult your MoneyWorks consultant if you have doubt.
Reference: page 348 of the MoneyWorks version 8 User Guide, Stocktaking

 

 

MoneyWorks accounting software update version 8.1.5

Cognito has released MoneyWorks version 8.1.5 update. The complete change history (a list the bug fixes and improvements) of version 8.1.5 is available at Cognito website.

A project-based business may consider using the job tagging feature in MoneyWorks to track the profitability of each job. You can tag a job code to the income and expenses, and then use the new job allocation report which comes with the new 8.1.5 update to serve as cost control and monitor the profitability.

For a non-profit organisation such as charities and schools may use job tagging feature to track project like upgrading facilities or social works, and use the job allocation report to monitor how they have used the fund which given by the parent or government body.

Check with your MoneyWorks consultant on how to use the job tagging feature for your organisation.

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.