Docstoc

Oracle Applications Chart of Accounts Template

Document Sample
Oracle Applications Chart of Accounts Template Powered By Docstoc
					       e7e7414e-a64d-4a2d-831a-0cbbc01416d0.xls                     Accounting Flexfield Segments                                  Prepared by : Richard Byrom
                                                                                                                                       Date: 5/8/2011 5:57 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
e7e7414e-a64d-4a2d-831a-0cbbc01416d0.xls
                                     Company or Business Unit   Prepared by : Richard Byrom
                                                                    Date : 5/8/2011 5:57 AM
                   Segment
           Range                                Description             Parent
                    Value
           01 - 98    01   Test Company                                    99
                      99   TOTAL COMPANY                                 None




                                                                                 Page 2 of 14
e7e7414e-a64d-4a2d-831a-0cbbc01416d0.xls   Cost Centre     Prepared By : NDB Project Team
                                                                   Date : 5/8/2011 5:57 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
        e7e7414e-a64d-4a2d-831a-0cbbc01416d0.xls   Department            Prepared by : NDB Project Team
                                                                                Date : 5/8/2011 5:57 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
          e7e7414e-a64d-4a2d-831a-0cbbc01416d0.xls                          Account                                                 Prepared by : Richard Byrom
                                                                                                                                        Date : 5/8/2011 5:57 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
        e7e7414e-a64d-4a2d-831a-0cbbc01416d0.xls                       Account                                                    Prepared by : Richard Byrom
                                                                                                                                      Date : 5/8/2011 5:57 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
          e7e7414e-a64d-4a2d-831a-0cbbc01416d0.xls                             Account                                                 Prepared by : Richard Byrom
                                                                                                                                           Date : 5/8/2011 5:57 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
          e7e7414e-a64d-4a2d-831a-0cbbc01416d0.xls                         Account                                                    Prepared by : Richard Byrom
                                                                                                                                          Date : 5/8/2011 5:57 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
          e7e7414e-a64d-4a2d-831a-0cbbc01416d0.xls                                        Account                                                    Prepared by : Richard Byrom
                                                                                                                                                         Date : 5/8/2011 5:57 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
          e7e7414e-a64d-4a2d-831a-0cbbc01416d0.xls                                  Account                                                    Prepared by : Richard Byrom
                                                                                                                                                   Date : 5/8/2011 5:57 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
          e7e7414e-a64d-4a2d-831a-0cbbc01416d0.xls                       Account                                                 Prepared by : Richard Byrom
                                                                                                                                     Date : 5/8/2011 5:57 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
          e7e7414e-a64d-4a2d-831a-0cbbc01416d0.xls                      Account                                                 Prepared by : Richard Byrom
                                                                                                                                    Date : 5/8/2011 5:57 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
e7e7414e-a64d-4a2d-831a-0cbbc01416d0.xls                          Product                                 Prepared by : Richard Byrom
                                                                                                              Date : 5/8/2011 5:57 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