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 Receivable Reports

Accounts Receivable Reports

Addresses of Debtors
Aged Debtors Report
Back Orders Advice
Billing Forecast
Credit Limit Letters
Credit Status Review
Ctrl Balances for Debtors
Customer Exchange Deposits
Customer Margin Analysis
Customer Sales Analysis
Debtor Transaction Report
Dishonoured Payments Report
Inactive Debtors Report
Item Sales History
Item Sales Report
Missed Sales Opportunities
Overdue Debtors Letters
Overdue Debtors Report
Pricing for Debtors
Sales History
Special Price Analysis
Statements Report
Stockists Buying Analysis
Top Debtors Report
Unallocated Credits Report

Addresses of Debtors

The Addresses of Debtors option provides the capability for producing selective listings of debtor names and addresses for accounts within the specified control account. The report content is defined by the account group, business group, location or salesperson 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-DR, TCSAcctAddr-DR-AGrp, and TCSAcctAddr-DR-Locn.

Aged Debtors Report

The Aged Debtors Report option provides the capability for producing debtors 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 debtor control account. Details listed include account numbers and names, credit days, total balances due and their age 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 and location, with debtors 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-Debt-Sum-Std, TCSAcctAged-Debt-Sum-Alt, TCSAcctAged-Debt-Sum-FX, TCSAcctAged-Debt-AGrp, and TCSAcctAged-Debt-Locn.

Back Orders Advice

The Back Orders Advice option provides the capability for producing customer advices in regard to sales orders outstanding due to stock unavailability. The warehouses on which sales orders have been placed, and the warehouses from which available stock is determined, may be separately specified to enable customer advices to be suppressed where available stock is imminent, e.g. held separately awaiting completion of a quality assurance process. Optionally, orders subject to credit hold may be included or excluded from the advices. The advice details include debtor account numbers, names and addresses, accompanied by order references and dates, inventory item codes and descriptions, order quantities and anticipated availability dates. The production of back order advices is preceded by the printing of a summary or control report, listing the customer and outstanding order details, and the output type, i.e. print, fax or email, applicable for each. Alternatively, the summary report may be produced as an action list, identifying all orders that may now be despatched. View sample reports TCSDebtBOrd-Excl-CrHold, TCSDebtBOrd-Incl-CrHold, TCSDebtBOrdAdvFormat-Stock, TCSDebtBOrdAdvFormat-Credit, and TCSDebtBOrd-Action.

Billing Forecast

The Billing Forecast option provides the capability to report any sales orders for a customer on which all order lines have not been invoiced and the invoice paid. The Report is a forward scan, i.e. 'Due by ' amounts are order line values due to be billed in the first period following the report date. The period sizes are variable, e.g. monthly, quarterly. The report may be for local or customer currency.

Credit Limit Letters

The "Credit Limit Letters option provides the capability for producing selective listings of debtor credit limit letters. Actual wording of each letter is specified in the report and can be tailored to suit any site requirements.

Credit Status Review

The Credit Status Review option provides the capability for producing selective listings of debtor balances and credit control limits as defined by the control account, account group, business group, location and 'as at' date requirements specified. The content may be restricted to an exception review of customer balances exceeding both minimum values and credit limits, or alternatively, a full report of all customers may be produced. The summary format includes debtor account numbers, names and addresses, contact telephone numbers, credit limits and account balances accompanied by selectable period overdue debt, whilst the detailed format includes contact names and email addresses, and current and overdue debt analysis. Both formats may be presented in either account number, account name, account group, business group or location sequence. View sample reports TCSDebtCredStatus-Full-Sum, TCSDebtCredStatus-Full-Det, TCSDebtCredStatus-Excp-Sum, and TCSDebtCredStatus-Excp-Det.

Ctrl Balances for Debtors

The Ctrl Balances for Debtors option provides the capability for producing listings of debtor account balances, as at the date specified, for nominated control accounts. The accounts to be reported may be restricted to those with credit 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-DR, TCSAcctCtrlBal-DR-CrBal, and TCSAcctCtrlBal-DR-FX.

Customer Exchange Deposits

