Accounting GL Setup

Setup your Company Record

Select Applications-Party-Create New Party Group

Enter Party Id "Company", Enter Group Name "Your Company, Inc." , Select Currency, Save

Enter Postal Address, Save

Select Company - Click on Create New Contact Information - Select Postal Address - Click Create

Enter Address, City, State, Zip, and Allow Solicitation = Y

Click Update on Contact Information

Select Billing (AP) Address and Click on Add Purpose

Select General Correspondence Address and Click on Add Purpose

Select Primary Address and Click on Add Purpose

Select Purchase Return Address and Click on Add Purpose

Select Shipping Origin Address and Click on Add Purpose

Click on Save then Click on Go Back

Click on Rolls

Add To Roll: view all - Select Internal Organization - Click on Add

Notes: If you don't set the Internal Organization Roll you will not be able to create the General Ledger Chart of Accounts for your company record.

Add To Roll: view all - Select Carrier - Click on Add

Notes: If you don't set the Carrier Roll you will not be able to create the Product Store.

Click on Profile

https://cwiki.apache.org/confluence/display/OFBENDUSER/How+to+Create+the+main+Company+in+Party+Manager

Setup minimum Chart of Accounts.

<entity-engine-xml><GlAccount glAccountId="1000" glAccountTypeId="CURRENT_ASSET" glAccountClassId="CASH_EQUIVALENT" glResourceTypeId="MONEY" parentGlAccountId="" accountCode="1000" accountName="ASSETS" /><GlAccount glAccountId="1100" glAccountTypeId="CURRENT_ASSET" glAccountClassId="CASH_EQUIVALENT" glResourceTypeId="MONEY" parentGlAccountId="1000" accountCode="1100" accountName="General Checking Account" /><GlAccount glAccountId="1200" glAccountTypeId="CURRENT_ASSET" glAccountClassId="CASH_EQUIVALENT" glResourceTypeId="MONEY" parentGlAccountId="1000" accountCode="1200" accountName="Undeposited Receipts" /><GlAccount glAccountId="1500" glAccountTypeId="ACCOUNTS_RECEIVABLE" glAccountClassId="CURRENT_ASSET" glResourceTypeId="MONEY" parentGlAccountId="1000" accountCode="1500" accountName="Accounts Receivable - Trade" /><GlAccount glAccountId="1600" glAccountTypeId="INVENTORY_ACCOUNT" glAccountClassId="INVENTORY_ASSET" glResourceTypeId="MONEY" parentGlAccountId="1000" accountCode="1600" accountName="INVENTORY" /><GlAccount glAccountId="2000" glAccountTypeId="CURRENT_LIABILITY" glAccountClassId="LIABILITY" glResourceTypeId="MONEY" parentGlAccountId="" accountCode="2000" accountName="LIABILITIES" /><GlAccount glAccountId="2100" glAccountTypeId="ACCOUNTS_PAYABLE" glAccountClassId="CURRENT_LIABILITY" glResourceTypeId="MONEY" parentGlAccountId="2000" accountCode="2100" accountName="Accounts Payable" /><GlAccount glAccountId="2400" glAccountTypeId="CURRENT_LIABILITY" glAccountClassId="CURRENT_LIABILITY" glResourceTypeId="MONEY" parentGlAccountId="2000" accountCode="2400" accountName="Sales Taxes Collected" /><GlAccount glAccountId="3000" glAccountTypeId="" glAccountClassId="EQUITY" glResourceTypeId="MONEY" parentGlAccountId="" accountCode="3000" accountName="OWNERS EQUITY and NET WORTH" /><GlAccount glAccountId="3500" glAccountTypeId="OWNERS_EQUITY" glAccountClassId="RETAINED_EARNINGS" glResourceTypeId="MONEY" parentGlAccountId="3000" accountCode="3500" accountName="Retained Earnings" /><GlAccount glAccountId="3999" glAccountTypeId="OWNERS_EQUITY" glAccountClassId="EQUITY" glResourceTypeId="MONEY" parentGlAccountId="3000" accountCode="3999" accountName="Suspense" /><GlAccount glAccountId="4000" glAccountTypeId="" glAccountClassId="REVENUE" glResourceTypeId="MONEY" parentGlAccountId="" accountCode="4000" accountName="SALES" /><GlAccount glAccountId="4100" glAccountTypeId="" glAccountClassId="REVENUE" glResourceTypeId="MONEY" parentGlAccountId="4000" accountCode="4100" accountName="General Sales" /><GlAccount glAccountId="4200" glAccountTypeId="" glAccountClassId="COGS_EXPENSE" glResourceTypeId="MONEY" parentGlAccountId="4000" accountCode="4200" accountName="Discounts on Sales" /><GlAccount glAccountId="5000" glAccountTypeId="" glAccountClassId="COGS_EXPENSE" glResourceTypeId="MONEY" parentGlAccountId="" accountCode="5000" accountName="COST OF GOODS SOLD" /><GlAccount glAccountId="5100" glAccountTypeId="" glAccountClassId="COGS_EXPENSE" glResourceTypeId="MONEY" parentGlAccountId="5000" accountCode="5100" accountName="Wages" /><GlAccount glAccountId="5300" glAccountTypeId="" glAccountClassId="COGS_EXPENSE" glResourceTypeId="MONEY" parentGlAccountId="5000" accountCode="5300" accountName="Raw Material Purchases" /><GlAccount glAccountId="5500" glAccountTypeId="" glAccountClassId="COGS_EXPENSE" glResourceTypeId="MONEY" parentGlAccountId="5000" accountCode="5500" accountName="Merchant Account Fees" /><GlAccount glAccountId="5700" glAccountTypeId="" glAccountClassId="COGS_EXPENSE" glResourceTypeId="MONEY" parentGlAccountId="5000" accountCode="5700" accountName="Freight-In" /><GlAccount glAccountId="6000" glAccountTypeId="" glAccountClassId="EXPENSE" glResourceTypeId="MONEY" parentGlAccountId="" accountCode="6000" accountName="EXPENSES" /><GlAccount glAccountId="6100" glAccountTypeId="" glAccountClassId="SGA_EXPENSE" glResourceTypeId="MONEY" parentGlAccountId="6000" accountCode="6100" accountName="Advertising and Promotions" /><GlAccount glAccountId="6200" glAccountTypeId="" glAccountClassId="SGA_EXPENSE" glResourceTypeId="MONEY" parentGlAccountId="6000" accountCode="6200" accountName="Bank Service Charges" /><GlAccount glAccountId="6300" glAccountTypeId="" glAccountClassId="SGA_EXPENSE" glResourceTypeId="MONEY" parentGlAccountId="6000" accountCode="6300" accountName="Business Licenses and Permits" /><GlAccount glAccountId="6400" glAccountTypeId="" glAccountClassId="SGA_EXPENSE" glResourceTypeId="MONEY" parentGlAccountId="6000" accountCode="6400" accountName="Data Processing Expenses" /><GlAccount glAccountId="6500" glAccountTypeId="" glAccountClassId="SGA_EXPENSE" glResourceTypeId="MONEY" parentGlAccountId="6000" accountCode="6500" accountName="Dues and Subscriptions" /><GlAccount glAccountId="6600" glAccountTypeId="" glAccountClassId="SGA_EXPENSE" glResourceTypeId="MONEY" parentGlAccountId="6000" accountCode="6600" accountName="Education and Training" /><GlAccount glAccountId="6700" glAccountTypeId="" glAccountClassId="SGA_EXPENSE" glResourceTypeId="MONEY" parentGlAccountId="6000" accountCode="6700" accountName="Human Resources Expense" /><GlAccount glAccountId="6800" glAccountTypeId="" glAccountClassId="SGA_EXPENSE" glResourceTypeId="MONEY" parentGlAccountId="6000" accountCode="6800" accountName="INSURANCE EXPENSE" /><GlAccount glAccountId="6810" glAccountTypeId="" glAccountClassId="SGA_EXPENSE" glResourceTypeId="MONEY" parentGlAccountId="6800" accountCode="6810" accountName="General Liability Insurance" /><GlAccount glAccountId="6820" glAccountTypeId="" glAccountClassId="SGA_EXPENSE" glResourceTypeId="MONEY" parentGlAccountId="6800" accountCode="6820" accountName="Workmans Comp Insurance" /><GlAccount glAccountId="6900" glAccountTypeId="" glAccountClassId="SGA_EXPENSE" glResourceTypeId="MONEY" parentGlAccountId="6000" accountCode="6900" accountName="Interest Expense" /><GlAccount glAccountId="7000" glAccountTypeId="" glAccountClassId="SGA_EXPENSE" glResourceTypeId="MONEY" parentGlAccountId="6000" accountCode="7000" accountName="Meals and Entertainment" /><GlAccount glAccountId="7100" glAccountTypeId="" glAccountClassId="SGA_EXPENSE" glResourceTypeId="MONEY" parentGlAccountId="6000" accountCode="7100" accountName="Office Supplies" /><GlAccount glAccountId="7200" glAccountTypeId="" glAccountClassId="SGA_EXPENSE" glResourceTypeId="MONEY" parentGlAccountId="6000" accountCode="7200" accountName="Postage and Delivery" /><GlAccount glAccountId="7300" glAccountTypeId="" glAccountClassId="SGA_EXPENSE" glResourceTypeId="MONEY" parentGlAccountId="6000" accountCode="7300" accountName="Professional Fees" /><GlAccount glAccountId="7400" glAccountTypeId="" glAccountClassId="SGA_EXPENSE" glResourceTypeId="MONEY" parentGlAccountId="6000" accountCode="7400" accountName="Rent Expense" /><GlAccount glAccountId="7500" glAccountTypeId="" glAccountClassId="SGA_EXPENSE" glResourceTypeId="MONEY" parentGlAccountId="6000" accountCode="7500" accountName="Repairs and Maintenance" /><GlAccount glAccountId="7700" glAccountTypeId="" glAccountClassId="SGA_EXPENSE" glResourceTypeId="MONEY" parentGlAccountId="6000" accountCode="7700" accountName="Telephone" /><GlAccount glAccountId="7800" glAccountTypeId="" glAccountClassId="SGA_EXPENSE" glResourceTypeId="MONEY" parentGlAccountId="6000" accountCode="7800" accountName="Travel" /><GlAccount glAccountId="7900" glAccountTypeId="" glAccountClassId="SGA_EXPENSE" glResourceTypeId="MONEY" parentGlAccountId="6000" accountCode="7900" accountName="Utilities" /></entity-engine-xml>

