Docstoc

Eastman Savings and Loan Federal Credit Union

Document Sample
Eastman Savings and Loan Federal Credit Union Powered By Docstoc
					                                           eXLeratedTM Queries by KS2
Database String=>   Database Type:        IBMDA400
IP or Name =>       Machine Name          192.168.1.4

                                          SELECT * FROM KS2#FILE.GLBAL WHERE
Formula=>           SQL Statement:        FISCAL = '2002' and ACCT# = '2110'
Named Range=>       Where to put output   Output



                    SELECT *
      Key in        FROM KS2#FILE.GLBAL
    Your SQL        WHERE FISCAL = '2002' and ACCT# = '2110'
    Statement
  in Rows 10 - 15
2002   2110 Vendor/Accounts Payable
2002



Years     3    <==Link: this tells you what position in the list it is.
 2000   2002   <==Value selected
 2001
 2002
 2003
 2004
 2005
 2006
 2007
 2008
 2009
 2010




                                                                          1125
                                                                          1126
                                                                          1127
                                                                          1130
                                                                          1150
                                                                          1151
                                                                          1200
                                                                          1202
                                                                          1205
                                                                          1210
                                                                          1215
                                                                          1217
                                                                          1218
                                                                          1219
                                                                          1220
                                                                          1222
                                                                          1223
                                                                          1225
                                                                          1230
1240
1242
1244
1246
1247
1248
1250
1275
1280
1290
1291
1292
1294
1296
1300
1420
1425
1430
1432
1434
1435
1440
1441
1450
1451
1460
1461
1500
1505
1600
1610
1620
1622
1624
1625
1640
1641
1642
1644
1650
1660
1670
1672
1675
1676
1680
1690
1695
1700
1701
1702
1704
1706
1708
1800
1801
1802
1803
1804
1900
2010
2011
2040
2110
2111
2120
2140
2145
2150
2155
2157
2160
2180
2190
2200
2210
2220
2230
2240
2242
2310
2320
2330
2340
2355
2360
2365
2370
2375
2380
2390
2400
2405
2450
2460
2470
2480
2489
2490
2495
2500
2505
2520
2522
2524
2526
2528
2530
2532
2534
2536
2538
2540
2542
2544
2546
2548
2550
2552
2554
2556
2558
2560
2562
2564
2566
2568
2570
2572
2574
2576
2900
2910
2920
2930
2990
3000
3010
3020
3030
3060
3250
3300
3500
3800
3900
3999
4010
4020
4021
4030
4040
4050
4060
4070
4080
4090
4100
4160
4210
4220
4230
4240
4250
4500
4510
4520
4530
4540
4550
4560
4570
4600
5100
5125
5140
5150
5155
5160
5161
5162
5200
5210
5220
5230
5299
5320
5325
5330
5400
5401
5420
5500
5510
5515
5520
5525
5530
5532
5540
5541
5550
5580
5600
5650
5670
5690
5700
5710
5720
5730
5800
5810
5815
5820
5825
5830
5835
5840
5845
5850
5855
5860
5865
5899
6100
6110
6120
6125
6140
6150
6155
6160
6161
6162
6200
6210
6220
6230
6300
6310
6320
6325
6330
6360
6400
6514
6520
6525
6535
6540
6550
6560
6565
6567
6600
6605
6607
6610
6615
6619
6620
6625
6630
6632
6635
6640
6641
6642
6645
6650
6655
6657
6658
6660
6665
6670
6680
6685
6699
6700
6705
6710
6715
6720
6725
6800
6810
6815
6817
6820
6825
6830
6835
6840
6845
6850
6852
6855
6860
6865
6880
6884
6886
6888
6890
6895
6899
7100
7105
7106
7110
7115
7120
7125
7130
7140
7150
7155
7156
7160
7161
7162
7199
7200
7210
7220
7230
7240
7299
7300
7310
7320
7325
7330
7335
7340
7345
7350
7355
7360
7365
7370
7375
7390
7399
7400
7600
7605
7610
7619
7620
7625
7630
7642
7645
7650
7655
7660
7665
7670
7680
7690
7699
7700
7705
7710
7712
7715
7720
7730
7731
7740
7750
7798
7799
7800
7810
7815
7817
7820
7825
7830
7835
7840
7845
7846
7850
7852
7855
7860
7865
7870
7872
7874
7880
7881
7882
7884
7886
7888
7890
7899
8000
8005
8010
8300
8305
8306
8310
8315
8320
8325
8330
8335
8340
8350
8500
8505
8510
8515
9100
9200
9800
9850
2110 Vendor/Accounts Payable



             109             <==Link: this tells you what position      in the list it is.
