Construction Company Chart of Accounts

Document Sample
Construction Company Chart of Accounts Powered By Docstoc
					       6fbc7ccc-1d8c-46fa-9a33-7117fb64cd61.xls                     Accounting Flexfield Segments                                  Prepared by : Richard Byrom
                                                                                                                                      Date: 1/8/2011 12:00 AM

     Company                   Cost Centre                Department                                Account                   Product                   Future
      2 Characters               3 Characters               2 Characters                            4 Characters             3 Characters              3 Characters
01 Test Company        000   No Cost Centre       00   No Department               1000   Income                     100   Product Group 1       000   DEFAULT
99 Total Company       010   Head Office          05   Agencies                    2000   Expenses                   200   Product Sub Group 1
                       020   Gaborone             10   Public Relations            3000   Assets                     300   Product Sub Group 2
                       030   Francistown          15   Business Development        5000   Liabilities                400   Product Sub Group 3
                       040   Maun                 20   General Management          6000   Share Capital & Reserves   500   Product Group 2
                       999   Total Cost Centre    25   Admin                       9999   Total Account              999   Total Product
                                                  30   Human Resources
                                                  35   Legal
                                                  40   Information Services
                                                  45   Finance
                                                  50   Audit
                                                  99   Total Department




                                                                                                                                                 Page 1 of 14
6fbc7ccc-1d8c-46fa-9a33-7117fb64cd61.xlsCompany or Business Unit   Prepared by : Richard Byrom
                                                                      Date : 1/8/2011 12:00 AM
                   Segment
           Range                                   Description             Parent
                    Value
           01 - 98    01   Test Company                                       99
                      99   TOTAL COMPANY                                    None




                                                                                    Page 2 of 14
6fbc7ccc-1d8c-46fa-9a33-7117fb64cd61.xls     Cost Centre     Prepared By : NDB Project Team
                                                                    Date : 1/8/2011 12:00 AM

          Segment
 Range                         Description          Parent
           Value
000 - 998   000      No Cost Centre                    999
            010      Head Office                       999
            020      Gaborone                          999
            030      Francistown                       999
            040      Maun                              999
            999      TOTAL COST CENTRE                None




                                                                               Page 3 of 14
        6fbc7ccc-1d8c-46fa-9a33-7117fb64cd61.xls   Department            Prepared by : NDB Project Team
                                                                               Date : 1/8/2011 12:00 AM
        Segment
Range             Description                                   Parent
         Value
00 - 98    00     No Department                                    99
           05     Agencies                                         99
           10     Public Relations                                 99
           15     Business Development                             99
           20     General Management                               99
           25     Admin                                            99
           30     Human Resources                                  99
           35     Legal                                            99
           40     Information Services                             99
           45     Finance                                          99
           50     Audit                                            99
           99     TOTAL DEPARTMENT                               None




                                                                                           Page 4 of 14
          6fbc7ccc-1d8c-46fa-9a33-7117fb64cd61.xls                           Account                                                 Prepared by : Richard Byrom
                                                                                                                                        Date : 1/8/2011 12:00 AM


                Segment                                                                                                                  Cross Validation
  Range                                               Description        A/C Type      Old A/C No.   Parent       Rollup
                 Value
                                                                                                                           Company   Cost Centre   Department      Product
1000 - 1999       1000      OPERATING INCOME                            Income                N/A             9999 TEST    Yes       Yes           Yes             Yes
1100 - 1250       1100      INTEREST INCOME                             Income                N/A             1000         Yes       Yes           Yes             Yes
                  1110      LOAN INTEREST                               Income                N/A             1100         Yes       Yes           Yes             Yes
                  1120      Loan 1                                      Income                N/A             1110         Yes       Yes           Yes             Yes
                  1130      Loan 2                                      Income                N/A             1110         Yes       Yes           Yes             Yes
1301 - 1499       1300      OTHER INCOME                                Income                N/A             1000         Yes       Yes           Yes             Yes
                  1310      Other 1                                     Income                N/A             1300         Yes       Yes           Yes             Yes
                  1320      Other 2                                     Income                N/A             1300         Yes       Yes           Yes             Yes
1501 - 1599       1500      MISCELLANEOUS INCOME                        Income                N/A             1300         Yes       Yes           Yes             Yes
                  1510      Misc 1                                      Income                N/A             1500         Yes       Yes           Yes             Yes
                  1520      Misc 2                                      Income                N/A             1500         Yes       Yes           Yes             Yes
2000 - 2999       2000      EXPENSES                                    Expense               N/A             9999 TEST    Yes       Yes           Yes             Yes
2100 - 2199       2100      COST OF BORROWING                           Expense               N/A             2000         Yes       Yes           Yes             Yes
                  2105      Interest Expense                            Expense            850000             2100         Yes       Yes           Yes             Yes
                  2110      Interest on Overdraft                       Expense            850005             2100         Yes       Yes           Yes             Yes
2200 - 2999       2200      PAYROLL COST                                Expense               N/A             2000         Yes       Yes           Yes             Yes
                  2205      Salaries & Allowances                       Expense            875000             2200         Yes       Yes           Yes             Yes
                  2210      Overtime                                    Expense            875005             2200         Yes       Yes           Yes             Yes
                  2215      Casual Labour                               Expense            875008             2200         Yes       Yes           Yes             Yes
                  2220      Medical Aid Contributions                   Expense            875010             2200         Yes       Yes           Yes             Yes
                  2225      Pension Contribution                        Expense            875015             2200         Yes       Yes           Yes             Yes
                  2230      Staff Gratuities                            Expense            875020             2200         Yes       Yes           Yes             Yes
                  2235      Leave Pay                                   Expense            875022             2200         Yes       Yes           Yes             Yes
                  2240      Other Salary Manual Payments                Expense            875036             2200         Yes       Yes           Yes             Yes
                  2245      Bonus Payment                               Expense            875038             2200         Yes       Yes           Yes             Yes