GL Account Class Id sets the hierarchy for reporting. I found a nice reference at HotWaxSystems - https://www.hotwaxsystems.com/ofbiz/ofbiz-tutorial-charts-of-accounts/

Check for 1150, Unapplied Payments - 1500, Inventory - 1800 Deposits - 2100, Customer Deposits

Setup Journals

Accounting - Organization GL Settings - Setup - Journals

May need Error Journal and a General Journal

Setup GL Account defaults

Accounting - Organization GL Settings - Setup - GL Account Defaults


Setup Financial Type GL Accounts

Accounting - Organization GL Settings - Setup - GL Account defaults - FinAccount Type Gl Account

Bank Account

Credit Card Account

Deposit Account

Equity Line Account

Gift Certificate

Investment Account

Loan Account

Replenish Account

Store Credit Account

Serivce Credit Account



Create Global General Ledger Accounts

Looks like 2 ways to add GL accounts from scratch. Add the GLAccountId, accountCode, accountName via the Web Tools Entity Data Maintenance interface and then clean up in the Accounting - Global GL Settings. The other way is to perform an XML Data Import from the Web Tools Menu.

Notes: It is critical that you enter the GLAccountId manually and make sure that it matches the accountCode as it will make it far easier to find a GL account later on. Allowing the system to assign any sequence number will create problems when searching for a specific GL account number.

