Setup Considerations: Accounting Center

Administrator Guide

You can use this topic to help make decisions when planning your configuration and use of Accounting Center. It explains:

Why to set it up.

How it fits into the rest of Workday.

Downstream impacts and cross-product interactions.

Security requirements and business process configurations.

Questions and limitations to consider before implementation.

Refer to detailed task instructions for full configuration details.

What It Is

Accounting Center is a fully integrated solution built on an analytic engine that enables you to:

Bring into Workday high-volume operational transactions from external sources.

Transform and enrich the external business transactions into accounting journals.

Business Benefits

You can:

Ingest, enrich, and transform external transactions into Workday journals.

Manage and track transactions in batches from ingestion to summarized accounting.

Generate detailed and summarized accounting.

Post summarized journals to your ledger.

Report on both the detailed and summarized balances for financial, operational, and managerial reporting in both the primary and alternate ledger accounts.

Close your books with full audit capability.

Use Cases

You can use Accounting Center to bring in to transform and combine external transactions with Workday-generated accounting to include them in your Workday ledger.

Examples:

For insurance companies - Transform policy and claims data.

For healthcare companies - Transform healthcare provider insurance plan data.

For media companies - Transform business events for production shows, including casting, payroll, set designs, visual effects, and campaign costs through award seasons.

For retail companies - Transform point of sales and subscription billing services.

For banking companies - Transform loan information.

Questions to Consider

