Previous  Next          Contents  Index  Navigation  Glossary  Library

Aging - 4 and 7 Bucket Reports

Use the Receivables Aging - 4 Bucket and the Aging - 7 Bucket reports to review information about your open items within either four or seven aging buckets . 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 see credit memos, on-account credits, unidentified payments, and on-account and unapplied cash amounts.

Aging reports show detail and summary information about open items. The aging reports will be sorted by company with each item allocated to a company.

Aging can show open credits in either summarized or aged format. Both these formats will only report open credits for the company to which they were entered.

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.

Selected Report Parameters for Receivables Aging Reports

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.

As of Date: Receivables includes all open items whose GL date is before or the same as the date you enter. The default is the current date.

Order By: The option you want Receivables to use to sort your information. For example, you can sort by:

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 Format: Format parameters include 'Brief' and 'Detailed'. The Brief format prints customer name and customer number with item information. The Detailed format also prints address and contact at address.

Report Summary: The type of report summary you want. The Invoice Summary option prints information on all customers' debit items. The Customer Summary option prints customers' names with their total debit item balances.

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.
Summarize Receivables displays the sum of your credit items in the Customer Credit Memos, Customer Payments, and the Customer Balance rows. This is the default option.
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.

Report Headings

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. Receivables lets you sort your Aged Trial Balance - 4 Bucket report by customer or transaction type.

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.

Column Heading (Aging - 7 Bucket Report)

Type: The transaction type for each open item. For each customer, Receivables prints all payments last. Receivables lets you review reports for a specific transaction type or for all existing types.

Row Headings

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. This total is included in the Customer Balance row for each customer.

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.

See Also

Running Standard Reports and Listings

Common Report Parameters

Common Report Headings

Receivables Standard Reports

Aging Buckets


         Previous  Next          Contents  Index  Navigation  Glossary  Library