Account Categories

Account Categories in i21 control where and if the account can be used in a specific place. For example accounts in the cash category could not be used as a debit on an accounts payable transaction as this would put the cash account out of balance with the subledger.

Category	Description	Modules that Require this Category	Screens that Require/Use this Category	Comments
AP Account	Accounts Payable Account	Purchasing	Voucher Company Location
AR Account	Accounts Receivable Account	Sales	Invoice Payments
Cash Account	Used on bank accounts and relates to the balance in the bank account	Cash Management Purchasing	Bank Transaction Bank Deposit Bank Transfer Bank Account Payment Company Location
Cost of Goods	Cost of goods sold for inventory items	Sales	Invoice
Discount Receivable		Sales
DP Income
DP Liability
Interest Income				Use 'Other Charge Income' instead
Inventory	Used for all item types Inventory	Purchase, Sales, Inventory	Voucher, IR IA IT IS SI Physical Count Mfg
Purchase Adv Account
Rail Freight				Use 'Other Charge Expense' instead
Sales Account			Inventory GL Setup Category GL Setup Invoice GL selection Invoice Posting Routine
Sales Discount			Receive Payment Sales Company Config Setup
Service Charges			Calculate Service Charges Routine Sales Company Config setup
AP Clearing	To book amounts to be cleared between a receipt and voucher posting.	Purchase, Inventory	Voucher IR
Inventory In-Transit	To book amounts which are shipped but not invoiced.	Inventory, Sales	IS Invoice
General	This category is used if the account should have no restrictions on it.
Sales Tax Account			Tax Code Setup Invoice posting Routine
Purchase Tax Account			Tax Code Setup Purchases Posting Routine
Undeposited Funds	Used as a holding account for cash that has been received but not yet deposited into the bank	Cash Management Sales	Bank Deposit
Inventory Adjustment	COGS account for booking any changes to inventory value caused by changes to stock.	Inventory	IA Physical Count
Work In Progress	To book amount which are manufacturing in process.	Mfg	Blending Bag off FG Production Process
Vendor Prepayments	To book the Debit to accounts payable (vendor receivable) for amounts advanced tot he vendor	AP	Vendor Prepayment
Customer Prepayments	To book the Credit to accounts payable for prepaid amounts.	AR	Customer Prepayment
Other Charge Expense	All charges like freight, brokerage etc which are accrued is booked in this category.	Purchase, Inventory	Voucher IR IS
Other Charge Income	All charges like freight, storage etc which are invoiced or borne by the company is booked in this category.	Purchase, Inventory, Sales	Voucher, Invoice, IR, IS
Maintenance Sales			Inventory GL Software type Setup Category GL software type setup Invoice Routine posting for UGD
Deferred Revenue			Invoice Routine posting for UGD Sales Company Configuration Setup
Write Off
Unrealized Gain or Loss Accounts Receivable	Used with multi-currency to store the amount gained or lost based on a purchase that includes a currency conversion
Unrealized Gain or Loss Accounts Payable
Unrealized Gain or Loss Inventory
Unrealized Gain or Loss Contract Purchase
Unrealized Gain or Loss Contract Sales
Unrealized Gain or Loss Offset AR
Unrealized Gain or Loss Offset AP
Unrealized Gain or Loss Offset CM
Unrealized Gain or Loss Offset Inventory
Unrealized Gain or Loss Accounts Payable
Unrealized Gain or Loss Inventory
Unrealized Gain or Loss Contract Purchase
Unrealized Gain or Loss Contract Sales
Unrealized Gain or Loss Offset Inventory
Unrealized Gain or Loss Cash Management
Unrealized Gain or Loss Offset Contract Purchase
Unrealized Gain or Loss Offset Contract Sales
Realized Gain or Loss Payables
Realized Gain or Loss Receivables
Futures Gain or Loss Realized
Futures Trade Equity
Unrealized Gain or Loss Foreign Currency

Category	Description	Modules that Require this Category	Screens that Require/Use this Category	Comments
AP Account	Accounts Payable Account	Purchasing	Voucher Company Location
AR Account	Accounts Receivable Account	Sales	Invoice Payments
Broker Expense				Use 'Other Charge Expense' instead
Cash Account	Used on bank accounts and relates to the balance in the bank account	Cash Management Purchasing	Bank Transaction Bank Deposit Bank Transfer Bank Account Payment Company Location
Cash Over/Short
Contract Equity
Contract Purchase Gain/Loss
Contract Sales Gain/Loss
Cost of Goods1	Cost of goods sold for inventory items	Sales	Invoice
Credit Card Fee
Currency Equity
Currency Purchase Gain/Loss	Used with multi-currency to store the amount gained or lost based on a purchase that includes a currency conversion
Currency Sales Gain/Loss	Used with multi-currency to store the amount gained or lost based on a sale that includes a currency conversion
Discount Receivable
DP Income
DP Liability
Fee Expense				Use 'Other Charge Expense' instead
Fee Income				Use 'Other Charge Income' instead
Freight AP Account
Freight Expenses				Use 'Other Charge Expense' instead
Freight Income				Use 'Other Charge Income' instead
Interest Expense				Use 'Other Charge Expense' instead
Interest Income1				Use 'Other Charge Income' instead
Inventory	Used for all item types Inventory	Purchase, Sales, Inventory	Voucher, IR IA IT IS SI Physical Count Mfg
Options Expense				Use 'Other Charge Expense' instead
Options Income				Use 'Other Charge Income' instead
Purchase Account
Purchase Adv Account
Rail Freight				Use 'Other Charge Expense' instead
Sales Account			Inventory GL Setup Category GL Setup Invoice GL selection Invoice Posting Routine	Do we need this one as a category? - Yes
Sales Adv Account
Sales Discount			Receive Payment Sales Company Config Setup
Service Charges			Calculate Service Charges Routine Sales Company Config setup
Storage Expense				Use 'Other Charge Expense' instead
Storage Income				Use 'Other Charge Income' instead
Storage Receivable
Auto-Variance	To book any variance caused in inventory value caused by change in cost. Cost can change for backdated transactions or inventory is recovering from negative stock position.	Purchase, Inventory	Voucher IR IT IA
AP Clearing	To book amounts to be cleared between a receipt and voucher posting.	Purchase, Inventory	Voucher IR
Inventory In-Transit	To book amounts which are shipped but not invoiced.	Inventory, Sales	IS Invoice
General 1	This category is used if the account should have no restrictions on it.
Sales Tax Account			Tax Code Setup Invoice posting Routine
Purchase Tax Account			Tax Code Setup Purchases Posting Routine
Undeposited Funds	Used as a holding account for cash that has been received but not yet deposited into the bank	Cash Management Sales	Bank Deposit
Inventory Adjustment1	COGS account for booking any changes to inventory value caused by changes to stock.	Inventory	IA Physical Count
Work In Progress	To book amount which are manufacturing in process.	Mfg	Blending Bag off FG Production Process
Vendor Prepayments1
Customer Prepayments1
Other Charge Expense1	All charges like freight, brokerage etc which are accrued is booked in this category.	Purchase, Inventory	Voucher IR IS
Other Charge Income	All charges like freight, storage etc which are invoiced or borne by the company is booked in this category.	Purchase, Inventory, Sales	Voucher, Invoice, IR, IS
Maintenance Sales1			Inventory GL Software type Setup Category GL software type setup Invoice Routine posting for UGD
Deferred Revenue			Invoice Routine posting for UGD Sales Company Configuration Setup
Realized Gain or Loss Foreign Currency
Unrealized Gain or Loss Foreign Currency

Page tree

Account Categories