ORCA Financial developed by TCS Created with Caché
Home Page Solutions Services Company Partnerships Contact Us Site Map  
> Solutions > ORCA Financial Product Overview > Functionality > Reporting > Cash and Banking Reports

Cash and Banking Reports

Bank Deposit Report
Bank Fees Document Report
Cashflow Forecast Report
Cashflow Statement
Cheque Issues Schedule
Cheque Run
Cheques Register
Daily Receipts Summary
Direct Credit Schedule
Direct Debit Payments Report
Direct Debit Schedule
Foreign Exchange Rates Report
Foreign Exchange Schedule
Payments Document Report
Prepayments Document Report
Remittance Advice Report
RePrint Cheques

Bank Deposit Report

The Bank Deposit Report option provides the capability for producing documentation to accompany physical deposits of funds with banking organisations. It incorporates details of individual cheques, e.g. bank codes, drawers and amounts, and summaries of cash and other instruments, e.g. manual VISA dockets, that are lodged in this manner. The title of these schedules is prefixed 'Draft' if the originating documents have not been processed, i.e. updated. View sample report TCSDocuBankDep.

Bank Fees Document Report

The Bank Fees Document Report option provides the capability for producing schedules in regard to the fees and charges levied by banking organisations. The schedules present summary information in regard to document numbers, bank account numbers and names to which fees apply, charge dates and references, and, where applicable, currencies and exchange rates, accompanied by the details of the fee or charge amounts and the ledger accounts against which they have been allocated. The title of the schedules is prefixed 'Draft' if the originating documents have not been processed, i.e. updated. Such schedules are typically produced to enable the verification of proposed amounts against the bank statements from which they have been obtained. View sample reports TCSDocuBankFee, and TCSDocuBankFee-FX.

Cashflow Forecast Report

The Cashflow Forecast option provides the capability for producing financial cashflow forecasts as at nominated dates. Values are derived from the financial and budget transactions that allow for detailed bank transaction analysis and the presentation is typically 'tailored' to individual company (i.e. entity) standards and requirements.

Cashflow Statement

The Cashflow Statement option provides the capability for producing financial cashflow statements as at nominated dates. Values are derived from the defined financial reporting composite structures that accumulate ledger account balances, and the presentation is typically 'tailored' to individual company (i.e. entity) standards and requirements.

Cheque Issues Schedule

The Cheque Issues Schedule option provides the capability for the production of files for effecting the transmission of the details of cheque payments made over a specified time period, as defined in processed (i.e. completed) payments and prepayments documents. The details of cancelled cheques are also included. The file creation, in the format specific to the recipient banking organisation, is accompanied by a control report or prooflist, documenting the cheque details recorded. View sample report TCSChqIssuesSched.

Cheque Run

The Cheque Run option provides the capability for the production of cheques for effecting the remittance of amounts as defined in processed (i.e. completed) payments documents. In addition to cheque printing, this process records the cheque numbers associated with each payment in regard to bank account and payee account transactions. The specific print format is typically 'tailored' to observe both banking organisation and company (i.e. entity) standards and requirements. View sample report TCSChequeFormat.

Cheques Register

The Cheques Register option provides the capability for producing listings of cheques issued, from specified bank accounts and for nominated timespans (i.e. periods) that comprise the traditional 'cheque registers'. In addition to including details of cheque numbers, payees and amounts, they incorporate cheque numbering sequence validations to identify 'missing' items. View sample report TCSBankCheqReg.

Daily Receipts Summary

The Daily Receipts Summary option provides the capability for producing listings of payments received from customers, suppliers and other sources as defined by the control account, date range and format requirements specified. The report details include account numbers and names, account addresses or additional account descriptions as appropriate, and receipted amounts optionally accompanied by receipt document numbers. Additionally, the report content may be restricted to those payers whose account is set to 'Held' status, or those payers with outstanding payment overdue calls recorded. The report may be presented in either account number, account name, account group, business group or location sequence. View sample reports TCSAcctRcptSumm, TCSAcctRcptSumm-Rcpt-Docs, TCSAcctRcptSumm-Held-Only, and TCSAcctRcptSumm-ODue-Only.

