oracle chart of accounts (Excel)

Document Sample
oracle chart of accounts (Excel) Powered By Docstoc
					         6036542f-0fcc-421d-80d2-d312e5e32f11.xls                            Accounting Flexfield Segments                                      Prepared by : Richard Byrom
                                                                                                                                                  Date: 4/22/2012 11:32 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 13
6036542f-0fcc-421d-80d2-d312e5e32f11.xls ompany or Business Unit
                                       C                           Prepared by : Richard Byrom
                                                                     Date : 4/22/2012 11:32 AM
              Segment
      Range                                  Description             Parent
               Value
      01 - 98    01   Test Company                                       99
                 99   TOTAL COMPANY                                    None




                                                                                 Page 2 of 13
6036542f-0fcc-421d-80d2-d312e5e32f11.xls     Cost Centre     Prepared By : NDB Project Team
                                                                  Date : 4/22/2012 11:32 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 13
        6036542f-0fcc-421d-80d2-d312e5e32f11.xls   Department            Prepared by : NDB Project Team
                                                                              Date : 4/22/2012 11:32 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 13
          6036542f-0fcc-421d-80d2-d312e5e32f11.xls                                 Account                                                     Prepared by : Richard Byrom
                                                                                                                                                 Date : 4/22/2012 11:32 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
                  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

                                                                                                                                                              Page 5 of 13
        6036542f-0fcc-421d-80d2-d312e5e32f11.xls                              Account                                                        Prepared by : Richard Byrom
                                                                                                                                               Date : 4/22/2012 11:32 AM



              Segment                                                                                                                   Cross Validation
Range                                               Description    A/C Type      Old A/C No.     Parent          Rollup
               Value
                                                                                                                          Company   Cost Centre   Department   Product
                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
                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

                                                                                                                                                            Page 6 of 13
          6036542f-0fcc-421d-80d2-d312e5e32f11.xls                                    Account                                                     Prepared by : Richard Byrom
                                                                                                                                                    Date : 4/22/2012 11:32 AM



                Segment                                                                                                                      Cross Validation
  Range                                              Description           A/C Type      Old A/C No.     Parent       Rollup
                 Value
                                                                                                                               Company   Cost Centre   Department   Product
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
                  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

                                                                                                                                                                 Page 7 of 13
          6036542f-0fcc-421d-80d2-d312e5e32f11.xls                             Account                                                        Prepared by : Richard Byrom
                                                                                                                                                Date : 4/22/2012 11:32 AM



                Segment                                                                                                                  Cross Validation
  Range                                              Description    A/C Type      Old A/C No.     Parent          Rollup
                 Value
                                                                                                                           Company   Cost Centre   Department   Product
                  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
                  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

                                                                                                                                                             Page 8 of 13
          6036542f-0fcc-421d-80d2-d312e5e32f11.xls                                            Account                                                        Prepared by : Richard Byrom
                                                                                                                                                               Date : 4/22/2012 11:32 AM



                Segment                                                                                                                                 Cross Validation
  Range                                              Description                   A/C Type      Old A/C No.     Parent          Rollup
                 Value
                                                                                                                                          Company   Cost Centre   Department   Product
                  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
                  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

                                                                                                                                                                            Page 9 of 13
          6036542f-0fcc-421d-80d2-d312e5e32f11.xls                                     Account                                                     Prepared by : Richard Byrom
                                                                                                                                                     Date : 4/22/2012 11:32 AM



                Segment                                                                                                                       Cross Validation
  Range                                              Description            A/C Type      Old A/C No.     Parent       Rollup
                 Value
                                                                                                                                Company   Cost Centre   Department   Product
                  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
                  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

                                                                                                                                                                 Page 10 of 13
          6036542f-0fcc-421d-80d2-d312e5e32f11.xls                             Account                                                     Prepared by : Richard Byrom
                                                                                                                                             Date : 4/22/2012 11:32 AM



                Segment                                                                                                               Cross Validation
  Range                                              Description    A/C Type      Old A/C No.     Parent       Rollup
                 Value
                                                                                                                        Company   Cost Centre   Department   Product
                  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
                  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

                                                                                                                                                         Page 11 of 13
          6036542f-0fcc-421d-80d2-d312e5e32f11.xls                             Account                                                    Prepared by : Richard Byrom
                                                                                                                                            Date : 4/22/2012 11:32 AM



                Segment                                                                                                              Cross Validation
  Range                                              Description    A/C Type      Old A/C No.   Parent          Rollup
                 Value
                                                                                                                         Company Cost Centre Department    Product
0000 - 9998       9999     TOTAL ACCOUNTS                          Ownership             N/A             None            Yes     No          No            No




                                                                                                                                                        Page 12 of 13
6036542f-0fcc-421d-80d2-d312e5e32f11.xls                          Product                                 Prepared by : Richard Byrom
                                                                                                            Date : 4/22/2012 11:32 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 13

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:74
posted:4/22/2012
language:English
pages:13