2110 Vendor/Accounts Payable <==Value selected
1000                         Petty Cash
1005                         Comerica Bank-Payroll
1010                         Wells Fargo 125
1015                         Compass 401K
1020                         Compass Bank
1025                         Texas Capital bank
1030                         Community Credit Union
1035                         United Texas Bank
1040                         Colonial Bank
1045                         Mercantile Bank
1050                         Wells Fargo
1055                         First Mercantile
1060                         Inwood Bank
1065                         Pavillion Bank
1070                         Founders Bank
1075                         Legacy bank
1080                         First Savings Bank
1085                         Bank of the Southwest
1090                         Northeast National Bank
1095                         First American Bank
1100                         Wells Fargo Sweep Account(Operating)
1102                         Wells Fargo Manual Checking
1105                         First American-Money Market #325941640
1110                         Wells Fargo Interim
1120                         First American-Operating Acct #325941569
1122                         First American-Manual Checking#326430600
1125                         First American-Payroll #326430765
1126                         First American-125 Account #326430846
1127                         First American-401K Account #326431007
1130                         WASHINGTON MUTUAL
1150                         Investments/Marketable Securities
1151                         Unrealized Gain/Loss
1200                         Closing Receivables
1202                         Interim Receivables
1205                         Closing Reveivables - Escrows
1210                         Accounts Receivable
1215                         Accounts Receivable-Rebates
1217                         Accounts Receivable-Employees
1218                         Employee Receivable-Payroll
1219                         Accounts Receivable-Shindoo & Shindoo
1220                         Intercompany Receivables
1222                         Intercompany Receivable-Shindoo Dev.
1223                         Intercompany Receivable - ATC
1225                         Intercompany Rec.-Shindoo Consolidated
1230                         Intercompany Payroll Receivable
1240   Notes Receivable
1242   Notes Receivable - Phyllis
1244   Notes Receivable - PSJ Builders
1246   Notes Receivable - N. Smith
1247   Notes Receivable-Peter Shindoo Jr.
1248   Notes Receivable-Trust
1250   Note Receivable-Peter Shindoo Sr.
1275   Interim Loans Receivable
1280   Receivable-Julie Eastman
1290   Escrow-Woods at Wellington
1291   Escrow-Schmitz,24202, Flood Plain
1292   Escrow-Custer Meadows Amentity Center
1294   Escrow-ATC Resale Certificate
1296   Escrow-Hunters Landing Amentity Center
1300   Salesperson Advances/Draws
1420   Finished Lots
1425   Release Finished Lots to WIP
1430   Work in Process
1432   Salary Allocation to WIP
1434   WIP Expense before Start
1435   Interest Allocation Adjustment
1440   Amortized Project Costs
1441   Amortized Cost Allocations
1450   Indirect Construction
1451   Indirect Construction Allocation
1460   Sales & Marketing
1461   Sales and Marketing Allocations
1500   Finished Model Homes
1505   Houses-Bought Back
1600   Lot Contract Earnest Money Deposits
1610   Prepaid Development Costs Reimburseable
1620   Prepayments
1622   Prepaid-Computer Block Time Agreement
1624   Prepaid-Entertainment,Parties
1625   Prepayments-Permits/Reinspections
1640   Prepaid Line Fee-First American Bank
1641   Prepaid Line Fee-Washington Mutual
1642   Prepaid Line Fee-Legacy Bank
1644   Prepaid Rent
1650   Escrows for Mechanics Liens
1660   Deposits on Equipment/Trailer/Other
1670   Pre-paid Rent
1672   Prepaid-Postage
1675   Prepaid Insurance
1676   Prepaid Placement Costs
1680   Refundable Taxes
1690   Deferred Tax Asset
1695   Deferred Loan Commitment
1700   Office Equipment
1701   Model Home Furniture
1702   Automobiles
1704   Plans
1706   Leasohold Improvements
1708   Computer Software
1800   Accumulated Depreciation
1801   Accumulated Amortization-Ownership Plans
1802   Accumulated Depr.-Model Home Furniture
1803   Accumulated Depreciation-Autos
1804   Accumulated Depreciation-Leasehold Imprv
1900   Loans to/from Affiliates
2010   Customer Deposits
2011   Cancelled Job Deposits
2040   Lot Closing Payable
2110   Vendor/Accounts Payable
2111   Unrecoverable Backcharges
2120   Interim Interest Payable
2140   Property Taxes Payable
2145   Franchise Tax Payable
2150   Other Payables
2155   Accrued Compensation
2157   Accrued Expenses
2160   Reserve for Disputed Impact Fees
2180   Reserve to Complete
2190   Reserve to Complete (Accruals)
2200   Notes Payable
2210   Notes Payable - PHS Sr.
2220   Notes Payable - Equipment
2230   Notes Payable - PSJ
2240   GMAC Payable-2002 Yukon(Beth)
2242   Chrysler Financial-2002 Jeep Cherokee(Td
2310   Withholding Tax Payable
2320   FICA Payable
2330   FUTA Payable
2340   TWC Payable
2355   125 Cafeteria Plan
2360   401K Deductions
2365   401K Contributions
2370   Voluntary Health Deductions - EE
2375   125 Plan Deductions
2380   Garnishments
2390   Back Up Withholding - Subcontractors
2400   Worker's Compensation Payable
2405   Worker's Compensation Payable - Employee
2450   General Liability Insurance Payable
2460   Federal Income Taxes - Current
2470   State and Local Tax - Current
2480   Retainage Payable
2489   Warranty Reserves-Accruals from Closings
2490   Warranty Reserves-Actual Expenditures
2495   Federal Income Taxes - Deferred
2500   Interest Payable
2505   Interest Paid
2520   Interim Construction Loans
2522   Bank of America
2524   Bank of the Southwest
2526   Colonial Bank
2528   Compass Bank
2530   Comerica Bank
2532   First American Bank
2534   First Horizon
2536   First Independent National Bank
2538   1st International Bank
2540   First Mercantile
2542   First Savings Bank
2544   Founders National Bank
2546   Inwood National Bank
2548   Legacy Bank
2550   Mercantile Bank
2552   Northeast National Bank
2554   Pavillion Bank
2556   Prism Builder Finance
2558   United Texas Bank
2560   Southtrust Bank
2562   Security Bank
2564   Texas Capital Bank
2566   Town Bank
2568   Wells Fargo & Co.
2570   Parkway Bank
2572   Orange Savings Bank
2574   Washington Mutual
2576   First Bank & Trust
2900   Paid in Capital
2910   Common Stock
2920   Retained Earnings
2930   Distribution to Shareholders
2990   Suspense Account
3000   Home Sales - Base Price
3010   Home Sales - Lot Premium
3020   Home Sales - Options
3030   Home Sales - Miscellaneous Revenue
3060   Giveaway/Allowance
3250   Lot Sales Revenue
3300   Rebates and Discounts
3500   Management Fees
3800   Forfeited Deposits
3900   Interest Income
3999   Miscellaneous Income
4010   Lot Cost and Taxes
4020   Direct Construction
4021   Finished Inventory COGS
4030   Options and Upgrades
4040   Interim Loan Cost
4050   Warranty Reserve
4060   Extras and Overages
4070   Points and Closing Costs
4080   Sales Commission
4090   Realtor Commission
4100   Title and Recording
4160   Other/Discounts
4210   Indirect Construction Allocation
4220   Sales and Marketing Allocation
4230   Amortized Project Costs
4240   Sales Management Fee
4250   Lot Sales - Cost of Sales
4500   Cost after Closing
4510   Loan Origination/Committment
4520   Inspection Fees
4530   Loan Origination/Committment Allocation
4540   Interest Expense
4550   Interest Expense Allocation
4560   Interest Allocation Adjustment
4570   Interest on Finished Homes
4600   Salary Allocation to WIP
5100   Salaries and Wages - Builders
5125   Auto Allowance
5140   Bonuses
5150   Temporary Help
5155   Placement Costs
5160   FICA-ER
5161   FUTA
5162   TWC-SUI
5200   Worker's Compensation
5210   Health Insurance
5220   Property Insurance
5230   Liability Insurance
5299   Miscellaneous Insurance
5320   Photography
5325   Training and Seminars
5330   Legal Fees and Consulting
5400   Utilities
5401   Generators and Generator Fuel
5420   Portable Toilets
5500   Special Construction and Tools
5510   Lot Mowing
5515   Street Cleaning
5520   Trailer Cleaning
5525   Subdivision Cleanup
5530   Trailer Hookups
5532   EPA/Storm Water
5540   Warranty
5541   Warranty Accrual Adjustment
5550   Construction Delay
5580   Development Related Expenses
5600   Advertising
5650   Promotions and Awards
5670   Business Cards
5690   Uniforms
5700   Trailer Rent
5710   Copier Expense
5720   Computer Expense
5730   Furniture
5800   Telephone, Long Distance and Internet
5810   Mobile Phones and Pagers
5815   Office Supplies
5820   Printing/Stationary/Forms
5825   Blueprints and Reproductions
5830   Postage
5835   Courier and Overnight Delivery
5840   Coffee and Beverages
5845   Travel- Air and Hotel
5850   Employee Functions
5855   Theft and Vandalism
5860   Maintenance and Repair
5865   Taxes
5899   Miscellanceous Construction G&A
6100   Salaries and Wages
6110   Salesperson Draw
6120   Other Compensation
6125   Auto Allowance
6140   Bonuses
6150   Temporary(Contract) Labor
6155   Placement Costs
6160   FICA-ER
6161   FUTA
6162   TWC-SUI
6200   Worker's Compensation
6210   Health Insurance
6220   Property Insurance
6230   Liability Insurance
6300   Agency Services and Production
6310   Design Fees
6320   Photography
6325   Training and Seminars
6330   Legal Fees and Consulting
6360   Market Research
6400   Utilities
6514   Home Buyer's Guide
6520   Model Conversion
6525   Model Cleaning
6535   Model Maintenance/Pest Control
6540   Model Repairs
6550   Model Landscape
6560   Spec Maintenance
6565   Spec Landscape
6567   Spec Cleaning
6600   Newspaper Advertising
6605   Classified Advertising
6607   Radio Advertising
6610   Magazine Advertising
6615   Billboard and Outdoor Advertising
6619   Miscellaneous Advertising
6620   Brochure Reprints
6625   Direct Mail and Flyers
6630   Public Relations
6632   CO-OP Marketing/Rebate
6635   Flags & Doormats
6640   Directional Sign Placement
6641   Directional Sign Reorder
6642   Subdivision Lot Signs
6645   Realtor Gifts
6650   Promotions and Awards
6655   Open Houses and Lunches
6657   Homeowner Gifts
6658   Buyer Goodwill
6660   Sales Contest and Spiffs
6665   Promotional Materials and Awards
6670   Business Cards
6680   MLS Fees
6685   Internet Marketing
6699   Brochure Inserts
6700   Trailer Rent
6705   Model Financing/Lease/Interest
6710   Copier Expense
6715   Sales Office Furniture
6720   Computer Rent/Expense
6725   Model Furniture Rental
6800   Telephone, Long Distance and Internet
6810   Mobile Phones and Pagers
6815   Office Supplies
6817   Toner-Copier, Printer and Fax
6820   Printing, Stationary and Forms
6825   Blueprints and Reproductions
6830   Postage
6835   Courier and Overnight Delivery
6840   Coffee and Beverages
6845   Travel-Air and Hotel
6850   Realtor Parties
6852   Donations and Contributions
6855   Theft and Vandalism
6860   Maintenance and Repair
6865   Taxes
6880   Depreciation-Model Home Furniture
6884   Web Page and Software
6886   Homeowner's Association Assessment
6888   Dues and Subscriptions
6890   Corporate Sales and Marketing Allocation
6895   Capitalized Sales and Marketing
6899   Miscellaneous Sales and Marketing
7100   Salaries and Wages
7105   Salaries and Wages - President
7106   Salaries and Wages-Secretary(PSS)
7110   Salaries and Wages - Senior Management
7115   Other Compensation
7120   Salary Allocation to WIP
7125   Auto and Phone Allowance
7130   401K Contribution
7140   Bonuses
7150   Temporary(Contract) Labor
7155   Placement Costs
7156   Drug Testing/Screening
7160   FICA-ER
7161   FUTA
7162   TWC-SUI
7199   Miscellaneous Salaries and Wages
7200   Worker's Compensation
7210   Health Insurance
7220   Property Insurance
7230   Liability Insurance
7240   Auto Insurance
7299   Miscellaneous Insurance
7300   Agency Services and Production
7310   Design Fees
7320   Photography
7325   Training and Seminars
7330   Legal Fees and Consulting
7335   Lobby Fees
7340   Annual Audit Fees
7345   Tax Service and Business Planning
7350   Engineer Fees
7355   Consulting Fees
7360   Market Research
7365   401K/125 Fees
7370   Payroll Processing Fees
7375   Filing Fees
7390   Miscellaneous Feasibility Costs
7399   Miscellaneous Professional Services
7400   Utilities
7600   Newspaper Advertising
7605   Classified Adveritsing
7610   Magazine Advertising
7619   Miscellaneous Advertising
7620   Corpoarate Brochure and Reprints
7625   Direct Mail and Flyers
7630   Public Relations
7642   Other Sign Repaint
7645   Gifts and Flowers
7650   Promotions and Awards
7655   Business Entertainment
7660   Sales Contest and Spiffs
7665   Promotional Materials
7670   Business Cards and Name Badges
7680   MLS Fees
7690   Uniforms
7699   Miscellaneous Marketing
7700   Office Rent
7705   Storage Unit Rent
7710   Copier Expense
7712   Fax Machine Expense
7715   Furniture/Equipment Expense
7720   Computer Expense
7730   A/S 400 Lease
7731   Computer Software Lease
7740   Postage Equipment Rental
7750   Design Center Supplies/Expenses
7798   Miscellaneous Equipment
7799   Miscellaneous Rent
7800   Telephone, Long Distance and Internet
7810   Mobile Phones and Pagers
7815   Office Supplies and Paper
7817   Toner-Copier, Printer and Fax
7820   Printing, Stationary and Forms
7825   Blueprints and Reproductions
7830   Postage
7835   Courier and Overnight Delivery
7840   Coffee and Beverages
7845   Travel - Air and Hotel
7846   Travel-Meals
7850   Employee Functions
7852   Donations and Contributions
7855   Theft and Vandalism
7860   Maintenance and Repair
7865   Taxes
7870   Auto - Fuel and Oil
7872   Auto Repair
7874   Auto Loan Payment
7880   Depreciation
7881   Depreciation-Plans
7882   Depreciation-Leasehold Improvements
7884   Data Processing/Software
7886   Bank and Check Fees
7888   Dues and Subscriptions
7890   Corporate General and Admin. Allocation
7899   Miscellaneous General and Administrative
8000   Other Income
8005   Gain/Loss on Investment
8010   Interest Income
8300   Plans-50' W Bld Pad Front Entry
8305   Plans-60' Bld Pad Rear Entry
8306   Plans - 60' Front Entry
8310   Plans-50' Rear Entry
8315   Plans-52' Rear Entry
8320   Plans-55' Front Entry
8325   Plans-40' Front Entry
8330   Plans-46' Rear Entry
8335   Plans - 70' Building Pad
8340   Plans - 80' Building Pad
8350   Plans-Otherby Homes
8500   Interest Expense
8505   Loan Administration Fee
8510   Finance Expense
8515   Finance Fee/Line Fee
9100   Bank Adjusting Entries
9200   Legal Settlement
9800   Texas State Franchise Tax
9850   Federal Income Taxes
what position in the list it is.

            1000 Petty Cash
            1005 Comerica Bank-Payroll
            1010 Wells Fargo 125
            1015 Compass 401K
            1020 Compass Bank
            1025 Texas Capital bank
            1030 Community Credit Union
            1035 United Texas Bank
            1040 Colonial Bank
            1045 Mercantile Bank
            1050 Wells Fargo
            1055 First Mercantile
            1060 Inwood Bank
            1065 Pavillion Bank
            1070 Founders Bank
            1075 Legacy bank
            1080 First Savings Bank
            1085 Bank of the Southwest
            1090 Northeast National Bank
            1095 First American Bank
            1100 Wells Fargo Sweep Account(Operating)
            1102 Wells Fargo Manual Checking
            1105 First American-Money Market #325941640
            1110 Wells Fargo Interim
            1120 First American-Operating Acct #325941569
            1122 First American-Manual Checking#326430600
            1125 First American-Payroll #326430765
            1126 First American-125 Account #326430846
            1127 First American-401K Account #326431007
            1130 WASHINGTON MUTUAL
            1150 Investments/Marketable Securities
            1151 Unrealized Gain/Loss
            1200 Closing Receivables
            1202 Interim Receivables
            1205 Closing Reveivables - Escrows
            1210 Accounts Receivable
            1215 Accounts Receivable-Rebates
            1217 Accounts Receivable-Employees
            1218 Employee Receivable-Payroll
            1219 Accounts Receivable-Shindoo & Shindoo
            1220 Intercompany Receivables
            1222 Intercompany Receivable-Shindoo Dev.
            1223 Intercompany Receivable - ATC
            1225 Intercompany Rec.-Shindoo Consolidated
            1230 Intercompany Payroll Receivable
1240 Notes Receivable
1242 Notes Receivable - Phyllis
1244 Notes Receivable - PSJ Builders
1246 Notes Receivable - N. Smith
1247 Notes Receivable-Peter Shindoo Jr.
1248 Notes Receivable-Trust
1250 Note Receivable-Peter Shindoo Sr.
1275 Interim Loans Receivable
1280 Receivable-Julie Eastman
1290 Escrow-Woods at Wellington
1291 Escrow-Schmitz,24202, Flood Plain
1292 Escrow-Custer Meadows Amentity Center
1294 Escrow-ATC Resale Certificate
1296 Escrow-Hunters Landing Amentity Center
1300 Salesperson Advances/Draws
1420 Finished Lots
1425 Release Finished Lots to WIP
1430 Work in Process
1432 Salary Allocation to WIP
1434 WIP Expense before Start
1435 Interest Allocation Adjustment
1440 Amortized Project Costs
1441 Amortized Cost Allocations
1450 Indirect Construction
1451 Indirect Construction Allocation
1460 Sales & Marketing
1461 Sales and Marketing Allocations
1500 Finished Model Homes
1505 Houses-Bought Back
1600 Lot Contract Earnest Money Deposits
1610 Prepaid Development Costs Reimburseable
1620 Prepayments
1622 Prepaid-Computer Block Time Agreement
1624 Prepaid-Entertainment,Parties
1625 Prepayments-Permits/Reinspections
1640 Prepaid Line Fee-First American Bank
1641 Prepaid Line Fee-Washington Mutual
1642 Prepaid Line Fee-Legacy Bank
1644 Prepaid Rent
1650 Escrows for Mechanics Liens
1660 Deposits on Equipment/Trailer/Other
1670 Pre-paid Rent
1672 Prepaid-Postage
1675 Prepaid Insurance
1676 Prepaid Placement Costs
1680 Refundable Taxes
1690 Deferred Tax Asset
1695 Deferred Loan Commitment
1700 Office Equipment
1701 Model Home Furniture
1702 Automobiles
1704 Plans
1706 Leasohold Improvements
1708 Computer Software
1800 Accumulated Depreciation
1801 Accumulated Amortization-Ownership Plans
1802 Accumulated Depr.-Model Home Furniture
1803 Accumulated Depreciation-Autos
1804 Accumulated Depreciation-Leasehold Imprv
1900 Loans to/from Affiliates
2010 Customer Deposits
2011 Cancelled Job Deposits
2040 Lot Closing Payable
2110 Vendor/Accounts Payable
2111 Unrecoverable Backcharges
2120 Interim Interest Payable
2140 Property Taxes Payable
2145 Franchise Tax Payable
2150 Other Payables
2155 Accrued Compensation
2157 Accrued Expenses
2160 Reserve for Disputed Impact Fees
2180 Reserve to Complete
2190 Reserve to Complete (Accruals)
2200 Notes Payable
2210 Notes Payable - PHS Sr.
2220 Notes Payable - Equipment
2230 Notes Payable - PSJ
2240 GMAC Payable-2002 Yukon(Beth)
2242 Chrysler Financial-2002 Jeep Cherokee(Td
2310 Withholding Tax Payable
2320 FICA Payable
2330 FUTA Payable
2340 TWC Payable
2355 125 Cafeteria Plan
2360 401K Deductions
2365 401K Contributions
2370 Voluntary Health Deductions - EE
2375 125 Plan Deductions
2380 Garnishments
2390 Back Up Withholding - Subcontractors
2400 Worker's Compensation Payable
2405 Worker's Compensation Payable - Employee
2450 General Liability Insurance Payable
2460 Federal Income Taxes - Current
2470 State and Local Tax - Current
2480 Retainage Payable
2489 Warranty Reserves-Accruals from Closings
2490 Warranty Reserves-Actual Expenditures
2495 Federal Income Taxes - Deferred
2500 Interest Payable
2505 Interest Paid
2520 Interim Construction Loans
2522 Bank of America
2524 Bank of the Southwest
2526 Colonial Bank
2528 Compass Bank
2530 Comerica Bank
2532 First American Bank
2534 First Horizon
2536 First Independent National Bank
2538 1st International Bank
2540 First Mercantile
2542 First Savings Bank
2544 Founders National Bank
2546 Inwood National Bank
2548 Legacy Bank
2550 Mercantile Bank
2552 Northeast National Bank
2554 Pavillion Bank
2556 Prism Builder Finance
2558 United Texas Bank
2560 Southtrust Bank
2562 Security Bank
2564 Texas Capital Bank
2566 Town Bank
2568 Wells Fargo & Co.
2570 Parkway Bank
2572 Orange Savings Bank
2574 Washington Mutual
2576 First Bank & Trust
2900 Paid in Capital
2910 Common Stock
2920 Retained Earnings
2930 Distribution to Shareholders
2990 Suspense Account
3000 Home Sales - Base Price
3010 Home Sales - Lot Premium
3020 Home Sales - Options
3030 Home Sales - Miscellaneous Revenue
3060 Giveaway/Allowance
3250 Lot Sales Revenue
3300 Rebates and Discounts
3500 Management Fees
3800 Forfeited Deposits
3900 Interest Income
3999 Miscellaneous Income
4010 Lot Cost and Taxes
4020 Direct Construction
4021 Finished Inventory COGS
4030 Options and Upgrades
4040 Interim Loan Cost
4050 Warranty Reserve
4060 Extras and Overages
4070 Points and Closing Costs
4080 Sales Commission
4090 Realtor Commission
4100 Title and Recording
4160 Other/Discounts
4210 Indirect Construction Allocation
4220 Sales and Marketing Allocation
4230 Amortized Project Costs
4240 Sales Management Fee
4250 Lot Sales - Cost of Sales
4500 Cost after Closing
4510 Loan Origination/Committment
4520 Inspection Fees
4530 Loan Origination/Committment Allocation
4540 Interest Expense
4550 Interest Expense Allocation
4560 Interest Allocation Adjustment
4570 Interest on Finished Homes
4600 Salary Allocation to WIP
5100 Salaries and Wages - Builders
5125 Auto Allowance
5140 Bonuses
5150 Temporary Help
5155 Placement Costs
5160 FICA-ER
5161 FUTA
5162 TWC-SUI
5200 Worker's Compensation
5210 Health Insurance
5220 Property Insurance
5230 Liability Insurance
5299 Miscellaneous Insurance
5320 Photography
5325 Training and Seminars
5330 Legal Fees and Consulting
5400 Utilities
5401 Generators and Generator Fuel
5420 Portable Toilets
5500 Special Construction and Tools
5510 Lot Mowing
5515 Street Cleaning
5520 Trailer Cleaning
5525 Subdivision Cleanup
5530 Trailer Hookups
5532 EPA/Storm Water
5540 Warranty
5541 Warranty Accrual Adjustment
5550 Construction Delay
5580 Development Related Expenses
5600 Advertising
5650 Promotions and Awards
5670 Business Cards
5690 Uniforms
5700 Trailer Rent
5710 Copier Expense
5720 Computer Expense
5730 Furniture
5800 Telephone, Long Distance and Internet
5810 Mobile Phones and Pagers
5815 Office Supplies
5820 Printing/Stationary/Forms
5825 Blueprints and Reproductions
5830 Postage
5835 Courier and Overnight Delivery
5840 Coffee and Beverages
5845 Travel- Air and Hotel
5850 Employee Functions
5855 Theft and Vandalism
5860 Maintenance and Repair
5865 Taxes
5899 Miscellanceous Construction G&A
6100 Salaries and Wages
6110 Salesperson Draw
6120 Other Compensation
6125 Auto Allowance
6140 Bonuses
6150 Temporary(Contract) Labor
6155 Placement Costs
6160 FICA-ER
6161 FUTA
6162 TWC-SUI
6200 Worker's Compensation
6210 Health Insurance
6220 Property Insurance
6230 Liability Insurance
6300 Agency Services and Production
6310 Design Fees
6320 Photography
6325 Training and Seminars
6330 Legal Fees and Consulting
6360 Market Research
6400 Utilities
6514 Home Buyer's Guide
6520 Model Conversion
6525 Model Cleaning
6535 Model Maintenance/Pest Control
6540 Model Repairs
6550 Model Landscape
6560 Spec Maintenance
6565 Spec Landscape
6567 Spec Cleaning
6600 Newspaper Advertising
6605 Classified Advertising
6607 Radio Advertising
6610 Magazine Advertising
6615 Billboard and Outdoor Advertising
6619 Miscellaneous Advertising
6620 Brochure Reprints
6625 Direct Mail and Flyers
6630 Public Relations
6632 CO-OP Marketing/Rebate
6635 Flags & Doormats
6640 Directional Sign Placement
6641 Directional Sign Reorder
6642 Subdivision Lot Signs
6645 Realtor Gifts
6650 Promotions and Awards
6655 Open Houses and Lunches
6657 Homeowner Gifts
6658 Buyer Goodwill
6660 Sales Contest and Spiffs
6665 Promotional Materials and Awards
6670 Business Cards
6680 MLS Fees
6685 Internet Marketing
6699 Brochure Inserts
6700 Trailer Rent
6705 Model Financing/Lease/Interest
6710 Copier Expense
6715 Sales Office Furniture
6720 Computer Rent/Expense
6725 Model Furniture Rental
6800 Telephone, Long Distance and Internet
6810 Mobile Phones and Pagers
6815 Office Supplies
6817 Toner-Copier, Printer and Fax
6820 Printing, Stationary and Forms
6825 Blueprints and Reproductions
6830 Postage
6835 Courier and Overnight Delivery
6840 Coffee and Beverages
6845 Travel-Air and Hotel
6850 Realtor Parties
6852 Donations and Contributions
6855 Theft and Vandalism
6860 Maintenance and Repair
6865 Taxes
6880 Depreciation-Model Home Furniture
6884 Web Page and Software
6886 Homeowner's Association Assessment
6888 Dues and Subscriptions
6890 Corporate Sales and Marketing Allocation
6895 Capitalized Sales and Marketing
6899 Miscellaneous Sales and Marketing
7100 Salaries and Wages
7105 Salaries and Wages - President
7106 Salaries and Wages-Secretary(PSS)
7110 Salaries and Wages - Senior Management
7115 Other Compensation
7120 Salary Allocation to WIP
7125 Auto and Phone Allowance
7130 401K Contribution
7140 Bonuses
7150 Temporary(Contract) Labor
7155 Placement Costs
7156 Drug Testing/Screening
7160 FICA-ER
7161 FUTA
7162 TWC-SUI
7199 Miscellaneous Salaries and Wages
7200 Worker's Compensation
7210 Health Insurance
7220 Property Insurance
7230 Liability Insurance
7240 Auto Insurance
7299 Miscellaneous Insurance
7300 Agency Services and Production
7310 Design Fees
7320 Photography
7325 Training and Seminars
7330 Legal Fees and Consulting
7335 Lobby Fees
7340 Annual Audit Fees
7345 Tax Service and Business Planning
7350 Engineer Fees
7355 Consulting Fees
7360 Market Research
7365 401K/125 Fees
7370 Payroll Processing Fees
7375 Filing Fees
7390 Miscellaneous Feasibility Costs
7399 Miscellaneous Professional Services
7400 Utilities
7600 Newspaper Advertising
7605 Classified Adveritsing
7610 Magazine Advertising
7619 Miscellaneous Advertising
7620 Corpoarate Brochure and Reprints
7625 Direct Mail and Flyers
7630 Public Relations
7642 Other Sign Repaint
7645 Gifts and Flowers
7650 Promotions and Awards
7655 Business Entertainment
7660 Sales Contest and Spiffs
7665 Promotional Materials
7670 Business Cards and Name Badges
7680 MLS Fees
7690 Uniforms
7699 Miscellaneous Marketing
7700 Office Rent
7705 Storage Unit Rent
7710 Copier Expense
7712 Fax Machine Expense
7715 Furniture/Equipment Expense
7720 Computer Expense
7730 A/S 400 Lease
7731 Computer Software Lease
7740 Postage Equipment Rental
7750 Design Center Supplies/Expenses
7798 Miscellaneous Equipment
7799 Miscellaneous Rent
7800 Telephone, Long Distance and Internet
7810 Mobile Phones and Pagers
7815 Office Supplies and Paper
7817 Toner-Copier, Printer and Fax
7820 Printing, Stationary and Forms
7825 Blueprints and Reproductions
7830 Postage
7835 Courier and Overnight Delivery
7840 Coffee and Beverages
7845 Travel - Air and Hotel
7846 Travel-Meals
7850 Employee Functions
7852 Donations and Contributions
7855 Theft and Vandalism
7860 Maintenance and Repair
7865 Taxes
7870 Auto - Fuel and Oil
7872 Auto Repair
7874 Auto Loan Payment
7880 Depreciation
7881 Depreciation-Plans
7882 Depreciation-Leasehold Improvements
7884 Data Processing/Software
7886 Bank and Check Fees
7888 Dues and Subscriptions
7890 Corporate General and Admin. Allocation
7899 Miscellaneous General and Administrative
8000 Other Income
8005 Gain/Loss on Investment
8010 Interest Income
8300 Plans-50' W Bld Pad Front Entry
8305 Plans-60' Bld Pad Rear Entry
8306 Plans - 60' Front Entry
8310 Plans-50' Rear Entry
8315 Plans-52' Rear Entry
8320 Plans-55' Front Entry
8325 Plans-40' Front Entry
8330 Plans-46' Rear Entry
8335 Plans - 70' Building Pad
8340 Plans - 80' Building Pad
8350 Plans-Otherby Homes
8500 Interest Expense
8505 Loan Administration Fee
8510 Finance Expense
8515 Finance Fee/Line Fee
9100 Bank Adjusting Entries
9200 Legal Settlement
9800 Texas State Franchise Tax
9850 Federal Income Taxes
                                    2002          2110 Vendor/Accounts Payable


     CO#   FISCAL   AREA#   REGN#        DIV#    SUBDIV    ACCT#       GLCC#     GLBEG       GLJAN
01         2002     01      01      01          080       2110                   63400.53    -1454.21
01         2002     01      01      01          024       2110                    -129997    118748.7
01         2002     01      01      01          025       2110                    8946.53          50
01         2002     01      01      01          026       2110                   -4435.61     3091.87
01         2002     01      01      01          029       2110                   -14974.7     6499.13
01         2002     01      01      01          030       2110                   -51877.6    49717.35
01         2002     01      01      01          031       2110                    -125222    104544.8
01         2002     01      01      01          032       2110                      -989.2    1238.34
01         2002     01      01      01          033       2110                    -108096    83351.44
01         2002     01      01      01          034       2110                   -47986.8    38798.32
01         2002     01      01      01          035       2110                    -115222    95044.21
01         2002     01      01      01          036       2110                     -52094    43736.32
01         2002     01      01      01          037       2110                   -1712.15    -10779.6
01         2002     01      01      01          038       2110                   -21797.5    -18405.9
01         2002     01      01      01          039       2110                    -153958    149526.8
GLFEB    GLMAR      GLAPR       GLMAY      GLJUN      GLJUL        GLAUG      GLSEP      GLOCT
-1432.56 -1462.99      -44352   47119.05   -3410.22    -28689.21   31617.72    -245.48    3567.33
-13603.8 16510.3    -93037.1    25791.77   67473.56    -41777.52   33497.01    7531.61   21257.97
  650.25     -180     -225.37      45.37        360         -285         85          0    -650.25
 4339.66    87.56   -2259.67     2325.51    -1006.5      -113.86    1182.52   -7100.21    7172.21
 -739.83   739.83        -135          0        333          -40        -30         70        150
-5656.86 9827.65     -119295    108220.1    6407.87      -486.88    -1774.9     6793.8    1812.32
 6630.44 9713.35     -101235    37033.68   59602.77    -85252.89   85430.67   -25795.2   41445.63
   25.86        0   -19259.6    19205.67      80.21     -14826.1    14791.8    8434.21   -8076.21
22011.09 -1520.74    -173169    132629.3   18982.02    -27386.07   55487.58   -14397.9    27028.2
14086.37 -12007.6      -65079   67639.86   -1390.01     -59169.3   77529.66   -44454.9   44159.36
16405.89  -3219.7      -44077   41498.07   -4572.56    -14597.96   23728.12   -37487.1   42769.52
-11519.1 9173.06    -13090.8     6576.85   16883.59    -54128.07   30731.72     9834.7   17134.35
-24065.6 27305.23   -99325.8     90616.5   12551.29    -18625.33    6338.39   -15462.5   31767.52
-20745.6 61026.5     -163960    146229.3   10623.65    -60960.57   59737.98     -34741   43294.81
-40400.8 20371.5     -176521    140434.5    37641.1   -100102.87     116701   -83245.7   89034.22
GLNOV      GLDEC
 -222.78   -18143.9
-18386.4    9132.45
       0           0
 -3896.7     -1569.1
 -143.05       -6.95
-1221.72     -438.28
-5491.43   -3962.13
 1261.12   -2544.73
 2071.57   -3682.51
 -7465.5    -103245
  660.03   -1168.23
-10056.8   -61363.5
-1826.49   -8394.89
-15900.5    2888.13
-15270.9   -33846.7

				
DOCUMENT INFO
Description: Eastman Savings and Loan Federal Credit Union document sample