Answers
© EWP Go to www.emilewoolfpublishing.com for Q/As, Notes & Study Guides 429
Hash totals (e.g. the total of all credit limits and key fields (if
numeric)) may be calculated to check the completeness and accuracy
of input.
Customer details should be input to the computer. The data on the
computer should be saved regularly during this process, and a
printout obtained.
The printout should be agreed back to the manual listing of
customers, preferably by a person who is not responsible for the
input of data. Any errors found should be marked and amendments
made to the computer files.
When all the customer details have been entered, the computer can
generate the hash totals of credit limits and account references. These
should be agreed back to the manual totals. If there are differences
then the reason for the difference should be ascertained by checking
the computer files to the manual listing in detail.
Full back up copies of the complete customer file should be taken,
and one copy always kept in a secure location, away from the
computer.
(ii) Price list
The input of price list details is very similar to that of customer details.
A manual list of products and prices is prepared.
A key field is determined and hash totals calculated.
A list of products is approved by Mr Pivo.
Products are input to the computer with frequent back-ups and
printouts produced of the items input.
Printouts agreed to the manual list, and hash totals agreed to
manually calculated hash totals.
Independent person agrees accuracy of transfer of product details.
(iii) Sales ledger balances
The date of the transfer of balances must be decided in advance.
On this date a manual list of the sales ledger balances should be
taken, and reconciled to the sales ledger control account.
Any differences in the above reconciliation should be investigated
and the final listing produced.
If only the balances are to be input to the computer system, then the
list can be input, and the total generated by the computer of all
balances agreed to the manual list. Any differences should be
investigated and the totals finally agreed.
Pivo may wish to input details of the invoices making up the
individual sales ledger balances. In this case each balance will have a
sublisting of invoices. Input will be the total as above, and then the
supporting invoices for each ledger account. A print out of all
balances and totals should be agreed to the manual listing and any
errors corrected.