2300 - 2899       2300      ADMINISTRATION COSTS                        Expense               N/A             2000         Yes       Yes           Yes             Yes
2311 - 2399       2310      DEPRECIATION                                Expense               N/A             2300         Yes       Yes           Yes             Yes
                  2315      Land & Buildings : Depreciation             Expense            810000             2310         Yes       Yes           Yes             Yes
                  2325      Motor Vehicles : Depreciation               Expense            820000             2310         Yes       Yes           Yes             Yes
                  2330      Office Furniture : Depreciation             Expense            825000             2310         Yes       Yes           Yes             Yes
                  2335      Staff Furniture : Depreciation              Expense            830000             2310         Yes       Yes           Yes             Yes
                  2340      Office Equipment : Depreciation             Expense            835000             2310         Yes       Yes           Yes             Yes
                  2345      Computer Hardware : Depreciation            Expense            835025             2310         Yes       Yes           Yes             Yes
                  2350      Computer Software : Depreciation            Expense            835035             2310         Yes       Yes           Yes             Yes
2401 - 2499       2400      REPAIRS & MAINTENANCE                       Expense               N/A             2300         Yes       Yes           Yes             Yes
                  2405      Repairs & Maintenance : Buildings           Expense            845025             2400         Yes       Yes           Yes             Yes
                  2410      Repairs & Maintenance : Residential         Expense            845026             2400         Yes       Yes           Yes             Yes
                  2415      Repairs & Maintenance : Computer Hardware   Expense            845030             2400         Yes       Yes           Yes             Yes
                  2420      Repairs & Maintenance : Office Equipment    Expense            845035             2400         Yes       Yes           Yes             Yes
                  2425      Repairs & Maintenance : Office Furniture    Expense            845040             2400         Yes       Yes           Yes             Yes
                  2430      Repairs & Maintenance : General             Expense            845045             2400         Yes       Yes           Yes             Yes
                  2435      Repairs & Maintenance : Motor Vehicles      Expense            845050             2400         Yes       Yes           Yes             Yes
2501 - 2899       2500      OTHER ADMIN COSTS                           Expense               N/A             2300         Yes       Yes           Yes             Yes
                  2505      Auditors Other Services                     Expense            802000             2500         Yes       Yes           Yes             Yes
                  2510                                                  Expense            880000             2500         Yes       Yes           Yes             Yes
                  2515      Advertising & Marketing                     Expense            845140             2500         Yes       Yes           Yes             Yes
                  2520      Aids Awareness                              Expense            875085             2500         Yes       Yes           Yes             Yes
                  2525                                                  Expense            875056             2500         Yes       Yes           Yes             Yes
                  2530      Annual Report                               Expense            845108             2500         Yes       Yes           Yes             Yes
                  2535      AR Payments Discount                        Expense            855030             2500         Yes       Yes           Yes             Yes

                                                                                                                                                    Page 5 of 13
        6fbc7ccc-1d8c-46fa-9a33-7117fb64cd61.xls                        Account                                                    Prepared by : Richard Byrom
                                                                                                                                      Date : 1/8/2011 12:00 AM


              Segment                                                                                                                  Cross Validation
