Assigning Group Account Numbers to Natural Accounts for HR Analytics

You must assign the following group account numbers in Fusion Applications for HR. (You can skip this task if you have already completed this task for General Ledger.)

  • 'CONT EXP' for 'Contracting Expenses'

  • 'COGS' for 'Cost of Goods Sold'

  • 'DEPCN' for 'Depreciation Expenses'

  • 'EMP BENFT' for 'Employee Benefits Related Expenses'

  • 'EMP OVERTIME' for 'Employee Overtime Expenses'

  • 'EMP SUPP' for Employee Support Expenses'

  • 'GEN PAYROLL' for General Admin and Other Payroll'

  • 'MISC OPER EXP' for 'Miscellaneous Operating Expenses'

  • 'MKTG PAYROLL' for 'Payroll Expenses'

  • 'SLS PAYROLL' for 'Payroll Expenses'

  • 'R&D PAYROLL' for 'Payroll Expenses' (GEN PAYROLL is already listed)

  • 'VARIANCE EXP' for 'Product Variance Expenses'

  • 'REVENUE' for 'Revenue'

Note:

'Other Operating Expenses' is a derived column. It does not need a group account number assignment.

How to Assign Group Account Numbers to Natural Accounts:

  1. Log in to Fusion Applications.
  2. Click the Applcore menu.
  3. Identify the value set used for your natural account.
  4. Open the window to maintain value set values
  5. Assign financial categories to each natural account from the list of values.

    The following group account numbers (financial categories) are seeded:

    ACC DEPCN - Accumulated Depreciation
    ACC LIAB - Accrued Liabilities
    AP - Account Payables
    AR - Account Receivables
    CASH - Cash
    CMMN STOCK - Common Stock
    COGS - Cost Of Goods Sold
    CONT EXP - Contracting Expenses
    DEFERRED COGS - Deferred Cost of Goods Sold
    DEFERRED REVENUE - Deferred Revenue
    DEPCN - Depreciation Expenses
    EMP BENFT - Employee Benefits Related Expenses
    EMP OVERTIME - Employee Overtime
    EMP SUPP - Employee Support and Cafeteria Expenses
    FG INV - Finished Goods Inventory, FREIGHT - Freight Expenses 
    GEN PAYROLL - General Admin And Other Payroll 
    GOODWILL - Goodwill 
    INC TAX - Income Tax 
    INT EXP - Interest Expenses 
    LT DEBT - Long Term Debt 
    MISC OPER EXP - Miscellaneous Operating Expenses 
    MKTG PAYROLL - Marketing Payroll 
    OTHER ASSET - Other Assets 
    OTHER CA - Other Current Assets 
    OTHER CL - Other Current Liabilities 
    OTHER EQUITY - Other Equity Related 
    OTHER INC - Other Income 
    OTHER LIAB - Other Liabilities 
    OTHER MKTG EXP - Other Marketing Expenses 
    OTHER R&D EXP - Other R&D Expenses 
    OTHER SLS EXP - Other Sales Expenses 
    PPAID EXP - Prepaid Expenses 
    PPE - PPE 
    PREF STOCK - Preferred Stock 
    PURCH - Purch 
    R&D PAYROLL - R&D Payroll 
    RET EARNING - Retained Earning 
    REVENUE - Sales Revenue 
    RM CONS - RM Cons 
    RM INV - Raw Material Inventory 
    SLS PAYROLL - Sales Payroll 
    ST BORR - ST Borr 
    TAX LIAB - Tax Liabilities 
    TRAVEL & ENT EXP - Travel & Entertainment Expenses 
    VARIANCE EXP - Product Variance Expenses 
    WIP INV - WIP Inventory