Skip to main content
Administrator Guide
Last Updated: 2026-03-13
Reference: Invoicing and Receivables Reports

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:
  • Adjustments total
  • Beginning balance
  • Currency
  • Ending balance
  • Invoices total
  • Payments total
  • Refunds total
  • Write-off total
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.
You can select to run these reports as operational aging based on the invoice date, or financial aging based on the accounting date by accounting period. For each customer, view the current amount and invoice amounts for different ages, depending on the selected aging group. For operational aging, the reports display outstanding customer receivable amounts in user-defined aging buckets. Supports up to 6 aging buckets. Workday displays a warning if an aging group has more than 6 aging buckets.
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:
  • Specify the desired aging periods.
  • Report on other invoice attributes such as invoice types, or billable projects.
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:
  • Aging Report Mode
  • Aging Basis Date
  • Reporting Date
  • Reporting Currency
  • Currency Rate Type
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.