Range                                                Description    A/C Type      Old A/C No.   Parent          Rollup
               Value
                                                                                                                         Company   Cost Centre   Department      Product
                2540      AR Write Off Discount                    Expense            855035             2500            Yes       Yes           Yes             Yes
                2545      Archiving Expenses                       Expense            860010             2500            Yes       Yes           Yes             Yes
                2550      Auction Fees                             Expense            855020             2500            Yes       Yes           Yes             Yes
                2555      Audit Fees                               Expense            801000             2500            Yes       Yes           Yes             Yes
                2560      Bank Charges                             Expense            845130             2500            Yes       Yes           Yes             Yes
                2565      Bankers Institute Events                 Expense            875054             2500            Yes       Yes           Yes             Yes
                2567      Car Rental Expenses                      Expense            845001             2500            Yes       Yes           Yes             Yes
                2570      Cell Phones                              Expense            845090             2500            Yes       Yes           Yes             Yes
                2575      Cleaning                                 Expense            845020             2500            Yes       Yes           Yes             Yes
                2580      Computer Hardware Support                Expense            845125             2500            Yes       Yes           Yes             Yes
                2585      Computer Licence Expenses                Expense            845115             2500            Yes       Yes           Yes             Yes
                2590      Computer Software Purchases              Expense            845120             2500            Yes       Yes           Yes             Yes
                2595      Consultancy and Advisors                 Expense            855001             2500            Yes       Yes           Yes             Yes
                2600      Directors Expenses                       Expense            805005             2500            Yes       Yes           Yes             Yes
                2605      Directors Fees                           Expense            805000             2500            Yes       Yes           Yes             Yes
                2610      Dividends Expense                        Expense            805001             2500            Yes       Yes           Yes             Yes
                2615                                               Expense            860005             2500            Yes       Yes           Yes             Yes
                2620      Doubtful Rents                           Expense            615032             2500            Yes       Yes           Yes             Yes
                2625      Education Allowance                      Expense            875035             2500            Yes       Yes           Yes             Yes
                2630      Electricity                              Expense            845010             2500            Yes       Yes           Yes             Yes
                2635      Entertainment Expenses                   Expense            845135             2500            Yes       Yes           Yes             Yes
                2640      ERP Project Expenses                     Expense            835040             2500            Yes       Yes           Yes             Yes
                2645      Exchange Gains/Losses                    Expense            840000             2500            Yes       Yes           Yes             Yes
                2650      Expenses W/OFF General                   Expense            855036             2500            Yes       Yes           Yes             Yes
                2655      Fax Charges                              Expense            845085             2500            Yes       Yes           Yes             Yes
                2660      Group Life Assurances                    Expense            875090             2500            Yes       Yes           Yes             Yes
                2665      Insurance                                Expense            845110             2500            Yes       Yes           Yes             Yes
                2670      ISO 9000                                 Expense            855010             2500            Yes       Yes           Yes             Yes
                2675      Legal Fees                               Expense            855015             2500            Yes       Yes           Yes             Yes
                2680      Management/Consultants Fees              Expense            855000             2500            Yes       Yes           Yes             Yes
                2685      Miscellaneous Expenses                   Expense            860000             2500            Yes       Yes           Yes             Yes
                2690      Motor Vehicle Fuel & Oils                Expense            845055             2500            Yes       Yes           Yes             Yes
                2695      Motor Vehicle Ins & Licencing            Expense            845060             2500            Yes       Yes           Yes             Yes
                2700      Office Rental Expense                    Expense            845000             2500            Yes       Yes           Yes             Yes
                2705      P.W. Consultancy costs                   Expense            855005             2500            Yes       Yes           Yes             Yes
                2710      Postages                                 Expense            845095             2500            Yes       Yes           Yes             Yes
                2715      Printing & Publications                  Expense            845105             2500            Yes       Yes           Yes             Yes
                2720      Public Relations                         Expense            875053             2500            Yes       Yes           Yes             Yes
                2725      Rates and Taxes                          Expense            845005             2500            Yes       Yes           Yes             Yes
                2730      Recruitment Expenses                     Expense            875045             2500            Yes       Yes           Yes             Yes
                2735      Security Expenses                        Expense            855025             2500            Yes       Yes           Yes             Yes
                2740      Staff Presents                           Expense            860015             2500            Yes       Yes           Yes             Yes
                2745      Staff Recreation                         Expense            875051             2500            Yes       Yes           Yes             Yes
                2750      Staff Rent and Other Services            Expense            875030             2500            Yes       Yes           Yes             Yes
                2755      Staff Travel & Settling Allowance        Expense            875025             2500            Yes       Yes           Yes             Yes
                2760      Staff Uniform Expenses                   Expense            875050             2500            Yes       Yes           Yes             Yes
                2765      Stationery Expenses                      Expense            845100             2500            Yes       Yes           Yes             Yes
                2770      Subscriptions                            Expense            805002             2500            Yes       Yes           Yes             Yes
                2775      Tea & Coffee Expenses                    Expense            845065             2500            Yes       Yes           Yes             Yes
                2780      Telephone Charges                        Expense            845080             2500            Yes       Yes           Yes             Yes

                                                                                                                                                  Page 6 of 13
          6fbc7ccc-1d8c-46fa-9a33-7117fb64cd61.xls                              Account                                                 Prepared by : Richard Byrom
                                                                                                                                           Date : 1/8/2011 12:00 AM


                Segment                                                                                                                     Cross Validation
  Range                                              Description            A/C Type      Old A/C No.   Parent       Rollup
                 Value
                                                                                                                              Company   Cost Centre   Department      Product
                  2785      Training Expenses                              Expense            875040             2500         Yes       Yes           Yes             Yes
                  2790      Travelling Expenses Local                      Expense            845070             2500         Yes       Yes           Yes             Yes
                  2795      Travelling Expenses Overseas                   Expense            845075             2500         Yes       Yes           Yes             Yes
                  2800      Water Charges:H/Office                         Expense            845015             2500         Yes       Yes           Yes             Yes
                  2805      Y2K Expenses                                   Expense            860011             2500         Yes       Yes           Yes             Yes
                  2810      Year End Function                              Expense            875052             2500         Yes       Yes           Yes             Yes
2901 - 2949       2900      EXTRA ORDINARY ITEMS                           Expense               N/A             2000         Yes       Yes           Yes             Yes
                  2905      (Profit)/Loss on Sale of Shares                Expense            620005             2900         Yes       Yes           Yes             Yes
2951 - 2999       2950      BAD DEBT PROVISION & W/OFFS                    Expense               N/A             2000         Yes       Yes           Yes             Yes
                  2955      Bad Debts Recoveries                           Expense            615035             2950         Yes       Yes           Yes             Yes
                  2960      Provision for Doubtful Debts                   Expense            870000             2950         Yes       Yes           Yes             Yes
                  2965                                                     Expense            870001             2950         Yes       Yes           Yes             Yes
                  2970      Loans Written Off                              Expense            870005             2950         Yes       Yes           Yes             Yes
                  2975      Write Back Amortised                           Expense            870002             2950         Yes       Yes           Yes             Yes
                  2980      Research and Development                       Expense            875057             2950         Yes       Yes           Yes             Yes
                  2985      Restructuring Costs                            Expense            875055             2950         Yes       Yes           Yes             Yes
                  2990      Provision for Dividends                        Expense            805001             2950         Yes       Yes           Yes             Yes
3000 - 4999       3000      ASSETS                                         Asset                 N/A             9999 TEST    Yes       No            No              No
                  3005      FIXED ASSETS : NBV                             Asset                 N/A             3000         Yes       No            No              No
3101 - 3199       3100      FIXED ASSETS : COST                            Asset                 N/A             3005         Yes       No            No              No
                  3105      Land & Buildings : Cost                        Asset              321000             3100         Yes       No            No              No
                  3110      Land & Buildings : WIP                         Asset              321004             3100         Yes       No            No              No
                  3125      Office Furniture : Cost                        Asset              321010             3100         Yes       No            No              No
                  3130      Staff Furniture : Cost                         Asset              321015             3100         Yes       No            No              No
                  3135      Office Equipment : Cost                        Asset              321020             3100         Yes       No            No              No
                  3140      Computer Software : Cost                       Asset              321022             3100         Yes       No            No              No
                  3145      Computer Software : WIP                        Asset                 N/A             3100         Yes       No            No              No
                  3150      Computer Hardware : Cost                       Asset              321023             3100         Yes       No            No              No
                  3152      Computer Hardware : WIP                        Asset                                 3100         Yes       No            No              No
                  3155      Motor Vehicles : Cost                          Asset              321030             3100         Yes       No            No              No
                  3160      Asset Clearing                                 Asset                 N/A             3100         Yes       No            No              No
                  3165      WIP Clearing                                   Asset                 N/A             3100         Yes       No            No              No
