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 > General Ledger Reports

General Ledger Reports

Balance Sheet Report
Chart of Accounts
Composite Structure
Contract Maintenance Review
Detailed Reporting Code TB
Gift Card Revenue Accruals
GST/VAT Tax Analysis
GST/VAT Tax Review
Journal Document Report
Ledger Allocations Report
Ledger Transaction Report
Ledger Trial Balance Report
Management Commitment Report
Operating Budget Analysis
Operating Forecast Report
Operating Statement Report
Reconciliation Report
Summary Reporting Code TB
Transaction Set Log
Transaction Set Report
Year End Document Report

Balance Sheet Report

The Balance Sheet Report option provides the capability for producing balance sheets as at a nominated date. The values listed 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. The report presents current month values, previous month values, and prior year month values, accompanied by movement values on the summary formats, or percentage changes on the detailed formats. View sample reports TCSBalSheet-Sum, and TCSBalSheet-Det.

Chart of Accounts

The Chart of Accounts option provides the capability for producing selective listings of general ledger account numbers. The listing may be a summary of main or parent accounts only, or a listing of all posting level accounts, and may optionally include fiscal numbers in addition to account numbers, account descriptions, extra account descriptions and trial balance classifications. The listing may also be restricted to selected departments, or profit centres, and may be presented in either number, i.e. account or fiscal, or department sequence. View sample reports TCSLedgChart-Sum, TCSLedgChart-Sum-Fisc, TCSLedgChart-Det, and TCSLedgChart-Det-Dept.

Composite Structure

The Composite Structure option provides the capability for producing listings of financial reporting immediate composite structures, for nominated timespans (i.e. periods), documenting the various accumulative 'levels' established, and respective balances at each level. This information may be supported, if required, by details of the posting level general ledger accounts that are associated with, and contribute balances to the base level composites. View sample reports TCSCompStruct, TCSCompStruct-BGrp, TCSCompStruct-Locn and TCSCompStruct-Dept.

Contract Maintenance Review

TCSLedgContractMtce-Sel-TrnsTCSLEDGCONTRACTMTCEJOBANAL.html">TCSLedgContractMtceJobAnal, and TCSLedgContractMtceInvAnal.

Detailed Reporting Code TB

The Detailed Reporting Code TB option provides the capability for producing general ledger trial balance detailed schedules comprising of the values obtained from the composite accounts established for the required financial reporting ledger account accumulations, accompanied by details of the associated ledger account balances. Values are presented for both 'year to date' and the current month, sequenced and sub-totalled by trial balance codes, and may be produced at main (i.e. company), business group, department, location or operating summary level as required. If cash reporting has been enabled, the values presented may be determined on either standard accrual accounting date principles, or optionally, on cash accounting date principles. Additionally, budget values, accompanied by both amount and percentage variances, may optionally also be included. The report is typically used as a prooflist for checking and reconciliation prior to the printing of the 'formal' financial reports (i.e. operating statements and balance sheets). View sample reports TCSLedgRepTBDet, TCSLedgRepTBDet-BGrp, TCSLedgRepTBDet-Locn, and TCSLedgRepTBDet-Dept.

Gift Card Revenue Accruals

The Gift Card Revenue Accruals provides the ability to report on and generate accruals relating to gift card balances.

GST/VAT Tax Analysis

The GST/VAT Tax Analysis option provides the capability for producing listings of the GST or VAT tax payable and tax receivable ledger accounts over specified time periods, as defined by the company code, date range and format requirements specified. The summary format presents, for each tax category, totals for tax inclusive, tax exclusive and tax amount values, whilst the detailed format lists all the transactions for the selected time period, presenting dates, types and references, source document numbers and dates, customer or supplier account numbers, names and tax numbers as appropriate, and tax inclusive, tax exclusive and tax amount values, sub-totalled by tax category. If multiple company codes have been selected, then the reports are titled as 'Group' presentations, and sub-totals at company level are incorporated within each tax category section. Additionally, where cash reporting has been enabled, the values presented may be determined on either standard accrual accounting date principles, or optionally, on cash accounting date principles. View sample reports TCSAcctTaxAnalysis-Sum, TCSAcctTaxAnalysis-Det, TCSAcctTaxAnalysis-Grp-Sum, and TCSAcctTaxAnalysis-Grp-Det.

GST/VAT Tax Review

