General Ledger account codes

These General Ledger account codes are referenced in General Ledger integration.

Addon Expense:

This income statement debit account is used only for Warehouse Transfer addons that are not capitalized. The account is updated by Transfer Receipt of Inventory Entry.

Addon in Transit:

This balance sheet asset account is used for tracking addon charges on inventory that is being shipped from one warehouse, but is not yet received by the destination warehouse. The account is updated by Transfer Shipping Entry and Transfer Receipt of Inventory Entry.

Addon Revenue:

This income statement credit account is used for Warehouse Transfer revenue for the shipping warehouse. The account is updated by Transfer Shipping Entry. When all warehouses are consolidated, the Addon Expense and Revenue accounts should offset one another.

AP Bank:

This balance sheet asset account identifies the cash account for payments made through Vendor Entry Pay Invoices Due Report.

AP Control:

This balance sheet liability account is used for accumulating Accounts Payable postings. The account is updated by: Vendor Invoice Center Entry costing, Vendor Entry Pay Invoices Due Report, Vendor Entry Group Update/Reconcile Invoices Report.

AP Discount:

This income statement credit account is used for posting revenue generated from terms discounts taken. For example, on 2% 10, Net 30 terms, if payment is made in time, this is the account that would be credited for the 2%. The account is updated by Vendor Entry Pay Invoices Due Report.

AP Expense/Asset:

This income statement debit account is used for Accounts Payable expenses. The account is only used by Vendor Invoice Center Entry and can be overridden by Vendor Invoice Center Entry from the General Ledger Distribution view.

AP Trade Unmatched:

This balance sheet liability account handles invoices received and costed through Accounts Payable, but not received in Purchase Receipt of Inventory Entry. The account is used in: Vendor Entry Batch Update Report, Vendor Entry Group Update/Reconcile Invoices Report, Vendor Entry Batch Reconciliation Report if the matching function is used, Vendor Invoice Center Entry.

AR Bank:

This balance sheet asset account identifies the cash account for funds received (or ROA) through Customer Cash Receipt Entry or Sales Order Entry. Customer Setup records, if established, can override the account or the CR Bank Setup record, if a GL account is specified.

AR Control:

This balance sheet asset account is used for tracking Accounts Receivable postings. The account is updated by Sales Entry Invoice Processing Report, Customer Transaction Entry, Customer Cash Receipt Entry, and Customer Entry Batch Update Report.

AR Discount:

This income statement debit account is used for the expensing of terms discounts. For example, if 2% 10, Net 30 terms are offered, this is the account that would be debited for the 2%. The account is updated by Customer Cash Receipt Entry.

AR Income:

This account is used for sales transactions created through Customer Transaction Entry and is rarely used.

AR Sales:

This income statement credit account is only used for sales transactions created through Customer Transaction Entry. The account is rarely used.

AR Service Charge:

This income statement credit account is used for miscellaneous income generated from service charges on past due account receivables. The account is updated by Customer Entry Roll Balances Report, and if the account is not specified here, a suspense posting is made when a service charge is added to the system.

AR Write-off:

This income statement debit account is used for expensing miscellaneous write-offs made through Customer Cash Receipt Entry. The account works with the Paid In Full Allowance Amount option in SA Administrator Options-Customers-Cash Receipts. If the account is not specified here, a suspense posting is made when a write-off is performed.

Bank:

This is an asset account that is used to establish a General Ledger account number for each bank. This account is used to reconcile your monthly bank statement.

Excise Tax:

These balance sheet liability accounts are used to accumulate excise tax payable for states, counties, cities and other taxing entities. The accounts are updated by: Sales Entry Invoice Processing Report, Customer Cash Receipt Entry. If your sales and use tax liabilities are calculated on actual cash receipts and not gross sales, you must set up the Cash Basis/GL accounts relating to the aforementioned accounts.

Expensed Addons:

This income statement debit account is used for Purchase Order addons that are not being capitalized. The account is updated by: Vendor Invoice Center Entry, Vendor Entry Group Update/Reconcile Invoices Report, Vendor Invoice Center Entry.

IC Control:

This balance sheet asset account is used for inventory. The account is updated by: Sales Entry Invoice Processing Report, Vendor Invoice Center Entry, Product Warehouse Transfer Entry, Product Adjustment Entry, Product Maintain Cost Entry, Product Entry Count Update Report, Product Adjust Non-Stock/Direct Order Entry, Vendor Entry Group Update/Reconcile Invoices Report, KP Work Order Center Entry, Transfer Receipt of Inventory Entry, Transfer Shipping Entry, Transfer Exception Receipt Entry, PI Entry Update Products Report, and Purchase Receipt of Inventory Entry. The account can be overridden by Product General Ledger Distribution Setup.