3201 - 3299       3200      FIXED ASSETS : ACCUMULATED DEPRECIATION        Asset                 N/A             3005         Yes       No            No              No
                  3205      Land & Buildings : Accumulated Depreciation    Asset              322000             3200         Yes       No            No              No
                  3215      Office Furniture : Accumulated Depreciation    Asset              322010             3200         Yes       No            No              No
                  3220      Staff Furniture : Accumulated Depreciation     Asset              322015             3200         Yes       No            No              No
                  3225      Office Equipment : Accumulated Depreciation    Asset              322020             3200         Yes       No            No              No
                  3230      Computer Hardware : Accumulated Depreciation   Asset              322025             3200         Yes       No            No              No
                  3235      Computer Software : Accumulated Depreciation   Asset                 N/A             3200         Yes       No            No              No
                  3240      Motor Vehicles : Accumulated Depreciation      Asset              322030             3200         Yes       No            No              No
3301 - 3399       3300      INVESTMENTS/NEGOTIABLE INSTRUMENTS             Asset                 N/A             3000         Yes       No            No              No
                  3305                                                     Asset              330000             3300         Yes       No            No              No
                  3310                                                     Asset              330005             3300         Yes       No            No              No
                  3315                                                     Asset              330010             3300         Yes       No            No              No
                  3320                                                     Asset              340034             3300         Yes       No            No              No
                  3325                                                     Asset              350016             3300         Yes       No            No              No
                  3330                                                     Asset              350019             3300         Yes       No            No              No
                  3335                                                     Asset              350015             3300         Yes       No            No              No
3401 - 3499       3400      LOANS GROSS                                    Asset                 N/A             3000         Yes       No            No              No
                  3405                                                     Asset              240040             3400         Yes       No            No              No

                                                                                                                                                       Page 7 of 13
          6fbc7ccc-1d8c-46fa-9a33-7117fb64cd61.xls                          Account                                                    Prepared by : Richard Byrom
                                                                                                                                          Date : 1/8/2011 12:00 AM


                Segment                                                                                                                    Cross Validation
  Range                                               Description    A/C Type         Old A/C No.   Parent          Rollup
                 Value
                                                                                                                             Company   Cost Centre   Department      Product
                  3410                                              Asset                 240042             3400            Yes       No            No              No
                  3415                                              Asset                 240043             3400            Yes       No            No              No
                  3420                                              Asset                 240045             3400            Yes       No            No              No
                  3425                                              Asset                 240046             3400            Yes       No            No              No
                  3430                                              Asset                 240047             3400            Yes       No            No              No
                  3435                                              Asset                 340000             3400            Yes       No            No              No
                  3440                                              Asset                 340002             3400            Yes       No            No              No
                  3445                                              Asset                 340003             3400            Yes       No            No              No
                  3450                                              Asset                 340005             3400            Yes       No            No              No
                  3455                                              Asset                 340009             3400            Yes       No            No              No
                  3460                                              Asset                 340010             3400            Yes       No            No              No
                  3465                                              Asset                 340015             3400            Yes       No            No              No
                  3470                                              Asset                 340045             3400            Yes       No            No              No
                  3475                                              Asset                 340050             3400            Yes       No            No              No
                  3490                                              Asset                    N/A             3400            Yes       No            No              No
                  3492                                              Asset                    N/A             3400            Yes       No            No              No
3500 - 3799       3500      OTHER ASSETS                            Asset                    N/A             3000            Yes       No            No              No
3506 - 3549       3505      PAYROLL                                 Asset                    N/A             3500            Yes       No            No              No
                  3508                                              Asset                 240050             3505            Yes       No            No              No
                  3511                                              Asset                 240055             3505            Yes       No            No              No
                  3514                                              Asset                 240060             3505            Yes       No            No              No
                  3517                                              Asset                 240065             3505            Yes       No            No              No
                  3520                                              Asset                 240070             3505            Yes       No            No              No
                  3523                                              Asset                 240072             3505            Yes       No            No              No
                  3526                                              Asset                 240073             3505            Yes       No            No              No
                  3529                                              Asset                 240075             3505            Yes       No            No              No
                  3532                                              Asset                 240080             3505            Yes       No            No              No
                  3535                                              Asset                 240090             3505            Yes       No            No              No
                  3538                                              Asset                 240095             3505            Yes       No            No              No
                  3541                                              Asset                 240100             3505            Yes       No            No              No
3551 - 3599       3550      OTHER DEBTORS                           Asset                    N/A             3500            Yes       No            No              No
                  3553      Auction Sales Proceeds                  Asset                 240085             3550            Yes       No            No              No
                  3556      Sundry Debtors:Personal                 Asset                 240101             3550            Yes       No            No              No
                  3559      Staff Debtors:Credit Card Control       Asset                 240102             3550            Yes       No            No              No
                  3562      Sundry Detors:Main A/C                  Asset                 240103             3550            Yes       No            No              No
                  3565      Sundry Debtors Control                  Asset                 240104             3550            Yes       No            No              No
                  3568      Debtors Control                         Asset                 240105             3550            Yes       No            No              No
                  3574      Rent Receivable                         Asset                 360000             3550            Yes       No            No              No
                  3577      Dividends Receivable                    Asset                 360030             3550            Yes       No            No              No
                  3580      Receivables Others                      Asset                 360020             3550            Yes       No            No              No