Direct Credit Schedule

The Direct Credit Schedule option provides the capability for the production of files for effecting the remittance of amounts as defined in processed (i.e. completed) payments or prepayments documents. This is accompanied by a report documenting the payments to be made. View sample report TCSDirCreditSched.

Direct Debit Payments Report

The Direct Debit Payments Report option provides the capability for producing payments schedules in regard to existing direct debit payments documents. The summary information presented includes document numbers, bank accounts to which payments will be deposited, payment dates, and documentation of the criteria by which payer accounts, e.g. debtor accounts, with balances due for payment have been selected. The details for payers include account numbers, names and addresses, and the total amounts receivable, accompanied by all the individual transactions that constitute those amounts. The report is typically produced as a draft schedule, i.e. prior to document processing, to enable the verification of the proposed payments, e.g. reconciliations to debtor statements. View sample reports TCSDocuPmntDD-Draft, and TCSDocuPmntDD.

Direct Debit Schedule

The Direct Debit Schedule option provides the capability for the production of files for effecting the transmission of the details for the collection of amounts as defined in processed, i.e. 'Complete' status, direct debit payments documents. The file created, in the format specific to the recipient banking organisation, is accompanied by a control report or prooflist, documenting the payments to be received. View sample report TCSDirDebitSched.

Foreign Exchange Rates Report

The Foreign Exchange Rates Report option provides the capability for producing listings of foreign exchange codes and their respective exchange rates on the specified date. All foreign exchange codes defined, and their descriptions, are presented irrespective of whether rates have been maintained for the specified date. View sample report TCSCodeFXRates.

Foreign Exchange Schedule

The Foreign Exchange Schedule option allows the reporting of the exchange rates for up to six foreign exchange codes for a selected date range. View sample report TCSCodeFXSched.

Payments Document Report

The Payments Document Report option provides the capability for producing payments schedules in regard to existing payments documents. The summary information presented includes document numbers, bank accounts from which payments will be made, payment dates, and documentation of the criteria by which payee accounts, e.g. creditor accounts, with balances due for payment have been selected. The details for payees include account numbers, names and addresses, prefixed by company code if an 'inter company' creditor account payment, and the total amounts payable, accompanied by all the individual transactions that constitute those amounts. If a payee is also a customer of the company, then any associated debtor account numbers that have been specified, from either the paying company or other companies, are also listed with their current balances due. The report is typically produced as a draft schedule, i.e. prior to document processing, to enable the verification of the proposed payments, e.g. reconciliations to creditor statements. View sample reports TCSDocuPmnt-Draft, TCSDocuPmnt, TCSDocuPmnt-InterCo, and TCSDocuPmnt-FX.

Prepayments Document Report

The Prepayments Document Report option provides the capability for producing payments schedules in regard to existing prepayment documents. Summary information presented includes document numbers, bank accounts from which payments will be made. Detail for 'payees' includes total amounts payable, and the associated individual transactions that constitute these amounts. This report is typically produced to enable the verification of proposed payments. View sample report TCSDocuPrePmnt.

Remittance Advice Report

The Remittance Advice Report provides the capability for producing payee advices for the payments to be made from specified payments documents. In addition to listing the payment details, this process can optionally record the payment reference associated with each payment in regard to bank account and payee account transactions. The production of remittance advices is preceded by the printing of a summary or control report, listing the payee and payment details and the output type, i.e. print, fax or email, applicable for each. Both the summary report and the remittance advices are presented in the currency in which payment has been effected. View sample reports TCSRemitAdvFormat, TCSRemitSumm, TCSRemitAdvFormat-FX, and TCSRemitSumm-FX.

RePrint Cheques

The RePrint Cheques option provides the capability for reprinting cheques from a previously processed, and previously printed, cheque type payments document. It is applicable where a cheque print run has been 'interrupted' prior to completion (e.g. paper jam, ribbon or printer malfunction) and only the cheques from that point onwards are required to be re-printed. Refer to Cheque Run