"When we arrived at GIS we found that the systems were in disarray. There were no systems procedures, manuals and a general lack of knowledge in regard to the day-to-day maintenance of any system. Users were trained by other users and my understanding is that due to many personality conflicts in the organisation, there was a turnover of 16 accounts staff in the 12 months prior to our appointment. As there were no written procedures, the training of staff lacked somewhat.
The Accounting system provides for a standard General Ledger structure with a ledger and sub-ledgers for debtors and creditors. This means that "one-sided" journals are an acceptable practice. It also means that without constant trial balances, the system does not necessarily balance with itself. (NOTE: These balances were not being carried out regularly). Profit and Loss statements also include the movement in "Work in Progress" which seems to be 'pulled out of the air'.
During the years of use of the CBA system, many duplicate debtor and creditor accounts have been created due to user error and the balances in these accounts cannot be reconciled with any level of confidence. This is often due to a liability being accrued in one customer account and paid for in another or a debtor payment being credited to the wrong account or the wrong period (the future) which causes an incorrect balance for the period being reconciled.
The payroll system utilizes a piece of software called 'Micro-pay' and as this software is not dynamically linked to the accounting system it means that at the end of a pay period, the accrued Prescribed Payment accounts are manually re-keyed into the CBA accounting system. There is a flaw in the accounting system which means that if anyone happened to be in the accounts payable area whilst the payroll was being batched through, a simple press of the key can wipe out all pending creditors or make then appear as paid in the future.
It is also feasible to manually alter the database to remove certain transactions. The debtor's database does not contain a current balance field for each customer and summing the debtor transactions generates a customers debt owing. This would be acceptable, however the system also allows for a transaction set to be removed once the debt has been paid. This was common practice before we arrived and certainly opens the possibility of fraud being committed against the company (or contra set-offs) by anyone who knew this.
Invoices are only generated monthly which reduces the company's cashflow position. There also seems to have been no reconciliation of the timesheets to the payroll system, which means that there is no guarantee that all costs are being recovered in the operation.
As timesheets were being transcribed manually onto spreadsheets, we have seen many transcription errors as well as overlap in dates and times worked.
There was no system backup for any data created in the personal computer environment and no security within the office for confidential documentation. All drives on PC's were shared to all others. There are also many pirate copies of software being used in the office.
CHANGES SINCE ADMINISTRATION
To resolve some of these issues, we have made many alterations to the systems in the office. Our brief was to make the systems stable and provide reliable information, create system backups and security, standardise whatever method of operation we could, at minimal possible cost.
To do this we did the following:
A Software audit was started to determine the depth of Software piracy and to resolve this issue by buying or removing the software for/from the PC's.
We stabilised the existing PC and terminal environment to allow continued operation by the staff at the site.
We assessed the needs of the Administration in relation to information and wrote extract procedures to retrieve data from the existing Accounting system.
A file server (using existing hardware and software) was created in the Como office and backup and security groups were created to maintain a level of security of data in the organisation. Data from all available machines was consolidated and a daily backup is now performed and stored off-site (The same methodology is now being adopted at Kalgoorlie office).
M.Y.O.B. was installed, initially as a stand-alone piece of software to capture the purchase orders for the administration and subsequently we networked it on a multi-user version to do the billing at Como and Kalgoorlie. As a result, billing can now be done daily to increase cashflow. (We recognise that the software being used does not provide a long or medium solution to the systems needs at GIS, but they do offer a cheap short-term solution).
Data transfer is now occurring on a daily basis to ensure that we can provide a daily P&L position. (NOTE: This is an incremental process and will need time to complete).