|
- Record could contain;
- cheque number, Date
- Name of payee, Amount of cheque/deposit
- Type of Expense cheque covers, GST included
- Use other fields to create a field - Amount less GST
|
|
- Advantages
- Whilst a spreadsheet is typically used for reconciling cheque books, the advantage of a
database is the ability to code each entry and produce basic financial reports. For
example; List of all cheques related to a particular customer.
- Updating data
New cheques easily added
- Selection data
Show all cheques of a specified type
- Multiple reports
Cheque transaction list, list of cheques sorted by type of purchase, List of deposits.
|