Create Consolidated Billing Schedules for Customer Contracts
- Enable consolidated billing for a billing schedule type.
- Create and approve a customer contract.
- Configure theBilling Schedule Eventbusiness process and security policy in the Customer Contracts and Project Billing functional areas.
- Security:Process: Billing Schedule - Coredomain in the Customer Contracts and Project Billing functional areas.
You can create consolidated billing schedules to specify billing and invoicing information for installment, transaction, prepaid, and usage-based customer contract lines.
Workday uses the billing schedule to determine how to bill customers for costs on your customer contract lines. You can group:
- Customer contract lines that span multiple contracts in the same billing schedule.
- Projects for the same company and customer in the same billing schedule.
When you generate installments, Workday associates 1 contract line with each installment line.
- Access theCreate Billing Schedule for Customer Contracttask.
- As you complete the task, consider:
Option Description Schedule TypeSelect a schedule type that you enabled for consolidated billing on theMaintain Schedule Typestask.Customer ContractsWhen you create the billing schedule, Workday adds the customer contract lines from contracts that you select.Billable ProjectSelect the billable project associated with the customer contract lines that you want to create a billing schedule for. - (Optional) On theSchedule Optionstab, consider:
Option Description Statutory Invoice TypeSelect a statutory invoice type that you configured for customer invoices on theMaintain Invoice Types by Countryreport. Workday filters the options that display in this prompt by the company that you select on the billing schedule.Workday uses the statutory invoice type to:- Determine the bill from location.
- Populate the statutory invoice type from the billing schedule onto the customer invoice. When you create a customer invoice, you can change the statutory invoice type to be different from the statutory invoice type on the billing schedule.
Workday doesn't support statutory invoice types on award contracts, intercompany contracts, or student contracts.Recurring Invoice DayEnter a day of the month to override the invoice dates on customer invoices that you create using this billing schedule. Consolidated billing schedules only apply invoice dates at the time of invoicing. - (Optional) As you complete theInstallmenttab, consider:
Option Description Billing FrequencyWhen you select these options, installment periods start at the beginning of the selected time frame:- Calendar Week
- Calendar Month
- Calendar Quarter
- Calendar Year
When you select these options, installment periods start at theFrom Date:- Weekly
- Monthly
- Quarterly
- Annual
RecurrenceEnter a number to generate installments in multiples of the billing frequency.Example: When the billing frequency is weekly, enter3to bill the customer every 3 weeks.Proration MethodDisplays when you select theSpread Evenbilling method and a billing frequency.Select:- Actual Calendar Daysto use the actual number of days in each billing unit (28 to 31), leap years included.
- Fixed Year 365 Daysto prorate using a fixed 365-day year (leap years ignored).
- 30 Day Monthto prorate using 30-day months (360-day year).
- Monthly Plus Dailyto count full months as 1.0 and prorate stub days by average month length (365 ÷ 12).
- By Calendar Monthto split stub across calendar months, and prorate each by actual days in that month.
You can use either theProrate First and Last Installmentcheck box or theProration Methodprompt, but not both. Workday disables theProrate First and Last Installmentcheck box when you select an option from this prompt.For details on proration method calculations, see Concept: Proration Methods for Consolidated Billing Schedules.Billing PeriodDetermines whether the installment date is inside or outside of the installment period. When you select:- Advance, installment dates start from the last day of the previous installment period.
- Arrears, installment dates start from the first day of the next installment period.
- Current, installment dates start from the first day of the current installment period.
Installment DayWhen a month doesn't have the date you select, Workday uses the last day of the month. Example: When you select30th, Workday uses the 28th for an installment in February.When the billing period is:- Advance, Workday uses the occurrence of this day or of the date closest to the end of the previous installment period.
- Arrears, Workday uses the occurrence closest to the start of the next installment period.
- Current, Workday uses the occurrence closest to the start of the current installment period.
Prorate First and Last InstallmentDisplays when you select theSpread Evenbilling method and 1 of these billing frequencies:- Calendar Week
- Calendar Month
- Calendar Quarter
Select to prorate the first and last installments when the installments don't cover a full installment period.Example: When the billing frequency isCalendar Weekand theFrom Dateis a Thursday, the first billing installment covers 4 days instead of a full calendar week.When both the first and last installments are partial periods, use these calculations:- First installment = (Number of days to bill ÷ Total number of days in the period) × (Total amount to bill ÷ Number of installments)
- Last installment = (Number of days to bill ÷ Total number of days in the period) × ((Total amount to bill - First installment amount) ÷ Number of installments))
- Other installments = (Total amount to bill - First installment amount - Last installment amount) ÷ (Number of installments - 2)
When either the first or last installment is a partial period and the other installment is a full period, use these calculations:- Partial installment = (Number of days to bill ÷ Total number of days in the period) × (Total amount to bill ÷ Number of installments)
- Other installments = (Total amount to bill - Partial installment amount) ÷ (Number of installments - 1)
You can use either theProrate First and Last Installmentcheck box or theProration Methodprompt, but not both. Workday disables theProration Methodprompt when you select this check box.Automatically Regenerate InstallmentsSelect to generate new installments when you modify the contract line amount on the customer contract. When you enable proration for the first and last installments, Workday updates the proration calculations accordingly.Automatically Submit Schedule via Contract AmendmentDisplays when you select theAutomatically Regenerate Installmentscheck box.Select to submit new installments for approval. Workday doesn't update installments when you have contract amendments on a business process.StatusWhen you create credit adjustments or credit and rebill customer invoices, Workday changes theCompletedinstallment status toCredited.When you:- Cancel the billing schedule, Workday only deletes installments inAvailablestatus.
- Change the billing schedule, you can't edit installments inCreditedstatus.
InvoiceWorkday appends IDs to credit adjustment and credit and rebill customer invoices using the custom ID generators that you configure on these tasks:- Edit Company ID Definitions
- Edit Tenant Setup - Financials
Example: You can configure these custom IDs to display on credit adjustment and credit and rebill customer invoices:- 9874CR - Credit
- 9875RB - Rebill
- (Optional) On theTransactiontab, select aProject Invoice Summary Definitionto group time transactions instead of displaying individual lines.You can create project invoice summary definitions on theMaintain Project Invoice Summary Definitionstask.
- (Optional) As you complete thePrepaidtab, consider:
Option Description Invoice Prepaid Installments with Other Transaction TypesDisplays when you create a customer contract with at least 1Prepaidline type and 1 other line type.Workday automatically enables this check box and bills prepaid installments on the same invoice as other installments and transactions when you create customer invoices.When the check box selection that you configure on the billing schedule is different from the check box selection on theEdit Tenant Setup – Financialstask, Workday uses the selection on the billing schedule to bill prepaid installments.Prepaid MappingMap prepaid customer contract lines to installment or transaction type lines.InstallmentsSet up prepaid installments for each prepaid mapping. To remove a prepaid line with a prepaid balance from the billing schedule, create a negative installment to zero out the prepaid balance.You can place prepaid installmentsOn Hold, but you can't bill or consume against them. You also can't cancel billing schedules that have prepayment balances.When you create a credit adjustment or credit and rebill a prepaid installment, Workday displays the credit adjustment and rebilled installment. - (Optional) SelectManage Attachmentsfrom theMoremenu to add attachments.
Workday routes the billing schedule to the
Billing Schedule Event
business process for review and approval. If the Review Consolidated Billing Schedule
step has been added to the Billing Schedule Event
business process, reviewers can edit the billing schedule directly from My Tasks if they choose to, and then take action on it:
- Approve: Approves the billing schedule and routes it to the next step in the business process.
- Deny: Denies the billing schedule. The billing schedule doesn't proceed any further in the business process.
- Send Back: Sends the billing schedule back to the initiator for revisions, including any changes made by reviewers.
Create customer invoices from contracts.