Use the Receivables Aging reports to review information about outstanding receivables as of a specific date. These reports can print both detail and summary information about your customer's current and past due invoices, debit memos, and chargebacks.
Receivables also gives you the option to age or summarize on-account credits, unidentified payments, and on-account and unapplied cash amounts.
If you are using Oracle Trade Management, then you can also see cash claims.
The aging reports are sorted by company with each item allocated to a company.
Receivables aging reports do not include customers with a zero balance.
Review information about open items using these aging reports:
Aging - 4 Buckets and Aging - 7 Buckets: Use these two reports, along with the Aging - 7 Buckets - By Account report, during reconciliation. If you run these reports using the last day of the prior period and last day of current period, then the totals match the beginning and ending outstanding balances respectively on the AR Reconciliation report.
Submit these reports using the Customer Summary option to display customer totals. Or, use the Invoice Summary option to display detailed invoice information.
Do not use other aging reports for reconciliation purposes, because the report totals might not agree with the total outstanding receivables on the AR Reconciliation report.
Aging - 7 Buckets - By Account: This report provides GL account information and automatically displays invoice details. Use this report during reconciliation.
Aging - 7 Buckets - By Amount: If you sort by balance due, Receivables sorts and prints your open invoices and debit memos by amount with the greatest amounts appearing first. This organization-specific report is always based on current date.
Aging - 7 Buckets - By Collector: Does not include unidentified receipts, because a collector cannot be associated with an unidentified receipt.
The Aging - 7 Buckets - By Collector report sorts information by collector, and then groups information by balancing segment, customer name and number, and site ID.
Aging - 7 Buckets - By Salesperson: Does not include receipt chargebacks, because a salesperson is not associated with a receipt chargeback.
The Aging - 7 Buckets - By Salesperson sorts information by balancing segment, and then groups information by salesperson and customer name.
Note: Receivables ages transactions according to due date. The aging reports, however, select transactions according to GL date.
Note that if you have created overlapping aging buckets, transactions might be included in more than one bucket and bucket total. However, Receivables will correctly include such transactions only once when calculating the total Outstanding Amount.
Note: See also: Common Report Parameters for Reconciliation Reports.
Choose to order all the reports by customer. This will let you research transactions based on customer name or number.
Suggestion: When sorted by customer, the Aging reports do not give the details of the transactions that are included in the calculation of the outstanding balances. If you need to find out details of such transactions, you might choose to print the Aging reports ordered by type. Use either the Aging - 4 Buckets or the Aging - 7 Buckets - By Account report for reconciliation.
Order By: The option that you want Receivables to use to sort your information. For example, you can sort by:
Customer (Aging - 4 Buckets, Aging - 7 Buckets, and Aging - 7 Buckets - By Amount reports)
This option displays customer balances only, no invoice detail.
Transaction Type (Aging - 4 and 7 Bucket reports)
This option displays invoice detail by transaction type.
Note: If you set the Order By parameter to Type, you cannot set the Show On Account parameter to Summarize.
Balance Due (Aging - 7 Buckets - By Amount report)
Note: If the profile option AR: Sort Customer Reports by Alternate Fields is Yes and you choose to sort information by Customer Name, Receivables sorts information according to the value of the Alternate Name field in the Customers window. Otherwise, Receivables sorts information according to the Customer Name field.
Report Summary: The type of report summary. The Invoice Summary option prints information on all customers' open receivables. The Customer Summary option prints customers' names with their total open balances.
Report Format: Format parameters include 'Brief' and 'Detailed', and affects customer information, not transaction information. The Brief format prints customer name and customer number with item information. The Detailed format also prints customer's city and state with contact name and telephone number.
As of GL Date: Receivables includes all open items whose GL date is before or the same as the date you enter, and whose GL date closed is after the date you enter. The default is the current date.
Aging Bucket Name: Receivables prints your report information from the bucket set you specify. The default bucket set is 'Standard'. You define different aging bucket sets in the Aging Buckets window.
Show Open Credits/Show On Account: Choose whether to print credit items for your customers. Choose one of the following options:
| Do Not Show | Receivables does not include these credit items in your customer's balances. In this case, Receivables does not display any of your identified or unidentified payments, or on-account credit memos. |
| Age | Receivables ages your credit items and includes the credit amounts in the appropriate aging bucket columns. This is the default option. |
| Summarize | Receivables displays the sum of your credit items in the Customer Credit Memos, Customer Payments, and the Customer Balance rows. |
Show Receipts at Risk: Receipts at Risk are receipts that have either not been cleared or factored receipts that have not been risk eliminated. Select one of the following values for your report:
| Age | Include receipts at risk in this report. Receivables displays the receipts at risk with other open receipts in the appropriate bucket and includes them when determining the customer's balance. |
| Summarize | Receivables displays the sum of your receipts at risk in the Customer Credit Memos, Customer Payments, and the Customer Balance rows. |
| Do Not Show | Receipts at risk will not be included in this report. This value is used as the default. |
Show Claims: Claims are non-invoice related claims that are not yet resolved. Receivables considers non-invoice related claims to be unresolved cash, similar to on-account or unapplied cash. For users of Trade Management only.
Select one of the following values for your report:
| Age | Include non-invoice related claims in this report. Receivables displays the claims with other open receipts in the appropriate bucket and includes them when determining the customer's balance. |
| Summarize | Receivables displays the sum of your claims in the Customer Credit Memos, Customer Payments, and the Customer Balance rows. |
| Do Not Show | Claims will not be included in this report. This value is used as the default. |
Invoice related claims that are not yet resolved place the related invoices in dispute. Depending on how you set up your aging buckets, these disputes can be included in the appropriate aging period or as a separate total. These disputes are also shown in the Disputed Invoice report.
As of (Date): The as of date you specify for this report. You specify the as of date as a report option in the Parameters zone.
Company Segment: The balancing segment of the Receivables account associated with the transaction included in this group.
Order By: Your sort option.
Total for: All Customers/Total For: All Types: The grand totals for all customers for each numeric column in your report if you sort by Customer. Receivables prints the grand totals for all transaction types if you sort by Type.
Type: The transaction type for each open item, displayed if Order By parameter is Transaction Type. Receivables lets you review reports for a specific transaction type or for all existing types. For each customer, Receivables prints transaction types first, then payments, on-account credit memos, and bills receivable.
Company Total: The total outstanding amount for this company. If you choose Do Not Show or Summarize as your Show On-Account report parameter, Receivables does not include credit item amounts in your customers' totals. If you choose Age as your Show On-Account report option, Receivables includes credit item amounts in your company total.
Customer Balance: The total balance for each customer when you choose Summarize as your Show On-Account report parameter. This balance includes all debit and credit items for each customer.
Customer Credit Memos: The total amount of credit memos for each customer if you choose Summarize as your Show On-Account report option. This total is included in the Customer Balance row for each customer.
Customer Payments: The total amount of payments for each customer within this site if you choose Summarize as your Show On-Account report option. Payments include both unapplied and on-account cash. This total is included in the Customer Balance row for each customer.
Salesperson Customer Balance: The total balance for each customer. If you choose Do Not Show or Age as your Open Credits report option, Receivables does not include on-account payments, unapplied payments and on-account credits in your customers' balances. If you choose Summarize, these credit items are included in your customers' balances.
Site Balance: The total balance for each site when you choose Summarize as your Show On-Account report parameter. This balance includes all debit and credit items for each company.
Site Credit Memos: The total amount of credit memos for each customer site if you choose Summarize as your Show On-Account report option. This total is included in the Site Balance row for each company.
Total Customer Balance: The grand total customer balance for all customers or types in your report.
Total for: All Customers/Total For: All Types: The grand totals for all customers for each numeric column in your report if you sort by Customer. Receivables prints the grand totals for all transaction types if you sort by Type.
Total Payments and Credit Memos: The grand total for credit items for all customers or types in your report.