3601 - 3649       3600      RECEIVABLES AGENCIES                    Asset                    N/A             3500            Yes       No            No              No
                  3603                                              Asset                 250005             3600            Yes       No            No              No
                  3606                                              Asset                 250006             3600            Yes       No            No              No
                  3609                                              Asset                 250007             3600            Yes       No            No              No
                  3612                                              Asset                 250008             3600            Yes       No            No              No
                  3615                                              Asset                 250009             3600            Yes       No            No              No
                  3618                                              Asset                 250010             3600            Yes       No            No              No
                  3621                                              Asset                 250015             3600            Yes       No            No              No
                  3624                                              Asset                 250016             3600            Yes       No            No              No
                  3627                                              Asset                 250017             3600            Yes       No            No              No

                                                                                                                                                      Page 8 of 13
          6fbc7ccc-1d8c-46fa-9a33-7117fb64cd61.xls                                         Account                                                    Prepared by : Richard Byrom
                                                                                                                                                         Date : 1/8/2011 12:00 AM


                Segment                                                                                                                                   Cross Validation
  Range                                              Description                    A/C Type         Old A/C No.   Parent          Rollup
                 Value
                                                                                                                                            Company   Cost Centre   Department      Product
                  3630                                                             Asset                 250018             3600            Yes       No            No              No
                  3633                                                             Asset                 250019             3600            Yes       No            No              No
                  3636                                                             Asset                 350085             3600            Yes       No            No              No
                  3639                                                             Asset                 350090             3600            Yes       No            No              No
                  3642                                                             Asset                 360015             3600            Yes       No            No              No
3651 - 3699       3650      STAFF DEBTORS                                          Asset                    N/A             3500            Yes       No            No              No
                  3653                                                             Asset                 355000             3650            Yes       No            No              No
                  3656                                                             Asset                 355001             3650            Yes       No            No              No
                  3659                                                             Asset                 355005             3650            Yes       No            No              No
                  3662                                                             Asset                 355008             3650            Yes       No            No              No
                  3665                                                             Asset                 355010             3650            Yes       No            No              No
                  3668                                                             Asset                 355015             3650            Yes       No            No              No
                  3671                                                             Asset                 355020             3650            Yes       No            No              No
                  3674                                                             Asset                 355025             3650            Yes       No            No              No
                  3677                                                             Asset                 355030             3650            Yes       No            No              No
                  3680                                                             Asset                 360095             3650            Yes       No            No              No
3700 - 3749       3700      INTEREST RECEIVABLE                                    Asset                    N/A             3500            Yes       No            No              No
                  3703                                                             Asset                 360005             3700            Yes       No            No              No
                  3706                                                             Asset                 360006             3700            Yes       No            No              No
                  3709                                                             Asset                 360007             3700            Yes       No            No              No
                  3712                                                             Asset                 360008             3700            Yes       No            No              No
                  3715                                                             Asset                 360009             3700            Yes       No            No              No
                  3718                                                             Asset                 360010             3700            Yes       No            No              No
3751 - 3799       3750      PREPAYMENTS                                            Asset                    N/A             3500            Yes       No            No              No
                  3753                                                             Asset                 240000             3750            Yes       No            No              No
                  3756                                                             Asset                 240106             3750            Yes       No            No              No
                  3759                                                             Asset                 360025             3750            Yes       No            No              No
                  3762                                                             Asset                 360035             3750            Yes       No            No              No
                  3765                                                             Asset                 360040             3750            Yes       No            No              No
                  3768                                                             Asset                 360090             3750            Yes       No            No              No
3801 - 4049       3800      BANK BALANCES                                          Asset                    N/A             3000            Yes       No            No              No
3805 - 3899       3805      CURRENT ACCOUNTS                                       Asset                    N/A             3800            Yes       No            No              No
3811 - 3819       3810      BARCLAYS MAIN ACCOUNT TOTAL                            Asset                 350065             3805            Yes       No            No              No
                  3811      Barclays Main Current Account                          Asset                 350065             3810            Yes       No            No              No
                  3812      Barclays Main Current Account Clearing                 Asset                 350065             3810            Yes       No            No              No
                  3813      Barclays Main Current Account Errors                   Asset                 350065             3810            Yes       No            No              No
                  3814      Barclays Main Current Account Transfers                Asset                 350065             3810            Yes       No            No              No
                  3815      Barclays Main Current A/C Confirmed Receipts           Asset                 350065             3810            Yes       No            No              No
                  3816      Barclays Main Current A/C Reversed DD Clearing         Asset                 350065             3810            Yes       No            No              No
3821 - 3829       3820      BARCLAYS KNIGHT FRANK ACCOUNT TOTAL                    Asset                 350045             3805            Yes       No            No              No
                  3821      Barclays Knight Frank Current Account                  Asset                 350045             3820            Yes       No            No              No
                  3822      Barclays Knight Frank Current Account Clearing         Asset                 350045             3820            Yes       No            No              No
                  3823      Barclays Knight Frank Current Account Errors           Asset                 350045             3820            Yes       No            No              No
                  3824      Barclays Knight Frank Current Account Transfers        Asset                 350045             3820            Yes       No            No              No
                  3825      Barclays Knight Frank Current A/C Confirmed Receipts   Asset                 350045             3820            Yes       No            No              No