IC Cost Adjustment:

This income statement debit account is used only if the Post to SM By and Post to GL By options in SA Administrator Options-Products-Costs are set to Standard or Replacement. This account stores all variances from standard or replacement cost by: Purchase Receipt of Inventory Entry, Vendor Invoice Center Entry, Vendor Invoice Center Entry costing, and PI Entry Update Products Report.

IC Cost of Goods Adjustment:

This income statement expense account captures costing adjustments that cannot be applied to available inventory. The account is also considered a contra account to IC Cost of Goods Sold and is updated by Vendor Invoice Center Entry and Vendor Invoice Center Entry-costing and Sales Entry Invoice Processing Report. The account is only used if the Post COGS Adjustment in Costing option in SA Administrator Options-Products-Costs is not selected.

IC Direct Order Inventory:

This balance sheet asset account is used for storing inventory for Direct Order (DO) order types. The account is updated by: Purchase Receipt of Inventory Entry, Vendor Invoice Center Entry, Transfer Receipt of Inventory Entry, Transfer Shipping Entry, Product Adjust Non-Stock/Direct Order Entry, Vendor Entry Group Update/Reconcile Invoices Report, Vendor Invoice Center Entry, and Sales Entry Invoice Processing Report. The account should be cleared out each day if the day’s work in a day concept is being used.

IC Direct Order:

This balance sheet asset account is used for storing inventory cost for Direct Order (DO) order types. The account is updated by: Purchase Receipt of Inventory Entry, Product Adjust Non-Stock/Direct Order Entry, Transfer Shipping Entry, Transfer Receipt of Inventory Entry, Vendor Entry Group Update/Reconcile Invoices Report, Vendor Invoice Center Entry, and Sales Entry Invoice Processing Report. Clear out this account each day if you are using the day’s work in a day concept.

IC Non-Stock Inventory:

This balance sheet asset account stores the cost of nonstock orders. The account is updated by: Purchase Receipt of Inventory Entry, Product Adjust Non-Stock/Direct Order Entry, Transfer Receipt of Inventory Entry, Transfer Shipping Entry, KP Work Order Center Entry, Vendor Entry Group Update/Reconcile Invoices Report, Vendor Invoice Center Entry, and Sales Entry Invoice Processing Report.

IC Non-Stock:

This balance sheet asset account stores the cost of nonstock orders. The account is updated by: Product Adjust Non-Stock/Direct Order Entry, Transfer Receipt of Inventory Entry, Transfer Shipping Entry, Sales Entry Invoice Processing Report, Purchase Receipt of Inventory Entry, Vendor Entry Group Update/Reconcile Invoices Report, and Vendor Invoice Center Entry. Clear out this account each day if you are using the day’s work in a day concept.

IC Physical Adjustment:

This income statement debit account is used for all adjustments made because of count discrepancies. The account is updated by: Product Adjustment Entry, and Product Adjust Non-Stock/Direct Order Entry.

IC Rebate Cost Adjustment:

This income statement debit account keeps a running total of cost adjustments involving rebate amounts due to you from your vendor for the year. To activate this account, select the Subtract Vendor Rebate from Cost option in SA Administrator Options-Sales History-Rebates/Basis, and set up the vendor for rebates in PD Mass Maintenance Entry. The account is updated by Sales Entry Invoice Processing Report, Vendor Invoice Center Entry, and Vendor Invoice Center Entry.

IC Rebate Due:

This balance sheet debit account stores the rebate due to you from your vendor. To activate this account, select the Subtract Vendor Rebate from Cost option in SA Administrator Options-Sales History-Rebates/Basis, and set up the vendor for rebates in PD Mass Maintenance Entry. The account is updated by: Sales Entry Invoice Processing Report, Vendor Invoice Center Entry, and Vendor Invoice Center Entry costing.

IC Uninvoiced Addons:

This balance sheet liability account is similar to IC Uninvoiced Inventory and is used for tracking third party capitalized addons. The account is updated by: Purchase Receipt of Inventory Entry, and Vendor Invoice Center Entry. The account should always be cleared out. The system checks SA Table Code Value Setup PO Addons for an account number first. If the account number is not available in SA Table Code Value Setup or SA Operator Setup-GL Defaults, a suspense entry is posted.