The Customer Exchange Deposits option provides the capability for producing selective listings of customer activity in regard to inventory items to which exchange deposits, or core charges, apply, as defined by the debtor control account and account number range, deposit item inventory control account and format requirements specified. The summary format presents customer account numbers and names, and deposit item codes, descriptions and quantities. The detailed format presents the summary data, accompanied by the date, document number and quantity associated with each deposit charge or exchange return. All deposit items may be reported, or only those for which an exchange return is due, i.e. outstanding. View sample reports TCSDebtInvDeposits-Sum-Due, and TCSDebtInvDeposits-Det-All.

Customer Margin Analysis

The Customer Margin Analysis option provides the capability for producing selective analyses of the profitability of sales to customers as defined by the company, location, related account, date range and format requirements specified. A 'customer' may be either a debtor account, or a related account identifier maintained within and across companies. The analysis may be produced across multiple companies to provide 'group' level reporting. The summary report presents revenue values, gross margin values and margin percentages, for sales invoices, job invoices and in total, for the selected customers or specified number of customers, ranked in either descending, i.e. top nn, or descending, i.e. bottom nn, sequence. The supporting detail report, produced for each selected company, may otionally include the individual sell-to debtor accounts from which the summarised values for related accounts have been accumulated. View sample reports TCSDebtMargin-Revenue, and TCSDebtMargin-Margin.

Customer Sales Analysis

The Customer Sales Analysis option provides the capability for producing selective analyses of sales to customers over nominated time periods, as defined by the control account, department, related account, account group range, account number range and account number, date range, and format requirements specified. Optionally, ledger items may also be included, or the analysis may be restricted to sales credits, i.e. credit notes, only. The summary format presents customer account numbers, names and addresses, and total quantities, total sales values, total cost values and percentage margins, accompanied by total quantities and values for each item, or alternatively, item group totals or franchise totals only for corresponding analyse by selections. The detailed format incorporates the summary information, accompanied by per sale data regarding invoice numbers and dates, item codes and descriptions, quantities and values, prefaced by item group totals or franchise totals for corresponding analyse by selections. Both formats may be presented with debtors in either account number, account name, department, account group or related account sequence, with item details listed in either item number, item group or franchise order. Additionally, a summary page may also be optionally produced, presenting overall totals by inventory item, group or franchise, for all the customers selected for reporting. View sample reports TCSDebtSalesAnalysis-Sum-Alpha-Itm, TCSDebtSalesAnalysis-Sum-RelId-Grp, TCSDebtSalesAnalysis-Sum-Dept-Frn-Incl-Sum-Page, TCSDebtSalesAnalysis-Det-Alpha-Itm, TCSDebtSalesAnalysis-Det-RelId-Grp, and TCSDebtSalesAnalysis-Det-AGrp-Frn-Incl-Sum-Page.

Debtor Transaction Report

The Debtor Transaction Report option provides the capability for producing selective listings of debtor account transaction details, as defined by the control account, 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 or account name sequence. Optionally, values may be presented in foreign currencies where applicable. View sample reports TCSAcctTrnDet-DR, and TCSAcctTrnDet-DR-FX.

Dishonoured Payments Report

The Dishonoured Payments Report option provides the capability for producing selective listings of customers with a history of dishonoured payments as defined by the control account, account group, business group, location, transaction start date, as at date and format requirements specified. The report includes debtor account numbers and names, credit limits and account balances, accompanied by the dates, references, narrations and amounts of dishonoured payment transactions, and may be presented in either account name, account number, account group, business group or location sequence. View sample report TCSDebtDisPmnt.

Inactive Debtors Report

The Inactive Debtors Report option provides the capability for producing selective listings of customer accounts on which sales and receipting 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 customer 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 debtors 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-DR-Sum, TCSAcctInactive-DR-AGrp, and TCSAcctInactive-DR-Locn.

Item Sales History