Questions	Considerations
Will you be ingesting multiple records and including those records in a single transaction?	Ingestion is the process of moving external transactions into a dataset from where you can access and analyze them. Use Transaction Grouping ID in enrichment validation stages and the Accounting Source Configuration to properly group records for: Error Management: Ensures that even if 1 record in the transaction has an error, all records in the transaction error out. Balancing at the transaction level: Ensures that the journal balances at the transaction level. Transaction Grouping ID is alpha-numeric and isn’t case-sensitive.
Will you be processing more than 300,000 records per transaction in Detailed Accounting?	Split the transaction into smaller sets of records and balance each smaller transaction if approaching this limit. Example: Processing 5 transactions with each transaction containing 20,000 records will perform better than processing 1 transaction with 100,000 records. For more information, see Accounting Center - Splitting Large Transactions.
How many enrichment steps do you want to create for an accounting source?	Enrichment is the process of enhancing your source data so you can use it for detailed and summarized accounting. Example: adding worktag mapping, reformatting or removing field and so on. You can create a maximum of 3 enrichment stages. You can't change the number of enrichment stages once you create the accounting source.
How do you want Workday to process each batch in a stage?	You can configure the Accounting Center Process to specify how you want Workday to process each batch for a stage. You can select to process and advance each batch: Always Advance to Next Stage and Dismiss Any Errors to Next Batch. Manually Select Next Action. Only Advance to Next Stage if No Errors. To remove records from further processing, add a custom dismiss to your process. To specify how you want to process each batch in a stage, access the Edit Accounting Center Process Configuration task and select an option.
Will you be including additional information on the detailed journal lines?	Include fields as additional attributes from the enrichment dataset in the detailed journal lines. Workday recommends you use text as your primary format for attributes.
What information do you want to include on the summarized journal lines?	Use Worktag Mapping Tables and dataset joins to bring necessary business objects into your enrichment datasets. Once these fields exist on your enriched datasets, you can select these fields on your Accounting Source journal line rules.
Do you have more than 2 million lines in a single summary journal?	The summarization process will fail if the summary journal exceeds the maximum limit of 2 million lines. Workday recommends that you update your configuration or ingested data so that the summarization results in fewer journal lines.
Will you be using custom validations?	Ensure that your transactions meet your specified conditions by: Creating validation stages in the enrichment datasets for identifying specific errors. Creating critical custom validations for the Accounting Center Detailed Journal type.
Will you be dismissing certain error-free transactions?	Create a custom dismissal step to remove certain transactions from a batch.
Will your ingested data include records with no value?	Ingested records with no value can cause batch errors. Workday must account for every transaction in a batch. You can either: Filter out the records with no value in the derived dataset that is the source for the Data Change Task used in the Accounting Source. This will reduce the count of transactions or records that the Accounting Center processes. If you need to maintain records of each ingested record, remove these records from detailed accounting using custom dismissal.
Will you be using custom account posting rule dimensions?	Use a Join to instantiate the custom account posting rule dimension to the applicable field in your ingested data.
Will you configure alternate ledger currency? See: Steps: Set Up Alternate Ledger Currency.	For Detailed and Summary Journals - When alternate ledger currency is enabled for your line company, through both Primary Source and Manual batch types, Workday will now generate accounting center detailed and summary journals in both primary and alternate ledger currency. For intercompany transactions: When Line and Header companies have the same alternate ledger currency, Workday applies the Alternate Ledger Currency Rate Type of the Header company to the Line company. When the Line and Header companies don't have the same alternate ledger currency or the Header company doesn't have alternate ledger currency enabled, Workday applies the Alternate Ledger Currency Rate Type of the Line company to the Line company's alternate ledger currency journal entries. For Reversal Journals - Workday now creates a reversal journal in the alternate ledger currency when the Reversed and Reversed By journals are respectively accounted for before and after the Alternate Ledger Period start date. Example: Alternate ledger currency is enabled for Calendar Year 2023. You process a transaction with an accounting date of December 31, 2022. Accounting Source option to Create Reversal is checked. Reversing Journal (Reversed By) to be created with an accounting date of January 1, 2023. Result: The Reversed (12/31/2022) journal is generated in only the primary ledger currency and the Reversed By (1/1/2023) journal is generated in both the primary and alternate ledger currency. For Reporting in Accounting Center: When you enable alternate ledger currency for a company and report directly from Prism, Workday recommends that you select a single ledger currency. When you don't specify a single ledger currency, Workday returns both Primary from Alternate ledger currency journal lines. Alternatively, Workday adds a new Ledger field to the detailed accounting output tables that populates the ledger value for each detailed journal line, enabling you to utilize this field when reporting on detailed accounting journal lines. Example: You can filter on the Ledger field to exclude detailed journal lines associated with an alternate ledger currency.
Will you be using multicurrency journals?	Consider whether you need to include the instance of the transaction currency code in your enriched data. Also, consider: If you want to record both the transaction amount and the ledger amount. Have Workday calculate the ledger amount using currency conversion rates.
Do you have intercompany journal lines with different ledger currencies?	We now apply the currency rate type in this order: For the header company: Currency Rate Type defined on the Journal Header Rules tab of the Edit Accounting Source Configuration task. Currency Rate Type Override defined on the Edit Company Accounting Details task. Default Currency Rate Type defined on the Edit Tenant Setup - System task. For the line company: Currency Rate Type Override defined on the Edit Company Accounting Details task. Currency Rate Type defined on the Journal Header Rules tab of the Edit Accounting Source Configuration task. Default Currency Rate Type defined on the Edit Tenant Setup - System task. For the header company alternate ledger currency journal: Alternate Ledger Currency Rate Type Override defined on the Edit Company Accounting Details task. Default Currency Rate Type defined on the Edit Tenant Setup - System task. For the line company alternate ledger currency journal: Alternate Ledger Currency Rate Type Override defined on the Edit Company Accounting Details task. Default Currency Rate Type defined on the Edit Tenant Setup - System task.
Will the ingestion data include cash journals and will you reconcile the cash journals?	Include the instance of the bank account in your ingested data. Also, include the bank account worktag as a worktag type in the accounting configuration and select Reconcile to Bank . Also, use the Transaction Reference field when selecting Reconcile to Bank . Include condition rules to separate your cash and bank accounts from your other lines.
Do you want to track the number of transactions Workday dismisses from a current batch?	Access the Find Accounting Center Batch report and view the Dismissed Transactions column.
Do you require notifications of certain events as the Accounting Center is processing the batch through various stages?	Set up custom notifications in the business process definition using report fields on the Accounting Center event.
Will you be using alternate account sets for reporting?	Access the Edit Company Accounting Details task and select an alternate account set for the company to generate reports that map alternate account sets or statutory account sets to your preferred account set. Once you create or post journals, you can't change the alternate account set.
Will you be controlling access for creating and editing mapping table definitions or mapping tables based on role assignments?	Create and assign roles enabled for the Source System. Access the Maintain Assignable Roles task. Enter a role and for the Enable for field , select Source System . Access the View Mapping Table Definition report. From the related actions of the Source System , select Roles Assign Roles. On the Assign Roles task, assign the Source System role you previously created to a user. Create a role-based security group (constrained) using the newly created role. Add the newly created role-based security group (constrained) to the security domain policy for Set Up: Mapping Table Definitions or Set Up: Mapping Tables. Users will only be able to access the Mapping Table Definitions and Mapping Tables, which contain a source system value for which the user has an assigned role.
Will you be controlling access to an accounting source based on roles defined for a source system?	Create and assign roles enabled for a source system. Create or select an existing source system. You can use the Create Source Systems task to create a new source system. Add the role enabled for Source System, to the newly created role-based security group. Access the Maintain Assignable Roles task. Enter a role and for the Enable for field , select Source System to create roles enabled for the source system. From the related actions of the source system, select Assign Roles to assign a user to an assignable role. Create a role-based security (constrained) group. Edit the accounting source and add the Source System attribute. Add the constrained role-based security group to the applicable domain or business policy with Allowed Security Group Types: Roles Source System. When a user has access to domains through a constrained role-based security group that uses a role enabled for Source System, they can only access Accounting Sources that contain a Source System value in which the user has been assigned a role.
Did you create tables enabled for analysis or published datasets that support the following use cases?	These are the use cases that are eligible for exclusion: Ingestion table connected to the Accounting Source that is visible on the View Accounting Source report. Prism tables used for Accounting Center pre-ingestion processing such as landing tables. Custom reporting tables for Accounting Center errors. Custom reporting across multiple Prism and Accounting Center tables to confirm processing success. Consolidated reporting tables that join detailed accounting data from multiple Accounting Sources. Use the Maintain Prism Artifact Usage task to manually tag Prism artifacts for exclusion from Prism entitlement calculations. Security: Set Up: Accounting Source – Create domain.
When will you schedule your weekly maintenance?	Ensure that you don't schedule any jobs or processes to run near the start of your weekly maintenance. Once maintenance starts, all currently active jobs and processes will stop running and error out. As Workday doesn't support an automatic restart, you'll have to restart the jobs or processes manually.
Do you use the Manage Workday Maintenance Window task to end your active sessions?	Configure the Manage Workday Maintenance Window task because we enforce Session Restriction on the detailed accounting process. To continue with Accounting Center batches during the maintenance window, add your user that is configured on the business process to the System Accounts Excluded from Session Restriction option on the Manage Workday Maintenance Window task. This is the Run As User for the Accounting Center Detailed Accounting Primary Process Job in the Accounting Center Detailed Accounting business process definition.

