CashBook

CashBook Menu

CashBook can be run stand-alone or integrated to Signet's General Ledger, Creditors and Debtors systems, and is designed to record, report, and graphically present data on your bank account transactions.

Multiple Bank Accounts can be maintained (limited only by your available disk space).

In order to facilitate detailed allocation of your transactions, CashBook allows you to allocate each transaction to an Allocation Code. The allocation code is 50 characters long, allowing extreme flexibility in analysing where you are earning and spending your money.

This Allocation code is used as the General Ledger account code. If you are not linked to the General Ledger, these same codes can still be used, and later converted to GL account codes when you decide to link.

A full reconciliation feature is incorporated to allow accurate comparison to your bank statement.

Debit orders can be entered into CashBook, and are thereafter posted automatically each month (after confirmation).

CashBook also allows the management of Sub Ledgers. This facility allows you to separately track transactions for your Petty Cash or Credit Cards, with consolidated transactions being transferred to the main bank account. 


Transaction Details

Each transaction comprises the following:

  • Type (Cheque / Deposit / Sundry Payment / Sundry Receipt / Debit Order / Bank Charges / Electronic Payment / Electronic Receipt / Bank Charges).
  • Date of transaction.
  • Reference Number (e.g. Cheque No).
  • Description.
  • Amount.
  • Cleared from Bank (Yes/No).
  • Clearance Date.

Reconciliation is done on screen, directly from the bank statement. This same screen also allows you to calculate the balance after ANY transaction.

In addition, the transactions can be viewed on screen in any of the following sequences:

  • Clearance Date (for reconciliation)
  • Reference Number (for finding particular transactions by reference number)
  • Description (for finding all transaction pertaining to a particular concept e.g. Telkom)
  • Transaction Date (to see transactions in chronological order)


Allocation

Each transaction can optionally be allocated to one or more allocation codes.

CashBook allows you to perform split postings (i.e. the amount of the transaction could be split to several allocation codes). An unlimited number of separate allocation codes can be entered per transaction.


Sub Ledgers

CashBook allows you to create any number of Sub Ledgers against any Bank Account.

This is useful for:

  • Petty Cash - Create a Sub Ledger for your Petty Cash, with only a few transactions going through to the main Bank Account each month. Detailed amount allocation can still be done in the Petty Cash if you require.
  • Credit Card management - Create a Sub Ledger to keep tabs on a Credit Card account. Once again, detailed amount allocation can be done in the Credit Card, with summaries being posted to the main Bank Account.


Reporting

CashBook features the following reports:

  • Summary Report - Provides a summary of the current Account status.
  • Position Report - Prints the account cash position.
  • Reconciliation Report - After entry of the bank statement balance, prints a report detailing the current CashBook balance, uncleared debits and credits, and the variance from the actual bank balance.
  • Transaction Report - All, Cleared, or Uncleared transactions can be printed, with either the transactions only, or including the allocation thereof.
  • Detailed Allocation Report - Lists (in allocation code order) transactions over a given period.
  • Allocation Summary Report - Gives a summary report of transactions, totalled by allocation code.
  • Account Listing Report - Lists all of your bank accounts.
  • Analysis Code Listing Report - Prints all analysis codes, with total figures over the past twelve months. After twelve months, the first amount is dropped, and a new month added at the end of the list.
  • Debit Order Listing Report - All current debit orders are printed on this report.
  • Missing Transaction Numbers Report - Lists all missing and duplicated transaction numbers (for instance cheque numbers).
  • Sub Ledger Transaction Listing Report - Lists the transactions in a Sub-Ledger (optionally by a date range).

CashBook allows all of the above reports to be directed to the Screen, Printer, a Disk file, or the Windows Clipboard for pasting into other Windows applications.

Also, each report can be requested over a specific period only (using a start and end date).

Cheques can be printed, with the actual layout of the cheque being under your control.

A Graphics facility allows you to examine your data in a graphical format (bar chart, pie chart, line chart, etc).