Tuesday 11th Dec 2012 Week 6

First of all, I prepare the disconnection list by see what account we will disconnect and what will no disconnect. Second, make the COM & DOV sheet. Furthermore, I add all the amounts that are above 30 days and the amounts that are above 60 days. After that I delete all the accounts that is relating to Nakial and some other accounts because they have special agreements with the company. Finally, do the “SA” for the property that will disconnect them.

Monday 10th Dec 2012 Week 6

For today I start with doing the disconnection list by myself and when I finish it I send it to Huda to check the list if it is right or there are a wrong. However, they disconnect the apartment if the customer didn’t pay the outstanding and the fee is too high and the meter in unlock.

Sunday 9th Dec 2012 Week 6

First of all, I start with downloading the disconnection list from the system and then I start to check it with the system. Second, send email of “Final Disconnecting Not” to the customer to remind them about the payment. Finally, I set with Huda and see how they do the disconnection list.

Thursday 6th Dec 2012 Week 5

First of all, I start with downloading the disconnection report from the “ORACLE” system. To disconnect the apartment it should have outstanding of DH 500 or above and it should be more than 60 days. However, I add all the amounts that are above 30 and 60 days then remove all the accounts that have outstanding of DH 500 and below. Furthermore, I add the amounts of the 30 days and 60 days and see the negative numbers, so if sum of them are below DH 500 we remove it.

Next, I set with Huda and see how they follow up with the customers before they disconnect the apartment. As well, she gave me some disconnection list to be checked with the system.

Wednesday 5th Dec 2012 Week 5

I start with correcting the daily collection that I was doing it yesterday because there is some mistake.  Then I did the bank collection reconciliation for the second period of November, but I had some problem that the last amount not getting “0.00”.

Tuesday 4th Dec 2012 Week 5

I start with doing the daily collection for the second week of November but I can’t finish it because I have problem in some part and I try to do it but I can’t and my supervisor was on holiday for this day.  

Monday 3rd Dec 2012 Week 5

I start with completing the work that I was doing it last week because there are some parts that I can’t finish it, so I finish it with getting some help from my supervisor. Then I did the “Revenue Allocations” that it must have the same amount that are in the reports.

Thursday 29th Nov 2012 Week 4

I start with doing the collection report for billing and accounting this is a CC and B daily collections of Oct 2012. However, I do the “Bank VS collection Reconciliation” on this excel sheet there is some difficult parts, but I try to understand it and do it.   

Wednesday 28th Nov 2012 Week 4

First of all, I start with checking the “Rossom” report from the website and match it with the report in the Dubai World website by checking the total amount and the number of transactions. Furthermore, when we check everything we a plowed it in the system, so this is on work that the collection department do every day. Second, I check the “Disconnection List” from 25 to 27 November 2012 with the “ORACLE” system by checking the “Field Activity Information” if it has the same date and it is completed. However, check the reconnection fee, chilled water if date is ok and the amount is AED 1,000.

Tuesday 27th Nov 2012 Week 4

I start the day with the national day celebrating and it is one part of the celebration. So we went to plant the Union Tree with the CEO of the company. Next, I check the daily cash for last period of October to first period of November. Finally, I check the bank statement, the total, cash and the CC from the daily cash.

Monday 26th Nov 2012 Week 4

I start with getting some information about the Collection department from Mr. Hisham. First of all, he shown me how to check the NBD report for yesterday that the bank send with the transaction in the system. Second, check the “Rossom” amounts with the trade website to be sure that it matches then compare it with the system. Finally, when we found that everything is correct and matches then we submit the reports in the system.

Mr. Hisham gives me the disconnecting bills to check the name, account, address of the customers, SA to be closed and the amount with the “ORACIE” system. However, I found some amount that is not matching with the system and there are some reactive in the SA for on account. So when I ask about it they told me that it is not a big problem, but at least the amount covers all the SA figures.

Sunday 25th Nov 2012 Week 4

From this week I start working with the commercial department. First of all, Mr. Hishame told me to read the policy for the department and the credit collection policy as well. Next, Mr. Hishame gives me brief information about collection department and what they spouse to do daily and weekly. The last thing that I did for this day was checking the “Daily Collection” it is for the second week of Nov.

Thursday 22nd Nov 2012 Week 3

Maryam give me some bills of payments that the company should pay them back because of received service or good from them. Furthermore, I create  an excel sheet that include the name of the company, date of received the invoice, the due date, date of work acceptance, date of approvable for the commercial and the date that the finance and account received it.

Wednesday 21st Nov 2012 Week 3

We had site visit for the hall day to their sites. One of the places that we want to is their customer service office on Al Mass Tower. Their customer can go to have the service and pay for the bills. However, we want to the site where they have the machines and were they control the systems of the cooling and where the recycling of the water happen to reach the customer apartments or building the cold are for their  air-cooled.

Tuesday 20th Nov 2012 Week 3

