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

Concept: Statistic Ledger Accounts in AP&C

You can use statistic ledger accounts to record and track quantitative or qualitative data for management and reporting purposes. Statistic ledger accounts don't have a direct impact on financial statements or the general ledger. Office Connect and Adaptive Planning support statistic ledger accounts.
Example 1: Your company is a hotel and you want to keep track of the number of filled and vacant rooms throughout the year. Instead of viewing this data by period, you want to view the specific days for reporting purposes. You can create a statistic ledger account to track the activity of the rooms. You can load the number of vacant and filled rooms each day or at the end of the month. Additional worktags can help break down the additional details, such as location.
Example 2: As part of the statistic loading process you want controls in place, such as business process approvals and custom validations, to ensure that you create accurate statistics. When you load the amounts into the statistic ledger accounts, it uses the
Accounting Journal Event
 business process and custom validations. You can create condition rules to validate the entries before submission using the custom validations. You can also add condition rules to the business process for routing of approvals.
Recommendations
If you need to keep track of balances or activities, you can:
  • Roll forward balance sheet accounts to the next year.
  • Use the year-end closing rules to ensure that the rolled forward balance goes to zero for the account and the rolled amount goes to a clearing statistic account.
  • Decide on the ledger account booking (debits and credits) and how you'll use and report on the statistics.
  • Determine whether you need a clearing account or if statistics should post to the same ledger account to create balanced entries.
  • If you use a clearing account:
    • Ensure there's a clearing account per balance sheet or income statement ledger account type. This helps you avoid generating retained earnings.
    • Filter to report on the relevant statistic accounts and exclude the clearing account.
  • If posting to the same ledger account, consider how you'd like the worktags to display on the debit and credit.
  • If reporting on the debit side, determine whether the credit side should have no worktags or have the same worktags.
    • Same worktags: Enables the line to report as a net zero when looking at debit minus credit. This can be useful for reporting on only 1 side, but can cause issues if you pull data into allocations.
    • No worktags: Enables you to differentiate between the lines for statistics and for clearing. We don't recommend it if you plan to have statistic lines with no worktag values. Example: Only company and ledger account statistic.
Ensure that you don't generate retained with the statistic journals. Even if the total balances net to zero, both the Redesigned Retained Earnings feature and the
Included Worktag Types
 option for retained earnings in the
Edit Tenant Setup - Financials
 task can still result in generating or rolling forward retained earnings with unintended worktag combinations. Note: For this reason, Workday doesn't recommend income statement accounts.