Reference: Invoicing and Receivables Reports
This table lists a number of useful customer-related reports.
Report | Description |
|---|---|
Customer Activity Details
| View the transactions for this customer or hierarchy
that fall within the specified time range. Details include the
transaction, date, type, number, due date, state, increase or decrease,
and balance. |
Customer Activity Summary
| View the total transaction amounts for the specified customers that
fall within the specified time range. Details include:
|
Customer Balance Details
| View the open balance for each customer. Details include currency,
reporting transaction, type, number, and date, due date, aging days,
original amount, payments applied, discounts, write off, and open
balance. |
Customer Balance Summary
| View the currency, invoices total, adjustments,
unapplied payments, and balance for each customer. |
Customer Invoices Requiring Action
| View invoices that might require action. Only returns
invoices that are late, on hold, in collection, or in dispute. Use this
report as the basis for custom reports that meet your specific criteria
for invoices that require attention. |
Customer Payment Detail
| View all customer payment activity for your company or company
hierarchy. Enables you to check the status and details of your customer
payments. You can narrow your report results to specific customers, a
payment date range, and other criteria. Example: Payment date, status,
type, and amount. You can also see payment application details
including customer invoices and adjustments paid, write off, and
payment amount on account. As related actions you can cancel,
return, or unapply payments as necessary. |
Customer Statements
| View customer statements for the specified customer or hierarchy that
apply to the specified company. Details on the
Transactions tab include each transaction
date, type, number, due date, state, increase or decrease, and
balance. These transactions are sorted by currency.Details on the Aging Report tab include, for
each customer, the current amount and amounts for different ages,
depending on the selected aging group. |
Find Customer Deposits
| View all deposits in the specified period. Details on both
the Deposits tab and the
Payments Included in Deposit tab include
the status, customer, date, bank account, deposit amount, and
currency. |
Find Customer Invoices
Find Customer Invoices for Billable
Projects Find Customer Invoices for
Company | View the number, company, status, customer, date, memo, discount
date, due date, invoice amount, amount due, currency, adjustment, and
adjustment reason for each invoice. For the Billable
Projects and Company standard
reports, you can save and refine your searches after Workday
displays your results. |
Find Customer Write-Offs
| View the status, customer, writeoff date, and amount for each bad
debt writeoff. View the status, customer, payment date, and amount
for each bad debt writeoff included in a payment. |
Receivables Aging
Receivables Aging Detail | We plan to retire these 2 receivables aging reports in
September 2023. Workday recommends that you use the Receivables
Aging Detail Standard Report and Receivables Aging Summary Standard
Report. If you run the aging report as
financial aging by accounting period, you can filter by Ledger
Period for Receivables Aging . Select either the current
period or a specific ledger period by ledger year.Both the operational and financial aging are cumulative in
capturing total invoice amounts. Operational aging is useful for
tracking your receivables from a collections perspective.
Financial aging is helpful for closing your accounting
period. Example: A customer invoice with an invoice date of 1/31/15, but
an accounting date of 2/1/15, won’t display in a financial aging
report for January of 2015. It displays in February 2015. An
operational aging report displays that invoice in January 2015.
Includes only transactions with an invoice date that is before
the selected report date. The most common aging report displays:
Current, 1-30, 31-60, 61-90 and >90. The Detail report breaks down aging by specific invoice
transaction. |
Receivables Aging Detail Standard Report
Receivables Aging Summary Standard Report | View aggregated past due amounts by company for a given period. When
you run the report for Financial Aging , you can
specify any reporting date, instead of defaulting to the last day of a
month. You can also report in a different currency than the company
currency. Copy these reports to create custom reports for using
calculated fields to:
You can also use the Customer Payment for
Invoices report data source to create custom reports
for viewing your receivables aging data based on payment balances in
reporting currency, transaction currency, or company currency. |
Sub-Receivables Aging Customer
Invoice
Sub-Receivables Aging Customer
Payment On-Account And
Unapplied Sub-Receivables Aging
Summary Customer
Invoice Sub-Receivables Aging
Summary Customer Payment
On-Account Sub-Receivables Aging
Summary Customer Payment Unapplied | View past due amounts based on on-account and unapplied payments
balances by company for a given period. It includes information about
original transaction amount, transaction balances in transaction
currency, company currency, and reporting currency, on-account balance
in reporting currency, and unapplied balance in reporting
currency. These matrix reports have required prompts to filter the
data by:
|