I start by replacing some of the payments that we found it yesterday because my manager found that they want specific things on the purchase order. However, they want purchase order to be in 2012 and most of the payments that we found it had purchase order that was in 2011. Furthermore, I check them if they have the invoice, delivery not and purchase order that is in 2012. As well, I check DEWA original bills with the bills that they print it from DEWA website. Next, check the cheques that are cancelled because the customer didn’t cash it on their time.

Monday 19th Nov 2012 Week 3

I start with what I was doing yesterday and finish it. However, Maryam gave me a list of payments number for the hall year to found it from the files because they have odat (the people that evaluate the company work) to evaluate them for this year. Also, I check this payments if they have the invoice, delivery order and the purchase order. Furthermore, we remove the payments that not have the purchase order because it have contract between the other company and Palm Utilities, so we replace it with other payments that not have contract and it have the purchase order. Finally, they gave me DEWA original bills to compare the total with the bills that they are printing them from the DEWA website.

Sunday 18th Nov 2012 Week 3

When I reach the work Maryam send me an excel sheet to my outlook and this excel sheet about “Bank Reconciliation Statement for 30^th September”. However, Maryam explain to me about this sheet and what I mast do on it. So I start falling it by comparing the statement that are on the excel sheet with the “Customer Account Statement” that come from the Bank. Furthermore, when I finish it I did new sheet for October.

Wednesday 14th Nov 2012 Week 2

I start with checking the cheques with the customer’s information and the attached papers and bills. However, for this week I going as the work plan that I was working in all payment works. For example, I was full in the excel sheet of the payment summary of the customer bills and I was checking the cheques that the company will give to the customer what they will leave the apartment.

Tuesday 13th Nov 2012 Week 2

From the mooring that I reach the work I was working on the excel sheet of payment that t was doing it yesterday and I fixed the rest. However there are some bills that was confuse so me and Maryam want to the collection department to let them check it on their system. Furthermore, Maryam gave me some customers’ cheque that the company will pay them back as their deposit to chick it with the summary. For example, I check the name on the cheque if it is smeller to the passport and the number of the cheque with the amount and the deposit bill.

Monday 12th Nov 2012 Week 2

I start with doing the excel sheet of payment and I spent all the day doing it because when I did it I find a lot of mistake between the bills and the amount the I got in the excel and I try to fixed it and I correct some of it only.

Sunday 11th Nov 2012 Week 2

I start with fall in excel sheet of payment. This payment is done for the customer that wants to leave the apartment. This payment because the customer pay a deposit when they sign the contract. However, when the customer want to do cancelation the y must provide the final bill with the previse month. Do we calculate it to know the capacity of the different that the company must pay the customer. From reading the bill if we notes that they didn’t pay the last bill so we need to calculate the consumption by adding the two month figure together. As well, I check the contract with their name and refund cheque name and the recipe if the correct and match with the summary. 

Work Plan

Thursday 8th Nov 2012 Week 1

The first thing that I start with today is edit some bills that they give me to the excel sheet of “Petty Cash Summery Report. This report have the description and amount of the bills, also it must completed by the number of the voucher. Next, for each bill I need to specify this bill for which project by enter the code of the project and from which account by entering the account code. As well, I meet the CEO of the company and he spoke with me what I do and what I learn from the things that I do and if it relating to may study or no. However, Maryam give me the Trial Balance to look at because net week I will go over it and they do a cheqce for a supplier to pay them

Wednesday 7th Nov 2012 Week 1

First I full the DU invoice summery and then they give me a bill to be chick. This bills is for the staff that they give them a budget of AED 3,000 that they can use it when the go to some project work relating  to the company and the staff pay this money from their own and after that the company pay them back. Some time they did not give me work because on this time of the month they close their account.

Tuesday 6th Nov 2012 Week 1

When I reach the work the first thing that I start to do it is continue what I was doing it yesterday. Then Maryam gave me other DU bills to fall the excel sheet summary for month of October and I keep doing it until the last minutes of my work time.

Monday 5th Nov 2012 Week 1

In the financial Department there are two sections one is payment and the other is collection. I start working with payment section with Maryam. She is my supervisor for the first 3 weeks. She introduce me to the work that they do in there section and one of the thing is chick the documents that they received from the commercial department. The documentation that they chick are consultant application, work completion certificate, delivery note, suppliers/service provider invoice and copy of agreement/ contract. Also the make a budget report for project that it is not budgeted and it is over the company budget. My work for this day was fell an excel sheet of DU Invoice Breakdown summary and when I finish it me and Maryam analysis that the total on the excel sheet not matching the total in DU bills. So we start to see what is the mistake and we analysis that there are some numbers that have to bills with different amount so this was the problem.

Sunday 4th Nov 2012 Week 1

This is my first day for the workplacment in Palm Utilities. I reach the company reception disc befor the 9 am that the work start. The employee that was on the reception disc was very helpful with me and I met with Mis. Amal and she introduce we to the staff. They prepare for me the disc and the computer with accessing to their system. For the first day I had orientationfrom 9:15am to 1:00pm about the company.