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:
Workday automatically populates the Start Date calendar prompt on the report. When you access the report, Workday sets the start date to 6 months prior to the end date. |
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. When you select valid start and end dates on the report, Workday only populates the customer invoices and payments that are within the specified date range. |
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, write-off date, and amount for each bad debt write-off.
View the status, customer, payment date, and amount for each customer invoice write-off included in a payment. |
Receivables Aging
Receivables Aging Detail | We plan to retire these 2 receivables aging reports in March 2026. For better performance and configurability, 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:
When you run the report in the financial aging mode, Workday doesn't display customer payments that are recorded but not applied. 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:
|
In addition to the above standard reports, you can create a custom report that includes both customer invoices and customer invoice proposals, to give you a complete view of your billing activity for a specific project or company. See the Customer Invoice Proposal Reporting link in the Related Information section.