Recommendations

Option	Recommendations
Ingestion Source for Accounting Source	Use a table as your ingestion source. Use the Edit Data Change Task (Accessed from the related actions menu of the Data Change Task ) to populate fields on the Accounting Source Ingestion table. Consider using these updates for simple transformations that you might require on your ingestion table: Creating a Transaction Grouping ID. Adding or deriving an accounting date. Field names shouldn't: Contain the word 'id.' Contain any special characters (Example:, !@#$%^&*, etc.). Exceed 255 characters in length. End in an underscore. Start with “WPA_” , "AC_CALC_", " AC_PRE_", or " AC_POST_"(reserved prefixes). Use AC_Batch, AC_Batch_Run, AC_Transaction_ID or AC_QUERY_KEY ( reserved words).
Enriching Data	Create a new dataset for enrichment between the System Filter {_UnprocessedForBatch} and the User dataset {_UserConfiguration} and perform all enrichment steps in the new dataset. When expanding 1 record per transaction into many records per transaction in Enrichment, use Transaction Grouping ID as a unique ID for each row in your ingested data. For complex enrichments, create separate enrichment stages. Separate enrichment stages ensure that Workday persists data at each stage separately, for diagnostic purposes. Keep Mapping and Validation stages separate. When adding fields as calculated fields or using Join/Mapping stage, their fields shouldn't: Start with “WPA_”, "AC_CALC_", AC_PRE_" or "AC_POST_" (reserved prefixes). Use AC_Batch, AC_Batch_Run, AC_Transaction_ID or AC_QUERY_KEY (reserved words)
Validating Data	Create a new derived dataset containing your validation stages between the System Filter {_UnprocessedForBatch} and the User dataset {_UserConfiguration}. Add the validation stage on the last Enrichment stage.
Currency Decimal Precision	The transaction and ledger amounts in detailed accounting must match the currency precision of the transaction and ledger currencies. If the amounts don't meet the currency precision of the relevant currencies, you must round these amounts to the correct currency precision in Enrichment.
Configuring domains and securing entities for tables and datasets for an accounting source.	To increase efficiency in configuring domains for tables and datasets for an accounting source, use the Edit Accounting Source Prism Data Source Security task. Security: Setup: Accounting Source - Create domain.
Creating Journal Line Rules	You can create up to 5,000 Journal Line Rules across all Snapshots in all Accounting Groups for an accounting source.

