Tag Archives: MoneyWorks

Track inventory from multiple locations

Software: MoneyWorks accounting system

An inventory system helps to monitor stock efficiently. Other than updating the stock on hand, the inventory system takes care of the product costing and value of the inventory when you enter a bill or sales invoice. The system debit (increase) the inventory asset account when goods purchased and credit (reduce) when sold. Although you only record a Sales or Purchase Invoice entry form, the accounting systems which has a built-in inventory system takes care of the accounting entry automatically.

Multiple locations

Besides taking care of the stock movement, MoneyWorks version 8 has multiple location features which monitor the quantity and cost of the inventory from different warehouses (or branches). You decide where to store and pick up the stock from when recording the purchase or sales invoice, and both the stock quantity and value transferred automatically when the stock moved across warehouses (or branches). You no longer need to update the stock manually with a spreadsheet, turn on multiple locations tracking in MoneyWorks and start to monitor the stock from multiple warehouses (or branches).

MoneyWorks gives you a big business capability at an affordable price. Try it out today!

MoneyWorks version 8

MoneyWorks | Desktop & Cloud-based accounting systems for Small Businesses

01_MWv8

Cognito has released MoneyWorks version 8, which is a major upgrade with the improvement such as:

  • Multiple Location / Warehouses
  • Serial/Batch number tracking
  • New database storage format results in smaller data files.
  • More user/custom fields and larger field capacity.
  • Multiple-section forms in forms designer
  • Account security levels and improved privilege control with User Roles
  • Unlimited contacts per Name record

View the full change history at Cognito website.

 

How to use a MoneyWorks filter?

Software: MoneyWorks accounting software

The transactions which you have recorded goes to the respective list. For example, when you record a Sales Invoice, it goes to the Sales invoice list; and a Purchase Invoice goes to the Purchase Invoice list, etc.

The list contains years of data which you have recorded. Use the Search function in MoneyWorks to quickly find the transaction(s) instead of scrolling up and down on the list. For example, you may enter ‘Bronze Widget’ in the Search bar to find any sales invoice which contains the product ‘Bronze Widget’. Search is a great function which allows you to find transaction(s), name or item easily. However, if you need to use the search criteria frequently, then you may consider creating a filter.

A Filter is like a ‘template’ with the search criteria set, activate the filter each time you need to use it instead of re-entering the search condition again. For example, you can use a filter to prepare a transaction list showing the Purchase Invoices from the creditors and Payment for the invoices within a date range.

To create a filter, select Edit Filter from the drop-down list beside the search bar. Then, click the New button at the Filter Function to create a filter.

The Purchase Invoice and Payment are in a different list view, create the filter in the ‘All’ list view to pull the transactions together.

Enter the Search Expression (Search Expr) as:
(Type = “CI@” or Type = “CPC”) and TransDate >= “1/4/2015” and TransDate <= “31/3/2016”

Note: ‘CI’ is a transaction type code of Purchase Invoice and ‘CPC’ is the transaction type code of the cash payment for a creditor invoice. Refer to the MoneyWorks User Guide for more information on Transaction Type Code.

This filter will search for Purchase Invoices and Payment for the invoices from 1 April 2015 to 31 March 2016.

Filter

Enter a name for your filter and set the filter for ‘Current view only’ before you saved the filter.

Use the newly created filter from the ‘All’ list each time you need to search for the Purchase Invoice and Payment of the invoices within the date range set in the filter. Amend the filter if your search condition has changed.

After the list found, click the NameCode column heading to sort the list by the creditor and print the list with subtotal by the NameCode.

Tips:
You can sort two columns by first clicking the column heading of the minor column (first sort), then hold down the Option key (Mac) or the Shift key (Windows) and click the column heading of the major column.

For example, you want to sort the list by the supplier and follow by the transaction date; then, the Transaction Date column is the minor and the NameCode is the major.

Alternatively, you can use the Related function to search for the Purchase Invoices and Payments of the creditor(s).