The Item Sales History option provides the capability for analysing customer sales history at product level to a nominated date, as defined by the debtor control account, related account, account group, location, account number range and account numbers, the inventory warehouse, franchise, item account group range and account number range, and the as at date and format requirements specified. The detailed format lists customer account numbers, names and addresses, item codes, descriptions and units, and twelve selectable periods, i.e. monthly, two-monthly, quarterly, six-monthly or annual, of either item sales quantities or item sales values, accompanied by all periods totals. The quantities or values reported may include or exclude job issues where the customer is the primary charge-to account, and may be presented with customers in either account number, account name, related account, account group or location order, and with inventory items in either item number, item group or franchise sequence. Optionally, a summary format presenting customer level quantities or values only, or a totals format presenting order by instance quantities or values only, may also be produced. View sample reports TCSDebtItemSalesHist-Tot-AGrp-Qty, TCSDebtItemSalesHist-Tot-RelId-Val, TCSDebtItemSalesHist-Sum-Alpha-Val, TCSDebtItemSalesHist-Sum-RelId-Qty, TCSDebtItemSalesHist-Det-Alpha-Itm, TCSDebtItemSalesHist-Det-Locn-Frn, and TCSDebtItemSalesHist-Det-RelId-Grp.

Item Sales Report

The Item Sales Report option provides the capability for producing selective listings of warehouse account, i.e. inventory item, sales to customers over nominated time periods, as defined by the debtor control account, related account, account group range and account number range, the warehouse, franchise, item account group range and account number range, and the date range and format requirements specified. Optionally, job issues or usages may be included or excluded. The summary format presents customer account numbers, names and addresses, and for each item, total quantities, total sales values, total cost values and percentage margins, whilst the detailed format incorporates the summary information accompanied by per sale data regarding invoice numbers and dates, customer references, and quantities, unit prices, sales values, cost values and percentage margins. Both formats may be presented with debtors in either account number, account name, account group or related account sequence, with inventory item details listed in either item number, item group or franchise order. View sample reports TCSDebtItemSales-Sum-Alpha-Itm, TCSDebtItemSales-Sum-RelId-Grp, TCSDebtItemSales-Sum-AGrp-Frn, TCSDebtItemSales-Det-Alpha-Itm, TCSDebtItemSales-Det-RelId-Grp, and TCSDebtItemSales-Det-AGrp-Frn.

Missed Sales Opportunities

The Missed Sales Opportunities option provides the capability for producing selective listings of the top sales ranked inventory items and all the customers for whom no purchases of such items have been recorded, as defined by the debtor control account, inventory control account, warehouse, ranking criteria, number of items, sales date range, purchasing date range and format requirements specified. The products may be ranked, within each sales analysis category, by either quantity sold or value sold over the specified sales period. The report details include the inventory item codes, descriptions and rank values, and the account numbers and names of the debtors to whom those items have not been sold over the specified purchasing period, and may be presented in either sales analysis category or customer name sequence. Optionally, the report may incorporate the updating of the 'not purchased' data on debtor accounts. View sample reports TCSDebtMissedSalesOpps-Qty-SACode, and TCSDebtMissedSalesOpps-Val-Cust.

Overdue Debtors Letters

The Overdue Debtors Letters option provides the capability for producing selective listings of debtor letters as at a specified date, defined on the basis of a nominated number of periods overdue and/or minimum account balance. Actual wording of each report is specified in the report and can be tailored to suit any site requirements.

Overdue Debtors Report

The Overdue Debtors Report option provides the capability for producing selective listings of debtor 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 debtor control account. Details listed include account numbers and names, credit days, total account balances and their age analysis by overdue periods, accompanied by the amounts and dates of the last payment received. 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 follow-up 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, location or salesperson is also available. View sample reports TCSAcctODue-Debt-Sum, TCSAcctODue-Debt-Sum-FX, TCSAcctODue-Debt-Sum-Calls, TCSAcctODue-Debt-AGrp, TCSAcctODue-Debt-Dept, and TCSAcctODue-Debt-AGrp-Update.

Pricing for Debtors

The Pricing for Debtors report option provides the capability for producing selective listings of customer prices that apply to inventory sales, and charge rates that apply to job costing, as defined by the control account, account group, business group, location code and price type selections specified. The report includes customer account numbers, names and addresses, and account classifications, price codes and values, job charge rates and details regarding their applicability in terms of working days and times, and may be presented in either account number, account name, account group, business group or location sequence. View sample reports TCSDebtPrices, TCSDebtPrices-Inv, and TCSDebtPrices-Job.

Sales History