3831 - 3839       3830      STD STAFF ADMIN ACCOUNT TOTAL                          Asset                 350105             3805            Yes       No            No              No
                  3831      Std Staff Admin Current Account                        Asset                 350105             3830            Yes       No            No              No
                  3832      Std Staff Admin Current Account Clearing               Asset                 350105             3830            Yes       No            No              No
                  3833      Std Staff Admin Current Account Errors                 Asset                 350105             3830            Yes       No            No              No
                  3834      Std Staff Admin Current Account Transfers              Asset                 350105             3830            Yes       No            No              No

                                                                                                                                                                     Page 9 of 13
          6fbc7ccc-1d8c-46fa-9a33-7117fb64cd61.xls                                   Account                                                    Prepared by : Richard Byrom
                                                                                                                                                   Date : 1/8/2011 12:00 AM


                Segment                                                                                                                             Cross Validation
  Range                                              Description              A/C Type         Old A/C No.   Parent          Rollup
                 Value
                                                                                                                                      Company   Cost Centre   Department      Product
                  3835      Std Staff Admin Current A/C Confirmed Receipts                         350105             3830            Yes       No            No              No
3841 - 3849       3840      STD DIRECT DEBIT ACCOUNT TOTAL                   Asset                 350014             3805            Yes       No            No              No
                  3841      Std Direct Debit Account                         Asset                 350014             3840            Yes       No            No              No
                  3842      Std Direct Debit Account Clearing                Asset                 350014             3840            Yes       No            No              No
                  3843      Std Direct Debit Account Errors                  Asset                 350014             3840            Yes       No            No              No
                  3844      Std Direct Debit Account Transfers               Asset                 350014             3840            Yes       No            No              No
                  3845      Std Direct Debit A/C Confirmed Receipts          Asset                 350014             3840            Yes       No            No              No
                  3846      Std Direct Debit A/C Reversed DD Clearing        Asset                 350014             3840            Yes       No            No              No
3850 - 3859       3850      FNB CREDIT CARD ACCOUNT TOTAL                    Asset                 350010             3805            Yes       No            No              No
                  3851      FNB Credit Card Account                          Asset                 350010             3850            Yes       No            No              No
                  3852      FNB Credit Card Account Clearing                 Asset                 350010             3850            Yes       No            No              No
                  3853      FNB Credit Card Account Errors                   Asset                 350010             3850            Yes       No            No              No
                  3854      FNB Credit Card Account Transfers                Asset                 350010             3850            Yes       No            No              No
3861 - 3869       3860      FNB DIRECT DEBIT ACCOUNT TOTAL                   Asset                 350012             3805            Yes       No            No              No
                  3861      FNB Direct Debit Account                         Asset                 350012             3860            Yes       No            No              No
                  3862      FNB Direct Debit Account Clearing                Asset                 350012             3860            Yes       No            No              No
                  3863      FNB Direct Debit Account Errors                  Asset                 350012             3860            Yes       No            No              No
                  3864      FNB Direct Debit Account Transfers               Asset                 350012             3860            Yes       No            No              No
                  3865      FNB Direct Debit A/C Confirmed Receipts          Asset                 350012             3860            Yes       No            No              No
                  3866      FNB Direct Debit A/C Reversed DD Clearing        Asset                 350012             3860            Yes       No            No              No
3871 - 3879       3870      STANBIC DIRECT DEBIT ACCOUNT TOTAL               Asset                 350013             3805            Yes       No            No              No
                  3871      Stanbic Direct Debit Account                     Asset                 350013             3870            Yes       No            No              No
                  3872      Stanbic Direct Debit Account Clearing            Asset                 350013             3870            Yes       No            No              No
                  3873      Stanbic Direct Debit Account Errors              Asset                 350013             3870            Yes       No            No              No
                  3874      Stanbic Direct Debit Account Transfers           Asset                 350013             3870            Yes       No            No              No
                  3875      Stanbic Direct Debit A/C Confirmed Receipts      Asset                 350013             3870            Yes       No            No              No
                  3876      Stanbic Direct Debit A/C Reversed DD Clearing    Asset                 350013             3870            Yes       No            No              No
3901 - 3949       3900      CALL DEPOSITS                                    Asset                    N/A             3800            Yes       No            No              No
3906 - 3914       3905      BARCLAYS MAIN CALL ACCOUNT TOTAL                 Asset                 350030             3900            Yes       No            No              No
                  3906      Barclays Main Call Account                       Asset                 350030             3905            Yes       No            No              No
                  3907      Barclays Main Call Account Clearing              Asset                 350030             3905            Yes       No            No              No
                  3908      Barclays Main Call Account Errors                Asset                 350030             3905            Yes       No            No              No
                  3909      Barclays Main Call Account Transfers             Asset                 350030             3905            Yes       No            No              No
3916 - 3924       3915      BARCLAYS KNIGHT FRANK CALL ACCOUNT TOTAL         Asset                 350050             3900            Yes       No            No              No
                  3916      Barclays Knight Frank Call Account               Asset                 350050             3915            Yes       No            No              No
                  3917      Barclays Knight Frank Call Account Clearing      Asset                 350050             3915            Yes       No            No              No
                  3918      Barclays Knight Frank Call Account Errors        Asset                 350050             3915            Yes       No            No              No
                  3919      Barclays Knight Frank Call Account Transfers     Asset                 350050             3915            Yes       No            No              No
3926 - 3934       3925      STD STAFF ADMIN ACCOUNT TOTAL                    Asset                 350110             3900            Yes       No            No              No
                  3926      Std Bank Staff Admin Call Account                Asset                 350110             3925            Yes       No            No              No
                  3927      Std Bank Staff Admin Call Account Clearing       Asset                 350110             3925            Yes       No            No              No
                  3928      Std Bank Staff Admin Call Account Errors         Asset                 350110             3925            Yes       No            No              No
                  3929      Std Bank Staff Admin Call Account Transfers      Asset                 350110             3925            Yes       No            No              No
3936 - 3944       3935      STD USD ACCOUNT TOTAL                            Asset                 350140             3900            Yes       No            No              No
                  3936      Std USD Account                                  Asset                 350140             3935            Yes       No            No              No
                  3937      Std USD Account Clearing                         Asset                 350140             3935            Yes       No            No              No
                  3938      Std USD Account Errors                           Asset                 350140             3935            Yes       No            No              No
                  3939      Std USD Account Transfers                        Asset                 350140             3935            Yes       No            No              No
