Spreadsheet: 758464d1638887150-populate-data-based-on-selection-from-dropdown-project-planning
Sheet: Admin expenses

Account | Description | Opening Debit | Opening Credit | Opening Balance | Opening Balance InCC | Debit | Debit In Company Currency | Credit | Credit In Company Currency | Closing Debit | Closing Credit | Closing Balance | Closing Balance InCC
Courier Charges |  | 25068.8 | 105 | 24,963.80 Dr | 24,963.80 Dr | 109.56 | 109.56 |  | 0 | 25178.36 | 105 | 25,073.36 [NAME] | 25,073.36 [NAME]
Parking Fees |  | 4284.68 | 0 | [NAME] | [NAME] | 180 | 180 |  | 0 | 4464.68 | 0 | 4,464.68 Dr | 4,464.68 Dr
Internet and Webhosting |  | 8210.03 | 0 | 8,210.03 Dr | 8,210.03 Dr | 1915 | 1915 |  | 0 | 10125.03 | 0 | 10,125.03 Dr | 10,125.03 Dr
Mobile-STC SIMS |  | 278682.44 | 0 | 278,682.44 Dr | 278,682.44 Dr | 9626.41 | 9626.41 |  | 0 | 288308.85 | 0 | 288,308.85 Dr | 288,308.85 Dr
Telephone & Fax |  | 69179.36 | 0 | 69,179.36 Dr | 69,179.36 Dr | 2453.2 | 2453.2 |  | 0 | 71632.56 | 0 | [NAME] | [NAME]
General  Repairs  & Maintenance |  | 47142.9 | 750 | 46,392.90 Dr | 46,392.90 Dr | 1100 | 1100 |  | 0 | 48242.9 | 750 | 47,492.90 Dr | 47,492.90 Dr
Repairs and Maint. - Machines |  | 273656.8 | 0 | 273,656.80 Dr | 273,656.80 Dr | 3333.88 | 3333.88 |  | 0 | 276990.68 | 0 | 276,990.68 Dr | 276,990.68 Dr
Repairs and Maint. - Vehicles (Battery) |  | 25825.9 | 0 | 25,825.90 Dr | 25,825.90 Dr | 704.33 | 704.33 |  | 0 | 26530.23 | 0 | 26,530.23 Dr | 26,530.23 Dr
Repairs and Maint. - Vehicles (Car Wash) |  | 10364.75 | 0 | 10,364.75 Dr | 10,364.75 Dr | 59 | 59 |  | 0 | 10423.75 | 0 | 10,423.75 Dr | 10,423.75 Dr
Repairs and Maint. - Vehicles (Change oil/filter) |  | 79476.44 | 0 | [NAME] | [NAME] | 2410.26 | 2410.26 |  | 0 | 81886.7 | 0 | 81,886.70 Dr | 81,886.70 Dr
Repairs and Maint. - Vehicles (others) |  | 451910.05 | 6000 | 445,910.05 Dr | 445,910.05 Dr | 6061.26 | 6061.26 |  | 0 | 457971.31 | 6000 | 451,971.31 Dr | 451,971.31 Dr
Repairs and Maint. - Vehicles (Tyres) |  | 54683.46 | 0 | 54,683.46 Dr | 54,683.46 Dr | 614.75 | 614.75 |  | 0 | 55298.21 | 0 | 55,298.21 Dr | 55,298.21 Dr
Workshop-Filters |  | 151246.06 | 147.2 | 151,098.86 Dr | 151,098.86 Dr | 3302.5 | 3302.5 |  | 0 | 154548.56 | 147.2 | 154,401.36 Dr | 154,401.36 Dr
Workshop-Repairs and Maintenance |  | 124294.55 | 87.75 | 124,206.80 Dr | 124,206.80 Dr | 2785 | 2785 |  | 0 | 127079.55 | 87.75 | [NAME] | [NAME]
Workshop-Safety Uniform and Shoes |  | 13422.1 | 0 | 13,422.10 Dr | 13,422.10 Dr | 325 | 325 |  | 0 | 13747.1 | 0 | 13,747.10 Dr | 13,747.10 Dr
Workshop-Supplies |  | 1407713.8 | 2298.91 | 1,405,414.89 Dr | 1,405,414.89 Dr | 22534.78 | 22534.78 |  | 0 | 1430248.58 | 2298.91 | 1,427,949.67 Dr | 1,427,949.67 Dr
Workshop-Tyre |  | 94947.94 | 40 | 94,907.94 Dr | 94,907.94 Dr | 3817.4 | 3817.4 |  | 0 | 98765.34 | 40 | 98,725.34 Dr | 98,725.34 Dr
Govt fees -  Custom Duty |  | 918314.03 | 0 | 918,314.03 Dr | 918,314.03 Dr | 792 | 792 |  | 0 | 919106.03 | 0 | 919,106.03 Dr | 919,106.03 Dr
Govt fees -  Labor Office Fee |  | 3573807 | 14726 | 3,559,081.00 [NAME] | 3,559,081.00 [NAME] | 162951 | 162951 |  | 0 | 3736758 | 14726 | 3,722,032.00 Dr | 3,722,032.00 Dr
Govt fees -  Transfer Sponsorship |  | 36600 | 0 | 36,600.00 [NAME] | 36,600.00 [NAME] | 2000 | 2000 |  | 0 | 38600 | 0 | 38,600.00 Dr | 38,600.00 Dr
Govt fees - Documentation |  | 33563.27 | 0 | 33,563.27 Dr | 33,563.27 Dr | 550 | 550 |  | 0 | 34113.27 | 0 | [NAME] | [NAME]
Govt fees - Exit Re-entry Visa |  | 81000 | 600 | [NAME] | [NAME] | 200 | 200 |  | 0 | 81200 | 600 | [NAME] | [NAME]
Govt fees - Iqama Issuance Fees |  | 8950 | 0 | [NAME] | [NAME] | 650 | 650 |  | 0 | 9600 | 0 | 9,600.00 Dr | 9,600.00 Dr
Govt fees - Renew Iqamah Fees |  | 299850 | 1800 | [NAME] | [NAME] | 10900 | 10900 |  | 0 | 310750 | 1800 | [NAME] | [NAME]
Govt fees - Visa Fee |  | 68500 | 18000 | [NAME] | [NAME] | 6000 | 6000 |  | 0 | 74500 | 18000 | 56,500.00 Dr | 56,500.00 Dr
Hotel Accomodation |  | 45333.35 | 0 | 45,333.35 Dr | 45,333.35 Dr | 619.56 | 619.56 |  | 0 | 45952.91 | 0 | [NAME] | [NAME]
Transportation & Taxi fare |  | 23310.14 | 0 | 23,310.14 Dr | 23,310.14 Dr | 540 | 540 |  | 0 | 23850.14 | 0 | 23,850.14 Dr | 23,850.14 Dr
Travel Fare - Local Air Ticket |  | 190847.04 | 3762.1 | [NAME] | [NAME] | 9085.41 | 9085.41 |  | 0 | 199932.45 | 3762.1 | 196,170.35 Dr | 196,170.35 Dr
Petrol & Diesel |  | 163150.89 | 509 | 162,641.89 Dr | 162,641.89 Dr | 12638.39 | 12638.39 |  | 0 | 175789.28 | 509 | 175,280.28 Dr | 175,280.28 Dr
Office Supplies - Documentation |  | 111184.09 | 1485 | 109,699.09 Dr | 109,699.09 Dr | 10751.38 | 10751.38 |  | 0 | 121935.47 | 1485 | 120,450.47 Dr | 120,450.47 Dr
Office Supplies - Stationary |  | 38262.93 | 0 | 38,262.93 Dr | 38,262.93 Dr | 1006 | 1006 |  | 0 | 39268.93 | 0 | 39,268.93 Dr | 39,268.93 Dr
Supplies - Others |  | 289240.95 | 0 | [NAME] | [NAME] | 7395.47 | 7395.47 |  | 0 | 296636.42 | 0 | 296,636.42 Dr | 296,636.42 Dr
Spare parts |  | 1663172.48 | 5017.31 | 1,658,155.17 Dr | 1,658,155.17 Dr | 7182 | 7182 |  | 0 | 1670354.48 | 5017.31 | 1,665,337.17 Dr | 1,665,337.17 Dr
Rent - Accommodation |  | 52330 | 0 | 52,330.00 Dr | 52,330.00 Dr | 577.39 | 577.39 |  | 0 | 52907.39 | 0 | 52,907.39 Dr | 52,907.39 Dr
Rent - Equipment |  | 364628.07 | 0 | 364,628.07 Dr | 364,628.07 Dr | 4125 | 4125 |  | 0 | 368753.07 | 0 | 368,753.07 Dr | 368,753.07 Dr
Admin Share Expense-OSP |  | 17350000 | 0 | 17,350,000.00 Dr | 17,350,000.00 Dr | 400000 | 400000 |  | 0 | 17750000 | 0 | 17,750,000.00 Dr | 17,750,000.00 Dr
Municipality Permit Fees/Baladia Permission |  | 173130.29 | 0 | 173,130.29 Dr | 173,130.29 Dr | 3000 | 3000 |  | 0 | 176130.29 | 0 | 176,130.29 Dr | 176,130.29 Dr