Requirements

The ledger period must be open for the journal to post.

Before you can initiate a batch, ensure it contains at least 1 transaction.

A stage must be complete with no errors before advancing to the next stage.

Limitations

If there are more than 10,000 validation exceptions, the entire batch errors out.

Summarized journals won't check for budget check and will post even if they cause the budget to exceed.

When you configure alternate ledger currency for a company:

Accounting Center doesn’t generate single ledger primary currency or alternate ledger currency journals when processing a transaction.

The existing Currency Rate Type field in the Accounting Source header only applies to the primary ledger currency. Accounting Center does not support overriding the alternate ledger currency rate type. The alternate ledger currency rate type is driven by the configuration at the company and tenant level.

Accounting Center doesn't enable you to define or override alternate ledger currency amounts. For Detailed Accounting processing, Workday uses the system exchange rate to generate all alternate ledger currency amounts.

See:

Steps: Set Up Alternate Ledger Currency.

You can't use Worktag Balancing functionality on transactions. Manually configure your accounting source to create the accounting correctly.

For Accounting Center journals, Workday will only support mapping rules from the primary to the alternate account set.

Accounting Center doesn’t support all Prism data types. For Accounting Center processing, Workday doesn’t support Currency, Double, and Integer field types. Additionally, for any numeric field that you use as a transaction amount, ledger amount, or taxable amount on the accounting source configuration, you must maintain a field precision of (20,6).

Tenant Setup

You can configure this option on the

Edit Tenant Setup - Financials

task.

Option	Considerations
No Intercompany Payable/Receivable Lines when Journals Self Balance by Company for Manual Accounting Center Detailed Journals	When you select this check box, Workday doesn't automatically generate intercompany payable and receivable journal lines for Manual Accounting Center Detailed Journals for a company if the journal lines for that company are already self-balanced.

Security

You can access the

Domain Security Policies for Functional Area

report to view all security domains for Accounting Center.

The security domains that you can configure include:

