The topics covered in this datasheet include:

Cash Books

Each book is identified by a two character alphanumeric code with a 30 character description and is associated with a company/currency. Multiple cash books can be operated for any company/currency combination. A GL profit centre and control account are assigned with full bank account details. Cash book cheque printing is determined on an individual cash book basis.

Any number of standing orders can be set up for a cash book which are processed at end-of-period for the next period.

Free format notes may be recorded against each cash book.

Dissection Codes

Dissection codes are defined per Cash Book. These are the equivalent to column headings in a manual cash book. An individual transaction can be analysed across an unlimited number of dissections (and thus GL PC/account codes) or the same dissection with a number of different GL codes. Column headings used for reports must be defined to identify the dissection.

Dissection Codes and General Ledger Analysis

For each dissection a GL analysis account and PC can be defined. These codes can be fixed ie. a given dissection is always analysed to the same GL PC/account or can act as the default for data entry purposes. For each dissection code, consolidated or detailed postings can be sent to the GL.

Transaction Types

Transactions types for the Cash Books are defined by the user eg. cheques, bank transfer etc. For integration with other source ledgers eg. DL and CL specific transaction types must be defined. Special transaction types can be specified for entry at reconciliation time eg. FID, bank charges.

Transaction Entry

Manually entered transactions are input in batches. All the transactions in a batch must be either payments or receipts and for a single cash book and currency. A batch can be for the current or next period.

Cheques can be printed from the batches with full payee details which are retained in transaction history for cash books appropriately designated.

Close of Session

The daybook must be printed at the end of each session of transaction entry. The close session function clears the "current session" which maybe a day, a week or a period dependent on transaction volumes.

Open batches are carried forward into the next session.

Bank Reconciliation

On-line matching of cash book transactions can be made to bank statements or to individual statement pages dependent on user choice. Transactions for reconciliation can be accessed in a number of ways for ease of use.

Template programs are available for automatic bank reconciliation facilities against electronically supplied bank statements.

Transactions sourced from the statement can be entered at reconciliation time. Transaction analysis for dissection or GL purposes can be performed at entry time or deferred for processing in transaction entry (transactions entered at bank reconciliation time reside in normal transaction batches for audit purposes.

GL Interface

Cash Manager has a optional automatic, fully audited interface into GL for "on request" or periodic posting.

End of Period

Closes the financial period for the Cash Manager and opens a next period to which transactions may be posted. Standing orders are also processed.

Different companies can have different financial years and periods.

Enquiries

Cash Manager has drill down enquiries on batches and on Cash Books.

Batch enquiries enable the user to view posted and open batches and drill down to the underlying details including dissections, GL Analysis and payee details where pertinent.

Cash Book enquiries offer a similar approach to transaction interrogation with the addition of queries on other Cash Book features including notes, standing orders etc.

Reports

Standard Reports are as follows:

• Batch Print - details of open batches - run before batches are closed.
• Daybook - details of closed batches in current session. Must be printed before end-of-session.
• Trial Balance by Dissection - prints a Trial Balance by dissection code for a selected Cash Book and period. The report contains totals for Period-to-date and Year-to-date receipts and payments for each dissection code. It can be run for previous periods where data has not been purged.
• Trial Balance by GL Analysis - see above.
• General Ledger Transfer Report - details of items posted to the General Ledger
• Cash Book Report - prints details for selected Cash Books and periods. Available for previous period data if this has not been purged.
• Numerous Reports for Bank Reconciliation purposes including unpresented items, reconciled items and Statement Direct items.

Databases

Global 3000 Cash Manager data can be held in a Btrieve format or (to be announced soon) SQL format database for compatibility with industry-standard office automation and data analysis tools.