The GST/VAT Tax Review option provides the capability for producing listings of the sales, expenses and purchases accounts on which GST or VAT is payable and receivable over specified time periods, as defined by the ledger control accounts, date range and format requirements specified. The report presents, for each account, period balances, the ledger amounts and tax amounts that have originated from sales invoice and purchases invoice transactions, and a 'check' calculation of the tax expected to be payable or receivable. Additionally, tax amounts originating from journals or other documents are also included. The report may be produced at either control account or posting account level, with the accounts sequenced in either account number or tax code order. If cash reporting has been enabled, the values presented may be determined on either standard accrual accounting date principles, or optionally, on cash accounting date principles. View sample reports TCSAcctTaxReview-Acct, and TCSAcctTaxReview-Code.

Journal Document Report

The Journal Document Report option provides the capability for producing selective 'prooflists' of journal documents, as defined by the document number range specified. Details presented include journal numbers and dates, forex parameters, total posting values and document references and narrations, accompanied by the account numbers and names, transaction types, amounts, references, narrations, quantities where applicable, and due dates for each posting entry. Where bin management is in force, multiple bin locations and associated quantities may be incorporated for inventory item accounts. Additionally, lot/serial references are incorporated for inventory item accounts where applicable, analysis account numbers and names are incorporated where job or employee level analysis has been implemented, and company codes are incorporated for inter-company journals. Each journal document is annotated with the created by and last modified by username and time, and the details of subsequent transaction sets once processed. View sample reports TCSDocuJnl, TCSDocuJnl-Analysis, TCSDocuJnl-BMLocns, TCSDocuJnl-LotSerial, TCSDocuJnl-InterCoy, and TCSDocuJnl-FX.

Ledger Allocations Report

The Ledger Allocations Report option provides the capability for producing selective listings of ledger accounts and amounts that are subject to allocation, as defined by the ledger account numbers and date range requirements specified, and the allocation codes defined on those ledger accounts. The report presents ledger account numbers and names, period amounts and the bases for allocation, accompanied by details of the allocated-to accounts and the amounts apportioned to each. The allocated-to accounts may be either other general ledger accounts, or analysis account instances, i.e. employee or job, within ledger accounts. Optionally, journal documents may be generated to process the calculated allocations. View sample reports TCSLedgAllocs-Ledger, and TCSLedgAllocs-Analysis.

Ledger Transaction Report

The Ledger Transaction Report option provides the capability for producing selective listings of general ledger account transaction details, as defined by the department, control account, ledger account number range and ledger account numbers, transaction date range, transaction status, i.e. all or current transactions only, transaction type, i.e. financial, non-financial, budget or fiscal, and format requirements specified. Optionally, transactions at sub-ledger account level may be included, as may transactions at analysis account level, or reporting may be restricted to selected analysis account transactions only. Details listed include account numbers and names, transaction dates, types, references and narrations, originating document details, amounts and cumulative amounts, and account movement totals, may optionally incorporate opening balances on either a full history or current financial year only basis, and may be presented in either account number or fiscal number sequence, optionally within department. If cash reporting has been enabled, the amounts presented may be determined on either standard accrual accounting date principles, or optionally, on cash accounting date principles. View sample reports TCSLedgTrnDet, TCSLedgTrnDet-Dept, TCSLedgTrnDet-SubL, TCSLedgTrnDet-Incl-Anal, TCSLedgTrnDet-Only-Anal, TCSLedgTrnDet-BFwd-All, TCSLedgTrnDet-BFwd-CYear, and TCSLedgTrnDet-Cash.

Ledger Trial Balance Report

The Ledger Trial Balance Report option provides the capability for producing general ledger trial balances as at specified dates, incorporating ledger account numbers and names, and debit and credit account balances as appropriate. The summary report format presents values at 'main' account level, e.g. account 770 Salaries, whilst the detailed format presents values at individual 'posting' account level in regard to ledger accounts, e.g. 770.1010 Salaries - Dept 1010, 770.2010 Salaries - Dept 2010, and control account balances in regard to subsidiary ledgers, e.g. debtors, creditors and inventory. If cash reporting has been enabled, the values presented may be determined on either standard accrual accounting date principles, or optionally, on cash accounting date principles. Additionally, budget values, accompanied by both amount and percentage variances, may optionally also be included. View sample reports TCSLedgTB, TCSLedgTB-Cash, TCSLedgTBBud, TCSLedgTB-Det, TCSLedgTB-Det-Cash, and TCSLedgTBBud-Det.

Management Commitment Report

The Management Commitment Report option provides the capability for producing financial commitments as at a nominated date. Values are derived from the defined financial reporting composite structures that accumulate ledger account balances. Reports may be produced at corporate (i.e. entity) level, or at defined lower levels (i.e. business groups, departments, locations, summaries) as required. The report includes actual expenditure for the year to date and outstanding purchase commitments. The total of these is compared with the budget year to date.

