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 > Accounts Payable Reports

Accounts Payable Reports

Addresses of Creditors
Aged Creditors Report
Creditor Transaction Report
Ctrl Balances for Creditors
Freight Zone Codes Report
Inactive Creditors Report
Investor Reports Generation
Investor Statements Report
Overdue Creditors Report
Top Creditors Report

Addresses of Creditors

The Addresses of Creditors option provides the capability for producing selective listings of creditor names and addresses for accounts within the specified control account. The report content is defined by the account group, business group or location codes optionally specified, and accounts on hold may be included or excluded. The account details may be sequenced numerically, i.e. by account number, or alphabetically, i.e. by alpha key, as required. View sample reports TCSAcctAddr-CR, and TCSAcctAddr-CR-AGrp.

Aged Creditors Report

The Aged Creditors Report option provides the capability for producing creditors aged trial balances as at a specified date. Note that the aged amounts are determined and presented with regard to the period end type, i.e. weekly, fortnightly, four weekly or monthly, defined on the creditor control account. Details listed include account numbers and names, total balances owing and their analysis in terms of periods overdue, and where utilised, account classifications by account group, business group, department and location. Report formats include both ledger summaries and ledger analyses by account group, business group, department or location, with creditors presented in either account number or account name sequence. All report formats may present the standard ORCA ageing of balances, or optionally, an alternate ageing analysis. View sample reports TCSAcctAged-Cred-Sum-Std, TCSAcctAged-Cred-Sum-Alt, TCSAcctAged-Cred-Sum-FX, TCSAcctAged-Cred-AGrp, and TCSAcctAged-Cred-Dept.

Creditor Transaction Report

The Creditor Transaction Report option provides the capability for producing selective listings of creditor account transaction details, as defined by the control account, account group range, account number range, transaction date range, transaction status, i.e. current only or all, transaction type, i.e. financial, non-financial or budget, and format requirements specified. The report details account numbers and names, and transaction dates, types, references, narrations, due dates, match dates, amounts and cumulative amounts, presented in either account number, account name or account group sequence. Optionally, values may be presented in foreign currencies where applicable. View sample reports TCSAcctTrnDet-CR, TCSAcctTrnDet-CR-AGrp, and TCSAcctTrnDet-CR-FX.

Ctrl Balances for Creditors

The Ctrl Balances for Creditors option provides the capability for producing listings of creditor account balances, as at the date specified, for nominated control accounts. The accounts to be reported may be restricted to those with debit balances only. Details listed include account numbers, names and addresses and account balances, and may be sequenced either numerically, i.e. by account number, or alphabetically, i.e. by alpha key, as required. Optionally, forex values may also be included where applicable. View sample reports TCSAcctCtrlBal-CR, TCSAcctCtrlBal-CR-DrBal, and TCSAcctCtrlBal-CR-FX.

Freight Zone Codes Report

The Freight Zone Codes Report option provides the capability for generating listings of the freight zone codes defined within the system, with the option of specifying whether 'open', 'closed' or all occurrences of code 'values' are to be presented. Additionally, the listing may be restricted to selected freight zone codes, and further restricted to a specified freight creditor account to whom the freight zone codes apply. The postcodes allocated to the freight zones may optionally be included in the listing. View sample reports TCSCodeFreightZone, and TCSCodeFreightZone-Postcodes.

Inactive Creditors Report

The Inactive Creditors Report option provides the capability for producing selective listings of supplier accounts on which purchasing and payment activity has concluded, as defined by the control account, account number or account classification code range, as at date, inactive since date, transaction types and format requirements specified. Details listed include supplier account numbers, names and addresses, contact names and contact details, account creation dates, dates, types and amounts of last transactions and account balances, and where utilised, account classifications by account group, business group, department and location. Report formats include both ledger summaries and ledger analyses by account classification code, with creditors sequenced in either account number or account name order, and with sub-totals provided for by account group, by business group, by department and by location selections. View sample reports TCSAcctInactive-CR-Sum, TCSAcctInactive-CR-AGrp, and TCSAcctInactive-CR-Dept.

Investor Reports Generation

The Investor Reports Generation option provides the capability for producing monthly reports for investors in regard to the properties they own, as defined by the control account, investor account, as at date and format requirements specified. The monthly reports 'package' includes covering letters, property statements, other optional attachments, e.g. property occupancy analyses, buyer generated tax invoices in regard to property profits or losses, and aged transaction listings where investor accounts reflect debit balances. The monthly packages may be printed, or alternatively, emailed or faxed to the investors, or their agents, and the production of 'packages' is accompanied by a summary report or prooflist, that details the recipients for whom they have been produced, and incorporates an analysis by output type, i.e. print, fax or email. View sample report TCSCredInvestorPack.

Investor Statements Report

The Investor Statements Report option provides the capability for producing financial operating statements, e.g. revenues and expenses, for investor's properties at a nominated date. The values are derived from the financial reporting composite structure that accumulates the ledger account balances, and the presentation is typically tailored to company requirements. Reports are produced at the analysis account level that identifies the individual property owned by each investor, and may incorporate both current month and financial year to date information in regard to actual, budget, and variance values, optionally accompanied by variance percentages. View sample report TCSLedgInvestorStmt.

Overdue Creditors Report

The Overdue Creditors Report option provides the capability for producing selective listings of creditor balances as at a specified date, defined on the basis of a nominated number of periods overdue and a minimum overdue amount. Note that the aged amounts are determined and presented with regard to the period end type, i.e. weekly, fortnightly, four weekly or monthly, defined on the creditor control account. Details listed include account numbers and names, total account balances and their age analysis by overdue periods, accompanied by the amounts and dates of the last payment remitted. The periodic overdue amounts are analysed in terms of both overdue balance totals and overall ledger totals. Optionally, the listing of overdue payment calls, incorporating account contact details and any associated followup actions, may also be included. The selected accounts may be presented in either account number, account name, total amount due or selective periods overdue amount sequence, and where applicable, analysis by account group, business group, department or location is also available. View sample reports TCSAcctODue-Cred-Sum, TCSAcctODue-Cred-Sum-FX, TCSAcctODue-Cred-Sum-Calls, TCSAcctODue-Cred-AGrp, and TCSAcctODue-Cred-Dept.

Top Creditors Report

The Top Creditors Report option provides the capability for producing selective listings of creditors, as at a nominated date, ranking them by their account balances outstanding, and secondly, by the value of purchases from them. The details listed include account names and addresses, total balances due and their age analysis, purchases values, and percentages of total due and total purchases respectively. Where Excel has been specified as the output type, account balances may be presented in either ORCA standard periods, or alternate ageing periods. View sample report TCSAcctTopSumm-CR.