IC Uninvoiced Inventory:

This balance sheet liability account is known as accrued accounts payable. The account is updated by: Purchase Receipt of Inventory Entry, Vendor Invoice Center Entry, Vendor Invoice Center Entry costing, Vendor Entry Batch Reconciliation Report, and Vendor Entry Group Update/Reconcile Invoices Report. The account should always be cleared out when the purchase order is costed in Vendor Invoice Center Entry, and balanced through GL Balance Purchase Order Report. The account can be overridden by Product General Ledger Distribution Setup.

IC Work In Process Write Off:

This balance sheet liability account is used to store the amount of a value add product that is written off. The account is updated by: Purchase Receipt of Inventory Entry, VA Shipping Entry, VA Receipt of Inventory Entry, VA Order Entry, and VA Internal Labor Time Entry.

IC Work in Process:

This balance sheet asset account stores the value of inventory that is being used to create a value add product. The account is updated by: Purchase Receipt of Inventory Entry, VA Shipping Entry, VA Receipt of Inventory Entry, VA Order Entry, and VA Internal Labor Time Entry.

Income or Retained Earnings:

This balance sheet liability account is used for accumulating the current year’s profits. The account is updated by GL Administrator Distribute Profit Report.

Intercompany WT:

This balance sheet asset account is used to track inventory that is transferred between companies. The account is updated by: Transfer Shipping Entry, and Transfer Receipt of Inventory Entry.

InterDiv Inventory:

This clearing account is used for tracking the cost of inventory that is being transferred from one division to another. The account is updated by Transfer Receipt of Inventory Entry. Each division within your system that uses full divisionalized accounting must balance by division.

Inventory in Transit:

This balance sheet asset account is used for tracking inventory that is shipped from one warehouse but has not yet been received by the destination warehouse. The account is updated by Transfer Shipping Entry and Transfer Receipt of Inventory Entry. The account should clear out when the destination warehouse receives inventory.

Inventory:

This balance sheet asset account is for inventory. The account is updated by: Vendor Invoice Center Entry, Product Adjustment Entry, Product Maintain Cost Entry, Product Entry Count Update Report, Product Adjust Non-Stock/Direct Order Entry, Product Warehouse Transfer Entry, Sales Entry Invoice Processing Report, Transfer Receipt of Inventory Entry, Transfer Shipping Entry, Transfer Exception Receipt Entry, KP Work Order Center Entry, Purchase Receipt of Inventory Entry, and PI Entry Update Products Report.

Loss/Gain Currency Exchange:

This income statement credit or debit account is used for tracking gains or losses from currency exchange transactions. The account is updated by: Sales Entry Invoice Processing Report, Purchase Receipt of Inventory Entry, Vendor Invoice Center Entry costing, Vendor Entry Group Update/Reconcile Invoices Report, Vendor Entry Batch Reconciliation Report, and Vendor Invoice Center Entry.

OE Addons:

These income statement credit accounts are used for taxed and nontaxed Sales Order Entry addons. They are updated by Sales Entry Invoice Processing Report.

OE COD:

This balance sheet asset account is used to post all accounts receivables for COD invoices. The account is updated by: Sales Entry Invoice Processing Report, and Customer Cash Receipt Entry. You can specify the account code used for AR Control. If this account is not specified here, a suspense posting is made.

OE Core Charge:

This balance sheet liability account is used for tracking core charges payable. Although the account should clear itself out, the account usually carries a credit balance. The account is updated by Sales Entry Invoice Processing Report and Sales Order Entry tendering and can be superseded by the Product General Ledger Distribution Setup record.

OE Cost of Goods:

This income statement debit account is used for all inventory cost of goods associated with Sales Order Entry orders. The account is updated by Sales Entry Invoice Processing Report , Vendor Invoice Center Entry, and Vendor Invoice Center Entry costing, and can be superseded by the Product General Ledger Distribution Setup record.

OE Direct Order COGS:

This income statement debit account is used for all Direct Order (DO) order type inventory costs. The account is updated by Sales Entry Invoice Processing Report and Vendor Invoice Center Entry, and Vendor Invoice Center Entry costing, and can be superseded by the Product General Ledger Distribution Setup record.

OE Direct Order Sales:

This income statement credit account is used for all sales generated by Direct Order (DO) order types. The account is updated by Sales Entry Invoice Processing Report and can be overridden or superseded by Product General Ledger Distribution Setup.

OE Down Payment:

This balance sheet liability account is used for storing down payments until an invoice has been processed. The account is updated by: Sales Entry Invoice Processing Report, and Sales Order Entry Tendering. the account should always clear itself out. If an account is not specified here, a suspense posting is made.

OE Gross Sales:

This income statement credit account is used for all sales generated through Sales Order Entry. The account is updated by Sales Entry Invoice Processing Report and can be overridden or superseded by Customer Setup and Product General Ledger Distribution Setup.

OE Line Discount:

This income statement debit account is used for all line discounts from Sales Order Entry. The account is updated by Sales Entry Invoice Processing Report and can be superseded by the Product General Ledger Distribution Setup record.

OE Lump Sum Bill:

This balance sheet liability account is used for tracking lump sum bill amounts from Blanket Release (BR) order types. The account is similar to the OE Down Payment account and is updated by Sales Entry Invoice Processing Report. If this account is not specified here, a suspense posting is made.

OE Order Discount:

This income statement debit account is used for all whole order discounts from Sales Order Entry. The account is updated by Sales Entry Invoice Processing Report and can be superseded by the Product General Ledger Distribution Setup record.

OE Restock Charge:

This income statement credit account is used for posting charges received for restocking returned inventory. The account is updated by Sales Entry Invoice Processing Report and can be superseded by the Product General Ledger Distribution Setup record.

OE Sales Returns:

This income statement debit account stores all returns made through Sales Order Entry. The account is updated through Sales Entry Invoice Processing Report and can be superseded by the Product General Ledger Distribution Setup record.

OE Uninvoiced Cash Sales:

This balance sheet liability account is used for storing cash receipts until an invoice has been processed. The account is updated by: Sales Entry Invoice Processing Report and Sales Order Entry Tendering. The account should always clear itself out and could be used in the same way as OE Down Payment. The OE Direct Order COGS and OE Down Payment accounts are compared to orders in the GL Balance Order Entry Report. If an account is not specified here, a suspense posting is made.

PO Order Discount:

This income statement credit account is used for purchase order whole order discount revenue that is expensed. The account is updated by: Vendor Invoice Center Entry and Purchase Receipt of Inventory Entry.

Profit Clearing:

This clearing account’s balance is displayed on the GL Trial Balance Report. The account is used only to offset the entry made for current year’s retained earnings and is updated by GL Administrator Distribute Profit Report.

PST Liability:

This balance sheet liability account is used for accumulating PST Tax liabilities. The account is updated by: Sales Entry Invoice Processing Report and Customer Cash Receipt Entry.

Sales Tax:

These balance sheet liability accounts are used to accumulate sales tax payable for states, counties, cities, and other taxing entities. The accounts are updated by: Sales Entry Invoice Processing Report and Customer Cash Receipt Entry.

Suspense Credit and Suspense Debit:

These clearing accounts are a catch-all and are used when other account codes are not properly established. If all accounts are properly set up, these accounts are only used for Sales Entry Invoice Processing Report and Vendor Invoice Center Entry rounding problems.

Tariff Payable:

This balance sheet liability account is used for accumulating tariff and processing fees payable. The account is updated by Purchase Receipt of Inventory Entry.

Transit Tax:

These balance sheet liability accounts are used to accumulate transit tax payable for states, counties, cities, and other taxing entities. The accounts are updated by: Sales Entry Invoice Processing Report and Customer Cash Receipt Entry.

Uninvoiced Addons:

This balance sheet liability account is similar to PO Uninvoiced for recording liability when capitalizing addons at receiving. The account is updated by: Purchase Receipt of Inventory Entry, Vendor Invoice Center Entry, Vendor Entry Batch Reconciliation Report, and Vendor Entry Group Update/Reconcile Invoices Report.

Use Tax:

These balance sheet liability accounts are used to accumulate use tax payable for states, counties, cities, and other taxing entities. The accounts are updated by: Sales Entry Invoice Processing Report and Customer Cash Receipt Entry.

Warranty Claims Receivable Offset:

This income statement income account is for recording the revenue generated by creating the warranty claim.

Warranty Claims Receivable:

This balance sheet asset account is for recording receivables that are related to warranty claims.

Warranty Claims Write-off:

This income statement expense account is for writing off claims that are not received from vendors.

Work In Process Inventory:

Work In Process Write Off:

WT Cost Adjustments:

This income statement debit account is for costing discrepancies where the product is no longer in inventory, but has been transferred to another warehouse. The account is updated through Vendor Invoice Center Entry.