Skip to main content
Documentation
Documentation
Administrator Guide
Last Updated: 2023-06-23
Steps: Set Up Statistic Ledger Accounts in AP&C

Steps: Set Up Statistic Ledger Accounts in AP&C

Security:
Set Up: Accounts
 domain in the Common Financial Management functional area.
Setting up a statistic ledger account in in Adaptive Planning and Consolidation (AP&C) enables you to:
  • Access statistics from the journal or plan lines data source.
  • Use custom validations or business processes for both actuals and budgeted data.
  • Control entries based on period status.
  • Create ledger account summaries for reporting
  • Use a workflow and prepare entries for statistics.
  • Have a plan amendment process for statistical data.
  • Upload statistics by accounting date instead of accounting period. Example: You can upload statistics daily rather than monthly.
  1. Create a balance sheet account type specifically for statistics.
    1. Create a statistic ledger account in the account sets. Use a separate child account set for statistics accounts that you want to add to the parent chart of account set.
    2. Determine whether you need a clearing account or if it should post to the same ledger account to create balanced entries.
      Include numberings for ledger account summaries to support reporting. Example: 99999s.
    3. Restrict ledger accounts to companies if applicable.
  3. You can create a journal source specifically for statistics.
  4. (Optional) Create a book code for statistics.
  5. Workday recommends creating custom validations for statistic ledger accounts to ensure that you:
    • Use 1 account type to avoid generating retained earnings.
    • Use the book code and journal source effectively when using statistic accounts. Example: Don't use a blank book for statistic accounts.
    • Use required worktags that are specific to certain statistic accounts.
    • Don't use intercompany with statistic accounts. This prevents generation of additional intercompany payables and receivables.
  6. You can create condition rules for the statistic ledger account, book code, or journal source for additional approvals.
  7. Create an accounting journal for the statistic ledger account.
    As part of the journal entry, you can use quantity with the statistic ledger account and amount. You can use quantity in reports but not in an allocation definition. Example: Number of shares with equity.
    1. Create a new translation rate type specifically for statistic ledger accounts. Load in a 1:1 translation for this new rate type to ensure there are no translation issues when doing multicurrency reporting. You only need to load once for all applicable currencies.
    2. Create a new translation method specifically for statistic ledger accounts. This can be similar to the current translation method but will reference the rate type you created.
    3. Update any existing translation rule sets to include a mapping of the statistic ledger account and ledger account summaries to the new translation method.
Your company wants to keep track of statistics at the company level only. Example: Number of shares outstanding; volumes; assets owned; assets under management. You can use a statistic ledger account to keep track of these statistics at the company and ledger account level. You can also restrict these ledger accounts so that only certain companies can use them. This enables you to enter the statistics and doesn't require you to use an unnecessary worktag.
You can report on statistic ledger accounts using the
Journal Lines
 or
Plan Lines
 report data sources. You can filter lines based on the ledger account.
To exclude statistics from reporting, you can either record them to their own book code or exclude the ledger account type from reporting.