The Sales History option provides the capability for analysing customer sales values to a nominated date, as defined by the control account, related account, account group range, account number range, location code, salesperson code, as at date, annual sales level and format requirements specified. The report details account numbers and names, account group, salesperson and location classifications, annual sales values, and six selective periods, i.e. monthly, two-monthly, quarterly, six-monthly, or annual, of sales values accompanied by the all periods totals. Customer addresses may be optionally included to assist with account identification, and the values reported may reflect sales invoices only, job invoices only, or all invoice types. The report may be presented in account number, account name, related account, account group, location, salesperson, annual sales or total period sales sequence, with the ability to restrict both sales value sequenced selections to a specified number of debtors only. If the output type has been specified as Excel, then optionally 12 periods of sales values may be presented. View sample reports TCSDebtSalesHistory-Alpha-All, TCSDebtSalesHistory-Alpha-Range, TCSDebtSalesHistory-AGrp, TCSDebtSalesHistory-RelId, TCSDebtSalesHistory-AnnSales, and TCSDebtSalesHistory-TotSales.

Special Price Analysis

The Special Price Analysis option provides the capability for producing selective listings of customer specific prices for inventory items, as defined by the control account, account group, business group, location, warehouse, effectivity date and format requirements specified. The analysis lists customer account numbers, names, addresses and account classifications, the inventory item codes and descriptions for which special pricing has been entered, accompanied by price and cost values and gross margin percentages, and may be presented in either account number, account name, account group, business group or location sequence. View sample report TCSDebtPriceAnalysis.

Statements Report

The Statements Report option provides the capability for producing debtor statements, as at a nominated date, providing the details of all transaction activity since the previous statement, accompanied by the analysis of outstanding balances in terms of current due, and one, two, three and four or more periods overdue. The output produced may be sequenced by either customer name or account number, within any dual combination of customer, account group, location and postcode, e.g. postcode within account group, and the presentation may optionally include a remittance advice section. The statements are accompanied by a control report, providing a reconciliation between the debtor control account value and the statements produced, and an analysis by output type, i.e. print, fax or email, of the statements produced. View sample reports TCSDebtStmtFormat and TCSDebtStmtRemitFormat.

Stockists Buying Analysis

The Stockists Buying Analysis option provides the capability for producing selective listings of customer's product purchasing volumes, as defined by the debtor control account, account group, postcode, product franchise, date range and format requirements specified. The report presents debtor account numbers and names, location addresses and sales values, sequenced in descending value order, annotated with both the currently determined stockist status and the previous status, and with stockist narrations where applicable. The analysis may be produced by either product franchise, debtor account group or postcode, ordered by either franchise, account group or postcode. Optionally, the report may incorporate the updating of stockist status on debtor accounts, unless accounts are excluded from such updating, e.g. an account directly set as a franchise stockist will remain so irrespective of whether the qualifying level of purchases for the franchise has been achieved. View sample reports TCSDebtStockistAnalysis-Franch-PCode, TCSDebtStockistAnalysis-Group-Franch, and TCSDebtStockistAnalysis-Group-Franch-Upd.

Top Debtors Report

The Top Debtors Report option provides the capability for producing selective listings of debtors, as at a nominated date, ranking them by their account balances outstanding, and secondly, by the value of sales to them. The details listed include account names and addresses, total balances due and their age analysis, sales values, and percentages of the total due or the total sales value respectively. Where Excel has been specified as the output type, account balances may be presented in either ORCA standard periods, or alternate ageing periods. Optionally, customer accounts may be presented on a combined basis, in terms of either statement-to account or related account associations that have been defined. If combined accounts have been selected, the summary is accompanied by a detailed report in which the aggregate values reported are analysed in terms of the values for each contributing debtor. View sample reports TCSAcctTopSumm-DR, TCSAcctTopSumm-DR-Stm, and TCSAcctTopSumm-DR-Rel.

Unallocated Credits Report

The Unallocated Credits Report option provides the capability for producing selective listings of credit amount transactions that have not been allocated against, or associated with, debit amount transactions on debtor accounts. The report content may be optionally restricted by a commencement date and to selected transaction codes, and may be produced as a single summary, or as an analysis by either account group, business group or location. The details listed include account numbers and names, and transaction dates, types, references, narrations, due dates, transaction set numbers, amounts and cumulative amounts, presented in either account number or account name sequence. Its primary use is to identify transactions for which allocation actions are required, to ensure correct nett balances due at transaction level, and to provide correct ageing of account balances. View sample reports TCSDebtUnallCred-Summ, and TCSDebtUnallCred-AGrp.