Way number 1:

Click on Web Tools - Entity Data Maintenance - G- GlAccount

Click on Create New

Add Top Level Accounts - GlAccountId, accountCode, accountName

1000, 1000, Assets - Click Create

2000, 2000, Liabilities - Click Create

3000, 3000, Owners Equity and Net Worth - Click Create

4000, 4000, Sales - Click Create

5000, 5,000, Cost of Goods Sold - Click Create

6000, 6000, Expenses - Click Create

7000, 7000, Other Expenses - Click Create

8000, 8000, Other Income- Click Create

8200, 8200, Other Expenses - Click Create

8500, 8500, Net Income - Click Create

9000, 9000, Income Tax - Click Create

(Now Update all Accounts with Proper Info)

Select Application-Accounting-Accounting Manager-Global GL Settings

Then Enter Gl Account Type, GL Account Class Id, Gl Resource Type Id, Account Code, Account Name

Not Applicable, Asset, Money, 1000, Assets - Click Add

Not Applicable, Liability, Money, 2000, Liabilities - Click Add

Not Applicable, Equity, Money, 3000, Owners Equity and Net Worth - Click Add

Not Applicable, Revenue, Money, 4000, Sales - Click Add

Not Applicable, Cost of Goods Sold, Money, 5000, Cost of Goods Sold - Click Add

Not Applicable, Expense, Money, 6000, Expenses - Click Add

Not Applicable, Selling, General, and Administrative Expense, Money, 7000, Other Expenses - Click Add

Not Applicable, Income, Money, 8000, Other Income- Click Add

Not Applicable, Cash Expense, Money, 8200, Other Expenses - Click Add

Profit Loss, Debit, Money, 8500, Net Income - Click Add

Not Applicable, Non-Posting, Money, 9000, Income Tax - Click Add

Need to Review Account Classes Ref: https://www.hotwaxsystems.com/ofbiz/ofbiz-tutorial-charts-of-accounts/

Way Number 2:

Click on Web Tools - XML Data Import (Cut and Paste)(If you modify make sure you get the sequence correct. Accounts further down reference accounts higher in the list.)