3951 - 3999       3950      TIME DEPOSITS                                    Asset                    N/A             3800            Yes       No            No              No
                  3955      Deposits with Barclays Bank.                     Asset                 350000             3950            Yes       No            No              No

                                                                                                                                                              Page 10 of 13
          6fbc7ccc-1d8c-46fa-9a33-7117fb64cd61.xls                       Account                                                 Prepared by : Richard Byrom
                                                                                                                                    Date : 1/8/2011 12:00 AM


                Segment                                                                                                              Cross Validation
  Range                                              Description    A/C Type       Old A/C No.   Parent       Rollup
                 Value
                                                                                                                       Company   Cost Centre   Department      Product
                  3960      Deposits with Standard Bank.           Asset               350005             3950         Yes       No            No              No
                  3965      Deposits with Bank of Botswana         Asset               350015             3950         Yes       No            No              No
                  3970      Deposit with Stanbic                   Asset               350020             3950         Yes       No            No              No
                  3975      FNB Deposits                           Asset               350040             3950         Yes       No            No              No
                  3985      Investec Deposits                      Asset                                  3950         Yes       No            No              No
                  3990      A.B.C                                  Asset                                  3950         Yes       No            No              No
4001 - 4049       4000      OTHER                                  Asset                  N/A             3800         Yes       No            No              No
                  4005      Petty Cash                             Asset               350055             4000         Yes       Yes           No              No
                  4010      Bank Transfer Control A/C              Asset               350135             4000         Yes       No            No              No
5000 - 5999       5000      LIABILITIES                            Liability              N/A             9999 TEST    Yes       No            No              No
                  5100      LOANS PROVISIONS                       Liability              N/A             5000         Yes       No            No              No
                  5105                                             Liability           340030             5100         Yes       No            No              No
                  5110                                             Liability           340031             5100         Yes       No            No              No
                  5115                                             Liability           340032             5100         Yes       No            No              No
                  5120                                             Liability           340033             5100         Yes       No            No              No
5251 - 5299       5250      BORROWINGS                             Liability              N/A             5000         Yes       No            No              No
                  5255                                             Liability           210000             5250         Yes       No            No              No
5301 - 5349       5300      OTHER BORROWINGS                       Liability              N/A             5000         Yes       No            No              No
                  5305                                             Liability           210010             5300         Yes       No            No              No
                  5310                                             Liability           210005             5300         Yes       No            No              No
5351 - 5399       5350      OWED TO AGENCIES                       Liability              N/A             5000         Yes       No            No              No
                  5355                                             Liability           250000             5350         Yes       No            No              No
                  5360                                             Liability           250011             5350         Yes       No            No              No
5401 - 5499       5400      CREDITORS                              Liability              N/A             5000         Yes       No            No              No
                  5403                                             Liability           240017             5400         Yes       No            No              No
                  5406                                             Liability           240020             5400         Yes       No            No              No
                  5407                                             Liability                              5400         Yes       No            No              No
                  5409                                             Liability           240021             5400         Yes       No            No              No
                  5412                                             Liability           210020             5400         Yes       No            No              No
                  5415                                             Liability           210025             5400         Yes       No            No              No
                  5418                                             Liability           210030             5400         Yes       No            No              No
                  5421                                             Liability           220000             5400         Yes       No            No              No
                  5424                                             Liability           230000             5400         Yes       No            No              No
                  5427                                             Liability           240023             5400         Yes       No            No              No
                  5430                                             Liability           240024             5400         Yes       No            No              No
                  5433                                             Liability           240027             5400         Yes       No            No              No
                  5436                                             Liability           240030             5400         Yes       No            No              No
                  5439                                             Liability           240032             5400         Yes       No            No              No
                  5442                                             Liability           240035             5400         Yes       No            No              No
                  5445                                             Liability           350080             5400         Yes       No            No              No
                  5448                                             Liability           350145             5400         Yes       No            No              No
5501 - 5549       5500      PROVISIONS AND ACCRUALS                Liability              N/A             5000         Yes       No            No              No
                  5503      Interest Payable (Accrued)             Liability           210015             5500         Yes       No            No              No
                  5506      Staff Gratuity                         Liability           240005             5500         Yes       No            No              No
                  5509      Bonus Provision                        Liability           240008             5500         Yes       No            No              No
                  5512      Leave Pay Provision                    Liability           240010             5500         Yes       No            No              No
                  5515      Creditors Accruals                     Liability           240025             5500         Yes       No            No              No
                  5518      Dividends Payable                      Liability           360031             5500         Yes       No            No              No
                  5521                                             Liability           240011             5500         Yes       No            No              No
                  5524      Audit Fees Payable                     Liability           240015             5500         Yes       No            No              No

                                                                                                                                               Page 11 of 13
          6fbc7ccc-1d8c-46fa-9a33-7117fb64cd61.xls                      Account                                                 Prepared by : Richard Byrom
                                                                                                                                   Date : 1/8/2011 12:00 AM


                Segment                                                                                                             Cross Validation
  Range                                              Description    A/C Type      Old A/C No.   Parent       Rollup
                 Value
                                                                                                                      Company   Cost Centre   Department      Product
                  5527      Provision for doubtful rents           Liability          240022             5500         Yes       No            No              No
