GL Account Setup for Standard Costing

GL Account Setup for Standard Costing




G/L Account Required for Standard Costing & PIT

Summary

This document helps explain some of the common accounts that are required for using EIQ in a Standard Costing environment when the transactions will be journalized.   Note that some of these accounts may already exist in your current setup.  Please carefully review this document to make sure that you have a clear understanding of what is required. 


Major GL Account Types


  1. Asset / Inventory Accounts (Balance Sheet) – these accounts are used to hold the inventory value of all purchased and Manufactured Items.   They can be setup in the following areas:
    1. GL Setup Default – allows for a main Inventory Account – recommend that this is an account that should never contain any value in it, this is done to assure that proper setup is being done. 
    2. Cost Element – is used for any purchased items, they will drive the purchase and consumption of the item into and out of this account
    3. Inventory Item Group – this is an override location for any item that is manufactured.  – OPTIONAL
    4. Inventory Item – a specific G/L account can be assigned to a Mfg. Item, this is where the item Std Cost will go into and out of when made, consumed or shipped. 

  2. Absorption / Earned Accounts  (Offset to expenses Income Statement) – these accounts are used to offset the cost of manufacturing an item.  They are used for both labor and overhead and can be broken out depending on how the user configures the system.
    1. GL Setup Default – is what is used if a cost element does not declare a specific account
    2. Cost Element – is the typical setup and will push the Manufacturing on an item into this account.  

  3. COGS / Ship Accounts  (Part of COGS – income statement) – is used when shipping an item they can be a bucket account or specific they are used to break out the Cost of Goods Sold when an item is sold
    1. GL Setup Default – is what is used if an override is not set up.
    2. Cost Element – is where a G/L Account can be setup to help split up the COGS entry at time of AR Invoicing 
    3. Inventory Item Group – allows the user to override the cost elements assigned G/L account

  4. Variance Accounts ---(COGS – income statement)  are used when an over/under use of materials, labor or overhead occurs. It is also used when an item is purchased and there is a difference between the standard cost and purchase/invoice price.   It is also used when doing specific types of manual adjustments in the system.  
    1. GL Setup Default Accounts – this is the main default when a variance occurs
    2. Cost Element – allows the user to assign a specific variance account for the element
    3. Inventory Item Group – override to the Cost Element allows the user to assign specific account for an inventory item group – NOTE MFG. items only.  
    4. Item Level – Overrides the Inventory Item group if used or the cost elements on MFG. Items only – this is specifically for MFG. Items consumption
    5. Note:  there are two types of MFG. Variance 
      1. Production Variance – which is hit during usage variance of a raw material
      2. Mfg. Production Variance  -- which is hit when usage variance occurs on consumption of a WIP item

  5. Other Accounts – (COGS – income statement)  there is an option to have the system use other variance accounts during cost rolls or Physical – Cycle Counting Variances 

Mandatory Setup

It is strongly recommended that the user defines the following for the system to flow the dollars correctly

  1. Default G/L Accounts – NOT OPTIONAL
  2. Cost Elements --   Strongly Recommended 



Note on the order of how the system determines what G/L Account to use

  1. Inventory Item – MFG. Items only
  2. Inventory Item Group – MFG. Items Only
  3. Cost Element 
  4. Default


In other words the system looks at the item first, then if it does not see an override is looks to see if the item belongs to and inventory item group, etc.







    • Related Articles

    • GL Account Setup for Standard Costing

      ​ ​ G/L Account Required for Standard Costing & PIT Summary This document helps explain some of the common accounts that are required for using EIQ in a Standard Costing environment when the transactions will be journalized.   Note that some of these ...
    • Account Revaluation

      Standard Costing in EIQ EnterpriseIQ supports a complete Standard Costing system, linking various inventory and financial transactions to specific General Ledger accounts.  The complete standard, perpetual inventory (explained below) costing system ...
    • Intercompany Setup

      Intercompany Setup Go to the Sys Setup Tab Access the System Parameters Module (Icon)   Access the Enterprise Tab Access the Miscellaneous tab for each Eplant (bottom right of the Enterprise Window)  Make sure "Use Intercompany" is checked for all ...
    • Multi-Curency Setup

      ​ ​ ATTC Multi-Currency Setup Summary This document explains the setup and basic use of the multi-currency system.    Including setup of the Multi-Currency Module, GL Setup – GL Defaults and Revalue functionality within EIQ.  NOTE – you must have the ...
    • GL Imports

      GL Tab Select New (If nothing shows up in the pick list – if there are items in the pick list, choose any of them) Cancel (out of create new group) File -> Import External File Choose NEW Import Code: GL Description: GL Import (Prepost Detail) File ...