Tag Archives: Small Business Accounting Software

How to create a Pick List in accounting software?

Software: MoneyWorks accounting software

A Pick List is a document for the store person at the warehouse to gather the products and get ready for delivery.

Pick-to-Order method

The Pick List looks more like an invoice (or a delivery order) if you adopt Pick-to-Order method. The store person carries the Pick List going around the warehouse picking up the items shown on the list. This method is commonly used by project business when there is a lot of products require to fulfil in one order, or like those pickers at the supermarket pushing the shopping cart around picking up items fulfilling the online sales order.

Batch Picking method

Another method is batch picking, a summary showing the total quantity needed for each item. This method allows the store person to pick up the required stock quantity for each item without going round and round the warehouse. Then, gather the items at the holding area and sort it out according to invoice, vehicle, or delivery person.

Most of the store person prefer method two than one, I think. Pick-to-order method requires more muscle, your legs may feel like two pieces of rubber extended from your torso after hours and hours of walking in the warehouse. Guess this is not a very favourable slimming program for some 🙂

Create a Batch Pick List

So, how to create a batch Pick List?

You can consider using the built-in report writer to build a report for Pick List if you are enthusiastic in coding or like to have more information printed; if not, an analysis report is good to go.

I amended the User 2 field label in the transaction screen to Deliver By, which allow me to enter vehicle number such as Van1 or Van2, etc. in my illustration.

MoneyWorks Sales Invoice transaction

From the File menu, select New Analysis from the New sub-menu to launch the analysis wizard. I use analysis by Transactions since my information is from the sales transaction.

Analysis report

I breakdown the report into two levels, subtotal by the User2 (Vehicle number) and follow by Product Code. Remove all the unwanted columns and keep only the quantity field. You can arrange your analysis as a report or list format (for my case, I leave it as report format). Lastly, don’t forget to save, sign and upload the report to the respective user. That’s it.

Sales transaction list

Highlight the invoices you need, then select the Pick List report to print. Send the Pick List together with the invoices or delivery order to the warehouse for them to gather the items and arrange for delivery.

Analysis report

Small businesses may not have the luxury for a warehouse automation system, depending on the business requirement, but a batch picking list does help in productivity.

Sign up a demo if you like to know more about MoneyWorks accounting system.

Learn computerised accounting

Of course, you can!

I guess the School may have adopted some accounting software to teach computerised accounting. However, for students who like to try out MoneyWorks Cashbook can go ahead and sign up a copy (Free Subscription).

Cashbook should be enough if the paper is mainly on journals. However, you can download a trial version for MoneyWorks Express to try out invoicing (Accounts Receivable and Accounts Payable) or even a MoneyWorks Gold to test drive multiple currencies and inventory modules such as assembly or multi-warehouses. 

More information on scripting, API, integration, automation, form design, and report writing is available at the developer site and the user guide.

Scripting
Scripting

Trial version is free. There is no time limit on the software but on the data file which you created is up to 45-days (or 99 opens, whichever comes first). You can create another data file (company file) and have a fresh 45-days after the existing data file has expired.

You can pull up the PDF user guide from the Help menu after you have installed MoneyWorks. To kick start,

  1. To create a new data file (company file). Go to the File menu > New > New MoneyWorks Document.
  2. To add or edit accounts list (Chart of accounts). Go to Show menu > Accounts (click New to add an account).
  3. To add a transaction (such as invoice or journal). Go to the Show menu > Transactions (then, click the New button to add)
  4. To post the recorded transactions (record into the ledger). Go to the Show menu > Unposted section at the left panel > go to the Edit menu, select the Select All feature, and click the Post button to post the highlighted transactions.
  5. Ledger report. Go to Reports menu > Audit > Ledger report.

Okay, this should be enough for you to digest. Have fun 🙂

Cash-basis free accounting software

Software: MoneyWorks Cashbook

MoneyWorks Cashbook is an entry-level accounting software by Cognito. It’s an elegant cash-basis accounting system with a free subscription; suitable for self-employed, small businesses, clubs, societies, and non-profit organisation (Check with your accountant or IRAS whether you are qualified for cash-basis accounting).

MoneyWorks Cashbook is a fully functional cash-basis accounting software; it’s FREE.

Being self-employed, you are supposed to have proper records of your income and operational expenses. It’s easier (accountability and traceability) to prepare the Statement of Accounts and extract the relevant figures for the 4-line Statement with an accounting software than using a spreadsheet.

MoneyWorks Cashbook - Free Cash-basis accounting software

Cashbook comes with Payment, Receipt, and General Journal features; suffice for recording payment out to the supplier, inflow of funds or revenue generated from sales of products and services, and journal adjustment during month-end or year-end closing.

You can start with Cashbook (which is free) when the I.T. budget is tight and then move on to an accrual basis accounting system like Express or MoneyWorks Now when the business grows.

Download a fully functional trial version or sign up a demo if you like to take a look on other option available such as MoneyWorks Express or Gold version.