<entity-engine-xml><GlAccount glAccountId="1000" glAccountTypeId="CURRENT_ASSET" glAccountClassId="CASH_EQUIVALENT" glResourceTypeId="MONEY" parentGlAccountId="" accountCode="1000" accountName="ASSETS" /><GlAccount glAccountId="1100" glAccountTypeId="CURRENT_ASSET" glAccountClassId="CASH_EQUIVALENT" glResourceTypeId="MONEY" parentGlAccountId="1000" accountCode="1100" accountName="CASH" /><GlAccount glAccountId="1110" glAccountTypeId="CURRENT_ASSET" glAccountClassId="CASH_EQUIVALENT" glResourceTypeId="MONEY" parentGlAccountId="1100" accountCode="1110" accountName="Petty Cash" /><GlAccount glAccountId="1120" glAccountTypeId="CURRENT_ASSET" glAccountClassId="CASH_EQUIVALENT" glResourceTypeId="MONEY" parentGlAccountId="1100" accountCode="1120" accountName="General Checking Account" /><GlAccount glAccountId="1130" glAccountTypeId="CURRENT_ASSET" glAccountClassId="CASH_EQUIVALENT" glResourceTypeId="MONEY" parentGlAccountId="1100" accountCode="1130" accountName="Payroll Checking Account" /><GlAccount glAccountId="1180" glAccountTypeId="CURRENT_ASSET" glAccountClassId="CASH_EQUIVALENT" glResourceTypeId="MONEY" parentGlAccountId="1100" accountCode="1180" accountName="Undeposited Receipts" /><GlAccount glAccountId="1200" glAccountTypeId="ACCOUNTS_RECEIVABLE" glAccountClassId="CURRENT_ASSET" glResourceTypeId="MONEY" parentGlAccountId="1000" accountCode="1200" accountName="ACCOUNTS RECEIVABLE" /><GlAccount glAccountId="1210" glAccountTypeId="ACCOUNTS_RECEIVABLE" glAccountClassId="CURRENT_ASSET" glResourceTypeId="MONEY" parentGlAccountId="1200" accountCode="1210" accountName="Accounts Receivable - Trade" /><GlAccount glAccountId="1260" glAccountTypeId="MRCH_STLMNT_ACCOUNT" glAccountClassId="CURRENT_ASSET" glResourceTypeId="MONEY" parentGlAccountId="1200" accountCode="1260" accountName="Accounts Receivable - Credit Card Processors" /><GlAccount glAccountId="1265" glAccountTypeId="MRCH_STLMNT_ACCOUNT" glAccountClassId="CURRENT_ASSET" glResourceTypeId="MONEY" parentGlAccountId="1200" accountCode="1265" accountName="Accounts Receivable - Paypal" /><GlAccount glAccountId="1400" glAccountTypeId="INVENTORY_ACCOUNT" glAccountClassId="INVENTORY_ASSET" glResourceTypeId="MONEY" parentGlAccountId="1000" accountCode="1400" accountName="INVENTORY" /><GlAccount glAccountId="1410" glAccountTypeId="INVENTORY_ACCOUNT" glAccountClassId="INVENTORY_ASSET" glResourceTypeId="MONEY" parentGlAccountId="1400" accountCode="1410" accountName="Finished Goods Inventory" /><GlAccount glAccountId="1420" glAccountTypeId="RAWMAT_INVENTORY" glAccountClassId="INVENTORY_ASSET" glResourceTypeId="MONEY" parentGlAccountId="1400" accountCode="1420" accountName="Raw Materials Inventory" /><GlAccount glAccountId="1430" glAccountTypeId="WIP_INVENTORY" glAccountClassId="INVENTORY_ASSET" glResourceTypeId="MONEY" parentGlAccountId="1400" accountCode="1430" accountName="Work In Process Inventory" /><GlAccount glAccountId="1490" glAccountTypeId="INV_ADJ_AVG_COST" glAccountClassId="INVENTORY_ASSET" glResourceTypeId="MONEY" parentGlAccountId="1400" accountCode="1490" accountName="Inventory - Average Cost Valuation Adjustment" /><GlAccount glAccountId="1500" glAccountTypeId="PREPAID_EXPENSES" glAccountClassId="CURRENT_ASSET" glResourceTypeId="MONEY" parentGlAccountId="1000" accountCode="1500" accountName="PREPAID EXPENSES, DEPOSITS, OTHER CURRENT ASSETS" /><GlAccount glAccountId="1510" glAccountTypeId="PREPAID_EXPENSES" glAccountClassId="CURRENT_ASSET" glResourceTypeId="MONEY" parentGlAccountId="1500" accountCode="1510" accountName="Prepaid Insurance" /><GlAccount glAccountId="1520" glAccountTypeId="PREPAID_EXPENSES" glAccountClassId="CURRENT_ASSET" glResourceTypeId="MONEY" parentGlAccountId="1500" accountCode="1520" accountName="Prepaid Rent" /><GlAccount glAccountId="1550" glAccountTypeId="PREPAID_EXPENSES" glAccountClassId="CURRENT_ASSET" glResourceTypeId="MONEY" parentGlAccountId="1500" accountCode="1550" accountName="Deposits" /><GlAccount glAccountId="1600" glAccountTypeId="FIXED_ASSET" glAccountClassId="LONGTERM_ASSET" glResourceTypeId="MONEY" parentGlAccountId="1000" accountCode="1600" accountName="LAND and BUILDING" /><GlAccount glAccountId="1610" glAccountTypeId="FIXED_ASSET" glAccountClassId="LONGTERM_ASSET" glResourceTypeId="MONEY" parentGlAccountId="1600" accountCode="1610" accountName="Land" /><GlAccount glAccountId="1620" glAccountTypeId="FIXED_ASSET" glAccountClassId="LONGTERM_ASSET" glResourceTypeId="MONEY" parentGlAccountId="1600" accountCode="1620" accountName="Building" /><GlAccount glAccountId="1700" glAccountTypeId="FIXED_ASSET" glAccountClassId="LONGTERM_ASSET" glResourceTypeId="FINISHED_GOODS" parentGlAccountId="1000" accountCode="1700" accountName="FURNITURE, FIXTURES, and EQUIPMENT" /><GlAccount glAccountId="1710" glAccountTypeId="FIXED_ASSET" glAccountClassId="LONGTERM_ASSET" glResourceTypeId="FINISHED_GOODS" parentGlAccountId="1700" accountCode="1710" accountName="Furniture - Fixtures and Equipment" /><GlAccount glAccountId="1720" glAccountTypeId="FIXED_ASSET" glAccountClassId="LONGTERM_ASSET" glResourceTypeId="FINISHED_GOODS" parentGlAccountId="1700" accountCode="1720" accountName="Data Processing Equipment" /><GlAccount glAccountId="1730" glAccountTypeId="FIXED_ASSET" glAccountClassId="LONGTERM_ASSET" glResourceTypeId="FINISHED_GOODS" parentGlAccountId="1700" accountCode="1730" accountName="Data Processing Software" /><GlAccount glAccountId="1740" glAccountTypeId="FIXED_ASSET" glAccountClassId="LONGTERM_ASSET" glResourceTypeId="FINISHED_GOODS" parentGlAccountId="1700" accountCode="1740" accountName="Vehicles" /><GlAccount glAccountId="1800" glAccountTypeId="FIXED_ASSET" glAccountClassId="ACCUM_DEPRECIATION" glResourceTypeId="MONEY" parentGlAccountId="1000" accountCode="1800" accountName="ACCUMULATED DEPRECIATION" /><GlAccount glAccountId="1810" glAccountTypeId="FIXED_ASSET" glAccountClassId="ACCUM_DEPRECIATION" glResourceTypeId="MONEY" parentGlAccountId="1800" accountCode="1810" accountName="Building" /><GlAccount glAccountId="1820" glAccountTypeId="FIXED_ASSET" glAccountClassId="ACCUM_DEPRECIATION" glResourceTypeId="MONEY" parentGlAccountId="1800" accountCode="1820" accountName="Land Improvements" /><GlAccount glAccountId="1830" glAccountTypeId="FIXED_ASSET" glAccountClassId="ACCUM_DEPRECIATION" glResourceTypeId="MONEY" parentGlAccountId="1800" accountCode="1830" accountName="Building Improvements" /><GlAccount glAccountId="1840" glAccountTypeId="FIXED_ASSET" glAccountClassId="ACCUM_DEPRECIATION" glResourceTypeId="MONEY" parentGlAccountId="1800" accountCode="1840" accountName="Leasehold Improvements" /><GlAccount glAccountId="1850" glAccountTypeId="FIXED_ASSET" glAccountClassId="ACCUM_DEPRECIATION" glResourceTypeId="MONEY" parentGlAccountId="1800" accountCode="1850" accountName="Furniture Fixtures and Equipment" /><GlAccount glAccountId="1860" glAccountTypeId="FIXED_ASSET" glAccountClassId="ACCUM_DEPRECIATION" glResourceTypeId="MONEY" parentGlAccountId="1800" accountCode="1860" accountName="Data Processing Equipment" /><GlAccount glAccountId="1870" glAccountTypeId="FIXED_ASSET" glAccountClassId="ACCUM_DEPRECIATION" glResourceTypeId="MONEY" parentGlAccountId="1800" accountCode="1870" accountName="Data Processing Software" /><GlAccount glAccountId="1880" glAccountTypeId="FIXED_ASSET" glAccountClassId="ACCUM_DEPRECIATION" glResourceTypeId="MONEY" parentGlAccountId="1800" accountCode="1880" accountName="Vehicles" /><GlAccount glAccountId="1900" glAccountTypeId="FIXED_ASSET" glAccountClassId="ASSET" glResourceTypeId="MONEY" parentGlAccountId="1000" accountCode="1900" accountName="OTHER ASSETS" /><GlAccount glAccountId="1910" glAccountTypeId="FIXED_ASSET" glAccountClassId="ASSET" glResourceTypeId="MONEY" parentGlAccountId="1900" accountCode="1910" accountName="Intangible Asset" /><GlAccount glAccountId="1950" glAccountTypeId="FIXED_ASSET" glAccountClassId="ASSET" glResourceTypeId="MONEY" parentGlAccountId="1900" accountCode="1950" accountName="Goodwill" /><GlAccount glAccountId="2000" glAccountTypeId="CURRENT_LIABILITY" glAccountClassId="LIABILITY" glResourceTypeId="MONEY" parentGlAccountId="" accountCode="2000" accountName="LIABILITIES" /><GlAccount glAccountId="2100" glAccountTypeId="ACCOUNTS_PAYABLE" glAccountClassId="CURRENT_LIABILITY" glResourceTypeId="MONEY" parentGlAccountId="2000" accountCode="2100" accountName="ACCOUNTS PAYABLE" /><GlAccount glAccountId="2110" glAccountTypeId="ACCOUNTS_PAYABLE" glAccountClassId="CURRENT_LIABILITY" glResourceTypeId="MONEY" parentGlAccountId="2100" accountCode="2110" accountName="Accounts Payable" /><GlAccount glAccountId="2130" glAccountTypeId="CUSTOMER_CREDIT" glAccountClassId="CURRENT_LIABILITY" glResourceTypeId="MONEY" parentGlAccountId="2100" accountCode="2130" accountName="Customer Credits" /><GlAccount glAccountId="2150" glAccountTypeId="CUSTOMER_DEPOSIT" glAccountClassId="CURRENT_LIABILITY" glResourceTypeId="MONEY" parentGlAccountId="2100" accountCode="2150" accountName="Customer Deposits" /><GlAccount glAccountId="2200" glAccountTypeId="CURRENT_LIABILITY" glAccountClassId="CURRENT_LIABILITY" glResourceTypeId="MONEY" parentGlAccountId="2000" accountCode="2200" accountName="ACCRUED EXPENSES" /><GlAccount glAccountId="2210" glAccountTypeId="CURRENT_LIABILITY" glAccountClassId="CURRENT_LIABILITY" glResourceTypeId="MONEY" parentGlAccountId="2200" accountCode="2210" accountName="Accrued Payroll" /><GlAccount glAccountId="2220" glAccountTypeId="CURRENT_LIABILITY" glAccountClassId="CURRENT_LIABILITY" glResourceTypeId="MONEY" parentGlAccountId="2200" accountCode="2220" accountName="Accrued Payroll Withholding" /><GlAccount glAccountId="2230" glAccountTypeId="CURRENT_LIABILITY" glAccountClassId="CURRENT_LIABILITY" glResourceTypeId="MONEY" parentGlAccountId="2200" accountCode="2230" accountName="Accrued Payroll Tax Withholding" /><GlAccount glAccountId="2240" glAccountTypeId="CURRENT_LIABILITY" glAccountClassId="CURRENT_LIABILITY" glResourceTypeId="MONEY" parentGlAccountId="2200" accountCode="2240" accountName="Accrued Payroll Taxes Tax" /><GlAccount glAccountId="2260" glAccountTypeId="CURRENT_LIABILITY" glAccountClassId="CURRENT_LIABILITY" glResourceTypeId="MONEY" parentGlAccountId="2200" accountCode="2260" accountName="Sales Taxes Collected" /><GlAccount glAccountId="2300" glAccountTypeId="CURRENT_LIABILITY" glAccountClassId="CURRENT_LIABILITY" glResourceTypeId="MONEY" parentGlAccountId="2000" accountCode="2300" accountName="CURRENT NOTES PAYABLE" /><GlAccount glAccountId="2310" glAccountTypeId="CURRENT_LIABILITY" glAccountClassId="CURRENT_LIABILITY" glResourceTypeId="MONEY" parentGlAccountId="2300" accountCode="2310" accountName="Short Term Obligation" /><GlAccount glAccountId="2320" glAccountTypeId="CURRENT_LIABILITY" glAccountClassId="CURRENT_LIABILITY" glResourceTypeId="MONEY" parentGlAccountId="2300" accountCode="2320" accountName="Current Portion of Long Term Debt" /><GlAccount glAccountId="2400" glAccountTypeId="LONG_TERM_LIABILITY" glAccountClassId="LONGTERM_LIABILITY" glResourceTypeId="MONEY" parentGlAccountId="2000" accountCode="2400" accountName="LONG-TERM NOTES PAYABLE" /><GlAccount glAccountId="2410" glAccountTypeId="LONG_TERM_LIABILITY" glAccountClassId="LONGTERM_LIABILITY" glResourceTypeId="MONEY" parentGlAccountId="2400" accountCode="2410" accountName="Long Term Obligation" /><GlAccount glAccountId="2420" glAccountTypeId="LONG_TERM_LIABILITY" glAccountClassId="LONGTERM_LIABILITY" glResourceTypeId="MONEY" parentGlAccountId="2400" accountCode="2420" accountName="Mortgage Note Payable" /><GlAccount glAccountId="2430" glAccountTypeId="LONG_TERM_LIABILITY" glAccountClassId="LONGTERM_LIABILITY" glResourceTypeId="MONEY" parentGlAccountId="2400" accountCode="2430" accountName="Loans From Owner or Stockholder" /><GlAccount glAccountId="2450" glAccountTypeId="LONG_TERM_LIABILITY" glAccountClassId="LONGTERM_LIABILITY" glResourceTypeId="MONEY" parentGlAccountId="2400" accountCode="2450" accountName="Other Long Term Obligation" /><GlAccount glAccountId="3000" glAccountTypeId="" glAccountClassId="EQUITY" glResourceTypeId="MONEY" parentGlAccountId="" accountCode="3000" accountName="OWNERS EQUITY and NET WORTH" /><GlAccount glAccountId="3100" glAccountTypeId="OWNERS_EQUITY" glAccountClassId="OWNERS_EQUITY" glResourceTypeId="MONEY" parentGlAccountId="3000" accountCode="3100" accountName="CAPITAL" /><GlAccount glAccountId="3110" glAccountTypeId="OWNERS_EQUITY" glAccountClassId="RETURN_OF_CAPITAL" glResourceTypeId="MONEY" parentGlAccountId="3000" accountCode="3110" accountName="Draws" /><GlAccount glAccountId="3200" glAccountTypeId="OWNERS_EQUITY" glAccountClassId="OWNERS_EQUITY" glResourceTypeId="MONEY" parentGlAccountId="3000" accountCode="3200" accountName="Owners Equity" /><GlAccount glAccountId="3300" glAccountTypeId="OWNERS_EQUITY" glAccountClassId="OWNERS_EQUITY" glResourceTypeId="MONEY" parentGlAccountId="3000" accountCode="3300" accountName="COMMON STOCK" /><GlAccount glAccountId="3500" glAccountTypeId="OWNERS_EQUITY" glAccountClassId="RETAINED_EARNINGS" glResourceTypeId="MONEY" parentGlAccountId="3000" accountCode="3500" accountName="Retained Earnings" /><GlAccount glAccountId="4000" glAccountTypeId="" glAccountClassId="REVENUE" glResourceTypeId="MONEY" parentGlAccountId="" accountCode="4000" accountName="SALES" /><GlAccount glAccountId="4010" glAccountTypeId="" glAccountClassId="REVENUE" glResourceTypeId="MONEY" parentGlAccountId="4000" accountCode="4010" accountName="General Sales" /><GlAccount glAccountId="4100" glAccountTypeId="" glAccountClassId="COGS_EXPENSE" glResourceTypeId="MONEY" parentGlAccountId="4000" accountCode="4100" accountName="Discounts on Sales" /><GlAccount glAccountId="4200" glAccountTypeId="" glAccountClassId="CONTRA_REVENUE" glResourceTypeId="MONEY" parentGlAccountId="4000" accountCode="4200" accountName="Customer Returns" /><GlAccount glAccountId="5000" glAccountTypeId="" glAccountClassId="COGS_EXPENSE" glResourceTypeId="MONEY" parentGlAccountId="" accountCode="5000" accountName="COST OF GOODS SOLD" /><GlAccount glAccountId="5100" glAccountTypeId="" glAccountClassId="COGS_EXPENSE" glResourceTypeId="MONEY" parentGlAccountId="5000" accountCode="5010" accountName="MANUFACTURING LABOR" /><GlAccount glAccountId="5110" glAccountTypeId="" glAccountClassId="COGS_EXPENSE" glResourceTypeId="MONEY" parentGlAccountId="5100" accountCode="5110" accountName="Wages" /><GlAccount glAccountId="5120" glAccountTypeId="" glAccountClassId="COGS_EXPENSE" glResourceTypeId="MONEY" parentGlAccountId="5100" accountCode="5120" accountName="Employer-FICA" /><GlAccount glAccountId="5130" glAccountTypeId="" glAccountClassId="COGS_EXPENSE" glResourceTypeId="MONEY" parentGlAccountId="5100" accountCode="5130" accountName="Employer-FUTA" /><GlAccount glAccountId="5140" glAccountTypeId="" glAccountClassId="COGS_EXPENSE" glResourceTypeId="MONEY" parentGlAccountId="5100" accountCode="5140" accountName="Employer-MEDI" /><GlAccount glAccountId="5150" glAccountTypeId="" glAccountClassId="COGS_EXPENSE" glResourceTypeId="MONEY" parentGlAccountId="5100" accountCode="5150" accountName="Employer-UI" /><GlAccount glAccountId="5300" glAccountTypeId="" glAccountClassId="COGS_EXPENSE" glResourceTypeId="MONEY" parentGlAccountId="5000" accountCode="5300" accountName="Raw Material Purchases" /><GlAccount glAccountId="5400" glAccountTypeId="" glAccountClassId="COGS_EXPENSE" glResourceTypeId="MONEY" parentGlAccountId="5000" accountCode="5400" accountName="Freight In" /><GlAccount glAccountId="5500" glAccountTypeId="" glAccountClassId="COGS_EXPENSE" glResourceTypeId="MONEY" parentGlAccountId="5000" accountCode="5500" accountName="Merchant Account Fees" /><GlAccount glAccountId="5510" glAccountTypeId="" glAccountClassId="COGS_EXPENSE" glResourceTypeId="MONEY" parentGlAccountId="5500" accountCode="5510" accountName="Credit Card Processing" /><GlAccount glAccountId="5515" glAccountTypeId="" glAccountClassId="COGS_EXPENSE" glResourceTypeId="MONEY" parentGlAccountId="5500" accountCode="5515" accountName="eBay Listing Fees" /><GlAccount glAccountId="5520" glAccountTypeId="" glAccountClassId="COGS_EXPENSE" glResourceTypeId="MONEY" parentGlAccountId="5500" accountCode="5520" accountName="Amazon Seller Fees" /><GlAccount glAccountId="5900" glAccountTypeId="" glAccountClassId="NON_CASH_EXPENSE" glResourceTypeId="MONEY" parentGlAccountId="5000" accountCode="5900" accountName="Inventory Adjustment" /><GlAccount glAccountId="6000" glAccountTypeId="" glAccountClassId="EXPENSE" glResourceTypeId="MONEY" parentGlAccountId="" accountCode="6000" accountName="EXPENSES" /><GlAccount glAccountId="6100" glAccountTypeId="" glAccountClassId="SGA_EXPENSE" glResourceTypeId="MONEY" parentGlAccountId="6000" accountCode="6100" accountName="Advertising and Promotions" /><GlAccount glAccountId="6200" glAccountTypeId="" glAccountClassId="SGA_EXPENSE" glResourceTypeId="MONEY" parentGlAccountId="6000" accountCode="6200" accountName="Bank Service Charges" /><GlAccount glAccountId="6300" glAccountTypeId="" glAccountClassId="SGA_EXPENSE" glResourceTypeId="MONEY" parentGlAccountId="6000" accountCode="6300" accountName="Business Licenses and Permits" /><GlAccount glAccountId="6400" glAccountTypeId="" glAccountClassId="SGA_EXPENSE" glResourceTypeId="MONEY" parentGlAccountId="6000" accountCode="6400" accountName="Data Processing Expenses" /><GlAccount glAccountId="6500" glAccountTypeId="" glAccountClassId="SGA_EXPENSE" glResourceTypeId="MONEY" parentGlAccountId="6000" accountCode="6500" accountName="Dues and Subscriptions" /><GlAccount glAccountId="6600" glAccountTypeId="" glAccountClassId="SGA_EXPENSE" glResourceTypeId="MONEY" parentGlAccountId="6000" accountCode="6600" accountName="Education and Training" /><GlAccount glAccountId="6700" glAccountTypeId="" glAccountClassId="SGA_EXPENSE" glResourceTypeId="MONEY" parentGlAccountId="6000" accountCode="6700" accountName="Human Resources Expense" /><GlAccount glAccountId="6800" glAccountTypeId="" glAccountClassId="SGA_EXPENSE" glResourceTypeId="MONEY" parentGlAccountId="6000" accountCode="6800" accountName="INSURANCE EXPENSE" /><GlAccount glAccountId="6810" glAccountTypeId="" glAccountClassId="SGA_EXPENSE" glResourceTypeId="MONEY" parentGlAccountId="6800" accountCode="6810" accountName="General Liability Insurance" /><GlAccount glAccountId="6820" glAccountTypeId="" glAccountClassId="SGA_EXPENSE" glResourceTypeId="MONEY" parentGlAccountId="6800" accountCode="6820" accountName="Workmans Comp Insurance" /><GlAccount glAccountId="6900" glAccountTypeId="" glAccountClassId="SGA_EXPENSE" glResourceTypeId="MONEY" parentGlAccountId="6000" accountCode="6900" accountName="Interest Expense" /><GlAccount glAccountId="7000" glAccountTypeId="" glAccountClassId="SGA_EXPENSE" glResourceTypeId="MONEY" parentGlAccountId="6000" accountCode="7000" accountName="Meals and Entertainment" /><GlAccount glAccountId="7100" glAccountTypeId="" glAccountClassId="SGA_EXPENSE" glResourceTypeId="MONEY" parentGlAccountId="6000" accountCode="7100" accountName="Office Supplies" /><GlAccount glAccountId="7200" glAccountTypeId="" glAccountClassId="SGA_EXPENSE" glResourceTypeId="MONEY" parentGlAccountId="6000" accountCode="7200" accountName="Postage and Delivery" /><GlAccount glAccountId="7300" glAccountTypeId="" glAccountClassId="SGA_EXPENSE" glResourceTypeId="MONEY" parentGlAccountId="6000" accountCode="7300" accountName="Professional Fees" /><GlAccount glAccountId="7400" glAccountTypeId="" glAccountClassId="SGA_EXPENSE" glResourceTypeId="MONEY" parentGlAccountId="6000" accountCode="7400" accountName="Rent Expense" /><GlAccount glAccountId="7500" glAccountTypeId="" glAccountClassId="SGA_EXPENSE" glResourceTypeId="MONEY" parentGlAccountId="6000" accountCode="7500" accountName="Repairs and Maintenance" /><GlAccount glAccountId="7600" glAccountTypeId="" glAccountClassId="SGA_EXPENSE" glResourceTypeId="MONEY" parentGlAccountId="6000" accountCode="7600" accountName="ADMINISTRATION" /><GlAccount glAccountId="7610" glAccountTypeId="" glAccountClassId="SGA_EXPENSE" glResourceTypeId="MONEY" parentGlAccountId="7600" accountCode="7610" accountName="Wages" /><GlAccount glAccountId="7620" glAccountTypeId="" glAccountClassId="SGA_EXPENSE" glResourceTypeId="MONEY" parentGlAccountId="7600" accountCode="7620" accountName="Employer FICA" /><GlAccount glAccountId="7630" glAccountTypeId="" glAccountClassId="SGA_EXPENSE" glResourceTypeId="MONEY" parentGlAccountId="7600" accountCode="7630" accountName="Employer FUTA" /><GlAccount glAccountId="7640" glAccountTypeId="" glAccountClassId="SGA_EXPENSE" glResourceTypeId="MONEY" parentGlAccountId="7600" accountCode="7640" accountName="Employer MEDI" /><GlAccount glAccountId="7650" glAccountTypeId="" glAccountClassId="SGA_EXPENSE" glResourceTypeId="MONEY" parentGlAccountId="7600" accountCode="7650" accountName="Employer UI" /><GlAccount glAccountId="7700" glAccountTypeId="" glAccountClassId="SGA_EXPENSE" glResourceTypeId="MONEY" parentGlAccountId="6000" accountCode="7700" accountName="Telephone" /><GlAccount glAccountId="7800" glAccountTypeId="" glAccountClassId="SGA_EXPENSE" glResourceTypeId="MONEY" parentGlAccountId="6000" accountCode="7800" accountName="Travel" /><GlAccount glAccountId="7900" glAccountTypeId="" glAccountClassId="SGA_EXPENSE" glResourceTypeId="MONEY" parentGlAccountId="6000" accountCode="7900" accountName="Utilities" /></entity-engine-xml>

Notes: My chart of accounts is a little different. I am a small company that is not currently running a perpetual inventory. So on my balance sheet I show $0.00 for inventory, raw materials, and finished goods. I am also a manufacturer but I record my labor and raw materials monthly as expense'd. So I want to see revenue's minus, cost of goods sold with labor each quarter. The purpose of going to OFBiz is so I can have a perpetual inventory, bill of materials for production runs, and work in process. Please setup your chart of accounts accordingly. I have mine here so all I have to do is a little cut and paste each time I have to blow out the database and start again.

Create New Accounting Company

Select Accounting - Organization GL Settings

Click on Create New Accounting Company

Select "Your Company Name"

Click on Create New Accounting Company

Set Base Currency

Click on Add