Operating Budget Analysis

The Operating Budget Analysis option provides the capability for producing budget reports to a nominated date. The values listed are derived from the defined financial reporting composite structures that accumulate ledger account balances, and the format typically mirrors the financial operating statement content. The report presents amounts for each month, accompanied by annual totals. View sample reports TCSOpBudget-Sum, and TCSOpBudget-Det.

Operating Forecast Report

The Operating Forecast Report option provides the capability for producing analyses of projected operations to a nominated date. These incorporate a combination of actual and budget values that are derived from the defined financial reporting composite structures that accumulate ledger account balances, and the format typically mirrors the financial operating statement content. The report presents amounts for each month, accompanied by annual totals. View sample reports TCSOpForecast-Sum, and TCSOpForecast-Det.

Operating Statement Report

The Operating Statement Report option provides the capability for producing financial operating statements, e.g. Profit and Loss, as at a nominated date. The values listed are derived from the defined financial reporting composite structures that accumulate ledger account balances, and the presentation is typically 'tailored' to individual company standards and requirements. The reports may be produced at corporate (i.e. entity) level, or at defined lower levels (i.e. business groups, departments, locations) as required and can incorporate both current month and financial year to date values in regard to actual, budget and variance amounts, and associated variance percentages. Optionally, the summary report format may also include a graphical presentation of values. View sample reports TCSOpStmt-Sum, and TCSOpStmt-Det.

Reconciliation Report

The Reconciliation Report option provides the capability for producing schedules documenting account reconciliation activities. Summary pages present reconcilation balances (e.g. bank statements) and ledger account balances as at specified reconciliation dates, and totals of un-reconciled transactions and transactions after the as at date included in the 'reconciled' balances. Accompanying pages provide detailed listings of individual transactions that constitute these respective categories. Report titles are prefixed 'Draft' or 'Account' to identify the status (i.e. new or complete respectively) of reconcilation documents. View sample report TCSDocuRecon.

Summary Reporting Code TB

The Summary Reporting Code TB option provides the capability for producing general ledger trial balance summary schedules comprising of the values obtained from the composite accounts established for the required financial reporting ledger account accumulations. Values are presented for both 'year to date' and the current month, sequenced and sub-totalled by trial balance codes, and may be produced at main (i.e. company), business group, department, location or operating summary level as required. If cash reporting has been enabled, the values presented may be determined on either standard accrual accounting date principles, or optionally, on cash accounting date principles. Additionally, budget values, accompanied by both amount and percentage variances, may optionally also be included. The report is typically used as a prooflist for checking and reconcilation prior to the printing of the 'formal' financial reports (i.e. operating statements and balance sheets). View sample reports TCSLedgRepTBSum, TCSLedgRepTBSum-BGrp, TCSLedgRepTBSum-Locn, and TCSLedgRepTBSum-Dept.

Transaction Set Log

The Transaction Set Log option provides the capability for producing selective analyses of transaction set processing activity, as defined by the transaction set effective date range and transaction set processed date range requirements specified. Transaction set numbers, originating document types and numbers, effective dates, usernames and creation dates and processed dates are presented, sequenced in effective date, processed date or transaction set number order as selected. View sample report TCSDocuTrnLog.

Transaction Set Report

The Transaction Set Report option provides the capability for producing selective listings of transaction set documents, as defined by the document number range specified. Details presented include transaction set numbers, transaction dates and originating document numbers are presented, accompanied by transaction types, account numbers and names, amounts, quantities, references, narrations and due dates for each constituent posting entry. Where bin management is in force, bin locations are incorporated for inventory item accounts, and where applicable, lot/serial references are incorporated for inventory item accounts and analysis account numbers and names are incorporated if job or employee level analysis has been implemented. View sample reports TCSDocuTrn, TCSDocuTrn-Analysis, TCSDocuTrn-BMLocns, TCSDocuTrn-LotSerial, and TCSDocuTrn-FX.

Year End Document Report

The Year End Document Report option provides the capability for producing prooflists of the year end documents that detail the 'closing' entries calculated to achieve financial year end processing of general ledger accounts. Financial year start dates, subsequent financial year start dates, document numbers and refences are presented, accompanied by account number and names, narrations and amounts. It is typically produced to allow for the checking and reconcilation of entries prior to the submission of the document for processing. View sample report TCSDocuYearEnd.