6000 - 6999       6000      SHARE CAPITAL AND RESERVES             Ownership             N/A             9999 TEST    Yes       No            No              No
6101 - 6199       6100      UNRECALLABLE CAPITAL                   Ownership             N/A             6000         Yes       No            No              No
                  6105                                             Ownership          110000             6100         Yes       No            No              No
                  6110                                             Ownership          110002             6100         Yes       No            No              No
                  6115                                             Ownership          110005             6100         Yes       No            No              No
                  6120                                             Ownership          110010             6100         Yes       No            No              No
                  6125                                             Ownership          110015             6100         Yes       No            No              No
                  6130                                             Ownership          110020             6100         Yes       No            No              No
                  6135                                             Ownership          110025             6100         Yes       No            No              No
                  6140                                             Ownership          110030             6100         Yes       No            No              No
                  6145                                             Ownership          110035             6100         Yes       No            No              No
6201 - 6299       6200      SUNDRY RESERVES                        Ownership             N/A             6000         Yes       No            No              No
                  6205                                             Ownership          120000             6200         Yes       No            No              No
                  6210                                             Ownership          120005             6200         Yes       No            No              No
                  6215                                             Ownership          120010             6200         Yes       No            No              No
                  6220                                             Ownership          140000             6200         Yes       No            No              No
                  6225      Revaluation Reserves                   Ownership          120015             6200         Yes       No            No              No
6301 - 6399       6300      ACCUMULATED TRADING PROFIT / LOSS      Ownership             N/A             6000         Yes       No            No              No
                  6305      Retained Earnings                      Ownership          130000             6300         Yes       No            No              No
                  6310      Take On Control                        Ownership                             6300         Yes       No            No              No
0000 - 9998       9999      TOTAL ACCOUNTS                         Ownership             N/A             None         Yes       No            No              No




                                                                                                                                              Page 12 of 13
6fbc7ccc-1d8c-46fa-9a33-7117fb64cd61.xls                          Product                                 Prepared by : Richard Byrom
                                                                                                             Date : 1/8/2011 12:00 AM

                                Segment
                   Range                   Description                                             Parent
                                 Value
                                  000      No Product                                               999
                                  100      PRODUCT GROUP 1                                          999
                                  200      PRODUCT SUB GROUP1                                       100
                 A01 - A99        A00      Agriculture                                              200
                                  A03      Livestock / Bredding Purchase                            A00
                                  A04      Agricultural Inputs                                      A00
                                  A05      Agricultural Machinery                                   A00
                                  A06      Water Services                                           A00
                                  A07      Farm Development                                         A00
                                  A21      Poultry                                                  A00
                                  A22      Horticulture                                             A00
                                  A45      Small Stock (Sheep & Goats)                              A00
                                  A46      Dairy                                                    A00
                                  A47      Piggery                                                  A00
                 R01 - R99        R00      Retailing                                                200
                                  R01      Supermarkets                                             R00
                                  R02      Large Scale Retailers                                    R00
                                  R24      General Dealers                                          R00
                                           Specialised Retailers (Service Stations, Restaurants,
                                  R26      Furniture Sales)                                        R00
                                  R27      Bottle Stores and Bars                                  R00
                                  R28      Butcheries Construction                                 R00
                 C01 - C99        C00      Commerce                                                200
                                  C30      Hotels and Catering                                     C00
                                  C35      Goods, Transport, Services                              C00
                                  C36      Construction Company Services                           C00
                                  C37      Business and Professional Services                      C00
                                  C40      Recreational Services                                   C00
                                  C41      Repairs of Motor Vehicles                               C00
                                  C42      Other Repairs of Motor Vehicles                         C00
                                  C43      Laundry, Dry Cleaning Etc.                              C00
                                  C44      Other Community, Personal Services                      C00
                  I01 - I99       I00      Industry, Manufacturing, Processing and Mining          200
                                  I11      Mining & Quarrying                                       I00
                                  I13      Grain Milling                                            I00
                                  I14      Bakery Products                                          I00
                                  I15      Textiles                                                 I00
                                  I16      Tanning, Leather Products and Processing                 I00
                                  I17      Furniture Manufacturing and Wood & Wooden Products       I00
                                  I18      Non Metallic Products Manufacturing                      I00
                                  I19      Metal Products Manufacturing (Welding Products)          I00
                                  I20      Other Manufacturing (e.g. Flowers)                       I00
                                  I32      Agricultural Based Manufacturing                         I00
                 P01 - P99        P00      Property Investments                                    200
                                  P78      Property Purchase                                       P00
                                  P79      Property Development (Construction)                     P00
                                  300      Government                                              100
                 S01 - S99        400      Staff Loans                                             100
                                  S70      Staff House Loan                                        400
                                  S71      Staff Car Loan                                          400
                                  S72      Computer                                                400
                                  S73      Furniture                                               400
                                  S74      Personal                                                400
                                  S75      Ex-Staff Motor Vehicle Loans                            400
                                  S76      Emergency (Staff)                                       400
                                  S79      Staff Housing Loans Extras                              400
                  V01 -V99        500      PRODUCT GROUP 2 - Motor Vehicles                        999
                                  V01      Motor Vehicle 1                                         500
                                  V02      Motor Vehicle 2                                         500
                                  V03      Motor Vehicle 3                                         500
                                  V04      Motor Vehicle 4                                         500
                                  V21      Motor Vehicle 5                                         500
                                  V22      Motor Vehicle 6                                         500
                                  V23      Motor Vehicle 7                                         500
                                  V24      Motor Vehicle 8                                         500
                                  V25      Motor Vehicle 9                                         500
                                  V26      Motor Vehicle 10                                        500
                                  V27      Motor Vehicle 11                                        500
                                  V28      Motor Vehicle 12                                        500
                                  V29      Motor Vehicle 13                                        500
                                  V30      Motor Vehicle 14                                        500
                                  V31      Motor Vehicle 15                                        500
                                  V32      Motor Vehicle 16                                        500
                                  V33      Motor Vehicle 17                                        500
                                  999      TOTAL PRODUCT                                           None




                                                                                                                       Page 13 of 14

				
DOCUMENT INFO
Description: Construction Company Chart of Accounts document sample