Domain	Considerations
Process: Accounting Center in the Accounting Center functional area.	Can configure accounting center processes and reports.
Process: Accounting Center Detailed Journals in the Accounting Center functional area. Includes these subdomains: Process: Accounting Center Detailed Journals - Add Attachment Process: Accounting Center Detailed Journals - Add/Change Attachment Process: Accounting Center Detailed Journals - Cancel Process: Accounting Center Detailed Journals - Core Process: Accounting Center Detailed Journals - Reporting Process: Accounting Center Detailed Journals - View	Can cancel, add attachments to, and view Accounting Center detailed journals.
Set Up: Accounting Center in the Accounting Center functional area. Includes these subdomains: Set Up: Accounting Source – Create Set Up: Custom Account Posting Rule Types Set Up: Accounting Source - Inactivate Set Up: Accounting Source – Maintain Set Up: Accounting Source Process Configuration Set Up: Maintain Accounting Center Processing Windows Set Up: Source Systems	Can create, inactivate, and edit accounting source tasks and web services, create source systems.
Process: Accounting Center Error Manager in the Accounting Center functional area.	Can view tasks, reports, and web services for the Accounting Center Error Manager.
Process: Accounting Center Summary Journals in the Accounting Center functional area.	Can view these reports: View Accounting Center Summary Journals View Accounting Center Summary Journal View Accounting Center Summary Journal (Expanded)
Report: Batches and Jobs Impacted During Disaster in the Accounting Center functional area.	Can view the Batches Impacted by Disaster Recovery report.
Set Up: Mapping Tables in the Accounting Center functional area.	Can create and update mapping tables.
Set Up: Mapping Table Definitions in the Accounting Center functional area.	Can create and update mapping table definitions.

Business Processes

Configure the Accounting Center Batch Initiation Event
business process to initiate an accounting center batch.

Configure the Accounting Center Cancel Batch Event
business process to create a workflow for the cancellation of an accounting center batch and approve cancellation requests.

Configure the Accounting Center Enrichment Event
business process to enrich data.

Configure the Accounting Center Detailed Accounting Event
business process to generate detailed accounting.

Configure the Accounting Center Summarization Event
business process to create summarized accounting.

Configure the Accounting Center In-Line Edit Approval Event
business process to grant access to all tasks and reports for using In-Line Edit for correcting errors.

Reporting

You can access the

Workday Standard Reports

report to view all reports for Accounting Center.

Reports or Dashboards	Considerations
Batches Impacted During Disaster Recovery report	Enables you to identify batches impacted during disaster recovery.
Run Time Metrics at Batch Level report	Enables you to monitor trending run time metrics at the batch level.
Run Time Metrics at Batch Stage Level report	Provides trending run time metrics for all stages in a batch or batches.
Run Time Metrics at Batch Run Level report	Enables you to report on trending run time metrics at the batch run event level.
View Accounting Source Snapshot report.	Provides details of a specific effective dated accounting source snapshot configuration.

You can also create custom reports using these report data sources:

Accounting Center Batch

Accounting Center Batch Run

Accounting Center Batch Stage

Custom Account Posting Rule Types

Integrations

You can use these web services to migrate and maintain accounting sources between different tenants:

Get Accounting Center Implementations

Put Accounting Center Implementations

Get Source Condition Rules

Get Accounting Source Process Configurations

Get Accounting Source Snapshots

Put Accounting Source Condition Rule

Put Accounting Source Process Configuration

Put Accounting Source Snapshots

You can use these web services to maintain account posting rules or mapping tables in Accounting Center:

Get Custom Account Posting Rule Dimensions

Get Custom Account Posting Rule Types

Get Mapping Table Definitions

Get Mapping Tables

Put Custom Account Posting Rule Dimension

Put Custom Account Posting Rule Type

Put Mapping Table

Put Mapping Table Definition

You can use the
Put Accounting Center Batch
web service to create a new batch.

You can use these web services to retrieve and update resolution details for dismissed transactions:

Get Dismissed Transactions

Put Dismissed Transaction

Refer to the web service directory on Workday Community for more web services.

Connections and Touchpoints

You can use Accounting Center with Financial Accounting to process journals, produce financial records, and perform period and year-end close.

Workday offers a Touchpoints Kit with resources to help you understand configuration relationships in your tenant. Learn more about the Workday Touchpoints Kit on Workday Community.